Library / Data quality / data-quality-002

Duplicate contact detection and merge review queue

Data quality Operations Hub Professional Contact Intermediate ~45 min to build

Outcome. Contacts that look like duplicates of an existing record are flagged into a review queue within minutes of creation, instead of being discovered weeks later during reporting.

Workflow mapEnrollment, branches and actions at a glance
flowchart TD
    A[Contact created] --> B[Custom code: search for near-match by domain+lastname or phone]
    B --> C{Match found?}
    C -->|yes| D[Flag Possible duplicate, store match ID]
    D --> E[Add to review list + create review task]
    C -->|no| F[Leave as Not checked]

When to use it / when not to

What the full spec adds

  • Prerequisites: 5 items, every property with its internal name, type and options
  • Enrollment: trigger, criteria as ticked in the UI, re-enrollment rule, suppression
  • Steps: 3 numbered actions with their parameters, branches and delays
  • Known pitfalls: 4 traps seen in production
  • Test plan, Variants and the YAML build spec
  • Files: PDF, Markdown, properties JSON to create the fields in one API call, and the custom coded action as a ready-to-paste .js file

One-time payment. Includes every spec added to the pack later, up to the full 500. Consultants: Everything, forever adds the agency licence for unlimited client portals.

Everything add-on Install this workflow in my portal Two clicks: authorise your portal, confirm. Properties created, workflow delivered switched off, ready to review. Coming to Everything and Pro buyers first.