Redirect Mapping Template (Optimization Theory, v3.0, November 2026)
===============================================================

Map every old URL to its new home and verify each redirect: one permanent hop, a 200 page, no noindex, matching canonical.

What it decides
  Whether each planned redirect actually reaches the approved destination in one permanent hop, on an indexable page whose canonical agrees, with a human sign-off.

Files
  Redirect Mapping Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Redirect Mapping 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: Old URL, Source HTTP status, Final canonical URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Start from the URL inventory: Bring in every old URL with a Redirect or Merge disposition and its approved target.
  2. Run a redirect trace: Use a crawler in list mode or a redirect checker to record the first status code, number of hops, final URL and final status for each old URL.
  3. Add destination checks: Record whether the final page has noindex (1/0), its canonical URL, and whether a human has reviewed the destination as equivalent (1/0).
  4. Fix, retest, sign off: Work the Fix or review rows, retrace them after deployment, then record evidence in Delivery QA.

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/redirect-mapping-template/
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
