SEO Templates and Worksheets – 2nd edition

Here are all the templates, worksheets, and sample documents we reference in our book, SEO: An Hour A Day (2nd Edition). These tools are free for you to download and use!

Note: This is an archived page for the second edition book.

Looking for other edition worksheets?

Download the full list of worksheets in PDF format, or download individual worksheets chapter by chapter:

  • The Goals Worksheet [DOC] Word Document can be used to clarify your business goals and the goals of your SEO campaign. This worksheet will help you lay the foundation for your entire SEO campaign. (Chapter 1) . {Note: this worksheet is meant to be printed out and filled out by hand. If anyone has made a verson for filling out on the computer, we hope you’ll email it to us so we can share it with other readers!}
  • The SEO Growth Worksheet [DOC] Word Document helps you determine your room to improve the search engine presence of your website. (Chapter 1)
  • The Keywords Worksheet [XLS] Excel Spreadsheet is where you can list possible target keywords for your website, along with important measures that will help you finalize your top picks. (Chapter 6)
  • The Site Assessment Worksheet [DOC] Word Document provides a checklist of factors to quickly assess the current optimization level of your website’s landing pages. (Chapter 6)
  • The Rank Tracking Worksheet [XLS]is an Excel spreadsheet that you’ll use every month to document your website rank and indexing status, both key indicators of your search engine visibility.
  • The Task Journal Worksheet [DOC] Word Document is a simple template that allows you to stay focused on Your SEO plan by giving you a place to record outstanding questions, thoughts, and issues that come up as you work. Rather than constantly going off on tangents, you will revisit your Task Journal items when time allows.(Chapter 6)
  • You can use the Competition Worksheet [XLS]Excel Spreadsheet to document the basic site optimization and search engine presence of your major competitors. (Chapter 6)
  • The Site Optimization Worksheet [DOC] Word Document provides a template for detailing the edits you will need on your website. (Chapter 7)
  • The Link Tracking Worksheet [XLS]is an Excel spreadsheet where you can document your ongoing link building communications.  Keeping this information organized will help you keep track of gains made and avoid embarrassing faux-pas such as re-sending a link request after already being accepted. (Chapter 7)

Looking for the sample link building letter? Click to read our article and see sample content.

{ 7 comments… read them below or add one }

Richard Ayre January 4, 2011 at 11:55 am

Hello I’m working through the 2nd edition book – excellent so far (much better than the rest) – but have hit a small snag. Page 135 says to refer to the companion website on here for a current list of search shortcuts and instructions (for tracking existing inbound links), but I can’t find it. Can you point me in the right direction please.

Regards

Richard

Gradiva Couzin January 6, 2011 at 12:58 pm

Hi Richard, the page you’re looking for is here: http://www.yourseoplan.com/search-shortcuts/ Thanks!

Gradiva

Tayo January 13, 2011 at 5:53 am

Hi,

Thank you soo much for the work in making SEO easier to understand. I have recently started reading your 2nd edition and finding it very informative.

Are there significant differences between 2nd and 3rd editions?

Regards

Tayo

Gradiva Couzin January 18, 2011 at 1:54 pm

hi Tayo,
So glad to hear the book has been helpful to you! There are quite a few differences between the 2nd and 3rd edition. The 3rd edition is fully updated with today’s SEO best practices. It has a great deal of additional info on social media and online word-of-mouth venues, including Facebook and Twitter. We have also expanded our discussions of Local and Shopping search, as well as video, image, and mobile. It was a ton of work and I’m REALLY proud of the 3rd edition! I hope you will have a chance to check it out.
Best regards,
Gradiva

Adam May 31, 2011 at 11:40 pm

Hi Gradiva,

I originally purchased the 2nd edition of your book and started reading that, but now however I have purchased the 3rd edition to catch up on the additions. Are there any particular areas that have been heavily added to? More so than the others? I am trying to be efficient about what I reread.

Thank you,
Adam

Gradiva Couzin June 1, 2011 at 10:43 am

hi Adam,
Thanks for being a repeat purchaser! Although there are updates throughout the book, you’ll see the most in the “Right Now” of search (Chapter 4) and in the more advanced weekly assignments, Chapters 8 and 9, especially Social Media Marketing (p. 226), Selling through Search (p. 262), Local Search (p. 277), and Special opportunities (p. 300).
Best,
Gradiva

Myra Yelland September 13, 2011 at 4:20 am

Hi,
Thank you for the excellent book. I am now capable to do my won website SEO myself. Thank you very much.

Leave a Comment