Title Tag CTR Test Calculator (Optimization Theory, v3.0, November 2026)
===================================================================

Compare two CTRs with a 95% interval and plain-English verdicts, so you don't ship a title change that was just noise.

What it decides
  Whether a title or snippet change produced a CTR difference that's distinguishable from noise, with honest labels for small samples and non-randomized comparisons.

Files
  Title Tag CTR Test Calculator.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Title Tag CTR 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 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. Define A and B: Split comparable pages into two groups, or compare time periods for one page if you can't split.
  2. Collect impressions and clicks: From Search Console, for the same date range and filters for each version.
  3. Mark randomization: Mark 1 only if pages were randomly assigned to A and B. Before/after on one page is 0.
  4. Read the interval, not the point: Ship only Positive interval results. Keep testing when the interval includes zero.

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-ctr-test-calculator/
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
