This tool helps us track keywords throughout the life of SEO campaigns – we use it as a part of our monthly reports for clients.
The tool runs in Google Sheets, pulling data from Google Analytics, Ahrefs and SEMrush and generate incredibly helpful keyword rank tracking reports.
We don’t like sending spreadsheet reports to clients, so we built a Google Data Studio template to visualize the data.
The keyword tracking report calculates and builds the following reports for you:
It’s an incredibly simple yet powerful way to track keyword ranking progressions over the course of am SEO campaign.
All that’s required to get started is access to SEMrush, Ahrefs, or any other keyword tracking tool.
Let’s walk through the tool in more detail…
Find out exactly how many customers you SHOULD be getting from organic search.
The total number of keywords in the top 2, top 10 and top 100 since your campaign started (also this month and last month). This is an incredibly simple and effective visual for client reporting, it clearly communicates how keywords rankings have shifted since you began work.
Keyword rankings in Google across your site segmented by average position and search volume. The true power of the tool is the keyword ranking comparison, showing you how these keywords are tracking this month, last month and since the start of your campaign.
A 2 page report tracking your key target pages and important keywords. We use these reports to completely reduce any need for external rank tracking software.
We built a simple to use interface that walks you through the details of how to run the report.
The tool is available for FREE in our training platform, along with step by step video guidance on how to set it up.
Find out how much organic traffic your website should be getting through our Traffic Projection Analysis.SHOW ME OUR POTENTIAL!
Using data from your website, our Traffic Projection analysis can accurately forecast how much traffic (and revenue) your website could be getting from Google.FIND OUT MORE