Welcome to the Q&A Forum

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?

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..

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!