Audit backlinks without ahrefs or semrush

Last Tuesday, a client running a boutique B2B SaaS platform asked us to review their domain health after cutting software expenses. They had canceled their $200-a-month SEO tool subscriptions, assuming Google Search Console was all they needed. Three days later, their primary commercial page lost its top-three ranking. When they opened Search Console to diagnose the dropped links, they found a truncated spreadsheet capping their link export at 1,000 rows, zero anchor text context, and no way to analyze what their top competitor had acquired over the weekend.

If you have tried to audit backlinks without Ahrefs or Semrush before, you probably hit this exact wall. Free tools feel disjointed, export limits cut off your visibility right when things get interesting, and proprietary metrics like Domain Authority disappear behind strict daily caps. But paying hundreds of dollars a month per seat isn’t always viable—or necessary. You can perform a professional, client-ready backlink audit using direct search engine data, free index tiers, and structured spreadsheets if you know how to bridge the gaps.

The Blind Spots of Relying Solely on Google Search Console

Most SEOs start and end their budget audits inside Google Search Console (GSC). While GSC is the only tool that reflects what Google’s parser actually sees on your domain, relying on it as a single source of truth for a full audit will fail you.

To build an audit that stands up to scrutiny, you must understand what GSC leaves out:

1. Truncated Data Caps: GSC limits table exports to 1,000 top linking domains and 1,000 top target pages. If your site has accumulated 5,000 referring domains over five years, GSC hides 80% of your tail data.
2. Missing Link Attributes: GSC does not explicitly break down dofollow versus nofollow links in export files, nor does it display page-level anchor text surrounding those links.
3. Indexation Filters: GSC generally omits links originating from non-indexed pages or pages Google considers unpersuasive. While this cleans up noise, it hides bad-neighborhood spam networks that might be building up right on the fringe of indexation.
4. Zero API or Competitive Context: You cannot query a competitor’s domain through GSC, nor can you pull programmatic historical snapshots without setting up custom BigQuery pipelines ahead of time.

As noted by auspia.ai, GSC remains an indispensable source of direct diagnostic feedback, but its structural limits mean it must serve as an anchor point within a broader tool stack rather than your sole data source.

Harvesting Free Link Data Beyond GSC

To pull off a rigorous audit without enterprise software, you must combine data from multiple index providers. Every index crawler visits the web differently; merging their free outputs yields a composite dataset that rival paid platforms in coverage.

1. Bing Webmaster Tools (BWT)

Bing Webmaster Tools is the most underutilized asset in technical SEO. Unlike Google, Bing explicitly allows you to check backlinks for domains you do not own, making it a powerful engine for competitor research.

BWT provides access to up to 1,500 referring domains and up to 10,000 referring pages within each domain. As documented by bing.com, its dedicated Backlinks report lets you compare your domain side-by-side with up to two competitors, breaking down anchor texts, referring domains, and top receiving pages for free. Keep in mind that detailed page lists within the interface cap at 100 entries per view, so routine CSV exports are required to retain complete datasets.

2. Seobility (Free Tier)

Seobility offers a generous free tier that fills the page-level gaps GSC leaves behind. A free registration allows up to 5 backlink checks per day on any domain, exporting up to 600 URLs per check. It provides a quick look at follow/nofollow ratios, anchor text usage, and a proprietary “Link Rating” score based on host layout and relevance.

3. Moz Link Explorer (Free Tier)

A free Moz account provides 10 queries per month. While row counts are limited to roughly 50 rows per query, Moz excels at delivering domain-level health indicators like Domain Authority (DA), Page Authority (PA), and Spam Score. Using your 10 monthly queries strategically on top-tier referring hosts helps isolate suspicious link farms.

4. Majestic SEO (Free Tier)

Majestic focuses strictly on backlink mapping. Its free web checker yields trust profiles for any URL, detailing Trust Flow (TF), Citation Flow (CF), and Topical Trust Flow. Evaluating the ratio between Trust Flow and Citation Flow helps uncover low-quality link spam without paying for premium seats.

Normalizing and Deduplicating Raw Data in Google Sheets

Once you export CSV files from Search Console, Bing Webmaster Tools, and Seobility, you will have a chaotic pile of non-standard URLs, missing protocols, and overlapping rows. Your primary task is organizing this data into a unified, actionable database.

Follow this step-by-step process to structure your data:

1. Create a Master Spreadsheet: Set up four raw data tabs: Import_GSC, Import_BWT, Import_Seobility, and Master_Clean.
2. Standardize Target URLs: Apply a formula across all target page columns to convert every entry into lower-case text while removing protocol headers and trailing slashes: =LOWER(REGEXREPLACE(A2, "https?://(www\.)?", ""))
3. Consolidate Unique Referring Domains: Pull all raw referring domain hosts into the Master_Clean tab and use the =UNIQUE() formula to build a single consolidated list of unique referring websites across all sources.
4. Cross-Reference Source Engines: Use a lookup formula like =IF(ISNUMBER(MATCH(A2, Import_GSC!A:A, 0)), "Yes", "No") to tag whether each domain was spotted by Google, Bing, or third-party crawlers.
5. Classify Link Target Distribution: Tag every cleaned target URL into clear subfolder categories (e.g., /blog/, /product/, /location/, or homepage). This reveals whether incoming authority is distributing properly or piling up exclusively on your root homepage.

If you skip this step, you will burn hours reviewing identical links reported across different tools under slightly varied URLs. A clean master sheet brings clarity to your entire manual review process.

How to Manual-Audit Anchor Text Distributions

Commercial paid software categorizes anchor text into convenient pie charts showing exact-match commercial, partial-match, branded, and generic distribution. When auditing manually, you can recreate these insights using simple string-matching rules inside Google Sheets.

Unnatural anchor text distributions are among the fastest ways to trigger manual actions or algorithmic suppression. If your commercial anchor ratio spikes past safe thresholds, rankings drop fast.

To categorize anchors without automated tools:

1. Export all anchor text strings from Bing Webmaster Tools and Seobility into a clean spreadsheet tab.
2. Add a new column called Anchor Type.
3. Apply a nested =IFS() formula that searches for key branded phrases, raw domain names, generic terms, or target commercial keywords: excel =IFS( REGEXMATCH(LOWER(B2), "brandname|brand name|domain.com"), "Branded", REGEXMATCH(LOWER(B2), "http|www|\.com|\.net"), "Naked URL", REGEXMATCH(LOWER(B2), "click here|website|link|source|visit"), "Generic", REGEXMATCH(LOWER(B2), "target keyword phrase|exact match term"), "Commercial Exact", TRUE, "Partial Match / LSI" )
4. Build a quick Pivot Table summarizing the count and total percentage of each anchor category across your entire profile.

In competitive niches, healthy profiles typically lean heavily on branded and naked URL anchors. If exact-match commercial anchors make up more than 15-20% of your total link volume, your site faces elevated risk during core search updates. To understand why aggressive anchor ratios often backfire on established pages, check out our deep-dive on why your new backlinks aren’t moving rankings.

Identifying Toxic Links and Bad Neighborhoods Without Paid Metrics

Paid SEO tools rely heavily on aggregate metrics like “Toxic Score” or “Authority Score.” However, these third-party scores are merely proxies; Google does not use them to rank your site.

When you conduct an audit without paid tools, you look directly for the structural footprint of bad link neighborhoods rather than relying on an arbitrary score.

Look for these concrete indicators during your manual review:

1. Foreign TLD Spikes

Filter your consolidated referring domain list for high-volume spikes from country-code top-level domains (ccTLDs) that have zero connection to your primary audience (e.g., .ru, .cn, .tk, or .top). A sudden influx of thousands of links from foreign TLDs usually indicates automated scraper attacks or low-grade directory syndication.

2. High Domain-to-Page Ratios

When inspecting raw link exports in Bing Webmaster Tools or Seobility, look for domains that generate thousands of individual links from a single source host. These sitewide footer or sidebar placements pass low equity per page and often look like paid link manipulation to search engine algorithms.

3. PBN and Template Footprints

Open a sample of questionable referring URLs in a web browser. Watch for explicit signs of Private Blog Networks (PBNs) or automated link farm setups: * Outdated layout templates with generic stock images. * Thin, AI-generated content covering completely unrelated topics on a single site (e.g., HVAC maintenance tips published right next to crypto gambling guides). * Hidden text or link insertion points tucked away in low-contrast footer code. * Identical physical addresses, registration details, or hosting IP ranges shared across dozens of distinct domains.

As outlined by metricfixer.com, failing to catch unnatural link spikes early can trigger algorithmic suppressions across Bing and Google simultaneously. Manual sanity checks on suspicious domains remain the most reliable line of defense.

Extracting Lost and Broken Link Equity

An effective backlink audit goes beyond detecting spam; it should also help you recover lost authority. Over time, site redesigns, content refreshes, and URL restructuring lead to broken target pages that drop incoming link value.

When high-value external links point to a 404 Not Found page, that equity evaporates. Identifying these broken destinations and redirecting them to live, relevant content is one of the fastest ways to recover organic performance.

+--------------------------+
|  Combine Export Sources  |
|  (GSC, BWT, Seobility)   |
+------------+-------------+
             |
             v
+--------------------------+
|  Run Free HTTP Status    |
|  Checker (Screaming Frog |
|  or Local Script)        |
+------------+-------------+
             |
             +-----------------------+
             |                       |
             v                       v
      [200 OK / Live]         [404 / 410 Error]
             |                       |
     Profile Intact          +-------+-----------------------+
                             | Evaluate External Equity      |
                             | & Referring Domain Quality    |
                             +-------+-----------------------+
                                     |
                                     v
                             +-------------------------------+
                             | Implement 301 Redirect to     |
                             | Equivalent Live Target URL    |
                             +-------------------------------+

Step-by-Step Link Equity Recovery Process

1. Extract All Unique Incoming Target URLs: Compile a list of every target URL receiving external backlinks from your consolidated GSC and BWT exports.
2. Batch Check HTTP Status Codes: Copy these target URLs into a free crawler like Screaming Frog SEO Spider (free up to 500 URLs) or run a simple local Python script to verify their live HTTP status codes.
3. Filter for 404 and 410 Errors: Isolate every dead target URL that is currently returning a 404 error while still holding external backlinks.
4. Evaluate Link Value: Cross-reference those broken destination URLs against your link dataset. Prioritize broken URLs that hold backlinks from high-authority, topically relevant referring domains.
5. Set Up 301 Redirects: Map every high-value 404 destination to its closest active equivalent page, then implement permanent 301 redirects in your server configuration or CMS.

For a deeper dig into structural setup decisions and building sustainable link profiles from day one, read our actionable blueprint on your first backlinks: a 50-link plan for a brand-new site.

If you run into issues where external targets return dead responses or disappear from index caches completely, read our tactical breakdown on why client backlinks vanish from the cache.

Executing Competitor Audits Without Enterprise Subscriptions

Without a paid subscription to platforms like Ahrefs or Semrush, analyzing competitor link profiles requires a tactical approach. While you cannot run automated batch queries, you can leverage Bing Webmaster Tools alongside focused manual sampling to map out how competitors earn top rankings.

+-----------------------------------------------------------------+
|               Free Competitor Link Audit Workflow               |
+-----------------------------------------------------------------+
                                 |
                                 v
   [1] Input Rival Domain into Bing Webmaster Tools Backlink Panel
                                 |
                                 v
   [2] Export Up to 1,500 Referring Domains & Top Referring Pages
                                 |
                                 v
   [3] Sort Destinations by Page Traffic & Keyword Rankings
                                 |
                                 v
   [4] Sample High-Equity Link Sources in Majestic / Seobility Free
                                 |
                                 v
   [5] Identify Link Types: Editorial Content, Guest Posts, Resources

Follow this framework to audit competitor backlinks for free:

1. Extract Structural Data via Bing

Log into Bing Webmaster Tools, navigate to Tools & Features > Backlinks, and select the Similar Sites tab. Enter your domain alongside up to two top-performing organic competitors. Export the complete domain comparison dataset to review referring domain counts, shared link sources, and primary anchor text categories.

2. Isolate Intersecting Link Opportunities

In Google Sheets, compare your domain’s referring source list against your competitor’s list using the =VLOOKUP() formula. Focus on domains that link to your competitor but omit your domain entirely. These intersecting sources represent warm outreach prospects that are already comfortable linking to sites in your space.

3. Spot-Check Top Referring Pages

Take the top 10 referring host domains found in your competitor’s profile and run them through Seobility or Majestic’s free web tiers. Identify which specific content pieces are attracting natural links: * Are they acquiring links through original industry research and data reports? * Are they heavily listed on curated resource hubs and local business directories? * Are they securing guest features on high-authority industry publications?

By reverse-engineering these patterns, you can adapt their successful strategies without spending money on subscription software. If you want to simplify this analytical step further, see our detailed guide on why your backlink audit checklist is failing (and the fix).

Disavow Files: When to Act and When to Step Back

Submitting a disavow file tells Google to ignore specific incoming links when evaluating your site’s ranking algorithms. Because search engines have grown increasingly effective at automatically ignoring low-quality spam, disavow files are rarely required for normal website upkeep.

However, when aggressive spam campaigns, paid link footprints, or manual warnings put your domain at risk, knowing how to compile a clean disavow file manually is essential.

# Clean Disavow File Example Format
# Updated: 2026-10-25
# Reason: Removing low-quality directory spam network

# Specific toxic URLs
http://spam-directory-example.com/links/page-12.html
http://unrelated-forum-farm.net/thread-3392.html

# Complete domain disavows for automated networks
domain:bad-neighborhood-network.com
domain:automated-scraper-site.ru

Action Criteria: When to Disavow vs. When to Ignore

                        Is Link Unnatural or Toxic?
                       /                           \
                    [YES]                          [NO]
                     /                               \
     Is there an Active Manual Action          DO NOT DISAVOW
     or Sharp Traffic Drop?                   (Let Google Ignore)
      /                  \
   [YES]                 [NO]
    /                      \
DISAVOW IMMEDIATELY    MONITOR CLOSELY
(Domain-Level File)   (Re-evaluate Quarterly)

1. Active Manual Action: If you see a “Unnatural Links to Your Site” manual penalty in Google Search Console, you must compile and submit a comprehensive disavow file immediately after attempting manual link removal outreach.
2. Algorithmic Traffic Drop Following Spam Influx: If a dramatic drop in rankings coincides with a massive spike in foreign, exact-match commercial anchor links, file a targeted disavow focusing on full domains (domain:spamsite.com).
3. Routine Low-Level Web Scraping: If you discover a handful of generic scraper sites republishing your content alongside broken links, do not disavow them. Google’s automated systems filter out routine web noise automatically. Disavowing these links needlessly consumes time and risks muting legitimate authority signals.

If you find yourself navigating a complex site recovery process, consult our playbook on what nobody tells you about recovering lost backlinks.

Implementation Checklist: Audit Backlinks Without Ahrefs or Semrush

Use this action checklist to complete a full backlink audit without paying for enterprise subscriptions:

1. [ ] Export Google Search Console Links: Download both the “Top linking sites” and “Top linking pages” reports directly from the GSC Links menu in CSV format.
2. [ ] Export Bing Webmaster Tools Backlinks: Navigate to BWT > Backlinks, enter your domain, and export both your referring domain profile and competitor comparison sets.
3. [ ] Gather Third-Party Web Samples: Query your top target URLs using free tiers on Seobility, Moz, and Majestic to fill in missing page-level context and anchor metrics.
4. [ ] Standardize Data Protocols in Google Sheets: Merge all raw exports into a central master sheet, applying regular expressions to clean URLs, protocols, and trailing slashes.
5. [ ] Deduplicate Domain Entries: Apply =UNIQUE() functions across your target lists to create a clean list of referring host domains.
6. [ ] Categorize Anchor Text Ratios: Run custom matching formulas to bucket all anchor text entries into Branded, Naked URL, Generic, and Commercial Exact categories.
7. [ ] Flag Structural Toxicity Signals: Filter host lists for suspicious country-code domains, unnatural sitewide link counts, and severe Trust-to-Citation Flow imbalances.
8. [ ] Run Dead Target HTTP Checks: Pass target backlink URLs through Screaming Frog or local status scripts to isolate high-equity 404 Not Found pages.
9. [ ] Implement Canonical 301 Redirects: Set up server-side redirects targeting broken 404 destinations to reclaim lost external link equity.
10. [ ] Document and File Disavow Targets (If Needed): If addressing a manual penalty or severe spam attack, draft a properly formatted .txt disavow file using domain: syntax and submit it via Google Search Console.

What to Do This Week

To get your audit moving right away, take these four simple steps:

• Log into Google Search Console and export your target URL and referring domain CSV files.
• Set up a free Bing Webmaster Tools account, verify your site ownership, and run your domain alongside your top organic competitor in the Backlinks tool.
• Create a simple Google Sheet to normalize target URLs, clean protocols, and merge data from both search engines.
• Run your incoming links through a batch status checker to locate high-equity 404 pages and set up 301 redirects to recover lost link value.

To skip the hassle of combining spreadsheets, tracking indexation shifts manually, and checking link stability across custom software stacks, modern teams use OptiLink to monitor backlink health and manage campaigns automatically.

Keep reading

Playbook

Broken link building, step by step: find, fix, and pitch

Broken link building works when your replacement does the dead link's job. Here is how to find dead links, verify them, match a fix, and pitch honestly.

Sofia Meyer October 9, 20262 min read

Playbook

Competitor backlink analysis that finds real opportunities

Competitor backlink analysis pays off when you sort rivals' links by how they were earned. Use the intersect, a repeatable-link test and a dated action list.

Sofia Meyer September 26, 20262 min read

Playbook

Digital PR: the most durable link building there is

Digital PR earns links from journalists through original data, timely news and expert commentary. Here's the campaign workflow and how to measure it honestly.

Sofia Meyer October 13, 20262 min read

Explainer

Dofollow vs nofollow in 2026: what still passes value

The link attributes changed, Google's treatment changed, and a lot of advice is out of date. Here's what dofollow, nofollow, sponsored and ugc actually do now.

The OptiLink Team October 10, 20262 min read