SEO Monthly Data Studio Reporting (SEMrush)

By David Krevitt from CIFL

This template generates monthly SEO campaign reporting in Data Studio, allowing you to share a beautiful visual report with your clients.

The report calculates the following KPIs for you:

  • Overall keyword counts, search volume and traffic value (sliced by top 10 and top 20 keywords)
  • Top landing page + keyword combinations
  • Rising, falling, and newly added keywords

Top 10 Keyword Performance by Month

Subscribe to RankTank Pro!
Step 1:
Step 2:
Get the Pro Sheet SEO tool!
Subscribe and get access to this Google Sheet as well as many other Pro Sheet SEO tools!

Current Version: 1

Not sure where to start your keyword research?

How it works?

Using the sweet date comparison functionality of Data Studio, it reports on these changes month-over-month, and over the life of your campaign.

Top 20 Keyword Performance Month on Month

All that’s required to get started is access to SEMrush, in order to export keyword reports from the start of your campaign, last month and this month.

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.