Technical SEO Prioritization Template (Optimization Theory, v3.0, November 2026)
===========================================================================

Turn a technical SEO audit into a ranked fix queue by recovered clicks, profit and profit per hour of dev time.

What it decides
  Which technical issues to fix first, ranked by an explicit estimate of recoverable clicks and monthly profit per hour of effort.

Files
  Technical SEO Prioritization Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Technical SEO Prioritization 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: the audit trail (Source reference)
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. List issues, not symptoms: Group crawler warnings into fixable issues with one owner each (e.g. 'faceted URLs indexable on category pages').
  2. Size the affected traffic: Enter monthly clicks for the affected page group and the share actually affected.
  3. Be explicit about uncertainty: Recoverable share is how much you could win back; confidence is how sure you are. Both are editable and visible.
  4. Rank and hand off: Sort by profit per hour. Give the top items to dev with the Owner column filled in.

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/technical-seo-prioritization-template/
Part of the Technical SEO Toolkit: https://optimizationtheory.com/download-view/technical-seo-toolkit-6-audit-and-validation-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
