Content Auditing for Link Builders – Why You Should Do It, Tips, and a Spreadsheet

When it comes to link building, one of the toughest challenges I ran into was clients who only wanted links built to specific pages on their site. Sometimes it was just one specific page – their homepage, and other times it would be to their homepage plus various product pages. Pages that no one really would want to naturally link to unless they were already buying the products.

The best link building clients were the ones that were open to link building towards any of their pages, including and especially to their great content. There is nothing easier than link building for a website that actually has link worthy content – infographics, videos, whitepapers, tutorials, lists, or even just informative blog posts. The only thing you run into with these clients is keeping up with all of the great content that there is to link to on their site.

The Purpose of a Content Audit Spreadsheet

This is where a content audit spreadsheet comes in handy for link building. A content audit spreadsheet for link builders is simply an analysis of the top pieces of link worthy content on a website, organized in a way that makes it easy for link builders to find the right pages to propose in their link requests to other sites based on category. The main goals of this spreadsheet are as follows.

 

Now that I’ve hopefully sold you on the benefits of a content audit spreadsheet for link builders, let’s look at the information you will want to keep in yours.

Information for a Content Audit Spreadsheet

The following pieces of information are crucial for a great content audit spreadsheet that will serve as your ultimate link building tool for each client.

 

Additional Tabs

Most link builders probably have your own tools for recording links. If not, just add additional tabs to this spreadsheet for each piece of content or one additional tab for all of the links. On the link recording tab, enter the anchor text used for the link, domain the link was placed on, domain authority, traffic, page the link was placed on, page authority, contact name, and contact email. This way, you have great information to give to the client if they need proof of work, and you also have a great record of contacts to get links from on future projects.

Get the Spreadsheet

Content Audit Spreadsheet

Not in the mood to create a spreadsheet from scratch? Just grab the sample spreadsheet on Google Docs!

For Google Docs Users

If you are signed into your Google account, simply use the File > Save option to save this spreadsheet to your documents and start filling it in with your information.

For Excel and Open Office Users

If you don’t have Google Docs, or would prefer to save it on your local machine, go to the Google Docs version and use the File > Download As to save it as your desired file type. I’d suggest Open Office or Excel if possible for functionality.

How do you organize content for link building? What other details would you include? Please share your thoughts in the comments, and happy auditing!

Image credit: Joe Hall

Stay Updated: Sign Up for New Blog Alerts

Follow: | | |

Tags: , , , | Categories: Creative

13 thoughts on “Content Auditing for Link Builders – Why You Should Do It, Tips, and a Spreadsheet

  1. Thanks for sharing this spreadsheet Kristi Hines.
    Very useful document for everyone in the link building business.

    I’ll put additional SEOmoz metrics and that’s it. :]

  2. I’d like to add a little tip to help with social auditing. Download the Chrome Simple Social Buttons extension from Tom Anthony of Distilled.

    Simply click the icon on any page and view the tweets, likes and +1’s. Perfect for sites that don’t display all of the buttons or use counters.

    Download link for chrome:
    http://www.tomanthony.co.uk/downloads/simple_social_buttons.crx

  3. I have a similar spread sheet, but it auto fills the page authority and domain authoriy via SEOmoz’s api. Could you upgrade your spread sheet to do the same across all the fields?

  4. Kristi says:

    You’re welcome Ivan! What additional metrics are you adding?

  5. Kristi says:

    Wow – I love it! Just installed it and it works like a charm! :) Thanks Anthony!

  6. Kristi says:

    Not fully sure how to do that Joshua – does it work across all applications (Google Docs, Excel, Open Office, etc.)? I try to make mine very basic so people can use it anywhere.

  7. Great advice, got to admit I’ve never really seen the need to record my link building efforts but when you see the data you should be tracking it makes you realise how much this information can help. Has really opened my eyes. Thanks

  8. I love the extension. Thanks for sharing Anthony!

  9. Analitica says:

    I always use Majestic SEO, Alexa and OpenSite Explorer since YahooSiteExplorer closed.

    Yes, is very useful.
    Thank you.

  10. David Ewing says:

    Awesome worksheet!! This post came at the best possible time as I’m going through thousands of content pieces trying to arrange a content hierarchy

  11. eQuoteMD says:

    This is some good stuff, as always, Kristi.

    Question in regards to your spreadsheet. What is the difference between the columns for social data? As in “Baseline” and “Current.” The spreadsheet is quite similar to what I already use, but without both columns for measure social shares.

    Thanks again for the share!

    -Michael

  12. click site says:

    only just wish to help you help one fully understand document appreciate your own
    personal initiatives listed here but on the exact same effort my partner and i is the think that you will placed a good good deal
    associated with endeavor through when crafting this specific article> Types regarding ridiculous comme you will consider?

Comments are closed.