We have all most likely used an Excel spreadsheet in the past to organize some information into a list – using them for link building campaigns though is a must to keep track of all the links going out and coming in.
Ann Smarty at Search Engine Journal has a great short blog piece on link building worksheets. Remember though, these are just examples…do not use an exact variant of the examples below but pick and choose from each and add custom elements of your own that you see fit.
The first example from Garrett French of Link-Building-Guide.com is a comprehensive and concise worksheet that promotes an advanced approach to link building…evaluate each linking page and track keywords in the title, text and within tags. This guide provides a systematic approach to link acquisition and takes into account many advanced SEO features like crawlers and massive amounts of link data.
Another link building spreadsheet from Kalena describes organizing a spreadsheet for directory submissions. Her system creates 5 or 6 Excel worksheets for different aspects of the link building campaign – columns in each workbook have the same headings. Read more about Kalena’s system here.
YourSEOplan also gives suggestions on how to construct a link building worksheet along with examples you can download…columns include: URL of linking page, requested landing page, contact e-mail, date requested, link received? (Y/N) and notes.
Two more examples, Raven Tools and WordStrea, are given in the comments section of Ann’s blog.
Also, see this forum discussion at Sphinn for more insights.
