Internal Linking Opportunity Template (Optimization Theory, v3.0, November 2026)
===========================================================================

Score each source-to-target internal link by expected visits and contribution per hour, then verify it went live.

What it decides
  Which internal links to add first, based on the source page's traffic, the expected link click-through and the value of the destination.

Files
  Internal Linking Opportunity Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Internal Linking Opportunity 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: Source page
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Find candidate sources: Pages with traffic that discuss a topic you have a target page for. Search Console and a site: search help.
  2. Write the anchor: Use a natural, descriptive anchor that matches the target's topic.
  3. Estimate link CTR and value: Contextual links in body copy often get 1% to 8% CTR. Use the destination's own conversion rate and value.
  4. Add, then verify: Add the top links, recrawl, and mark Already linked = 1 so the sheet stays accurate.

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/internal-linking-template/
Part of the Technical SEO Toolkit: https://optimizationtheory.com/download-view/technical-seo-toolkit-6-audit-and-validation-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
