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
-
New domain wipes out domain authority
A client wanted to change their domain name, which we have now done. The site content itself is exactly the same. We put 301 redirect links in so that Google searchers would redirect from the old site to the new one. However Moz then said that it couldn't crawl the old domain because of the redirects and advised creating a brand new campaign for the new domain. We have done this but now Moz says that the domain authority of the new site is 2 (it was 14 on the old domain). Specifics are:
Technical SEO | | mfrgolfgti
old domain: https://ryemeadcleaning.co.uk
new domain: https://ryemeadgroup.co.uk So basically it seems like we're starting again from scratch with the new domain and all the SEO from the old domain has been lost? Have we done it wrong?0 -
Acquired domains for SEO
hi there, For one of our insurance websites we acquired a domain, this domain is going to be redirected to our domain. After some research we discovered the domain we've bought also includes other domains which 301 redirect to specific 'insurance products'. These domains are also included in the deal. But what is the best technical solution for redirecting these specific redirected product domains? They already redirect to the product pages of the domain we've bought, so after redirect this domain, the sub (product) redirected domains will also link to us. It would be like this: A) www.sub-carinsurancesite.nl (301) -> www.domain-we-bought.com/car-insurance -> www.ourdomain.com/car-insurance
Technical SEO | | remkoallertz
B) www.sub-carinsurancesite.nl (301) -> www.ourdomain.com/car-insurance & www.domain-we-bought.com/car-insurance -> www.ourdomain.com/car-insurance etc0 -
Domain forwarding
Hi Is it ok or bad practice to domain forward shorter more memorable snappier domains used for promoting a website to a longer domain where the website actually lives, such as: Promoting in social media profiles, emails and offline literature a domain with forwarding set up like: www.brand.com To the main website: www.brandincludingprimaryproductrelatedkeyword.com And if ok (not bad practice), since its the forwarded domains that are being promoted they are hence the links most likely to be shared on social media and other websites so will they be treated like 301's and 'link building' for those will pretty much equate to link building for the main domain (or not) ? Many Thanks Dan
Technical SEO | | Dan-Lawrence0 -
Domains
My questions is what to do with old domains we own from a past business. Is it advantages to direct them to the new domain/company or is that going to cause a problem for the new company. They are not in the same industry.
Technical SEO | | KeylimeSocial0 -
WIki Contextual Links
I want to understand what are Wiki Contextual Links and how are they helpful for SEO. I hear google likes them. Is that true?
Technical SEO | | KS__0 -
301 Redirect & Linking Root Domain Count
Howdy Mozzers! If I do a 301 redirect from a domain that say has 200 linking root domains, to a fresh domain will the fresh domain now (when updated) have a linking root domain count of 200? Also, is it beneficial or detrimental to do a 301 redirect for an unrelated website i.e. garden hose website, to a children's playgorund equipment website in order to capture the link juice? Best
Technical SEO | | clickfactory0 -
Grabbing Expired Domains
How hard is it to grab expired domains? I have my eye on a domain that is expiring in 3 days, but I don't think it's quite that simple. Doesn't it go through months of waiting to become available? Is there an easy way to grab domains that are set to expire? Are the services that offer this type of service good? And who do you guys recommend?
Technical SEO | | applesofgold0 -
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