This content decay analyzer compares two Search Console exports from different periods and ranks your pages by the clicks they have lost. Every losing page gets a clear call — refresh it, rewrite it, or merge it into a stronger page.
How to use
- Export the Pages report from Search Console for an earlier period (CSV).
- Export the same report for a recent period of the same length.
- Paste both CSVs here and press Analyze decay.
- Work through the losing pages from the top, starting with the biggest click losses.
About this tool
Content decays: facts go stale, competitors publish better pages, and search intent shifts. Paid SEO suites now sell “content decay” alerts as a feature — but the maths is simple, and this tool does it in your browser. It matches pages across your two exports, computes the change in clicks, impressions and average position for each, and ranks the losers by clicks lost.
The action suggestion follows the page’s situation: a page still on page one or two usually needs a refresh; one that has fallen past position 20 with most of its clicks gone usually needs a rewrite or a merge. Comparing two equal-length periods (for example two 28-day windows) keeps seasonality from skewing the result.
How do I use this tool?
- Paste the earlier period’s Pages CSV into the first box.
- Paste the recent period’s Pages CSV into the second box.
- Click “Analyze decay” to see losing pages ranked by clicks lost.
- Use “Load sample” to see the expected CSV format first.
Where is this tool used?
Bloggers and site owners run a decay check every quarter, or whenever traffic slides without an obvious cause. It turns a vague “traffic is down” into a prioritised fix list: the five pages losing the most clicks are usually worth more than ten new posts. Agencies use the same comparison to show clients exactly which refreshes earned traffic back.
What are the limitations?
This tool only sees the two CSVs you paste — it cannot connect to Search Console, and it cannot tell you why a page decayed (a Google update, a stronger competitor, or stale content all look similar in the numbers). Check the live search results and the page itself before deciding between refresh, rewrite and merge. Pages missing from the recent export are treated as having zero clicks, so a changed URL will look like a total loss — match URLs carefully.
Frequently asked questions
What is content decay?
Content decay is the slow loss of search traffic as a page goes stale — its facts age, competitors publish better pages, or search intent shifts. A decay analysis finds the pages losing the most clicks so you can fix them first.
Which periods should I compare?
Two equal-length periods work best — for example the last 28 days against the 28 days before that, or this quarter against last quarter. Unequal periods make the click changes misleading.
How do I export the data from Search Console?
In Google Search Console, go to Performance, then Search results, switch to the Pages tab, set your date range, and export as CSV. Do it once for the earlier period and once for the recent period.
Refresh, rewrite or merge — how do I choose?
Refresh when the page still ranks on page one or two and just needs updated facts. Rewrite when it has fallen past position 20 and lost most of its clicks. Merge when the topic is better served by a stronger related page — then 301-redirect the old URL.
Updated November 2026 · Built and tested by Sharjeel Tahir · How our tools are tested