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.
Note The upper and lower case dotted I characters, or i-dot, found in languages such as
Turkish and Azerbaijani aren’t detected in duplicate matching. For example, the accounts
“iTest” and a second record named “İTest” aren’t identified as duplicates.
Did this article solve your issue?
Let us know so we can improve!
Loading
Salesforce Help | Article
Cookie Consent Manager
General Information
Required Cookies
Functional Cookies
Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.