SEO Split Test Calculator (Optimization Theory, v3.0, November 2026)
===============================================================

Estimate ratio-adjusted lift and difference-in-differences against matched control pages, with a pre-trend check.

What it decides
  Whether an SEO change moved traffic on treated pages relative to matched control pages, and whether the evidence supports reading the estimate.

Files
  SEO Split Test Calculator.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  SEO Split Test Calculator - 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: 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. Split comparable pages: Randomly assign similar pages to treatment and control. Hundreds of pages per group is ideal.
  2. Check the pre-period: Chart both groups for 6 to 8 weeks before the change. Mark parallel trends = 1 only if they moved together.
  3. Ship the change to treatment only: Leave control untouched for the test window.
  4. Read lift with the design in mind: Report the ratio-adjusted lift, note the evidence, and don't over-read small effects.

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/seo-split-test-calculator/
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
