Deduplicating a lead list across formatting variants
An example workflow for collapsing duplicate leads that appear under different formatting, spelling, and contact variants.
The challenge
The same person enters a lead database more than once under slightly different names, emails, or companies. Duplicates split activity history, double-count pipeline, and cause duplicate outreach.
Data before & after
Before
[
{ "name": "Bob Smith", "email": "bob@acme.com" },
{ "name": "Robert Smith", "email": "bob@acme.com" },
{ "name": "Bob Smith", "email": "b.smith@acme.com" }
]After
[
{
"canonical": { "name": "Bob Smith", "email": "bob@acme.com" },
"duplicates": 2,
"confidence": 0.94
}
]The workflow
- Normalize records first so trivial formatting differences do not hide matches.
- Run the set through Dedupe to group likely-duplicate records with a confidence score.
- Auto-merge high-confidence groups; route ambiguous groups to review.
Capabilities used
Repair
POST /api/v1/repairDeduplicate
POST /api/v1/dedupeMatch
POST /api/v1/matchProblems detected
- Same email under different display names
- Same person under multiple emails at one company
- Formatting variants that hide exact matches
Repairs performed
- Records normalized before comparison
- Duplicate groups scored by confidence
- A single canonical record chosen per group
Illustrative figures
Example dataset — illustrative only, not a customer result.
- 20,000
- Records processed
- 1,140
- Duplicate groups detected
- 890
- High-confidence auto-merges
Implementation
Normalize with Repair, then send the batch to Dedupe. Use the confidence score to decide auto-merge vs. review; use Match to compare a single pair when you need a targeted decision.
bash
curl -X POST https://zapinner.com/api/v1/dedupe \
-H "Authorization: Bearer $ZAPINNER_API_KEY" \
-H "Content-Type: application/json" \
-d '{ "records": [ /* your lead rows */ ] }'Technical architecture
- Normalize-before-dedupe removes formatting noise so matching keys on real differences.
- Confidence thresholds let you separate safe auto-merges from human review.
- Match handles the single-pair decision inside a larger workflow.
Fix messy data before it breaks your workflow.
Start free with 1,000 credits a month across every capability — no credit card required.
