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
-
Do you still loose 15% of value of inbound links when you redirect your site from http to https (so all inbound links to http are being redirected to https version)?
I know when you redesign your on website, you loose about 15% internally due to the 301 redirects (see moz article: https://mza.seotoolninja.com/blog/accidental-seo-tests-how-301-redirects-are-likely-impacting-your-brand), but I'm wondering if that also applies to value of inbound links when you redirect your http://www.sitename.com to https://www.sitename.com. I appreciate your help!
Technical SEO | | JBMediaGroup0 -
Will doing a 301 redirect for one domain to another give the latter domain the formers links?
I have some websites that I built a few years ago that are still in existence, but I no longer have access to the sites as they weren't hosted by myself. These sites all carry a "Designed by Me" text on the footer with a link to my (now old) website. I have since done 301 redirects on the domain names that are used in the footers of these sites so they link directly to my new site. However, will these websites now show up on Google Webmasters for example as external links to my site?
Technical SEO | | mickburkesnr0 -
Forwarding kw rich domains to main domain
Hi My client has a clutch of kw rich domains that want to point to main domain, apart from being good for promotional reasons is there any seo benefit for doing so (i know there used to be years ago but under impression hasn't been any benefit for a long while) Most importantly though can any bad come from doing this ? Best Rgds Dan
Technical SEO | | Dan-Lawrence0 -
Ratio of linking C-blocks to Linking domains
Hi, Our linkbuilding efforts have resulted in acquiring a high number of backlinks from domains within a C-block. We all know Google issues penalties whenever someone's link profile looks unnatural. A high number of backlinks but a low number of linking C-blocks would seem to be one of reasons to get penalized. Example: we have 6,000 links from 200 linking root domains coming in from 100 C-blocks. At what point should we start to worry about being penalized/giving off an unnatural look to mr G?
Technical SEO | | waidohuy0 -
No crawl code for pages of helpful links vs. no follow code on each link?
Our college website has many "owners" who want pages of "helpful links" resulting in a large number of outbound links. If we add code to the pages to prevent them from being crawled, will that be just as effective as making every individual link no follow?
Technical SEO | | LAJN0 -
Root domain ranks higher than sub pages
Our website is over 10 years old and has been very successful with google. We rank highly for our keywords, but recently a strange thing has happend. Google has indexed a video from our front page (which no longer exists) and shows this listing instead of the sub pages. This means the listing is irrelevant to the search term. Term is "Junior Cricket Bats"
Technical SEO | | NickKer
https://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGLL_en-GBGB377GB377&q=junior+cricket+bats should some up with this page
http://www.cricketsupplies.com/junior-cricket-bats.asp but shows the root domain
http://www.cricketsupplies.com/ with this video link which does not exist We should be ranking really well , and were , but now not so good , even though SEOmoz loves our pages if anybody can see anything obvious i would be thanksful. regards0 -
What Are The Page Linking Options?
Okay, so I'm working with a site that has pretty good domain authority, but the interior pages are not well linked or optimized. So, it ranks for some terms, but everything goes to the home page. So, I'd like to increase the authority of the interior pages. The client is not wild about spreading targeted juice via something like a footer. They also don't like a "Popular Searches" style link list. The objection is that it's not attractive. They currently use cute euphemisms as the linking text, so like "cool stuff" instead of "sheepskin seat covers." In that made up example, they'd like to rank for the latter, but insist on using the former. What about a slide show with alt text/links? Would that increase the authority of those pages in a term-targeted kinda way? Are there other options? Does it matter how prominent those links are, like footers not as good as something higher up the page? They currently use a pull-down kind of thing that still results in some pages having no authority. Do bots use that equally well? Thanks!
Technical SEO | | 945010 -
Onpage linking
On my homepage, I currently link to about 40 internal pages. I'm considering altering the internal linking structure to have 50-100 links on the 2nd level pages. If I was to do this, I'd only need 8 homepage links. Do you think the 8 pages linked from the homepage would go up in the SERPs as the pagerank would be less diluted? I've heard so many mixed views on this. Be interested to see what people here think. Thanks, Pete
Technical SEO | | PeterM220