Internal Linking Opportunity Template

Technical SEO Toolkit, template 4 of 6

Internal Linking Opportunity Template

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

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

  • Excel workbook (.xlsx), opens in Google Sheets
  • PDF field guide, 9 to 11 pages
  • Blank and worked CSV templates
  • DataForSEO import script

Free, no email required. Version 3.0, updated November 2026.

Internal Linking Opportunity Template.xlsx
N13fx=IF(K13="","",IF(K13<>"Ready","n.a.",M13/H13))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell N13. Scroll it sideways to read the whole rule.

Connected to the DataForSEO API

This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.

Setup steps

DataForSEO On-Page APIA crawl of your site: URLs, status codes, canonicals, inlinks and sitemap membershipon_page/task_post

Save the JSON responseThe full API response, kept as your source of truth.response.json

Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py import --template 16

Paste at A13Dashboard, checks and action list update instantly.Internal Linking Opportunity Template.xlsx

Column map for this template:Filled by the APIAudit trail (automatic)You add

Source pageTarget pageProposed anchorSource clicks / monthAssumed link CTRConversion rateValue per conversionWork hoursLink already existsSource reference
2 of 10 input columns come straight from DataForSEO

What the internal linking opportunity template decides

Internal links are the cheapest lever in SEO: they cost minutes, need no developer, and move both users and authority to the pages that matter. Most sites still add them haphazardly, a link here when someone remembers, with no idea which links would actually send visits.

This internal linking template scores each proposed link. Enter the source page's clicks, an expected link CTR, the destination's conversion rate and value, and the effort. It calculates potential destination visits, a monthly contribution hypothesis and contribution per hour. Links that already exist are zeroed out so you don't double count.

Who it's for

  • Content and SEO teams improving internal linking
  • Ecommerce teams connecting guides to category and product pages
  • Sites recovering from orphaned or deep pages
  • Anyone planning a hub-and-spoke content structure

Where it fits in your workflow

The internal linking opportunity template answers one question. These three templates answer the questions around it:

  • Technical SEO Prioritization Template: which technical issues to fix first, ranked by an explicit estimate of recoverable clicks and monthly profit per hour of effort.
  • Keyword Mapping Template: which single URL should own each keyword, and where your map assigns the same query to two different pages.
  • Content Audit Template: what to do with each existing page (keep, refresh, merge or retire) and which decisions would throw away conversions, links or a merge destination.

What's inside the download

One ZIP with the workbook, a 10-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.

Workspace. The working table. 10 input columns, 4 calculated columns, room for 250 rows. Dropdowns, Yes/No fields and range checks catch bad inputs as you paste.
Start Here. What it decides, a four-step setup and the colour key.
Dashboard. KPI cards, charts, a ranked Top 10 and an automatic action list.
Delivery QA. Pass, fail or exclude each validation step with evidence, owner and date.
Field Guide. Every field explained, plus each formula in plain English.

How the internal link audit calculation works

Potential target visits = source clicks × link CTR (zero if already linked). Contribution = visits × conversion rate × value. Contribution per hour = contribution ÷ effort.

The key formula, exactly as it appears in the workbook

=IF(K13="","",IF(K13<>"Ready","n.a.",M13/H13))
Result column Plain-English formula What it tells you
Potential target visits IF(Link already exists=1,0,Source clicks ÷ month × Assumed link CTR) Potential referred target visits from a new link, not new organic sessions.
Monthly contribution hypothesis Potential target visits × Conversion rate × Value per conversion Modeled conversion contribution from those visits.
Monthly contribution / hour Monthly contribution hypothesis ÷ Work hours Planning comparison for implementation effort.

How to use the internal linking opportunity template

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

The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.

Fill the internal linking opportunity template with DataForSEO

Every template in this library is built to run on DataForSEO data. This one uses DataForSEO On-Page API: a crawl of your site: URLs, status codes, canonicals, inlinks and sitemap membership.

Most of the data columns fill automatically. Add the business inputs listed below, then paste.

  1. Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
    POST https://api.dataforseo.com/v3/on_page/task_post [ { "target": "yourdomain.com", "max_crawl_pages": 1000 } ]

    Post the crawl task, wait for it to finish, then request on_page/pages with {"id": "<task id>", "limit": 1000} and save that response.

  2. Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
  3. Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
    python3 Automation/dataforseo_import.py import --template 16 --input response.json --output my-inputs.csv
  4. Add what the API can't knowTarget page, Proposed anchor, Source clicks / month, Assumed link CTR, Conversion rate, Value per conversion, Work hours, Link already exists
  5. Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
Fills automatically from DataForSEO You add
Source page Target page, Proposed anchor, Source clicks / month, Assumed link CTR, Conversion rate, Value per conversion, Work hours, Link already exists

Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.

Worked example: Northbeam Outdoor

Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 12 example rows.

12Records
0Rows with input issues
1,105Potential destination visits
$2,408Monthly contribution hypothesis

The best example link points from the sleeping bag buying guide to the down sleeping bag category. The homepage has far more clicks, but its link to the guides hub ranks lower because the intent is broader and the click-through smaller.

Top 10 by contribution / hour

# Source page Contribution / hour
1 https://www.northbeam.example/guides/choose-sleeping-bag/ $1,693.44
2 https://www.northbeam.example/guides/down-vs-synthetic/ $1,061.91
3 https://www.northbeam.example/guides/day-hike-checklist/ $544.63
4 https://www.northbeam.example/blog/winter-camping-tips/ $454.10
5 https://www.northbeam.example/ $403.20

Input fields

Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.

CSV field Column Meaning and rule Source
source_url Source page Existing relevant source URL. DataForSEO: url
target_url Target page Destination canonical URL. Your records
anchor Proposed anchor Descriptive anchor that suits the surrounding sentence. Your records
source_clicks Source clicks / month GSC clicks to the source page. Your records
link_ctr Assumed link CTR Assumed share of source visitors clicking the proposed link. Decimal: 0.08 = 8%. Your records
conversion_rate Conversion rate Conversions divided by eligible organic sessions for the same segment. This is an assumption. Decimal: 0.08 = 8%. Your records
value_per_conversion Value per conversion USD contribution profit per conversion or expected lead profit. Use one value basis. Your records
effort_hours Work hours Estimated implementation hours, greater than zero. Your records
already_linked Link already exists 1 only when the exact relationship is verified in the crawl. 1 = Yes, 0 = No. Your records
source_ref Source reference Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. DataForSEO: source_ref

Reading the result honestly

This estimates navigation value. Ranking changes from internal linking are not quantified by this formula.

Limits. Link-level CTR needs analytics or an explicit assumption. On-Page inlink counts do not identify exact source-target edges.

Internal link audit mistakes to avoid

Linking from irrelevant pagesA link from a busy but unrelated page gets few clicks and sends weak topical signals.
Exact-match anchors everywhereVary anchors naturally. Repetitive exact-match anchors look manipulative and read badly.
Forgetting to verifyCMS changes and template edits remove links. Recrawl and confirm.

Tips from practice

  • Use the PageRank simulator to see how links shift authority across a site.
  • Start with orphaned and deep pages that have value.
  • Link from guides to commercial pages and back; both directions help users.

Frequently asked questions

How do I find internal linking opportunities?

Look for pages with traffic that mention a topic you have a dedicated page for, but don't link to it. Search Console, site: searches and crawler content searches find them.

How many internal links should a page have?

There's no fixed number. Link where it helps the reader; prioritize links that are likely to be clicked.

Do internal links help rankings?

Yes. They help Google discover pages, understand topics and distribute authority, and they send real visitors.

What anchor text should I use?

Descriptive text that tells the reader what they'll get. Natural variation is better than repeating the exact keyword.

Part of the Technical SEO Toolkit

Get all 6 Technical SEO templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.

Download the Technical SEO Toolkit

See the complete SEO & GEO toolkit

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.

More on digital marketing in our blog

See all posts