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

Score every URL by lost clicks, conversions and links, choose keep, refresh, merge or retire, and catch the risky calls.

What it decides
  What to do with each existing page (keep, refresh, merge or retire) and which decisions would throw away conversions, links or a merge destination.

Files
  Content Audit Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Content Audit 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 On-Page API
  Fills automatically: Page URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Build the inventory: Export every content URL with clicks for two comparable periods (e.g. this year vs last year), conversions and referring domains.
  2. Pick a disposition: Keep, Refresh, Merge or Retire from the dropdown. Merges need a destination URL.
  3. Estimate effort: Hours to refresh, merge or redirect. This ranks refresh work by lost clicks per hour.
  4. Clear the review flags: Work the Dashboard action list before deleting anything. Then send merges and retirements to the redirect map.

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-audit-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
