Need advice on creating link report

[dsinger]

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.

[GlobeRunner]

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.

[Everett]

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.