Content Decay Analysis Template (Optimization Theory, v3.0, November 2026)
=====================================================================

Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.

What it decides
  Whether a page lost clicks because it lost rankings, lost CTR or the market lost interest, and how big the demand-adjusted gap is.

Files
  Content Decay Analysis Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Content Decay Analysis Template - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO Labs: Ranked Keywords
  Fills automatically: Page URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Export two comparable periods: Pull impressions and clicks per page from Search Console for the same months in two years.
  2. Add a demand index: Use Google Trends or keyword volume to estimate demand now vs then (0.9 = demand fell 10%).
  3. Compare CTR and impressions: Impressions falling means visibility loss; CTR falling with stable impressions means the SERP changed.
  4. Refresh the true decayers: Sort by demand-adjusted gap. Refresh visibility losers; rethink titles and snippets for CTR losers.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/content-decay-analysis-template/
Part of the Content SEO Toolkit: https://optimizationtheory.com/download-view/content-seo-toolkit-6-audit-brief-and-testing-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
