Match Rules

Learn how match rules identify records that belong to the same person.

Match rules are the heart of Identity Resolution. They define which field combinations identify records as belonging to the same person. In this article, we'll explore how matching works and strategies for effective rule design.

How Matching Works

Identity Resolution uses a cascading match approach:

  1. All records from all sources are collected
  2. Rule 1 is applied—records that match are grouped together
  3. Remaining (unmatched) records move to Rule 2
  4. This continues through all rules
  5. Records that don't match any rule remain as separate identities
Match Cascade
📘

Note

Once a record matches a rule, it stops processing. This is why rule order matters—place your highest-confidence rules first.

Anatomy of a Match Rule

Each match rule specifies:

ComponentDescription
Rule NumberThe order in which this rule is evaluated (1, 2, 3...)
PII FieldsThe fields that must match for records to be grouped

For example, a rule using Email + First Name + Last Name means: "Group records together if they share the same email AND first name AND last name."

Designing Effective Rules

Start Strict, Then Broaden

Your first rule should be your most confident match:

RuleFieldsConfidence
1Email + First Name + Last NameHighest
2Phone + First Name + Last NameHigh
3First Name + Last Name + PostalMedium
4Email onlyLower

This approach ensures:

  • High-confidence matches happen first
  • Broader rules only catch what stricter rules missed
  • You minimize false positives (incorrectly merging different people)

Choose Fields Wisely

Different fields have different matching characteristics:

FieldUniquenessData QualityNotes
EmailHighUsually goodBest single identifier, but people have multiple emails
PhoneHighVariableFormatting differences can cause misses
First + Last NameLow aloneGoodCommon names cause false positives; combine with other fields
Postal CodeLowGoodToo broad alone; useful as a supporting field
AddressMediumVariableFormatting variations can cause misses

Understanding Match Results

After running Identity Resolution, the Summary tab shows how your rules performed.

Match Results

Current Status

MetricDescription
Source RecordsTotal records processed across all source tables
Golden RecordsNumber of unified profiles created
Distinct Match ConfigurationsNumber of match rules applied

Matched Records On

The bar chart shows how records matched across your rules:

  • Each rule displays its count and percentage (e.g., Rule_1: 21 records, 36.21%)
  • Unmatched records didn't match any rule and remain as individual profiles
  • Colors help visualize the distribution across rules

Data Quality

This section highlights potential issues in your data:

MetricWhat It Means
Duplicate EmailsRecords with the same email found across sources
Conflicting RecordsRecords where sources have different values for the same field

The Conflicted Data in Columns table shows which fields have conflicts and how many — useful for identifying data quality issues upstream.

Interpreting Your Results

  • High Rule 1 matches — Your strictest rule is effective
  • Many unmatched records — Consider adding broader rules
  • High conflict counts — Review source data quality or adjust precedence

Troubleshooting

Too Many Unmatched Records

If most records aren't matching:

  1. Check PII coverage — Do your sources actually share common fields?
  2. Review data quality — Are there formatting differences (e.g., "[email protected]" vs "[email protected]")?
  3. Add broader rules — Consider rules with fewer required fields
📘

Note

Identity Resolution normalizes common variations (case, whitespace), but significant formatting differences may need data cleaning upstream.

Suspicious Merges

If unrelated people are being merged:

  1. Tighten rules — Add more required fields
  2. Check for data issues — Placeholder values like "[email protected]" can cause false matches
  3. Review source precedence — Ensure high-quality sources are prioritized

Missing Expected Matches

If records you know belong together aren't matching:

  1. Verify field mapping — Are the PII fields mapped correctly?
  2. Check for nulls — Records with null values in match fields won't match
  3. Review rule coverage — Do your rules cover this combination of fields?

Ready to understand your results? Continue to Output Tables to learn about the Final Identity Table and other outputs.


What’s Next

Understand your output tables