Link Reclamation Template (Optimization Theory, v3.0, November 2026)
===============================================================

Find lost and broken backlinks worth fixing and rank them by expected referrals per hour of outreach.

What it decides
  Which lost or broken backlinks are worth reclaiming, and which to tackle first by expected referrals per hour.

Files
  Link Reclamation Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Link Reclamation 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 Backlinks API
  Fills automatically: Referring page, Linked target, Provider reports lost, Provider reports broken, Target HTTP status
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Export lost and broken links: From your backlink tool, export lost links and links pointing at 4xx or 5xx URLs on your site.
  2. Check the target status: Record the current status of each target URL.
  3. Judge relevance: Mark relevant = 1 only for genuine sites in your space. Skip spam directories.
  4. Fix or reach out: Redirect broken targets yourself (fastest), then contact publishers for lost links in ranked order.

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/link-reclamation-template/
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
