How to deduplicate multi-location business prospect lists

TL;DR

Keep branch records in a location sheet and buying organizations in an account sheet. Deduplicate exact listings first, verify the operator relationship second, and connect each location to the account that can buy your service.

• An address identifies a location; it does not establish a buyer.
• Shared domains are useful grouping clues, not sufficient ownership proof.
• Keep unresolved locations separate from verified accounts.

A marketing agency can find dozens of branches and still have only a few potential buying conversations. The account map determines who receives outreach; the location map determines delivery scope. This workflow extends the multi-location agency prospecting guide with a practical way to keep those counts distinct.

1. Preserve the raw location records

Start with category and geography searches in Openmart’s business database. Save the business name, address, website, public contact route, source, and date collected. Give each source record an ID so later grouping decisions can be traced back to the original listing.

Do not delete branch detail when you create an account. Two offices may share a buyer while needing different location pages, hours, or appointment links. Retaining the original records lets the delivery team understand what an agreed service scope covers.

2. Remove duplicate listings of the same place

Compare normalized address and website fields. Standardize capitalization and ordinary address abbreviations for matching, but retain the original values. A listing with the same address and domain is a candidate duplicate; review suite numbers, moved offices, and co-located businesses before merging.

Different addresses should remain different location records until a source establishes that one is a move or an obsolete listing. A shared phone number can be a call center, so it is a supporting clue rather than the entire matching rule.

3. Verify the operator before merging branches

Use official location directories, company disclosures, and franchise information to establish which organization operates each place. One Hour Heating & Air Conditioning’s privacy policy describes separately owned franchise locations. Shared branding therefore does not establish one buying organization. Marketing authority still needs confirmation.

Use three relationship states: verified shared operator, verified separate operator, and unresolved. Merge branches into one account only for a verified shared operator. When the operator is unresolved, keep a provisional group for research and exclude it from the verified-account count.

4. Review the common edge cases

• One domain, several cities: check the official location directory and operating organization.
• One national brand, several franchisees: retain separate operator accounts when verified.
• Several brands, one operator: group under the operator while preserving each brand and location.
• One address, several businesses: review suite and business identity before deduplication.
• A location has moved: preserve the old source and link it to the current location after verification.

For a clearly hypothetical example, four branch rows could map to one verified regional operator, while two franchise rows map to separate operators. The result is six locations and three accounts. If the relationships are not verified, report six locations with unresolved account mapping instead. This arithmetic illustrates the distinction; it is not an Openmart benchmark.

5. Create the account sheet for outreach

• Account ID and verified operator name.
• Evidence URL and date for the operator relationship.
• Linked location IDs and verified location count.
• Buying responsibility: local, central, shared, or unresolved.
• One public issue relevant to your service, with page URL.
• Contact role or route and how responsibility was confirmed.
• Service scope and the next agreed action.

Confirm responsibility in a conversation before treating an account as a qualified opportunity. Your scope should specify which locations the service covers and which team approves changes. A brand-level contact can be useful for routing even when it cannot approve local work.

Recommendation

Review 20 candidate accounts, record why you grouped each set of branches, and separate verified counts from unresolved groups. Start business discovery in Openmart and use the resulting profiles to build your account map.

FAQs

Should branches with the same domain become one account?

Only after you verify the operating relationship. A national franchise website may cover several separate operators.

Should I remove branch records after grouping?

Keep them linked to the account so the service footprint and original sources remain available.

What if I cannot establish the operator?

Mark the relationship unresolved and research it before including the group in the verified-account count.

Research method reviewed October 2, 2026. Public examples illustrate verification decisions and are not customer results or current data exports.