How the roll-up gate works
This tool grades one list for exact copies and sneaky near-matches before you double-count or double-pay. It reads 7 records and rolls them into one verdict — the worst, never the average — then a gate that can only make it worse.
The 7 records
An exact email-key match to an earlier record is a DUPLICATE no matter what else differs, and a shared name or phone with a different email is only a REVIEW - but one DUPLICATE is enough to hold the whole batch at HAS DUPLICATES, whatever share of records are otherwise unique.
Why: Five of seven records are unique and one is a near-match worth a review - a mail-relay alias for Jane Doe sharing her phone number. But row 3 is an exact email match to row 1, so it's a DUPLICATE outright. Batch status is the worst record, never the average, so it reads HAS DUPLICATES.
No single record is the crisis — the clustering is. The roll-up takes the worst, the gate escalates when trouble compounds, and it names the one thing to fix first. Matches on the fields you provide using exact and shared-field rules; it does not merge records for you and does not identify people beyond the data given.