Skip to content

Free Search Console tool

Content Decay Checker

The Content Decay Checker reads a Google Search Console comparison export and finds the pages losing organic clicks period on period. It sorts every URL into Severe, Moderate, Stagnant or Growing, shows the keywords behind each drop where your export includes them, and exports a prioritised refresh list.

  • 100% free
  • No sign-up
  • Runs in your browser
How to get your Comparison Export (3 Methods)
Advanced (Best Data)

Looker Studio

  1. Create a blank report in Looker Studio. Add Data -> GSC -> URL Impression -> Web.
  2. Add a Table chart.
  3. Dimensions: Landing Page and Query.
  4. Metrics: Clicks.
  5. Default Date Range: Change from Auto to Advanced. Set a comparison (e.g., Last 3 months vs Previous 3 months).
  6. Export the table to CSV.
Alternative (Best Data)

Sheets Add-on

  1. Install Search Analytics for Sheets.
  2. Select your website.
  3. Set the Date Range to Compare.
  4. Group By: Query and Page.
  5. Click "Request Data", then download as CSV.
Basic Check

Standard GSC

  1. Log into standard GSC Performance report.
  2. Click the Date filter -> COMPARE tab. Apply a comparison.
  3. Click Export (top right) -> Download CSV.
  4. Upload ONLY the Pages.csv file here.
Showing 0 Targets (Rolled up from 0 raw rows)
Target (Page or Query) Status Prev Clicks Curr Clicks Net Change Action
Upload a Comparison CSV to begin.

How it works

How to use the Content Decay Checker

  1. Export a comparison

    In Search Console’s Performance report, compare two date ranges, such as the last three months against the previous three, and export the data.

  2. Upload the file

    Exports with both page and query columns give the deepest analysis. Page-only exports still work.

  3. Review the triage

    Start with Severe decay, then expand each page to see which keywords lost the clicks.

  4. Export the action list

    Download the refresh plan with severity, clicks lost and the top lost keywords for every decaying page.

Why pages lose traffic over time

Very few pages hold their rankings forever. Decay usually creeps in quietly, one or two positions at a time, until a page that once brought in steady leads is barely visible. The most common causes are:

  • Outdated content. Old prices, statistics, screenshots or year references signal staleness to readers and search engines.
  • Stronger competitors. Someone has published a more complete, more useful answer.
  • Intent shifts. The kind of result Google rewards for a query has changed, for example from guides to product pages.
  • SERP changes. AI Overviews, video carousels or ads now push organic listings further down.
  • Internal cannibalisation. A newer page on your own site has started competing for the same terms.

How to refresh a decaying page

  1. Diagnose before rewriting. Check whether impressions fell (lost rankings) or only clicks fell (lower CTR at a similar position). They need different fixes.
  2. Re-check the SERP for the lost keywords and note what the current top results do better.
  3. Update facts, examples and dates, and add sections that cover what is now missing.
  4. Improve the title and meta description if CTR is the problem. The CTR Benchmark Tool shows which queries underperform for their position.
  5. Refresh internal links so newer content passes authority back to the page.

How often to check for decay

Quarterly comparisons suit most sites and smooth out week-to-week noise. If your business is seasonal, compare against the same period last year instead, so a normal seasonal dip is not mistaken for decay.

Questions

Content Decay Checker FAQs

What is content decay?

Content decay is a gradual loss of organic traffic to a page that used to perform well. It is usually caused by outdated information, stronger competitor content, or a change in what searchers want.

How are Severe and Moderate decay defined?

Severe means losing at least 10 clicks and at least 15% versus the previous period. Moderate means losing more than 5 clicks and more than 5%. Pages gaining over 10 clicks and 5% are Growing, and everything else is Stagnant.

What if my export has no query column?

The tool rolls decay up by page instead. Enter your Search Console property and it creates a deep link into your live dashboard, filtered to that page and date comparison.

Why does it mention Looker Studio reverse maths?

Some Looker Studio exports include only a percentage change, not the previous period’s clicks. The tool works backwards from current clicks and the percentage to estimate the earlier figure.

Is my Search Console data uploaded?

No. The CSV is parsed and analysed in your browser and is never sent to a server.

Work with The Search Foundry

Found the opportunities? Let's capture them.

We turn Search Console insight into content refreshes, internal linking and on-page changes that move rankings.