Contacting web partners (syndicators)
-
In Analytics, you can see all the referrers who linked to you over a particular time period. For example, I can go to my referrer list for May and see everyone who linked to me (traffic sources>sources>referrals).
What I want to do is contact all the websites who went one month without linking to me. I know how to select the time frame and download the list. But what is the best way to compare the two lists then filter out those websites who need to be contacted?
It's tough to express, but I am hoping I am clear enough for you guys to understand what I am trying to accomplish.
-
It's easy enough to do in Excel.
Star by creating a superlist in column A. This should be a list of all sites that have sent traffic to you over a given time frame.
Then in column B run a vLookup to find the number of referring visitors for the last month. In order to do this you will have to have the referring visitors data downloaded and stored.
Then I'd go on to do a similar thing for the previous month's data in column C.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Google Web Master Tools show that my site has been crawled, but search results show old title tags, ect.
Does the index report reflect what will be displayed on Google results? Google seems to be indexing my site every Sunday...
Reporting & Analytics | | 928shopper0 -
Webmaster Tools, why does it show 486 pages submitted to web, and only 40 indexed?
I am confused on what a client account shows in WMTs, client account is http://multiview.com. They have a graph showing 486 pages submitted to web, but only 40 are indexed. Also, they recently re-launched, i.e in April 2014, and the new site has about 40 pages indexed.... so I am guessing that the 486 number relates to all the pages that are showing errors in retrieving...i.e. 28 soft 404 errors, 10 access denied errors, 808 not found errors. Does this make sense to explain why there is such a gap between 486 and 40?
Reporting & Analytics | | DianeDP0 -
Difference in incoming links between web masters tool and moz
Why are incoming links to my site in Google Webmasters tools totally different then in MOZ? Which is correct? According to Google as of this week I have hundreds of links coming from linkarena (dot) com (Never heard) Does any one know who they are or if they are hurting me? I definitely did not pay them to put me on there. It looks like a German site. Thank you.
Reporting & Analytics | | omakad0 -
Advanced Web Ranking Proxies
Hey, How can i set up multiple proxy server for Advanced Web Ranking? I managed to block everyone from Google the last time I used this 😕 Thanks, Luke.
Reporting & Analytics | | NoisyLittleMonkey0 -
Yikes..what is this? "We have detected that the root domain xxxxxx.com does not repsond to web requests"!!!
Can anyone tell me what this means? "We have detected that the root domain xxxxxx.com does not repsond to web requests. Using this domain, we will be unable to crawl your site or present accurate SERP information"
Reporting & Analytics | | MannixSEO0 -
Not found and Not followed Errors on Web Master Tools
Just noticed in web master tools that we are showing 150 not found errors on our site, the majority appear to be from old blog posts that have been deleted, is this damaging from an SEO perspective on a scale from 1-10? Also we have over 100000 not followed errors throughout the same site, is this damaging from an SEO perspective on a scale from 1-10? Thanks in Advance Andy
Reporting & Analytics | | First-VehicleLeasing0 -
Google.co.uk (The Web or Pages From UK) Query?
Hi, Google.co.uk is ambiguous at best, it is geo targeted for the UK, however, by default all results incorporate "The Web" meaning outside the UK. If a user wishes to filter to "Pages From UK" then they have to click that specifically. Now my clients regularly ask me whether the traffic they are getting is from Google.co.uk (The Web) or Google.co.uk (Pages from UK) In analytics it combines these two as single source = Google.co.uk without any further breakdown, is there a way to figure this out. If I can split the figures then I can run necessary additional comparisons etc. Regards Ausaf
Reporting & Analytics | | conversiontactics0 -
Is there any web analytics tool that let us track number of outgoing clicks (and visits) ?
I just wonder if we can measure outgoing visits from a specific URL with an online tool or not?
Reporting & Analytics | | merkal20050