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
-
Migrating domains from a domain that will have new content.
We have a new url. The old url is being taken over by someone else. Is it possible to still have a successful redirect/migration strategy if we are redirect from our old domain, which is now being used by someone else. I see a big mess, but I'm being told we can redirect all the links to our old content (which is now used by someone else) to our new url. Thoughts? craziness? insanity? Or I'm just not getting it:)
Technical SEO | | CC_Dallas0 -
Does a sub-domain benefit a domain...
I have seen some mixed comment as the whether a sub-domain would benefit from the authority built up by its domain... but does a domain benefit from a sub-domain?
Technical SEO | | Switch_Digital0 -
Too Many Page Links
I have 8 niche websites for golf clubs. This was done to carve out tight niches for specific types of clubs then only broadens each club by type - i.e. better player, game improvement, max game improvement. So far, for fairly young sites, <1 year, they are doing fairly well as I build content. Running campaigns has alerted me to one problem - too many on-page links. And because I use Wordpress those links are on each page in the right sidebar and lead to the other sites. Even though visitors arrive via organic search in most cases they tend to eventually exit to one of the other sites or they click on a product (Ebay) and venture off to hopefully make a purchase. Ex: Drivers site will have a picture link for each of the other 7 sites. Question: If I have one stie (like a splash page) used as one link to that page listing all the sites with a brief explanation of each site will this cause visitors to bounce off because they will have one click, than the list and other clicks depending on what other club/site they would like to go to. The links all open in new windows. This would cut down on the number of links per page of each site but will it cause too much work for visitors and cause them to leave?
Technical SEO | | NicheGuy0 -
Why is there duplicates of my domain
When viewing crawl diagnostics in SEOmoz I can see both "www.website.com" and a truncated version "website.com" is this normal and why is it showing (I do not have duplicates of my site on the server)? E.g.: http://www.klinehimalaya.com/
Technical SEO | | gorillakid
http://klinehimalaya.com/0 -
Links to Website Author
I'm a website developer, and in the past I have usually added a tiny backlink to the footer of my clients' websites like this: Website Design by MyCompanyName I understand that Google sees this as a low-quality backlink. However, I was wondering if such links can hurt my rankings. Does Penguin sees these links as spam? If so, should I add a rel="nofollow" to the links? Is there anything else I should change? I do not want to remove these links completely because they are good for marketing my business. I just want to minimize any negative SEO impact of the links. I appreciate your input. Thanks.
Technical SEO | | SiteWizard_LLC0 -
Google Shows 24K Links b/w 2 sites that are not linked
Good Morning, Does anyone have any idea why Google WMT shows me that i have 24,101 backlinks from one of my sites ( http://goo.gl/Jb4ng ) pointing to my other site ( http://goo.gl/JgK1e ) ... These sites have zero links between them, as far as I can see/tell. Can someone please help me figure out why Google is showing 24k backlinks? Thanks
Technical SEO | | Prime850 -
Too Many Internal Links?
Hi Guys, I'm completing a overhawl of our website at the moment have a certain penguin killed our site for our main keyword. I'm currently working on our internal linking as most of our blog posts have a link back to our home page with the main money keyword. At present we have 3,331 internal links and our site has only 1,000 pages. Can you get penalised for having too many internal links with exact match anchors. Thanks, Scott
Technical SEO | | ScottBaxterWW0 -
Domain.com and domain.com/ redirect(error)
When I view my campaign report I'm seeing duplicate content/ meta for mydomain.com and mydomain.com/ (with a slash) I already applied a 301 redirect as follows: redirect 301 /index.php/ /index.php Where am I messing up here?
Technical SEO | | cgman0