Programmatic SEO Checklist (Optimization Theory, v3.0, November 2026)
================================================================

QA every generated page for verified data, unique value, indexability, links and rendering before release.

What it decides
  Which programmatically generated pages are ready to release and which to hold, with the specific checks each one fails.

Files
  Programmatic SEO Checklist.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Programmatic SEO Checklist - 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. Release in batches: Generate a small batch first. One row per page with its template and record ID.
  2. Verify the data: Spot-check each page's facts against the source dataset. Mark 1 only if correct.
  3. Judge unique value: Does the page offer something a user can't get from the template alone? Be strict.
  4. Check tech and render: Indexable, internally linked, and renders correctly with JavaScript. Release only pages with zero open checks.

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/programmatic-seo-checklist/
Part of the SEO Business & Delivery Toolkit: https://optimizationtheory.com/download-view/seo-business-toolkit-10-forecasting-and-delivery-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
