How deduplication works
After reading, you can predict which records a deduplication rule keeps and which it removes.
A deduplication rule says which field marks duplicates and which record of a group stays. CAB applies the rules while an audience runs, before anything counts or is acted on.
Which audiences take part
Section titled “Which audiences take part”An active rule applies to every audience of its object, except audiences where Deduplicate this audience is cleared. Audiences take part by default. A rule you add or change applies from each audience’s next run; a run already under way keeps the rules it started with.
How records are matched
Section titled “How records are matched”- Records are grouped by the exact stored value of the match field, including upper and lower case:
Jane Doeandjane doeare two values. - Empty values never form a group. An email rule keeps every record without an email address.
- The keep sort decides which record of a group stays. Records with no value in the keep-sort field are removed first, and ties are broken the same way every time.
- With several rules, each rule works on what the rule before it left. An object can have up to three active rules.
- In a waterfall sequence, the order of the steps comes first: when an earlier step already holds a value, the later step gives it up. The keep sort decides only within a step.
Salesforce stores email addresses in lower case, so email rules match regardless of how people typed them. Phone numbers match only when they are stored the same way: +49 30 1234 and 030 1234 are different values.
Match a field regardless of case
Section titled “Match a field regardless of case”Every field other than email keeps what was typed. To match, say, company names regardless of case, deduplicate on a lower-case copy:
- Create a text field for the copy, for example Company Name (lower case).
- Add a before-save record-triggered flow that writes the lower-case value whenever the source field changes.
- Fill the field once for existing records, because the flow only runs on save.
- Choose that field as the rule’s Match field.
When a run fails instead
Section titled “When a run fails instead”CAB never delivers a partly cleaned audience. Above the run limits, the run fails and publishes nothing, and the run history shows the error. See CAB Settings.
- Match field. The field whose shared value marks records as duplicates.
- Keep sort. The field that decides which record of a group stays.
- Rule. Match field, keep sort and direction for one object.

