Content Decay Finder: Pages Losing Clicks Between Two Search Console Exports

Paste the Pages export of an earlier and a later period. The tool lists pages that lost clicks, how much, and whether impressions, position or CTR changed.

Use the tool

Why this tool exists

Content slowly loses traffic as it ages, competitors update and demand shifts. The pages that lost the most clicks are the best candidates to refresh first.

The hint tries to tell causes apart: a worse position points to ranking, fewer impressions point to demand or visibility, and steady rank and impressions with fewer clicks point to the snippet or SERP features. These are rules of thumb. Use periods of the same length, think about seasonality, and remember Search Console exports are limited to 1,000 rows.

How to use it

  1. Export Pages from Search Console for the earlier period and paste it in the first box.
  2. Export the later period and paste it in the second.
  3. Set the minimum earlier clicks and minimum drop.
  4. Open the worst pages and refresh or fix them.

Frequently asked questions

Which columns are needed?

A page column first, then Clicks. Impressions and Position make the hints better.

Why is a page missing from the later file?

It may have no impressions now, or fall below the 1,000 row export limit.

Which periods should I compare?

Equal lengths, ideally the same season, for example the last 3 months against the 3 months before, or year on year.

Is the hint a diagnosis?

No. Confirm in Search Console and check the page.