Is it possible to export Inbound Links in a CSV file categorized by Linking Root Domains ?
-
Hi,
I am performing an analysis of the total inbound links to my homepage and I would like to have the total amount of inbound links categorized by the Linking root domains.
For example, the Open Site explorer does offer the feature to show you the Linking Root Domains to your page. Then when you click on the first Linking Root Domain, it also shows you the Top Linking Pages ( Which means all the pages that link to your page from this particular top level domain)
Now I would like to export this data to a CSV file, but open site explorer only exports the total amount of top level linking domains.
Does anyone has a solution to this problem ?
Thank you very much for the help in advance!
-
You are correct. Excel should be able to match on that example or one similar to it. You may need to do some reading within the Microsoft help pages to see how it uses regular expressions (for example I dont know if you need the asterisk in your query). Just mess around with the function and you should be able to figure it out.
-
Thank you for sharing your thoughts CleverPhD.
Since the Domain Authority is the same for every link that springs from the same root domain, I already thought to use the given Domain authority in order to create a separate list.
However, different linking root domains can have the same domain authority. Thus, If I would like to summarize all links from one domain automatically I will have to establish a extended function that relates the domain authority to the text (name) stored as URL.
For example:
DA URL
18 http://blog.moneymanagedproperly.com/?cat=8
18 http://fulano.info/wordpress/?m=201008
I was wondering how to do this without creating a single function for each root domain (for example = COUNTIF(B2:B3;" =http://blog.* "
I am keen to know what are your thougts on this example?
-
There is logic built into Excel that allows you to both COUNT and COUNTIF or COUNTA
http://office.microsoft.com/en-us/excel-help/countif-function-HP010069840.aspx
If you are wanting to count the total number of domains you can setup a function to count non blank cells
http://office.microsoft.com/en-us/excel-help/count-nonblank-cells-HP003056101.aspx
=COUNTA(A2:A6)
This would count non blank cells from A2 though A6.
You can use this also to count if you have a value that is greater than a given number. Say you wanted to see all the linking domains with a DA greater than 20
=COUNTIF(B2:B7,">20")
You get the idea. Note that you may need to format your number cells as Numbers to get this to work.
You should be able to use one of the logic functions above in Excel to get you what you need.
-
Thank you for the answer Chris!
Yes that is correct, by sorting the spreadsheet by the URL simply from A to Z I can extract a list of all links from a particular root domain. However, then I will still have to manually (or automatically) count the links. This can be time consuming.. I was wondering if moz.com relate links to each other and export this..
-
Arne, isn't that something you would do after it is downloaded by sorting your columns in your excel or google docs spreadsheet? Your download contains all the same data as you see on the screen, ie. linking root domain, domain authority, and linking root domain. Is there something else you're trying to do?
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
-
Moving Shopify from a Sub Domain to the Full Domain
Apologies if this has been asked before. Currently we have a Shopify shop on a subdomain shop.lucybee.com a blog on subdomain blog.lucybee.com and the full domain of course. We'd now like to move everything onto Shopify on the full domain. Therefore the blog rolls into Shopify. We'll manually move pages into Shopify. Any advice or links to resources on how to manage would be gratefully received. Thank you , Jim
Technical SEO | | LucyBee0 -
Why am I getting millions of links from my root domain to my subdomains?
My site's subdomains (us.example.com, de.example.com, etc.) are showing millions of links (in Google Webmaster Tools) from the root domain. This seems very unnatural to me. Any idea what would be cause this or is this? In addition, I just found out that we deliberately stop googlebot crawling GEO-IP redirects, so that when googlebot tries to crawl our UK, DE, FR, etc. sites, it is not redirected to us.example.com. I'm thinking they may be linked? Thanks for your help!
Technical SEO | | CMcC0 -
3,638 mystery inbound links from google.com
Hello, can anybody help me. I my webmaster tools, under "Links to your Site" and "Who links the most" It shows Google as the top inbound link source, with 3,669 out of 4,14, all these links are pointing to one sub page of content. Yet when I click on the source it only shows me one Google Plus page. My traffic hell by 60% when I first noticed these links. we have not been building unnatural links and we have not had any Manual link building warning. This is the site: iunlock.org Two questions:- I have deleted this one linked to page what else can I do to reverse this impact Does anybody know what has happened? See attached WWwnb1W.png
Technical SEO | | Jack4ireland0 -
Redirect non www. domain to WWW. domain for established website?
Hey guys, The website in question has been online for more than 5 years but there are still 2 versions of the website. Both versions are indexed by Google and of course, this will result in duplicate content. Is it necessary to redirect the non-www domain to the www. domain. What are the cons and advantages? Will the www. links replace the non-www links when it comes to keyword rankings? Thanks.
Technical SEO | | BruLee0 -
My seo company has a footer link that links to my site by keyword will this effect my rankings
My old SEo company has a footer link by keyword to my site so it acts like a site wide link will this effect my rankings. My site was in the top 5 for many keywords now page 2 and 3 so I am trying to see what has effected it as we havent changed what we do
Technical SEO | | Casefun0 -
Possible reasons for being outranked?
Suppose you are being outranked for a keyword phrase by a competitor but you have a significantly higher page authority and domain authority. 9 out of 10 people would consider the content better on our page. We have more links pointing to our page from highly authoritative sites than they do. What other reasons could explain why we are being outranked?
Technical SEO | | ProjectLabs0 -
Why would a link shown on OSE appear differently than the page containing the link?
I recently traded links with a site that I will call www.example.com When I used open site explorer to check the link it came back with a different page authority as www.example.com/index.htm yet the link does appear on the www.example.com page. Why would this be?
Technical SEO | | casper4340 -
Internal Linking: Site-wide VS Content Links
I just watched this video in which Matt Cutts talks about the ancient 100 links per page limit. I often encounter websites which have massive navigation (elaborate main menu, side bar, footer, superfooter...etc) in addition to content area based links. My question is do you think Google passes votes (PageRank and anchor text) differently from template links such as navigation to the ones in the content area, if so have you done any testing to confirm?
Technical SEO | | Dan-Petrovic0