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

Check presence, syntax, required fields, visible-content match and policy for every structured data type you ship.

What it decides
  Which pages and schema types are ready to release, and which fail on syntax, required properties, content mismatch or policy.

Files
  Schema Markup Audit Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Schema Markup 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. List URLs per template and type: One row per URL and schema type. Pick the type from the dropdown.
  2. Validate syntax and required fields: Use the Rich Results Test and Schema Markup Validator. Record 1 or 0 for each.
  3. Compare with the visible page: Check that prices, ratings, dates and names in the markup match what users see.
  4. Review policy: Check eligibility rules, e.g. self-serving reviews and FAQ rich result restrictions. Record the outcome.

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/schema-markup-audit-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
