A Complete Template To Track Your SEO

It’s important to track SEO so that we can see how it is going. Good results gives confidence to move on and bad results gives us a chance to improve over. Both makes sense. Let’s see how I tracked SEO over time for WordPress posts. This template can also be applied to pages as well.

Why it is beneficial: This keeps the track of your SEO efforts at fingertips and makes you more confident when presenting your SEO success reports to your co-workers, managers etc

(SEOed= Search engine optimized)

Here are some of the screenshots.

 

seo tracking sheet
preview of SEO tracking sheet

 

preview of SEO tracking sheet 2
preview of SEO tracking sheet 2

Which information I tracked and why

  1. Blog post name: Here you can put the title of the blog post.
  2. Target keyword: Here you put the keyword your article was focused for.
  3. Author: name of the author.
  4. Keyword characteristics: Whether it was researched using tools, or was it came through a natural thought. It might help you getting an idea what worked the best.
  5. Rank on Google: for example: 3rd, 4th, Top10 etc. To know how to track ranks on Google, read my this article.
  6.  Other keywords, the content ranks for: It might be possible that you also rank for other keywords as well instead of just the keyword focussed on.
  7. URL: link to the published blog. You would be able to jump to the URL of the post directly from the sheet.
  8. Date Published: the date the article/post got published.
  9. SEOed before publishing: Was the content SEOed before publishing or not? This can help you track whether optimizing the article before publishing worked best for you or vice versa.
  10. Last SEOed: When was the last time you SEOed the content. Beneficial if the content was not SEOed before publishing.
  11. Language: Whether the content was written in English, German etc.
  12. Needs improvement: Does the SEO needs improvement or not?
  13. Social Media Sharing: Was the content shared on social media? Yes or no.
  14. Backlinks: Did you contact any other blogger or website to get some links back to your website. If yes, mention it here. Information at one place seems better.
  15. Page Views etc. on Google Analytics: link to Google Analytics of that particular page. You can also mention the page views number itself in the column but it would keep on changing.
  16. Screenshot: link to the screenshot of the rank on Google.com. Pictures look better for presenting your work.
  17. Comments: any comment you think you have related to the article or related to the rank you tracked over time. I generally comment every time I track the rank as it gives an idea how the SEO is performing and can help learning the trends.

I have used these types of tracking sheets in my internships and they work really well! An alternate SEO tracking template by HubSpot is here.