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.
Which information I tracked and why
- Blog post name: Here you can put the title of the blog post.
- Target keyword: Here you put the keyword your article was focused for.
- Author: name of the author.
- 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.
- Rank on Google: for example: 3rd, 4th, Top10 etc. To know how to track ranks on Google, read my this article.
- 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.
- URL: link to the published blog. You would be able to jump to the URL of the post directly from the sheet.
- Date Published: the date the article/post got published.
- 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.
- Last SEOed: When was the last time you SEOed the content. Beneficial if the content was not SEOed before publishing.
- Language: Whether the content was written in English, German etc.
- Needs improvement: Does the SEO needs improvement or not?
- Social Media Sharing: Was the content shared on social media? Yes or no.
- 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.
- 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.
- Screenshot: link to the screenshot of the rank on Google.com. Pictures look better for presenting your work.
- 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.