Search Performance Anomaly Detection
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.
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.