Salesforce finds and handles duplicates using a combination of matching rules and duplicate rules. Duplicate rules and duplicate jobs specify matching rules that determine how duplicates are identified. Duplicate sets and reports list the duplicates found.
Required Editions
| Available in: Lightning Experience and Salesforce Classic |
| Available in: Essentials, Professional, Enterprise, Performance, Unlimited, and Developer Editions |
1. A Matching Rule Compares Records and Detects Duplicates
The matching rule specified in a duplicate rule or job can compare records on the same object, such as leads, or one other object. For example, a rule can compare leads that duplicate contacts.
A matching rule consists of an equation that determines how to compare the fields in a pair of records. Criteria on the fields determine how broadly a match is defined. Indexing and algorithms speed up the matching process.
When a matching rule is activated, one or more match keys are applied to existing records. The matching rule looks only for duplicates among records with the same match key. If two records don’t share match keys, they aren’t considered duplicates, and the matching algorithms aren’t applied to them. This indexing process improves performance and returns a better set of match candidates.
2. A Duplicate Rule or Job Handles Duplicates
Duplicates can be detected when a sales rep creates, clones, or edits a record and a duplicate rule runs, or when you run a duplicate job. They can also be detected as part of other processes, such as importing or an API.
A duplicate rule alerts a sales rep and lists possible duplicates.
Duplicate job results list duplicates across an org.
3. Sets and Reports List Duplicates Found
Duplicate record sets list the duplicates found when duplicate rules or jobs run. Reports of duplicates are generated from these sets.
