Monthly Keyword Tracking
When you’re working with clients on SEO, it helps to have a validated, third-party data source to rely on when tracking progress. For many of us, that data source is SEMrush.
This template connects to the SEMrush $15 API, to snapshot keyword performance data each month, and retain a running log of progress for an SEO project.
How it works?
It produces a running monthly report, tracking keywords gained and lost, rising and falling.
Most importantly, it also calculates the traffic-weighted ranks and CPCs of those transitions – so you can understand whether those raw keyword wins and losses have any impact on the site.
The template also has an interactive data browser, where you can:
Search for progress over time of specific pages and keywords
Pull all keywords gained / lost / rising / falling in a given time period
Use this as a swiss army knife for producing keyword tracking reports for your clients (or boss).
And if you’re a fan of Google Data Studio, this template is configured to send data into your dashboard reports..