Content Decay Finder Skill

Find the pages that are losing Google clicks and see why for each one, from your Search Console exports: rankings dropped, demand fell (seasonal or lost queries), click-through fell at the same position, or the page dropped out of search. Ranked by clicks lost, so you know what to refresh first.

python3 -m decay pages-before.csv pages-after.csv --csv reports       # two Pages exports
python3 -m decay compare-export.csv                                   # one comparison export
python3 -m decay api-rows.csv --split 2026-10-15                      # rows with a date column (API / BigQuery)

• Two Search Console Pages exports (Top pages, Clicks, Impressions, CTR, Position): first file is the earlier period.
• A comparison export (date filter > Compare): two columns per metric; the one labelled "Previous" is the earlier period.
• Dated rows from the Search Analytics API, Looker Studio, a Sheets add-on or the BigQuery bulk export (sum_position handled, anonymized and non-web rows skipped). With query + page rows it also lists the queries each page lost. Periods of different length are compared per day.

• Site clicks before vs after, decaying pages (default: lost at least 20% and 10+ clicks, --min-drop, --min-clicks) with clicks, impressions, CTR and position for both periods, the cause and the next step.
• Growing pages (up 20%+).
• CSV (--csv DIR): decaying-pages.csv and growing-pages.csv.

skills/content-decay/SKILL.md tells Claude Code (or any agent that reads skills) how to get the right exports, run the check and turn it into a refresh plan. Copy it into .claude/skills/; the kit is also a Claude Code plugin (.claude-plugin/plugin.json).

Run ./demo.sh for the examples (one page per cause, plus a page with lost queries) and ./run_tests.sh for the tests. Python 3.9+, no dependencies, works offline.

Causes are read from the numbers (position, impressions, CTR); it can't see competitors, the live results or algorithm updates. Compare with the same period last year before treating a seasonal dip as decay.

Pairs with the Keyword Cannibalization Checker Skill and SEO Log File Analyzer. License: LICENSE.txt.