SEO Templates & Worksheets – 1st Edition

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

Note: This is an archived page for the first edition book. Click for the current edition worksheets.

You can download ALL of the worksheet files (Word and Excel) in this zipped file: Worksheets.zip. Or, download the worksheets in .pdf format: Worksheet Pdfs.zip (by popular demand for the anti-Microsoft crowd!).

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)
  • 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)
  • The PPC Keywords Worksheet [XLS] Excel Spreadsheet is a convenient place to assemble all of the information you will be entering into your first PPC campaign. (Chapter 7)
  • The PPC Cluster worksheet [XLS]Excel Spreadsheet allows you to compare the performance of these keyword clusters. (Chapter 9)

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

{ 10 comments… read them below or add one }

peter laszlo January 31, 2010 at 7:05 am

I just started reding your book (second edition) in first chapter it is recomended to download the goals worksheet.
It is posible to download all work sheets in zip file however the goals worksheet is not included, and it is not possible to download it individualy. Any suggestions?

gradiva January 31, 2010 at 11:38 pm

Hi Peter,
I think you might be looking at the 1st edition downloads page. You should be able to download the Goals Worksheet by clicking on “The Goals Worksheet [DOC] Word Document ” on this page: http://www.yourseoplan.com/book/templates-worksheets/

I hope this helps! Thanks,
Gradiva

tsjiang June 21, 2010 at 3:06 am

I love this book.thank you.
tsjiang China sd

Jun July 28, 2010 at 7:07 pm

No SEO tools used, and other SEO strategy inputs? If you can provide that. That would be nice!

Cheers!

Gradiva Couzin July 29, 2010 at 9:26 am

Hi Jun,
For Tools, visit our favorite SEO Blogs and Tools. You can find lots more SEO strategy and commentary on our blog.
-Gradiva

ADee August 30, 2010 at 7:50 pm

I’m very glad to read your book!I think that’s very helpful.but there is still a little problem:can you give a chinese convertion of http://www.yourseoplan?haha,yah,I‘m chinese.

Gradiva Couzin September 8, 2010 at 10:51 pm

Hi Jun,
You can browse the site for other SEO resources, including our favorite SEO blogs and tools.
-Gradiva

Marco January 11, 2012 at 10:18 am

I have a question, why is the incoming link sheet removed from the third edition?

Gradiva Couzin January 11, 2012 at 2:49 pm

Hi Marco,
This worksheet was intended to help folks track the links they had received for their website; however, in more recent years we’ve found that it is easier to review link data on a tool such as OpenSiteExplorer.org or Google Webmaster Tools, rather than manually tracking inbound links.
I hope this answers your question! Thanks,

Gradiva

Andy Kuiper - SEO Analyst June 5, 2013 at 1:01 pm

Thanks for sharing these tools; I’m using the Link Tracking Worksheet… it’s perfect for me, slick and simple, thanks Gravity 🙂

Leave a Comment