Symptoms
- Multiple versions of the same customer appear when searching.
- Customer Service agents see duplicate contacts linked to the same case.
- Reports overcount customers due to duplicated entries.
- Automated processes (e.g., email, routing) trigger multiple times for the same customer.
Root Cause
Duplicate records exist due to:
- Manual data entry without validation.
- Multiple source systems being merged.
- Poor migration logic or missing matching rules.
- Users unable to find existing customers before creating new ones.
Resolution Steps
1. Run a Duplicate Detection Report
- Go to Advanced Settings → Data Management.
- Select Duplicate Detection Jobs.
- Choose New.
- Select the record type (Account or Contact).
- Choose the appropriate matching rule (e.g., email + name).
- Run the job and review results.
2. Review Suggested Duplicates
- Open each potential duplicate pair.
- Compare key fields such as:
- Full name
- Phone number
- Address
- Account relationships
3. Merge Duplicates
- Open one of the records.
- Select Merge on the command bar.
- Choose which record will be the Master.
- Select field-by-field which values to keep.
- Confirm merge.
4. Create or Adjust Matching Rules (Optional)
- Go to Advanced Settings → Data Management → Duplicate Detection Rules.
- Rule examples:
- Contacts: Email exact match OR Mobile + Last Name match.
- Accounts: Account Name + Postcode.
- Publish the rule.
Validation
- Searching for a customer returns only one clean record.
- Merged record contains relevant historical activities and cases.
- Dashboards and reports show accurate counts.
Additional Notes
- Merging also reassigns related records (cases, activities) to the surviving entity.
- Always test duplicate rules in a non‑production environment.
