Loading
Salesforce now sends email only from verified domains. Read More
Data Quality
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Duplicate Detection and Handling Process

          Duplicate Detection and Handling Process

          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
          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.
           
          Loading
          Salesforce Help | Article