Colquhoun.AI
← All guides

Research Guides

Reconcile Backlink Exports Before Reporting New Links

· Colquhoun.shop editorial

A larger backlink spreadsheet does not automatically mean a campaign earned more links. Two exports can differ because their scope, grouping or coverage differs. Before reporting growth, establish what each row represents and which change you actually observed.

This worksheet is for reviewing exports you are authorized to access. It does not claim that Colquhoun.shop has earned particular backlinks or that it provides a backlink-monitoring integration.

1. Label the export before counting it

Record the provider, property, report name, export option, export time and filters. Keep the raw file unchanged and do reconciliation in a working copy. A source-page list, a source-domain summary and an anchor-text report are different datasets even if all contain a column called “links.”

Google documents that Search Console's Links report is a sample, combines duplicate links and groups pages using canonical URLs. It also includes links found over time that may no longer exist. Its table and export limits differ by view. These properties make an export a record of reported observations, not a complete live inventory. Google Search Console: Links report

2. Define a comparison key explicitly

For a page-level working ledger, start with the source URL and destination URL as separate fields. Retain the original values even if you add normalized comparison fields. State the normalization rules rather than silently stripping everything after a question mark or merging every subdomain.

If a provider has already grouped records, do not pretend to reconstruct individual placements from its aggregate. A root-domain count cannot tell you which exact paragraph contains a link. Likewise, two occurrences on one source page are not necessarily two independent editorial recommendations.

3. Separate a new row from a new placement

Consider an invented first export containing source page A linking to destination X. A later export contains A-to-X again and a newly listed B-to-X. The defensible initial statement is “B-to-X appeared in the later export and was not present in the earlier file.” It is not yet “B published a new link this week.”

The earlier export may not have included B, and a provider's observation or discovery time need not establish the publisher's original placement date. Keep “new to this comparison” separate from “newly published.” Do not assign campaign credit without additional evidence connecting the placement to the campaign.

4. Add a separate live-check layer

When a placement matters, open the public source page through permitted access and inspect the actual link, destination and surrounding context. Record the check time and any redirects. If access is blocked or the page cannot be read, mark it unverified rather than removed.

If a previously reported link is no longer found, document the scope of your inspection. A missing row in a later export alone is not proof of removal. A changed layout, different destination or incomplete rendering can require a closer review before making that claim.

5. Report four counts, not one ambiguous total

Keep the categories distinct; they answer different questions and should not be added together. Pair this record with the backlink opportunity worksheet when tracking outreach and editorial decisions.

This process does not turn sampling into completeness or prove ranking impact. It produces a more useful progress report: what the provider reported, what changed between comparable files and what a reviewer actually confirmed on a live page.

This guide describes the built-in Web Reader and Keyword Density behavior verified for this publication. Available data depends on the page response; these tools do not measure visits or search rankings.