Search Performance Anomaly Detection

By David Krevitt from CIFL

The first time I looked at this template’s results for my blog, my eyes popped out. I was shocked at how my search performance was thrashing week-to-week and month-to-month, without me having any idea. Search impressions were spiking for my target keywords. CTRs were plummeting when meta descriptions were accidentally deleted.

This template helps you keep track of those inevitable spikes (and dips) in your search performance, by bringing a bit of statistics into Google Sheets.

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

Note: The free version of this template requires Supermetrics, a paid Sheets Add-on. The Pro version pulls data via Google Apps Script and requires no additional tools.

Not sure where to start your keyword research?

How it works?

First, it uses the Search Console API to pull your search performance data into Sheets: impressions, clicks and CTRs by landing page and query.

Then, it analyzes each page and query combination’s performance over a chosen period (one week or one month), to find any outliers hiding in your data.

All you need to decide is two things:

How many search impressions must a page have to be on your radar? Default is simply above average.
What counts as an anomaly? Default is 25% above or below daily moving average.

And the template will show you anomaly pages – both positive and negative – that are performing outside their normal ranges of impressions, CTRs and clicks.

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.