Zoho's built-in dedup only matches exact values, so most duplicates need a normalized fuzzy match on lowercased email or digit-only phone, followed by a manual merge picking the record with the most recent activity as the survivor.
Key takeaways
- Zoho's native dedup misses fuzzy duplicates.
- Normalize email and phone before matching.
- Pick the most active record as the survivor — not the oldest.
- Always re-parent related records on merge.
- Add validation rules to prevent the same duplicates returning.
Table of contents
Why Zoho''s built-in dedup misses most duplicates
Zoho''s native deduplication compares exact values. But the same person shows up as john@acme.com and John.Smith@acme.com, or with two phone formats. Those don''t match — and they pile up.
Step 1: Export and normalize
Export Contacts and Leads. Lowercase emails. Strip punctuation from phones. Keep only digits.
Step 2: Find fuzzy matches
Match on normalized email or normalized phone. Group records that share either.
Step 3: Pick a survivor
The survivor is usually the record with the most recent activity and the most complete fields. Never the oldest by default.
Step 4: Merge safely
In Zoho, use the Merge action and re-parent related records (Notes, Activities, Deals) to the survivor. Always keep the merge log.
Step 5: Prevent recurrence
Add a validation rule that lowercases email on save and normalizes phone format. The cleanup is wasted without prevention.
See your own revenue leaks.
Run a free RevLeak AI scan on your CRM data.
Survivor selection rules
| Signal | Weight | Why |
|---|---|---|
| Last activity in past 30 days | High | Active relationship |
| More complete fields | High | Less data loss on merge |
| Linked to open deal | Highest | Never break active pipeline |
| Older record | Low | Age alone doesn't indicate quality |
Checklist
Frequently asked questions
Find out exactly where your CRM is leaking revenue.
Upload a CSV. Get a prioritized list of stale deals, missed follow-ups, duplicates, and the dollar value you're losing — in minutes.
Run my free scan