Two of everyone
The same customer appears in your CRM three times: once from a web form, once from an event list someone imported, and once created by a salesperson who could not find the first two. One record has their mobile number, another their order history, the third their latest emails. They get your newsletter twice. A salesperson calls them not knowing a colleague spoke to them yesterday.
Every so often someone runs a merge exercise. The CRM's duplicate tool finds a few hundred pairs, they are merged over an afternoon, and within a few months the numbers are back.
Why merging does not stick
Merging treats the symptom. The duplicates come from somewhere, usually from several places at once, and unless those sources change, they keep producing new ones.
| Source | Why it creates duplicates |
|---|---|
| Web forms | A returning customer uses a different email, or a typo |
| List imports | Matched only on email, or not matched at all |
| Integrations | Shop, billing or support tools create contacts with their own rules |
| Manual entry | Search is not done first, or finds nothing due to spelling |
| Company records | Trading names, abbreviations and 'Ltd' versus 'Limited' |
Built-in duplicate tools in HubSpot, Salesforce and others match on a few fields, usually email. They miss the person who used a work email once and a personal one later, or the company entered three different ways.
What duplicates cost
Customers receive the same email twice and wonder how organised you really are. Salespeople step on each other. Reports overcount leads and undercount revenue per customer, because one customer's orders are split across records. Marketing tools charge per contact in many cases, so you pay for the duplicates too. And any automation built on the CRM, such as follow-up sequences, misfires because it sees one relationship as several.
How we stop duplicates at the source
- Audit: we measure where duplicates come from by looking at how each duplicate record was created, so effort goes on the biggest sources first.
- Match before create: every entry point, including forms, integrations and imports, runs through a matching step that checks for an existing person or company using several signals: email, phone, name similarity, company domain and postcode.
- Decide by confidence: clear matches update the existing record; possible matches are linked and flagged; clearly new people get a new record.
- Clean the backlog: existing duplicates are grouped, a merge plan is proposed with which values to keep from each record, and you approve the rules before anything is merged.
- Review queue: uncertain pairs go to a person who can merge or separate them in one action, and their decisions refine the matching.
- Monitor: a regular report shows new duplicates by source, so a new integration that starts creating them is caught early.
We build this against the CRM's API, and where the CRM has native deduplication rules we configure those as well rather than duplicating their job.
A cleaner CRM, and one that stays clean
Each customer has one record with their full history. Salespeople see all previous contact in one place. Emails go out once. Reports reflect real people and real companies, and automations behave as designed. Most importantly, the cleanup is not a yearly event any more, because new duplicates are prevented rather than merged later.
Company-level data improves the most. When every contact at a customer is attached to one company record, you can finally see the whole relationship: who you have spoken to, what they have bought, which deals are open. That view is what account managers want from a CRM, and it is exactly what duplicates quietly destroy.
It also makes any future project easier. Migrating CRM, connecting a new marketing tool or building reporting all go more smoothly on data where one customer means one record.
Signs you have a duplicate problem
- Customers mention getting the same email more than once.
- Salespeople find a contact's history split across records.
- You have run merge exercises and the duplicates came back.
- Several tools create contacts in the CRM.
- Company names are entered in several different ways.