Link Reclamation Template

SEO Business & Delivery Toolkit, template 4 of 10

Link Reclamation Template

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

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

  • 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.

Link Reclamation Template.xlsx
K13fx=IF(J13="","",IF(J13<>"Ready","n.a.",IF(AND(F13=1,OR(C13=1,D13=1,E13>=400)),1,0)))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell K13. 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 Backlinks APILive and lost backlinks with their source, target, broken and status flagsbacklinks/backlinks/live

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 34

Paste at A13Dashboard, checks and action list update instantly.Link Reclamation Template.xlsx

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

Referring pageLinked targetProvider reports lostProvider reports brokenTarget HTTP statusHuman relevance verifiedExpected referrals / monthWork hoursSource reference
6 of 9 input columns come straight from DataForSEO

What the link reclamation template decides

The easiest links to build are the ones you already earned. Backlinks break when you change URLs, delete pages or migrate, and they get lost when publishers update articles. Reclaiming them is usually faster than earning new ones.

This link reclamation template records each linking page, its target on your site, whether the link is lost or broken, the target's status, whether the link is relevant, estimated referrals and effort. Relevant links that are lost, broken or pointing at an error page become reclamation candidates, ranked by referrals per hour.

Who it's for

  • SEOs running link building or digital PR
  • Teams cleaning up after a migration or URL change
  • Ecommerce sites with discontinued product URLs
  • Agencies looking for quick link wins

Where it fits in your workflow

The link reclamation template answers one question. These three templates answer the questions around it:

  • Redirect Mapping Template: 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.
  • Site Migration URL Inventory Template: which legacy URLs carry real value, what happens to each one at launch, and which planned retirements would throw away clicks, revenue or backlinks.
  • Internal Linking Opportunity Template: which internal links to add first, based on the source page's traffic, the expected link click-through and the value of the destination.

What's inside the download

One ZIP with the workbook, a 9-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. 9 input columns, 3 calculated columns, room for 1,000 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 link reclamation calculation works

Reclamation candidate = 1 when the link is relevant and lost, broken, or points at a target returning 400 or above. Referrals per hour = estimated referrals ÷ effort for candidates, otherwise 0.

The key formula, exactly as it appears in the workbook

=IF(J13="","",IF(J13<>"Ready","n.a.",IF(AND(F13=1,OR(C13=1,D13=1,E13>=400)),1,0)))
Result column Plain-English formula What it tells you
Reclamation review IF(AND(Human relevance verified=1,OR(Provider reports lost=1,Provider reports broken=1,Target HTTP status ≥ 400)),1,0) Flags relevant relationships needing a manual repair review.
Planned referrals / hour IF(Reclamation review=1,Expected referrals ÷ month ÷ Work hours,0) Expected referral opportunity per repair hour.

How to use the link reclamation template

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

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 link reclamation template with DataForSEO

Every template in this library is built to run on DataForSEO data. This one uses DataForSEO Backlinks API: live and lost backlinks with their source, target, broken and status flags.

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/backlinks/backlinks/live [ { "target": "yourdomain.com", "mode": "as_is", "backlinks_status_type": "all", "limit": 1000 } ]
  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 34 --input response.json --output my-inputs.csv
  4. Add what the API can't knowHuman relevance verified, Expected referrals / month, Work hours
  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
Referring page, Linked target, Provider reports lost, Provider reports broken, Target HTTP status Human relevance verified, Expected referrals / month, Work hours

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 10 example rows.

10Records
0Rows with input issues
6Reclamation candidates
615Est. referrals from candidates

Six example links are worth reclaiming. The top three point at old product and collection URLs that 404, so a redirect on Northbeam's side fixes them without any outreach.

Top 10 by referrals / hour

# Referring page Referrals / hour
1 https://www.runnersworld.example/trail-shoes-roundup/ 105.0
2 https://www.backpacker.example/gear/best-boots-2024/ 93.3
3 https://www.trailjournal.example/reviews/summit-tent/ 90.0
4 https://www.hikingblog.example/layering-guide/ 60.0
5 https://www.gearpatrol.example/water-filters/ 53.3

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 Referring page Page containing or formerly containing the link. DataForSEO: url_from
target_url Linked target Exact linked destination. DataForSEO: url_to
is_lost Provider reports lost Loss flag from the current backlinks response. 1 = Yes, 0 = No. DataForSEO: is_lost
is_broken Provider reports broken Broken flag from the response. Verify independently. 1 = Yes, 0 = No. DataForSEO: is_broken
target_status Target HTTP status Current observed status of the linked target. DataForSEO: url_to_status_code
relevant Human relevance verified 1 when restoring the relationship benefits users and the destination is equivalent. 1 = Yes, 0 = No. Your records
estimated_referrals Expected referrals / month Explicit traffic hypothesis based on actual referral history or a documented assumption. Your records
effort_hours Work hours Estimated implementation hours, greater than zero. 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

Provider link metrics describe observations. They are not a guaranteed amount of transferable ranking value.

Limits. A lost flag can be temporary. Review evidence before contacting a publisher or changing a redirect.

Link reclamation mistakes to avoid

Chasing spam linksNot every lost link is worth recovering. Relevance first.
Emailing before redirectingIf the target 404s, a redirect fixes it instantly. Outreach is for links that were removed.
Ignoring link value after migrationsMost broken backlinks appear after URL changes. Run this after every migration.

Tips from practice

  • Use the redirect mapping template to fix broken targets in bulk.
  • Prioritize links that send real referral traffic, not just authority metrics.
  • Check for unlinked brand mentions too; they're the next-easiest win.

Frequently asked questions

What is link reclamation?

Recovering backlinks you've lost or that point to broken URLs on your site, by redirecting targets or asking publishers to update links.

How do I find broken backlinks?

Use a backlink tool's broken backlinks report or filter your backlink export for targets returning 4xx or 5xx status codes.

Should I redirect broken backlinks?

Yes, to the most relevant live page. It recovers the link's value without outreach.

Are lost backlinks a problem?

Some loss is normal. Reclaim the relevant, valuable ones and let low-quality links go.

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