Find content decay with AI
Content decay is when a page that used to earn clicks slowly loses them. The prompt below compares your last 28 days of Search Console data with the 28 days before, lists the pages and queries losing clicks, separates ranking losses from falling demand, and gives you a refresh list for this month in priority order.
The prompt
Paste it into Claude, ChatGPT or any client connected to the Google Search Console MCP server. Replace [your property] with your site.
Using Search Console data for [your property], find content decay: pages losing clicks in the last 28 days compared with the previous 28 days. 1. List the declining pages with clicks, impressions and average position for both periods, sorted by clicks lost. 2. For each decliner, classify the cause: position got worse (ranking loss), position stable but impressions fell (less demand), or position and impressions stable but clicks fell (CTR loss). 3. For the top 3 decliners, show me a daily chart of clicks and impressions over the last 90 days, so we can see whether the drop was sudden or gradual. 4. Also list the queries losing the most clicks, and which page each belongs to. End with a refresh list for this month: up to 5 pages, in priority order, each with the cause and the one thing to do about it. Leave out pages where the drop is under 5 clicks.
What the agent does
Tools it calls, in order: search_insights, search_chart. About 2 to 5 data pulls per run (what counts as a data pull).
- Compare the two periods. The agent calls
search_insightswith themoversrecipe. It returns decliners, risers, new pages and lost pages for the current window against the previous one of the same length, with clicks, impressions and position for both. One data pull. Ask forby: queryas well if you want the losing queries (a second pull). - Classify each drop. No extra call: the agent reads the position and impression changes. Worse position means a ranking loss; stable position with fewer impressions means demand fell; stable both but fewer clicks means CTR dropped.
- Chart the shape. For the top decliners, the agent calls
search_chartfiltered to each page. In Claude this renders an interactive daily chart in the conversation; in other clients it comes back as a compact daily series. A cliff on one date points to a change (an update, a migration, a lost snippet); a slow slope points to staleness or new competition. One data pull per page.
A typical run is 2 to 5 data pulls. If the agent finds no decliners, the run ends after the first call.
Example output
This is a real run on mcpsearchconsole.com. Over 28 days (2 to 30 September 2026 against 5 August to 1 September), the movers recipe found no decliners at all: clicks went from 12 to 37 and every page with clicks was rising. That is an honest result for a young site, and it is what you should expect to see when nothing is decaying.
To show what a decliner looks like, the same recipe was run over a 14-day window (16 to 30 September against 2 to 15 September 2026):
| Page | Clicks | Impressions | Avg position | Cause |
|---|---|---|---|---|
| /blog/connect-google-search-console-to-grok-bot | 6 to 1 | 368 to 38 | 5.3 to 5.4 | Demand fell |
| /blog/connect-google-search-console-to-claude | 1 to 0 | 39 to 18 | 8.1 to 13.8 | Ranking loss |
| / (homepage, riser) | 8 to 18 | 574 to 381 | 27.5 to 13.2 | Improving |
The two decliners have different causes. The Grok guide held its position (5.3 to 5.4) while impressions fell by about 90%: people stopped searching for it as much, which fits a burst of interest that faded. The Claude guide lost position (8.1 to 13.8), falling off page one: a ranking loss. The search_chart call for the whole property over 56 days showed the same burst: daily impressions peaked at 200 on 2 September and settled between 25 and 55 a day in the second half of the month.
The verdict for this month: refresh the Claude guide (a real ranking loss on a page with steady demand), and leave the Grok guide alone, because its ranking held. Both drops are small in clicks; on a bigger site the agent would leave them out under the 5-click threshold in the prompt.
How to act on it
Each decliner's cause decides what to do with it.
- Ranking loss (position got worse). Refresh the page: update facts, dates and examples, add what newer results cover that yours does not, and check it is still indexed. These go to the top of the list. Pages slipping from page one into positions 11 to 20 also show up as striking-distance keywords.
- Demand fell (position stable, impressions down). Usually not fixable on the page: the topic is seasonal or interest has faded. Check the same period last year if you have it. Do not rewrite a page that still ranks well just because fewer people search.
- CTR loss (position and impressions stable, clicks down). Something changed on the results page, such as a new AI Overview, or Google rewrote your title. Treat it as a low-CTR page and work on the snippet.
- A sudden cliff on one date. Look for a cause before refreshing: a deploy, a redirect, a robots.txt change, a lost canonical. Run the free
check_redirectsandcheck_robotstools on the URL. If you recorded site changes as notes, ask the agent to read them. - Lost pages (clicks before, none now). Check they still exist and are indexed before anything else.
Refresh no more than a handful of pages a month, in the order the agent gives, and re-run the prompt next month to see which recovered.
Variations
Limits
- It cannot tell you why demand fell. Search Console shows impressions dropping but not whether the topic is seasonal, a trend ended or AI answers are absorbing the search. Use your own knowledge of the market.
- Short windows are noisy. A 28-day comparison can catch a holiday or a one-off spike. The example's 14-day window was used only to show decliners on a small site; on your own site, prefer 28 days or longer.
- Up to 16 months of history. Search Console keeps about 16 months of data, so year-on-year checks are limited to recent months.
- No competitor data. A ranking loss usually means someone else gained, but Search Console does not show who.
- Anonymized queries. Query-level decliners can miss rare searches that Google withholds, even when the page-level numbers include them.
If you run this every month, pair it with a weekly SEO report to catch cliffs earlier. To connect first, follow the guide to use Search Console in Claude, where search_chart renders as a live chart.
Questions
Related use cases
- Find striking-distance keywords with AI
- Fix low-CTR pages with AI
- Automate a weekly SEO report with AI
Run this on your own site in about a minute.
Connect Search Console free