Site Migration URL Inventory Template (Optimization Theory, v3.0, November 2026)
===========================================================================

Inventory every legacy URL with its traffic, profit and links, assign a destination and catch risky retirements.

What it decides
  Which legacy URLs carry real value, what happens to each one at launch, and which planned retirements would throw away clicks, revenue or backlinks.

Files
  Site Migration URL Inventory Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Site Migration URL Inventory 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. Collect every legacy URL: Combine a full crawl, XML sitemaps, Search Console pages, analytics landing pages and backlink targets. Deduplicate.
  2. Join value data: Add 90-day clicks from Search Console, profit or contribution from analytics, and referring domains from your backlink tool.
  3. Assign a disposition and destination: Choose Redirect, Keep, Merge or Retire. Every Redirect and Merge needs a destination URL; retirements get N/A.
  4. Clear every retirement flag: Open the Dashboard action list. Each Review retirement row has value. Redirect it to the closest equivalent or write down why not.

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/site-migration-url-inventory/
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
