# Placeholder values in required fields look like real data

Sentinels pass validation, then break blocking and blend into amounts.

By Ki Moon · 2026-09-21 · finding · current
Canonical: https://kihmoon.com/bench-notes/p/sentinel-values-look-like-data/

**Symptom:** A dedup or matching job slows sharply on one object, and its biggest block shares a placeholder name like "[not provided]".

Required fields get filled whether or not anyone knows the answer. An import that needs a last name writes "[not provided]", and an integration that needs an amount writes a template value.

Sentinel names wreck blocking. Dedup groups records by name before comparing pairs, so every record with the placeholder lands in one block, and pairs grow with its square.

Keeping sentinels out of the blocking keys makes the giant block go away, and intermediate rows fall by orders of magnitude.

Amounts are harder. A templated round number sits inside the real range, so no single value looks wrong. Only a cluster of identical amounts gives it away.

In a synthetic test set of 10,000 contacts, 1,000 of them carrying a placeholder name, blocking on name made 513,133 candidate pairs; excluding the placeholder left 13,633. The set shows the mechanism, not how common it is.

## Check your setup (read-only)

List the 20 most frequent values in each required name field and each amount field. Any placeholder string is a sentinel your matching and math will read as real. A round amount far more common than its neighbours is also a sentinel.

**Passes if:** The 20 most frequent values in each required name or amount field hold no placeholder and no outlying round amount. Otherwise, your matching excludes those values.

**Access needed:** crm-read

## If it fails (changes to make later, not part of the check)

1. Keep a per-field list of known placeholders, such as "[not provided]". Read listed placeholders as null.
2. Exclude placeholder values, like nulls, from dedup blocking keys.
3. Review any value in a field's 20 most frequent that has no plausible reason to repeat.
4. Flag round amounts that repeat far more often than nearby values. Keep flagged amounts out of averages until reviewed.

**Applies if:** Your dedupe or enrichment matches people or accounts by name, or your digests average CRM amounts, and imports or integrations fill required fields.

**Skip if:** Your CRM's import log and integration users show no writes to required fields.

Tags: data quality, matching, crm
