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?
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
-
Spammers created bad links to old hacked domain, now redirected to our new domain. Advice?
My client had an old site hacked (let's call it "myolddomain.com") and the hackers created many links in other hacked sites with links such as http://myolddomain.com/styless.asp?jordan-12-taxi-kids-cheap-T8927.html The old myolddomain.com site was redirected to a different new site since then, but we still see over a thousand spam links showing up in the new site's Search Console 404 crawl errors report. Also, using the links: operator in google search, we see many results of spam links. Should we be worried about these bad links pointing to our old site and redirecting to 404s on the new site? What is the best recommendation to clean them up? Ignore? 410s? Other? I'm seeing conflicting advice out there. The old site is hosted by the client's previous web developer who doesn't want to clean anything up on their end without an ongoing hosting contract. So beyond turning redirects on or off, the client doesn't want to pay for any additional hosting. So we don't have much control over anything related to "myolddomain.com". 😞 Thanks in advance for any assistance!
Technical SEO | | usDragons0 -
Treatment of domain names in content that are not actually a link
From PR activity we've found that lots of newspaper sites will include reference to a domain name in an article but not actually make this a link through to the domain. For example we will see text like: For further information read the full report at www.bluewidget.com Of course we make attempts to contact the newspaper to request they make it a link but this doesn't always achieve a result. So the question is, does Google place any value for the identified domain in a case like this?
Technical SEO | | bjalc20110 -
Backlink Profile: Should I disavow these links? Auto-Generated Links etc
Hello Moz Community, At first I wanted to say that I really like the Q&A section and that I read and learned a lot - and today it is time for my first own question 😉 I checked our backlink-profile these days and I found in my opinion a few bad/spammy links, most of them are auto-generated by pickung up some (meta) information from our webpage. Now my question is if I should dasavow these links over webmasters or if these links shouldn't matter as I guess basically every webpage will be picked up from them. Especially from the perspective that our rankings dropped significantly last weeks, but I am not sure if this can be the real reason. Examples are pages like: https://www.askives.com/ -Auto-Generates for example meta descriptions with links http://www.websitesalike.com/ -find similar websites http://mashrom.ir/ -no idea about this, really crazy Or we are at http://www.europages.com/, which makes sense for me and we get some referral traffic as well, but they auto-generated links from all their TLDs like .gr / .it / .cn etc. -just disavow all other TLDs than .com? Another example would be links from OM services like: seoprofiler.com Moreover we have a lot of links from different HR portals (including really many outdated job postings). Can these links “hurt” as well? Thanks a lot for your help! Greez Heiko
Technical SEO | | _Heiko_0 -
Redirect link from a particular domain
Hi guys/gals, I have a few domains and blogs which I use really for a bit of fun and experimenting. One of the domains (abc.com) wasn't doing much but has a few decent links built to it. I redirected this domain to an active blog (123.com). Here's the problem: There's a particular external link to the homepage of abc.com which drives a lot of traffic but isn't relevant to the content of 123.com which it redirects to, causing a huge bounce rate from this link. Is there a way (maybe using using htaccess) that I can redirect traffic from this one link to another domain completely? I've contacted the owner of the external site but they are unable (or unwilling) to change the link. I hope I haven't lost you all but shout if you need any clarification. Thanks in advance!
Technical SEO | | Confetti_Wedding0 -
2 home page domains causing split in link juice
We have 2 home page domains that are resulting in a split in links. We have mysite.com and mysite.com/index.php. The site is on Joomla and when we try and re-direct the /index.php to just mysite.com is causing an infinite loop. I have done this on other platforms with no problems - is this an issue because of Joomla? How can we complete a 301 re-direct to consolidate our link juice to one domain url?
Technical SEO | | devonkrusich0 -
Diagnostic says too many links on a page and most of the pages are from blog entries. Are tags considered links? How do I decrease links?
I just ran my first diagnostic on my site and the results came back were negative in the area of too many links one a page. There were also quite a few 404 errors. What is the best way to fix these problems? Most of the pages with too many links are from blog posts, are the tags counted as well and is this the reason for too many links?
Technical SEO | | Newport10300 -
If two links from one page link to another, how can I get the second link's anchor text to count?
I am working on an e-commerce site and on the category pages each of the product listings link to the product page twice. The first is an image link and then the second is the product name. I want to get the anchor text of the second link to count. If I no-follow the image link will that help at all? If not is there a way to do this?
Technical SEO | | JordanJudson0