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
-
Web traffic in steady decline since launching responsive design in July
The launch of the responsive design is the only event we can correlate to the beginning of the decline in overall visits to the website since July, however we're not sure if this is the issue. To give you some background, the website http://www.precisionpestcontrol.com.au/ is a pest control site in a highly competitive industry where there are many black hat tactics going on with huge keyword competition on a small range of keywords, however historically the website traffic for the above site has been gaining momentum. We create/ update 2 or 3 pages every month with rich content and post 8 blogs every month on pest control related topics. We have done the initial keyword research and all the keywords we used are medium to high volume terms. We don't do any black hat tactics or dodgy link building, we have invested time submitting the site to legitimate business listings in the past. It just seems strange that all of a sudden we go responsive and start to lose searchengine traffic. Possible Issues What we've been able to find so far were some pages that were not redirected properly, probably about 5, and 2 pages that seemed to lead to a 404 error. These have only just been fixed recently, otherwise the mobile site has been functioning effectively. Could this be the reason we have been in decline over the past few months? We also seem to have lost a whole lot of external links somehow, the external link measurement in MOZ has gone from 1500, up to 6,000 then down to 300 or so in the space of a few months. Basically we're trying to figure out what we're doing wrong, or what we can do to try and stop the decline of visits. We've checked the algorithm updates and don't think that Panda or the shift to the Google AI would have penalised us, but then again we could be wrong. Any advice anyone could offer would be hugely appreciated. Happy to provide any data for anyone to have a look at.
Reporting & Analytics | | Peter.Huxley590 -
Help With Understanding Chrome Web Store Analytics
Hi all, our website Creately is listed in the Chrome Web Store. Its not an extension or an app, but just a link to app which users can use to quickly log into the app and start drawing their diagrams. They do provide you a way to add Google Analytics to track some visitor data like user visits. But we want to figure out from which sections of Chrome Web Store is sending us traffic. When looking at the Source/Medium reports I can see the following. chrome-ntp-icon / (not set) chrome-app-launcher / (not set) chrome-ntp-launcher / (not set) chrome-app-launcher-search / (not set) chrome-app-launcher-info-dialog / (not set) I'm guessing these indicate where we're getting the traffic to the Chrome web store page but I can't seem to find any information about what they mean. Any help will be greatly appreciated.
Reporting & Analytics | | Nishadha0 -
Newer iteration of Avinash Kaushik's Web 2.0
Greetings all! Does anyone know if there is a more recent, but comparable, book that covers the topic of analytics like Avinash Kaushik's Web Analytics 2.0: The Art of Online Accountability and Science of Customer Centricity or Brian Clifton's Advanced Web Metrics with Google Analytics, 2nd Edition? These were published in 2009 & 2010. I know the core concepts remain the same, but the technology has improved greatly.
Reporting & Analytics | | AfroSEO0 -
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 -
Problem: Google web master tools with HTML Improvements
Hello, When using the google webmaster tools, on Optimization --> HTML Improvements, I have some problems in field the Short meta descriptions. This is easy to fix and I fixed some last days, then today I check this again. Google webmaster tool still report these errors. Please let me know how to notify to google, these errors was fixed?
Reporting & Analytics | | JohnHuynh0 -
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 -
How can I capture search terms and forward it along with my contact form?
I would like to be able to capture the keywords when someone comes to my site with a PPC click or a keyword search. I can't imagine that this is an uncommon request, but I can't find the tools that would let me do that, or heck something that will help me build it myself. What is everyone using to capture search information from people who contact you?
Reporting & Analytics | | ciinc0