Do you ever say to yourself: “I really wish I had a spreadsheet that would give me awesome graphs about my link profile distribution”? No? Just me? I doubt it.
Some days we need to have a quick way of visualizing our link profile to know where we stand. All linkbuilders and SEOs are looking for a “natural” link profile. We want a profile that has some lower domain authority links, some good solid DA links, and some awesome links (Moz, Distilled, NY Times) (maybe not the Wall Street Journal because you’ve probably been caught buying links. Oops!). But how can you find such a visualization, and fast?
Well, you could build out a spreadsheet to do it for you, but that’s going to take up some of your valuable billable time (and bosses like billable time).
To help you out (by keeping your boss happy and you with a job), I have found a couple of Excel spreadsheet templates that you can/should use to give you a visualization of the PA of links to your site broken down by increments of 10, one to help you find the DA broken down in the same way, and one to give you the top 10 keyword phrases included in links to your site.
In this post, Dr Pete provides a downloadable Excel spreadsheet wherein you can copy and paste your OSE export. It will clean the data and provide you with a graph of the distribution of PA across your backlinks.
I do highly recommend reading the post as it explains the reasons for these graphs well, but if you want the spreadsheet, Link Profile from Dr Pete.
Excel Spreadsheet to find the distribution of DA across your backlinks
This downloadable spreadsheet is the same as the one available above, but I have hacked it so that you receive the Domain Authority distribution across your backlinks. Since our industry now believes that the DA greatly affects the strength of a link, I thought this might be helpful.
Here’s the spreadsheet: Link Profile DA TEMPLATE.
Here’s a pretty graph that you will get from it:
Finally we’ve got Ian Bowden’s Anchor Text Distribution Spreadsheet. Once again using OpenSiteExplorer, this spreadsheet will visualize your anchor text distribution. This is helpful in order to see if any of your anchor text is unduly out of proportion and therefore looking unnatural.
I hope these sheets are helpful to you!