Updated: February 28, 2019
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.
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.