Why do pages that already link to me appear as opportunities?

The 'already have' check compares referring page URLs as exact lowercased strings between your export and the competitor exports. A trailing slash, http vs https, or a www difference makes the same page look new, so it survives the filter. If you see false opportunities, normalise the URL formats across your exports before uploading.

Why did most competitor rows disappear before analysis?

Two things combine. The Traffic column is coerced to numeric and anything unparseable becomes 0, and the minimum referring page traffic filter defaults to 10. So competitor rows with blank or non-numeric traffic values are silently dropped at the default setting. Set the minimum traffic to 0 if your export lacks reliable traffic data.

How is the competitor count calculated?

Rows are first deduplicated by referring page plus the domain extracted from the Link URL, then the count is the number of remaining rows per referring page. In effect it counts distinct competitor domains that page links to. This means uploading two export files for the same competitor domain still counts as one, and a page linking to five URLs on one competitor also counts as one.

Which columns do my files actually need?

Your own export needs only a referring page URL column. Competitor exports need referring page URL, Traffic and Link URL (the competitor page being linked to). Columns are auto-detected by name fragments ('referring' plus 'page', 'traffic', 'link' plus 'url') with a manual mapping expander if detection picks wrongly. Files are read as UTF-8 with a Latin-1 fallback.

Back to Tools

Backlink Intersector

Use cases

Link building prospecting Finding proven linkers in your niche Competitive backlink gap analysis

Compares referring domains across competitor backlink datasets using regex domain extraction ((?:https?://)?(?:www\.)?([^/]+)).

Marks pages already in your profile, then finds pages linking to multiple competitors but not you.

Deduplicates by (referring_page, target_domain) subset.

Filters by minimum traffic and competitor count thresholds.

Streamlit App

Platform

Browser-based (no installation required)

Input

Your backlinks CSV with Referring Page URL column

Competitor backlinks CSVs (multiple files) with Referring Page URL, Traffic, and Link URL (the Link Type column selector is optional and unused in the analysis)

Output

Excel with link building opportunities

Launch App View Source

Features

Column auto-detection with manual mapping override
Regex domain extraction from Link URL for target-domain dedup
Deduplication by referring_page + target_domain
Minimum referring page traffic filter (default: 10)
Minimum competitors linking threshold (default: 2)
UTF-8 and Latin-1 encoding fallback
Three-sheet Excel export (All Opportunities, Top 20, Detailed)

How to use

1 Export your backlinks from Ahrefs/SEMrush
2 Export competitor backlinks (one file per competitor)
3 Upload all files
4 Set minimum traffic threshold (default: 10)
5 Set minimum competitors linking (default: 2)
6 Download three-sheet Excel report

Frequently asked questions

Why do pages that already link to me appear as opportunities?: The 'already have' check compares referring page URLs as exact lowercased strings between your export and the competitor exports. A trailing slash, http vs https, or a www difference makes the same page look new, so it survives the filter. If you see false opportunities, normalise the URL formats across your exports before uploading.
Why did most competitor rows disappear before analysis?: Two things combine. The Traffic column is coerced to numeric and anything unparseable becomes 0, and the minimum referring page traffic filter defaults to 10. So competitor rows with blank or non-numeric traffic values are silently dropped at the default setting. Set the minimum traffic to 0 if your export lacks reliable traffic data.
How is the competitor count calculated?: Rows are first deduplicated by referring page plus the domain extracted from the Link URL, then the count is the number of remaining rows per referring page. In effect it counts distinct competitor domains that page links to. This means uploading two export files for the same competitor domain still counts as one, and a page linking to five URLs on one competitor also counts as one.
Which columns do my files actually need?: Your own export needs only a referring page URL column. Competitor exports need referring page URL, Traffic and Link URL (the competitor page being linked to). Columns are auto-detected by name fragments ('referring' plus 'page', 'traffic', 'link' plus 'url') with a manual mapping expander if detection picks wrongly. Files are read as UTF-8 with a Latin-1 fallback.

Want me to run this for you?

I run this tool as a managed service, or build something custom around your data. You get the insights without touching the code.

Tell Me What You Need

Anchor Text InterlinkerAppInternal Linking

Find internal linking opportunities by matching keywords to page content.

Link Quality AnalyserAppInternal Linking

Extract internal links from pages, check status codes, and analyse anchor text.

Anchor Text Relevance CheckerAppInternal Linking

Assess anchor text relevance for internal linking using AI.

BERTlinkerSaaSInternal Linking

SaaS platform for smarter internal linking using ML embeddings and semantic analysis.

eCommerce Link BuilderScriptInternal Linking

Find distributor and stockist link opportunities for product brands you sell.

ROAS CalculatorBrowserPPC

Calculate Return on Ad Spend from revenue and ad costs.

Need something built for your business?

This tool started as bespoke client work. I build custom scripts, data pipelines, and full apps for SEO and product data problems that off-the-shelf tools don't solve.