Content Decay Radar

Q: What if my export doesn't have a Query column?

The tool still rolls up decay by page, with a GSC deep-link generated from your Property ID so you can look up keywords manually in your live dashboard.

Q: What does the Looker Studio Delta Detected reverse-math note mean?

When an export only includes a percentage change, the tool works backwards from current clicks and the percentage to estimate previous clicks. Treat it as a close estimate rather than exact.

Q: What's in the exported Rewrite Action List?

One row per decaying page with its severity, total clicks lost, top lost keywords or a GSC deep-link, and a blank column for the writer to fill in.

Identify decaying pages (and the exact keywords causing the loss, if provided).

Upload Comparison CSV

How to get your Comparison Export (3 Methods)

Advanced (Best Data)

Looker Studio

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

Alternative (Best Data)

Sheets Add-on

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

Basic Check

Standard GSC

Log into standard GSC Performance report.
Click the Date filter -> COMPARE tab. Apply a comparison.
Click Export (top right) -> Download CSV.
Upload ONLY the Pages.csv file here.

Looker Studio Delta Detected: We reversed-engineered your previous clicks based on your percentage drop column.

Triage Filter

URL / Keyword Search

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.

☕

This tool is free to use

If it saved you some time, consider buying me a coffee to support future updates.

Buy me a coffee

What does Content Decay Radar do?

Content decay is when a page that used to perform well in search gradually loses clicks — often because the content has gone stale, a competitor published something better, or the search intent behind the query shifted. This tool takes a period-over-period Google Search Console comparison export and rolls it up by page (or by query, if no page column is present), triaging every target into Severe Decay, Moderate, Stagnant, or Growing based on both the raw click loss and the percentage change.

Where a Query column is present, decaying pages get an expandable "View Lost Keywords" breakdown showing exactly which search terms are behind the loss — the keywords worth doubling down on when rewriting. Where it isn't (a standard GSC export), enter your Property ID to get a direct deep-link into GSC's own dashboard, pre-filtered to that page and comparison period. Export a prioritised rewrite action list once you're ready to work through it.

Frequently asked questions

Is Content Decay Radar free to use?

Yes, completely free with no account or usage limit.

What counts as "severe" vs "moderate" decay?

Severe requires losing at least 10 clicks and at least a 15% drop versus the previous period. Moderate requires losing more than 5 clicks and more than a 5% drop. Anything gaining more than 10 clicks and 5% is marked Growing; everything else is Stagnant. Both the raw number and the percentage need to cross the threshold, so a small page losing 100% of a tiny click count isn't automatically flagged Severe.

What if my export doesn't have a Query column?

The tool still works — it rolls up decay by page instead of by query, and shows a warning that the keyword drilldown is unavailable for that upload. Enter your GSC Property ID in the box that appears and you'll get a direct link into your live GSC dashboard, pre-filtered to that page, so you can look the keywords up manually.

What does the "Looker Studio Delta Detected" reverse-math note mean?

Some exports (particularly from Looker Studio) only include a percentage change column, not the actual previous-period click count. When that happens, the tool works backwards from the current clicks and the percentage to estimate the previous figure. It's arithmetically sound given the data provided, but any rounding already present in the source percentage carries through, so treat the reconstructed previous-clicks figure as a close estimate rather than an exact one.

Is my Search Console data uploaded anywhere?

No. The CSV is parsed and analysed entirely in your browser using PapaParse — nothing is sent to a server.

What's in the exported Rewrite Action List?

One row per decaying page (Severe or Moderate only), with its severity, total clicks lost, and either its top three lost keywords to prioritise (if query data was available) or a direct GSC deep-link (if it wasn't) — plus a blank "Action Required" column for whoever's doing the rewrite to fill in.