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.
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 -
New GSC Search Analytics report: position mixes web and image
Dear all, I am auditing a site in Google Seach Console (GSC, formerly Google Webmaster Tools) and find the Position data in the new Search Analytics report very, very improbable. I suspect that even if you filter by "SearchType = web", the Position data does count the ranking of images in the Image search widget as a search position. Has anybody observed this as well? Here is the case: the site targets a quite broad search query in the bath room domain. I have made a number of searches with private browser sessions, different browsers, alternative IP address via a VPN, etc, and the look of the search result in the relevant geographical market is consistently the following. Three Adwords ads #1 organic result Images universal results widget #2-10 organic results The site’s first page ranks consistently around #15 of the organic results, hence on the second SERP. But it also consistently has an image in the Images universal results widget (usually #2 or #3). This is consistent with the data I have in Moz Analytics. Yet, the GSC Search Analytics report shows 2.2 as average position with the default SearchType=Web setting. I have done the search over and over, and never has a PAGE of the site ranked that high. Is there any public information how exactly the position is calculated? I mean, something more precise than the very general information on https://support.google.com/webmasters/answer/6155685?hl=en Is there any way to get the correct position/ranking? Thanks for sharing your experience!
Reporting & Analytics | | QRN0 -
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 -
Creating Meta Tags for a Web Hosting company
My client has recently had his site rewritten by a company which supplies a website/hosting/seo service. The client still wants to use me for establishing his site locally and for SEM. My problem is that the code is not accessible to me. They have set up GA tracking which feeds into the reports dashboard. There is no way of actually access the raw data. When I asked for access to the GA account I got this message from bOline solutions: "Your SEO consultant will need to create a new GA account and then add the meta tag to the reports tab of your site" Because I am still very much learning GA I do not know what meta tag they are referring too. I'm therefore stuck as to how to create it. I've started learning about "Google Tag Manager" and am working through "Digital Analytics Fundementals", I've a feeling this is just a question of terminology - can anyone more experience in the subject help me?
Reporting & Analytics | | catherine-2793880 -
Client's Google Analytics account access is 'user' only from previous web developer
Just wondering if you have any advice on the following scenario: Client's GA account was set-up by a previous web developer. The client's GA account is a user account (not admin). When we request from the previous web developer that the account access be changed to admin, the web developer says they can't do that as we'll then have access to all the other GA accounts within their account. Does this mean we'll have to create a new GA profile for the client and lose all historic GA data? Any guidance greatly appreciated.
Reporting & Analytics | | aoifep0 -
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 -
Verify web master tools ?!?!
Randomly today google web master tools all of a sudden wants me to re-verify my site and is giving me the error: Verification failed for **http://www.shiftins.com/ **using the Meta tag method (less than a minute ago). We couldn't find the verification meta tag. but if you view the page source it is clearly listed..... this happened only today while no changes were made to the site. Does anyone have a solution?
Reporting & Analytics | | shiftins0 -
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