Post-Migration SEO Monitoring Template (Optimization Theory, v3.0, November 2026)
============================================================================

Compare each migrated segment with an untouched control so you can tell real migration loss from seasonality.

What it decides
  Whether each migrated section is performing above or below what you'd expect after adjusting for market-wide changes, measured against a control segment that didn't move.

Files
  Post-Migration SEO Monitoring Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Post-Migration SEO Monitoring 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 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. Choose a control segment: Pick a section that didn't change (a help center, a subdomain, a subfolder) with stable traffic.
  2. Pull equal periods: Export clicks for each migrated segment and the control for the same number of days before and after launch.
  3. Enter segment rows: One row per segment: baseline clicks, post-launch clicks, control before and after, and the period lengths.
  4. Investigate the biggest gaps: Segments more than 10% below expected appear on the Dashboard. Check redirects, indexation and templates for those first.

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/post-migration-seo-monitoring/
Part of the SEO Migration Toolkit: https://optimizationtheory.com/download-view/seo-migration-toolkit-6-planning-and-qa-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
