Need advice on creating link report
-
I am trying to create a new report that will show the effectiveness of each link source in terms of delivering traffic and how quality that traffic is with regard to conversions....
With that, I want to know how I can first get a list of all external links to any page on my subdomain and then align that list with traffic/conversion data in Google Analytics.
Can someone provide me step by step instructions on this?
I assume I would start with Open Site Explorer and export the list of external links to pages on my subdomain. My issue lies in how to get the same general list out of GA that lines up with the urls in the OSE export. I have tried referrals, but that does not give me a compatible list.
-
Hopefully this will help:
Login to GA and click Acquisition --> All Referrers
This report will show all websites that sent traffic to you in the time period you have set in Analytics.
Click the Ecommerce or Goals tab at the top of the list and it should give you conversion data for your referrers.Just let us know if we've misunderstood what you're looking to achieve.
-
I would tend to start (and stick with) Google Analytics and export the list of URLs based on conversions. You may need to look up each URL's links separately. An alternative would be to narrow down the list of URLs from Google Analytics and then put them into a spreadsheet where you can write a formula to look up each of them.
In your case, I wouldn't start with OSE's links, I would start with the URLs from Google Analytics that have provided conversions and work the other way.
Also, I'm not sure if I fully understand why you're wanting this data. You can get the list of URLs that sent traffic and conversions to your site via Google Analytics. If a link is not in GA as a referral, then it still may be a great link to have that contributed towards rankings (that lead to conversions). You see, links and mentions might pass on Page Authority and Domain Authority to your site and you won't see the traffic or referrals: but those links allowed your site to be trusted more, leading to better rankings for your site.
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
-
If for few links the spam score is not discovered, then what is the possibility of risks for those links?
For one of the links, I was checking the domain authority and spam score for which the domain authority was 65 and spam score was not discovered. In such links how do I assume or what are the chances of risks with these links?
Link Explorer | | Sneha.chandan0 -
Just Discovered Links Are Down for ~2-3 Days
UPDATE 12/01/15: This issue is now resolved and Just Discovered Link data is back. Sadly, I've got bad news. Due to an error we made (literally a typo on a curl command), Just Discovered Links in Open Site Explorer will be unavailable for 2-3 days. The data was actually lost, but we're re-indexing all those links now and they should be back in working order by Monday. NOTE: this only affects link counts and links listed in the "Just Discovered" sections of OSE. No links in the main index nor any metrics (PA/DA/etc) are affected. Our sincere apologies - we're going to build mechanisms to prevent this for the future.
Link Explorer | | randfish3 -
Thousands of Missing Links in OSE Report
Hi there, Moz reports 70k+ external links pointing to my site but when I use the Open Site Explorer to export all links, I only see 9,000+ I have tried combining different combinations of fields ('this root domain', 'this subdomain', 'all links' etc) but can never see more than 9,000 links. My website does redirect to www. and have a couple of subdomains, the report for non www. only shows around 120 external links. We also use Ahrefs and the crawl reports here display 40k+ links (on the dashboard and when exported) which makes me believe the problem is not with my website but rather OSE. Any help is much appreciated, Thanks, Jason
Link Explorer | | Xtend-Life0 -
HTTP Status no data to report
In my Moz top pages report, why is there "no data" in the HTTP Status column? Is this an indication of something missing or an error?
Link Explorer | | jessential0 -
OSE not picking up all internal links?
Hi! I've been checking a few pages in OSE. For example: https://www.holidayhypermarket.co.uk/holidays/last-minute This, according to the tool, has only 6 internal links. However, a Screaming Frog crawl picks up 700+, which is about right seeing as there is a link in the footer. What do you think could be behind the discrepancy?
Link Explorer | | Blink-SEO0 -
When requesting a CSV for an internal 302 redirect report, the data isn't aligning with the UI. Does anyone have any suggestions?
When requesting a CSV for an internal 302 redirect report, the data isn't aligning with the UI. Does anyone have any suggestions?
Link Explorer | | Merkle-Impaqt0 -
Why does the number of the total external links and the followed linking root domains between Open site explorer and the campaign in Moz pro doesn't match?
Opensiteexplorer returns 52.473 total external links and 715 followed linking root domains while my campaign in Moz analytics return 35.899 total external links and 1092 followed linking root domains. Does anyone knows how this is possible?
Link Explorer | | ConversionMobstars0 -
External link numbers down year on year
Hi, Just wondering if anyone knows why a website that has definitely had some links acquired over the last year would now show less links and from fewer referring domains than they had this time last year? How is that possible - assume it is down to the way OSE / Moz crawl the web and collect data but need a definitive explanation for a client that has noticed the drop in link metrics and as a result authority. Many thanks,
Link Explorer | | lollowe0