Key takeaways
- Duplicates arrive with imports, lead runs and manual entry, so check after each.
- Match on work email first, then on name plus company.
- The surviving record is the most complete one, or the one with an open deal.
- Merge in small groups, so one wrong match does not spread.
Why do CRMs end up with duplicate records
CRMs end up with duplicate records whenever the same person arrives by two routes. A CSV import, a contact added from an email thread, a fresh lead run and a colleague typing a name by hand can each create a record for someone who is already there.
Small differences hide the match: a nickname, a missing middle initial, a personal address next to a work one, or the company written two ways. The CRM sees two people; the buyer sees two sellers.
How do you find duplicates in a CRM
Find duplicates by sorting or filtering on the fields that should be unique, starting with the work email. Then widen the search in steps, each one catching what the last one missed and each needing a little more human judgement.
- Same work email: almost always the same person; merge with confidence.
- Same full name and same company: very likely the same person under two addresses.
- Same name at two companies: often a job change; update rather than merge.
- Same company written two ways: merge the company records, then recheck the contacts.
Which record should survive a merge
The record with the most history should survive: the one with the activity, notes and open deal attached. If neither has history, keep the one with the confirmed work email and the right owner.
Before merging, compare the fields where the two records disagree. Decide each conflict on purpose, such as the newer job title or the address that last received a reply, rather than letting the CRM pick for you.
How do you remove duplicate leads before they reach the CRM
Remove duplicate leads before they land by closing the routes that create them: list every way a person enters the CRM, such as imports, lead runs and contacts saved from email, and give each route a check before records are created. Prevention is cheaper than a merge, because a duplicate that reaches outreach can mean one person hearing from two colleagues in a week.
Make one person or one routine responsible for imports, and agree a few naming rules: how company names are written, which email goes in the main field and where personal addresses go, if anywhere.
What should you check after merging CRM records
Check that activity, notes, deals and segment membership followed the surviving record, and that the owner is still right. Open a handful of merged records rather than trusting the count alone.
Keep a short note of each clean-up: the date, the match rule used and anything left for a person to decide. The next clean-up then starts where this one stopped.
How to dedupe CRM contacts, step by step
Work from the strongest match to the weakest and stop when the judgement calls start.
- Sort or filter the contacts by work email, so records sharing an address sit together.
- Repeat with full name and company to catch people saved under two addresses.
- For each group, choose the surviving record: the one with an open deal, or the most complete.
- Copy any useful value the survivor lacks into it, then merge the group.
- Open a sample of merged records to confirm notes, activity and deals came across, and note the date of the clean-up.
Where Pebbles Ai fits
- CapabilityProspecting & customer recordsThe Pebbles Ai CRM (in Beta) merges 2 to 100 records in one go, and records in the Bin can be restored. Record pages show details, activity and linked records, so you can see what each duplicate holds before you merge.
- FoundationIntegrationsIf your contacts live in Attio or Pipedrive, an assistant can read the records through the MCP connection and list likely duplicates in chat for you to review. Any update it makes is an approval action under the execution mode.
Common questions
Does merging contacts delete data?
It depends on the CRM. Most keep the surviving record and fold in the others' activity, but conflicting field values can be overwritten, so decide which value wins before you merge.
How often should you clean up CRM duplicates?
After every large import or lead run, plus a short monthly sweep. Small, regular clean-ups are far easier than one large one.
Is deduplication the same as email verification?
No. Deduplication finds two records for one person; verification checks whether an address can receive mail. A clean CRM needs both, done as separate jobs.
What if you are not sure two records are the same person?
Leave the pair for someone who knows the account. A wrong merge mixes two people's history, which is harder to untangle than a duplicate is to live with.
About this page. Written by the Pebbles Ai team for people who run sales, marketing and growth. Last updated .
