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
-
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 -
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 -
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 -
Ecommerce tracking problem with multiple domains on 1 web property
We recently launched 13 product marketing sites based on a Wordpress Multisite setup. To track all 13 sites we decided to use one web property, so we can use the same tracking code for all domains. To track the sites seperately, we set up a profile for each product site with a hostname filter. This works well for most stats, but eCommerce tracking is where the problem starts. Per profile we obviously want to track the products purchases on that website only. What happens now is that all purchases from all product sites are tracked on all profiles. How can we change this? Should I alter the eCommerce tracking code or can I fix this with an additional filter per profile? Thanks for your help Mozzers! Regards, Pieter van Diggele
Reporting & Analytics | | RBO
Online Marketing Executive
Elsevier Opleidingen0 -
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 -
Website not responding to web request
Hi, I'm attempting to create a campaign, but the website I want to analyse won't allow SEOmoz to crawl the site stating that the site does not allow 'web requests' - can anything be done about this? Thanks, Adam
Reporting & Analytics | | adamgthorndike0 -
Google Analytics/ Contact 7 Plugin
I have a site that uses the contact 7 plugin for its contact form sitewide in a sidebar and on a contact us page. I've set up a goal in analytics and tracked using the "on_sent_ok" hook but the number of goals GA is creating is far outweighing the number of times the form is actually completed. I figured my initial mistake was to use the contact-us page as the page tracker variable for the goal but wondered if it was counting all form completions AND anyone who went to the contact page. So I amended it to a contact-us/thank-you page that no site visitor could navigate to, and since I have no goals completed, even though we're getting enquiries through the form. Am I being dumb here and missing something quite simple?
Reporting & Analytics | | PerchDigital0