The Spreadsheet That Dies in Google Drive

Every link builder has done it. You pull a link intersect report from Ahrefs, export 2,000 domains, sort by Domain Rating, and feel productive for about twenty minutes. Then the spreadsheet sits in Google Drive for six months and nobody ever opens it again.

I know because I have built dozens of link gap analyses, and the first ones I made were exactly that: impressive exports with zero action attached. A link gap analysis is not a report. It is a decision tool. If it does not tell you who to email this week, which page to promote, and what anchor to use, it failed.

Here is the exact process I use now to turn competitor backlink data into a 90-day outreach plan that my team (or just me, on smaller campaigns) can execute without asking me what to do next.

What a Link Gap Analysis Actually Is

Strip away the jargon and a link gap analysis answers one question: which sites link to my competitors but not to me, and which of those links are worth chasing?

That is it. It is not a competitive intelligence report. It is not a pretty chart for a client deck, although clients do love the charts. It is a prioritized prospect list with context attached to every row: why this site matters, which page of yours it should link to, and how you are going to earn the link.

The gap between “sites that link to competitors” and “sites worth pitching” is where most analyses collapse. A raw intersect of three competitors might hand you 3,000 domains. Maybe 150 of them are real opportunities. The entire craft is in the filtering.

Step 1: Pull the Data the Right Way

I use Ahrefs Link Intersect for this. Enter your domain at the top, add three to five competitors below, and run it. But the default settings will drown you, so change three things before you export.

First, pick competitors who actually compete for your money keywords, not just sites in your niche. If you sell project management software, your competitors are the other tools ranking for “project management software,” not every productivity blog on the internet. I usually pick the three sites that outrank my target pages most consistently, plus one aspirational site that is bigger than us but linkable.

Second, set the intersect to show domains linking to at least two competitors, not all of them. Requiring all competitors shrinks the list to obvious directories and roundups. Two-competitor overlap is where the interesting editorial links hide.

Third, filter to dofollow links only, and exclude subdomains you do not care about. Then export. You will still get a big list, but it will be a big list of plausible candidates instead of raw noise.

Step 2: Delete 80 Percent of It

This is the step everyone skips, and it is the most important one. Open the export and start deleting with prejudice. Remove anything that falls into these buckets:

• Directories, profiles, and forum signatures. If a competitor got a link from a directory, you can too, but that is a five-minute task, not an outreach campaign. Put these on a separate “quick wins” tab and move on.
• Sites with no organic traffic. If Ahrefs shows zero traffic for a referring domain, the link is either dead weight or the site is too new to judge. I keep a small exception pile for genuinely new, high-quality sites, but the default is delete.
• Obvious link sellers and PBNs. You know the pattern: “write for us” pages with pricing, casino links in the footer, content in twelve unrelated niches. If you would not show the link to a client with pride, delete it.
• Links you cannot replicate. A competitor’s founder went on a podcast. A competitor got acquired and TechCrunch covered it. You cannot outreach your way into those. Delete them without guilt.
• Non-English or wrong-geo sites, unless your campaign is international. A German blog linking to your US competitor is not your prospect.

Be ruthless. I would rather hand a client 120 scored prospects than 1,200 rows of maybe. A short list gets worked. A long list gets ignored.

Step 3: Score What Survives

Every prospect that survives the purge gets scored on three dimensions, 1 to 5 each. Fifteen points maximum. This is the heart of the analysis, so do it honestly, not optimistically.

Relevance (1 to 5)

How topically close is this site to your page? A 5 means the site publishes in your exact niche and the linking page is about your exact topic. A 3 means same broad industry. A 1 means the connection requires creative writing to explain. Score the linking page, not just the domain. A marketing blog linking to a competitor’s pricing page from a martech roundup is a 5. The same blog linking from a generic “best tools” listicle is a 3.

Traffic Value (1 to 5)

Does the linking page get real organic traffic, and would that traffic plausibly click through? I check the referring page’s estimated traffic in Ahrefs, not just the domain. A 5 is a page with steady traffic in your niche. A 1 is a page with no traffic that exists only to host links. Traffic matters twice: it is a quality signal for Google, and it is actual referral visitors for you.

Attainability (1 to 5)

How likely are you to actually earn this link in the next 90 days? A 5 means the site accepts guest posts, or links out to resources like yours regularly, or you have a warm contact. A 3 means it is editorial and picky but possible with a great angle. A 1 means it is a tier-one publication that linked to your competitor because of a funding announcement. Be honest here. An unattainable 15-pointer is still unattainable.

How to read the scores

• 12 to 15: Tier 1. Pitch these first, with your best angles and most senior outreach.
• 9 to 11: Tier 2. Solid prospects for the main outreach sequence.
• 6 to 8: Tier 3. Worth a pitch if you have spare capacity, or revisit in quarter two.
• Below 6: Park them. Do not delete, but do not spend outreach hours here yet.

I put the score breakdown in three separate columns plus a total, because “why did this score an 11” matters when you revisit the sheet in month two and cannot remember your reasoning.

Step 4: Map Prospects to Pages

A prospect without a target page is just a domain name. For every Tier 1 and Tier 2 prospect, fill in two more columns: target page (which page on your site this link should point to) and link rationale (one sentence on why this site would link to this page).

This forces page-level thinking. Your homepage does not need 40 new links. Your money pages do. I typically find that 70 percent of prospects map naturally to two or three priority pages, which tells me exactly where my linkable assets are thin.

If a prospect cannot be mapped to any page with a straight face, the relevance score was probably inflated. Go back and rescore it. This column is a built-in honesty check.

When no existing page fits a great prospect, that is a content brief, not a dead end. Note it in a “content needed” column. Some of my best-performing assets started as rows in a gap analysis that said “we need a page worth linking to here.”

Step 5: Anchor Mapping Without Overthinking

Anchor text planning has a reputation for being either ignored or obsessed over. The sane middle ground: map a suggested anchor type per prospect, not an exact anchor.

I use four buckets: branded, naked URL, topical partial match, and exact match (used sparingly). For each Tier 1 and Tier 2 prospect, note which bucket fits the linking context. A resource page linking to your guide gets a topical partial match. A podcast show notes page gets branded. A directory gets whatever the directory uses.

Then I check the distribution across the whole plan. If 60 percent of my Tier 1 targets would naturally use exact match anchors, I have a problem, because that is not how natural link profiles look. I rebalance by shifting some prospects to branded or URL anchors, or by changing which page they point to.

Keep exact match anchors under 10 to 15 percent of new links. That single rule prevents most anchor-related headaches.

Step 6: Turn It Into a 90-Day Plan

Now the spreadsheet becomes a calendar. I split the scored prospects into three monthly waves:

• Days 1 to 30: All Tier 1 prospects, plus the quick-wins tab (directories, profiles, unlinked mentions). The goal is momentum and early placements you can show.
• Days 31 to 60: Tier 2 prospects, plus any Tier 1 non-responders moved to a new angle. This is also when content flagged as “needed” in step 4 should be published, so month three has ammunition.
• Days 61 to 90: Tier 3 prospects, second follow-ups on warm threads, and digital PR pushes around any newsworthy angle the campaign has surfaced.

Each wave gets a target: number of pitches sent, expected reply rate, expected placements. My honest benchmarks for cold outreach in most B2B niches are 5 to 10 percent reply rates and 2 to 5 percent placement rates. Anyone promising 30 percent is selling something.

Assign every prospect an owner and a status column: not started, pitched, follow-up 1, follow-up 2, negotiating, placed, dead. Review it weekly. A gap analysis that nobody looks at after week one is just an expensive export.

What to Measure (and What to Ignore)

Measure placements per month, average relevance score of placed links, and movement on the target pages those links point to. That is the chain that matters: analysis to outreach to placement to ranking.

Ignore total referring domains as a vanity metric unless the new domains clear your own quality bar. Fifty new directory links will move your domain count and nothing else. Five Tier 1 editorial links will move your rankings.

Re-run the intersect every quarter. Competitors earn new links constantly, and each fresh run surfaces prospects your last analysis missed. The second run is always faster because your filters and scoring criteria already exist.

The One-Page Version

If you take nothing else from this: pull the intersect, delete ruthlessly, score on relevance, traffic, and attainability, map every prospect to a page and an anchor type, and work it in monthly waves with honest reply-rate expectations. That is a link gap analysis you can actually use.

Most agencies hand you the export. I would rather hand you the plan. If you want someone to build this for your site, with the scoring done and the 90-day calendar attached, get in touch and I will show you what the output looks like before you commit to anything. You can also see exactly what my link building services cover.