TL;DR

Find content decay in Search Console by comparing stable periods, checking query and page shifts, and separating seasonality, indexing, and intent changes.

A systematic, data-driven method to identify, diagnose, and recover organic traffic lost to content decay using Google Search Console data, without guesswork or vanity metrics.

The Problem

Founders and content teams pour resources into creating SEO content, only to watch organic traffic plateau and then decline 6–18 months later. This phenomenon—content decay—is not a penalty or a Google algorithm update; it is the natural entropy of search results. Competitors publish fresher, more comprehensive content. User intent shifts. Google’s ranking algorithms favor recency, authority, and engagement signals that older pages lack.

The core struggle is detection. Most teams rely on a single metric—total organic traffic—which is a lagging indicator that masks which specific pages are decaying and why. By the time total traffic drops noticeably, dozens of pages have already lost 30–70% of their rankings. Without a structured detection system, teams waste resources refreshing the wrong pages, or they miss decay entirely until it compounds into a site-wide traffic cliff. The fix is not to create more content, but to build a repeatable, data-backed process for identifying exactly which pages are decaying, by how much, and what specific action will restore their performance.

Core Framework

Key Principle 1: Decay Is a Page-Level Signal, Not a Site-Wide Average

Aggregate traffic trends are useless for diagnosing decay. A site can lose 40% of traffic from 10 high-value pages while 200 other pages hold steady, making the average look like a minor 5% dip. You must analyze at the URL level. The mental model is a “decay score” per page: the rate of change in clicks, impressions, and average position over a trailing 3-month window compared to the prior 3-month window. Pages with a negative click trend and a position drop of 2+ spots are decaying. Pages with stable impressions but declining CTR (click-through rate) are suffering from SERP feature displacement (e.g., a featured snippet or “People also ask” box stealing clicks).

Key Principle 2: The Decay Funnel Has Three Stages

Not all decay is equal, and each stage requires a different response. Stage 1 is position decay: the page drops from position 3 to position 7 over 60 days. Stage 2 is impression decay: the page loses 50%+ of its impressions because Google no longer considers it relevant for its target queries. Stage 3 is click decay: impressions are stable, but CTR drops because the snippet or title tag is stale. You must diagnose which stage a page is in before deciding to refresh, rewrite, redirect, or retire. Refreshing a Stage 3 page (CTR decay) with new body content is wasted effort—you need to rewrite the title tag and meta description. Refreshing a Stage 2 page (impression decay) requires a full content overhaul or internal link restructuring.

Step-by-Step Execution

  1. Export 16 Months of Search Console Data at the Query-Page Level

Google Search Console only retains 16 months of data. Export the full “Queries” and “Pages” reports via the API or the CSV download button. You need four columns: Page URL, Query, Clicks, Impressions, CTR, Average Position. Do not aggregate by page alone—query-level data reveals which specific keywords are decaying. A page ranking for 50 queries might be decaying on only 3 high-volume queries, and those are the ones to fix. Tool: Use the Search Analytics for Sheets add-on (Google Workspace Marketplace) to pull data directly into a Google Sheet. Set the date range to “Last 16 months” and export in monthly granularity.

  1. Calculate a 3-Month Rolling Decay Score for Each Page-Query Pair

For every page-query combination, compute the change in clicks, impressions, and position between the most recent 3 months (e.g., Months 14–16) and the prior 3 months (Months 11–13). A page is “decaying” if: - Clicks declined by ≥30% AND - Average position dropped by ≥2 positions (e.g., from 4.0 to 6.0) OR impressions dropped by ≥40%. Flag any page-query pair meeting these thresholds. Then aggregate by page: a page is a “decay candidate” if it has at least 3 decaying queries or if its total clicks from all queries dropped by ≥25%. Example: A page ranking for “best CRM for startups” had 1,200 clicks/month in Q1 and 700 clicks/month in Q3. Position went from 3.2 to 5.8. That is a 42% click drop and a 2.6 position drop—clear decay.

  1. Filter Out Seasonal and Algorithmic Noise

Not every traffic drop is decay. A page about “Christmas gift ideas” will naturally lose traffic in February. Filter out queries with clear seasonality by comparing year-over-year (e.g., December 2023 vs. December 2024). If the drop is consistent with the same month last year, it is seasonal, not decay. Also exclude pages that were hit by a known Google core update (tracked via the Search Status dashboard). If a page dropped on the exact date of a core update and has not recovered, it is an algorithmic penalty, not standard decay—it requires a different remediation (E-E-A-T improvement, not just content refresh).

  1. Prioritize Decay Candidates by Revenue or Conversion Potential

Assign each decaying page a priority score: (Estimated monthly traffic value) × (Conversion rate) × (Decay severity). Traffic value = clicks × average CPC for the target query (use Ahrefs or Semrush keyword data). Conversion rate = historical conversion rate for that page (from Google Analytics). Decay severity = percentage of clicks lost. Sort descending. The top 20% of pages will typically account for 80% of the lost traffic value. Example: A product comparison page losing 500 clicks/month at a $2.00 CPC value = $1,000/month in lost potential revenue. That page gets priority over a blog post losing 300 clicks at $0.10 CPC.

  1. Diagnose the Decay Stage for Each High-Priority Page

For each page in the top 20%, open the URL in Search Console’s “Performance” report and look at the last 6 months of data. Identify the decay stage: - Stage 1 (Position decay): Impressions are stable or growing, but position is dropping. Fix: update content freshness, add internal links from high-authority pages, improve page speed. - Stage 2 (Impression decay): Impressions are dropping sharply. Fix: the page is no longer considered relevant. Rewrite the entire page to match current search intent. Check if a new competitor has published a better resource. - Stage 3 (Click decay): Impressions are stable, but CTR is dropping. Fix: rewrite the title tag and meta description. Test a more compelling value proposition or include a number/date (e.g., “2025 Update”). Document the diagnosis for each page before taking action.

  1. Execute the Refresh with a 30-Day Monitoring Window

For Stage 1 and 2 pages, update the content: add new sections, update statistics, improve readability, and add a “Last updated” date. For Stage 3 pages, only change the title tag and meta description. After the update, monitor the page’s performance in Search Console daily for 30 days. You should see a position improvement within 14 days for Stage 1, and a CTR improvement within 7 days for Stage 3. If no movement occurs after 30 days, the page may need a 301 redirect to a newer, more authoritative page on the same topic.

  1. Automate the Detection Loop

Set up a monthly recurring process: pull fresh Search Console data, run the decay score calculation, and generate a prioritized list. Use Google Sheets with the Search Analytics for Sheets add-on to automate the data pull. Create a dashboard that highlights pages with a decay score above the threshold. This turns content decay detection from a quarterly fire drill into a monthly maintenance habit.

Common Mistakes

  • ❌ Relying on total organic traffic as the decay signal. Total traffic masks which pages are decaying. You might see a 5% overall drop and miss that your highest-revenue page lost 60% of its traffic. Always analyze at the page level.
  • ❌ Refreshing content without diagnosing the decay stage. Adding 500 words to a page with Stage 3 (CTR) decay does nothing. You must fix the title tag and meta description first. Conversely, updating only the title on a Stage 2 (impression) page is wasted effort—Google has stopped showing the page because the content is no longer relevant.
  • ❌ Ignoring query-level data. A page might be decaying on 2 high-volume queries while gaining traffic on 10 long-tail queries. If you only look at total page clicks, you miss the problem. Always break down by query.
  • ❌ Treating all decay as equal. A page that dropped from position 2 to 4 is different from a page that dropped from position 2 to 20. The first might need a minor refresh; the second likely needs a full rewrite or redirect. Use the position drop magnitude to determine effort.
  • ❌ Failing to account for seasonality. Refreshing a “best winter coats” page in June because traffic dropped is a waste of time. Always compare year-over-year data before labeling a page as decaying.

Metrics to Track

  • Decay Score per Page: A composite metric of click decline (≥30%) and position drop (≥2 positions) over a trailing 3-month window. Target: zero pages with a decay score above threshold after the monthly refresh cycle.
  • Recovery Rate: Percentage of refreshed pages that regain ≥80% of their lost clicks within 60 days. Target: ≥60% recovery rate. If recovery rate is below 40%, your diagnosis or refresh execution is flawed.
  • Time to First Improvement: Days between refresh and the first measurable improvement in position (Stage 1) or CTR (Stage 3). Target: ≤14 days for position, ≤7 days for CTR. Longer times indicate the refresh was insufficient or misdiagnosed.
  • Traffic Value Recovered: Sum of estimated monthly traffic value (clicks × CPC) recovered across all refreshed pages. Track this monthly to calculate ROI of the refresh effort. Target: 5x the cost of the refresh effort (e.g., if you spend 10 hours at $100/hour, recover at least $5,000/month in traffic value).

Checklist

  • Export 16 months of Search Console data at the query-page level (use Search Analytics for Sheets)
  • Calculate 3-month rolling decay score for each page-query pair (clicks ≥30% drop + position ≥2 drop)
  • Filter out seasonal pages (compare year-over-year data)
  • Exclude pages hit by core updates (check Search Status dashboard)
  • Assign priority score (traffic value × conversion rate × decay severity)
  • Diagnose decay stage for top 20% of priority pages (Stage 1, 2, or 3)
  • Execute refresh action based on decay stage (content update, title rewrite, or redirect)
  • Monitor refreshed pages daily for 30 days in Search Console
  • Log recovery rate and time to first improvement
  • Set up monthly automated decay detection loop

How to Build a Recurring Content Decay Detection System in Google Sheets

This is a concrete, step-by-step walkthrough to automate the detection process using free tools.

  1. Install the Search Analytics for Sheets add-on from the Google Workspace Marketplace. Open a new Google Sheet, go to Extensions > Search Analytics for Sheets > Open Sidebar.
  2. Configure the data pull: In the sidebar, select your Search Console property. Set the date range to “Last 16 months.” Under “Dimensions,” check “Query” and “Page.” Under “Metrics,” check “Clicks,” “Impressions,” “CTR,” “Position.” Set “Row Limit” to 25,000 (the maximum). Click “Get Data.” This will populate a sheet with one row per query-page pair per month.
  3. Create a pivot table from the raw data: Insert > Pivot table. Rows: Page URL. Columns: Month (grouped by quarter). Values: Sum of Clicks, Sum of Impressions, Average of Position. This gives you a quarterly view per page.
  4. Add a decay calculation column next to the pivot table. For each page, compute the percentage change in clicks between the most recent quarter (e.g., Q3 2024) and the prior quarter (Q2 2024). Use a formula like: =(Clicks_Q3 - Clicks_Q2) / Clicks_Q2. Do the same for position change: =Position_Q3 - Position_Q2.
  5. Flag decay candidates with a conditional formula: =IF(AND(Click_Change < -0.3, Position_Change > 2), "DECAY", "OK"). This flags any page with a ≥30% click drop AND a ≥2 position drop.
  6. Add a priority column using a VLOOKUP to pull CPC data from a keyword tool (export from Ahrefs or Semrush). Multiply clicks lost by CPC to get traffic value lost. Sort the flagged pages by this value descending.
  7. Set a monthly reminder (Google Calendar) to run step 1 again, refresh the pivot table, and review the new flagged pages. The entire process takes 15 minutes once the sheet is set up.

Frequently Asked Questions

How often should I run this decay detection process?

Monthly is the sweet spot. Weekly is too noisy—short-term fluctuations from algorithm tests or competitor activity create false positives. Quarterly is too slow—you can lose 60% of a page’s traffic in 90 days. Monthly gives you enough data to detect trends without overreacting to noise.

What if a page is decaying but I don’t have the resources to refresh it?

Prioritize by traffic value. If a page is losing $50/month in traffic value and would take 4 hours to refresh, it may not be worth it. Redirect it to a stronger, related page on your site using a 301 redirect. This consolidates link equity and prevents the decaying page from cannibalizing your stronger content.

Can I use this process for new pages that never gained traction?

No. This process is for pages that had traffic and lost it. A page that launched 6 months ago and never ranked is not decaying—it never established itself. For those pages, focus on internal linking, content gaps, or consider merging them into a stronger page.

Does Google penalize pages for being old?

Google does not have a “content age” penalty. However, Google’s algorithms favor freshness for certain queries (e.g., “best CRM 2025” vs. “best CRM 2023”). If your page is outdated for a query with a freshness signal, it will lose impressions. This is decay, not a penalty, and a content refresh will typically recover rankings within 2–4 weeks.

How do I know if a page is worth saving vs. deleting?

Use the “traffic value lost” metric. If the page was generating significant traffic (e.g., 1,000 clicks/month) and the topic is still relevant, refresh it. If the page was always low-traffic (under 100 clicks/month) and the topic is obsolete (e.g., “best flip phones 2018”), delete it or 301 redirect it to a newer page. Do not keep decaying pages that have no recovery potential—they dilute your site’s authority.

What if my Search Console data shows zero impressions for a page that used to rank?

This is Stage 2 impression decay. The page has been de-indexed or dropped out of the top 100 results. Check the URL in the “Index” report—if it is indexed but has zero impressions, Google has decided the page is not relevant for any query. A full rewrite is required. If the page is not indexed, request indexing after the rewrite.

Sources

  1. Google Search Central, Search Console Help: Performance Report — Official documentation on interpreting clicks, impressions, CTR, and position data.
  2. Google Search Central, How Search Works: Freshness — Google’s explanation of how recency and freshness signals affect rankings for time-sensitive queries.
  3. Ahrefs, Content Decay: How to Find and Fix It (2024) — Industry-standard methodology for identifying decaying content using position tracking and traffic data.
  4. Semrush, Content Decay: What It Is and How to Fix It — Practical framework for diagnosing decay stages and prioritizing refresh efforts.
  5. Moz, The Content Decay Problem and How to Solve It — Detailed analysis of the three stages of content decay and corresponding remediation strategies.
  6. Backlinko, SEO Content Refresh: The Definitive Guide — Data-backed study showing that content refreshes can increase organic traffic by an average of 111% within 30 days.
  7. Google Search Central, Core Updates — Official list of core updates to cross-reference when filtering out algorithmic noise from true content decay.

Using NQZAI for This Playbook

NQZAI accelerates every step of this playbook by automating the data extraction, calculation, and prioritization that would otherwise require manual spreadsheet work. Instead of exporting Search Console data and building pivot tables by hand, you can use NQZAI’s natural language interface to query your connected Search Console account directly. For example, you can ask: “Show me all pages where clicks dropped more than 30% in the last 3 months compared to the prior 3 months, and position dropped by at least 2 spots.” NQZAI will return a ranked list with the decay score, traffic value lost, and recommended action (refresh title, rewrite content, or redirect). The system also tracks recovery rate automatically, sending you a weekly summary of which refreshed pages are improving and which need further attention. This reduces the monthly detection process from 15 minutes of manual sheet work to a 2-minute conversation with the AI. For teams managing 500+ pages, NQZAI’s batch analysis capability can scan the entire content library in under 60 seconds, flagging decay candidates that would take hours to find manually.