How to spot duplicate companies in a prospect research sample

To spot duplicate companies, first decide what one company means for the sample. Then compare names and websites, investigate relationships, and record why each entry counts separately. Five different rows can describe fewer than five companies. Equally, two businesses using the same brand can deserve separate records.

The useful question is: does each entry represent a distinct account under the counting rule you agreed?

Set the counting rule before checking the rows

Choose whether you are counting operating companies, corporate groups, or individual locations. State how subsidiaries and franchise operators will be treated.

For a company-level sample, a practical starting rule is one record per operating company, with branches attached to that record. A separately identified subsidiary can count separately if the brief allows it. For a location-based campaign, individual sites may be useful, but label the total as locations.

The Census Bureau distinguishes establishments from enterprises: one enterprise can contain multiple establishments. NAICS classifies establishments by activity. An industry code therefore cannot establish that two rows represent different companies. Census definitions · NAICS overview

Normalize the obvious differences

Keep the original record, then create comparison fields:

• Company name without differences in capitalization, punctuation or spacing
• Legal name and trading names in separate fields
• Website hostname, plus the original page URL
• Location, parent company and operator, where established
• A stable internal account ID used across deliveries

Use these fields to flag possible matches. Removing “LLC” can help find a pair to review; it cannot justify merging them.

Group homepage variants such as HTTP/HTTPS and www/non-www for inspection. Check where an old domain redirects. Preserve branch paths and subdomains until you understand what they represent. Different country domains, redirects and shared hostnames need investigation.

The SBA explains that entity names, DBAs and domain registrations serve different purposes; a website address need not match a legal name. Treat names and domains as clues to a relationship. SBA business-name guidance

Establish the relationship with evidence

Start with current company-owned sources: location pages, legal notices, company-history pages and explicit ownership statements. Where needed, corroborate legal names through the relevant official business register, recording the jurisdiction and public registration identifier.

For public companies, the latest annual filing can help explain the group. The SEC points readers to the 10-K business section and subsidiary exhibits. Check the filing period and subsequent announcements before treating an older relationship as current. SEC guide to reading a 10-K

Apply the same discipline to each relationship:

• Branch: identify its operating company; retain the location under that account.
• Trading name: connect it to the named operator before merging.
• Subsidiary: retain the ownership link, even when the counting rule permits a separate account.
• Franchise: identify the operator behind the branded location. The FTC distinguishes franchised and company-owned outlets, so a shared brand alone cannot settle the count. FTC franchise guide

A shared address or phone number is another review flag. It is insufficient for a legal identity conclusion. Likewise, separate registration does not establish separate purchasing authority. Record who controls the relevant service as unknown unless there is evidence.

A fictional six-row sample

Everything in this example, including names, domains and described evidence, is invented for illustration. It is not a customer result or researched prospect list. The agreed rule counts operating companies and allows separately identified subsidiaries.

1. Alderline Office Services LLC, alderline.example. The illustrative company page and registry record agree on the operator. Keep account A.
2. Alderline North Office, alderline.example/north. The illustrative locations page identifies a branch operated by Alderline. Attach this location to A; do not add another company.
3. Alderline Offices, alderlineoffices.example. The illustrative site redirects to Alderline, whose history page identifies the former trading name. Retain it as an alias of A.
4. Cove Desk Services Ltd, covedesk.example. The illustrative registry identifies a separate company, and Alderline’s ownership page lists it as a subsidiary. Keep account B and link it to A. Purchasing independence remains unverified.
5. Daybreak Offices East. The illustrative branded location page names Laneway Workspace LLC as its franchise operator, corroborated by its registry record. Keep Laneway as account C, with Daybreak recorded as the brand.
6. Daybreak Offices West. A matching logo appears, but the operator is unnamed. Hold this candidate for review. It could share Laneway’s operator or have another one.

Six submitted rows yield three countable companies and one unresolved candidate under this example’s rule. Preserve the two merged rows in the audit trail. If the rule instead excluded related subsidiaries, Cove’s treatment would change.

A checklist before accepting the sample

For each proposed account, ask:

• What counting unit was agreed, and does this row meet it?
• Were spelling variants, trading names, old domains and branches compared?
• Is a parent, subsidiary or franchise relationship supported by a specific source?
• Does the record distinguish verified identity from unknown purchasing responsibility?
• Was it checked against earlier deliveries and the supplied customer and exclusion lists?
• Is the outcome recorded as keep, merge, exclude or unresolved, with a reason, source and check date?

Count unresolved candidates separately until the evidence supports a decision. If an exclusion list was unavailable, mark that check pending. When merging, retain source links, aliases and location details so the decision can be reviewed later.

A clean count helps you judge the sample’s coverage. It still provides no evidence that those companies want a proposal, will reply or will buy.

Start with five examples

Request five free examples from Knockfolio to review the company selection and supporting evidence. Requests are reviewed for fit and capacity, with criteria, exclusions and timing confirmed before acceptance. Submitting interest does not place an order or start a subscription.