Skip to content
Adoptiv

Duplicate Detection

The same person landing on your list twice is what this stops. Before a lead is written it is checked on the email, and failing that the phone, both cleaned up first. Exact, with no similarity score for anybody to argue about.

See pricing

An incoming row that already exists

matched on email
Email · checked first
matched
trimmed and lowercased, nothing more
Phone · only if email did not match
not reached
00 44 7700 900 412
+447700900412
digits only, and the lead's mobile if there is no main number
Then
Field by field
on file · in the row · outcome
  • Job titlereplacedOperations ManagerHead of Logistics
  • Cityleft aloneOaklandempty
  • Lead scorereplaced6274
  • Assigned tonever touchedS. BhattM. Ortiz
  • Tagsnever touchedenterprisewebinar
  • Custom fieldsadded toterritoryfleet_size
Email then phone, both normalised · no name matching, no similarity score, and no record is ever folded into another
A non-empty incoming value replaces what was there. This is not a fill-the-blanks merge and it should not be sold as one. An empty cell in the file is ignored rather than treated as a deletion, and the assignment, tags and account fields are on a list the update is not allowed to touch at all.
0
checks, and always in that order
0
rows checked in one go, not one at a time
0
approximate matching anywhere in it

Product figures from the platform’s own defaults - not customer averages

The mechanism

How it works.

01

Email first, because it identifies

An email match is taken over a phone match whenever both are available, on the grounds that two people genuinely share a switchboard number far more often than they share a mailbox. Names are never compared at all.

02

Cleaning it up first is what makes it exact

Addresses are trimmed and lowercased. Numbers are reduced to their digits and rebuilt behind a plus, and a leading double zero is read as the international prefix it is, so a number wrapped in brackets and dashes lands on the same key.

03

Checked per chunk, not per row

During an import the comparison runs once for a whole batch of five hundred rather than once per row. Within a run the row identifiers are fixed, so a crash and a retry pick up without doubling anything; a second upload of the same file is a fresh run and leans on the keys alone.

04

The original wins, not the newest

Where several records hold the key, the earliest created one is the match. An incoming row therefore joins the record that has been accumulating history, rather than the copy somebody made last week.

Where it sits

Two moments in every record.

Every record passes through the same seven. Duplicate Detection is the lit ones, and everything either side of it is a different page in this category.

  1. 01
    Capture

    how it arrives, and from where

  2. 02
    Shape

    the fields and stages it carries

  3. 03
    Find

    getting back to the right ones

  4. 04
    Work

    what happens against it day to day

  5. 05
    Advance

    moving it toward a decision

  6. 06
    Protect

    who may see it, and staying clean

  7. 07
    Report

    what the floor is judged on

The specifics.

8 facts
Keys
Normalized email, then normalized phone. Names and addresses are never read
Email rule
Trimmed and lowercased. Dots and plus-addressing are not folded together
Phone rule
Primary then mobile, reduced to digits behind a plus. Home and other ignored
Method
Exact once normalized. No similarity scoring and no confidence value
Tie break
The earliest created record is chosen when several carry the key
Runs on
Import, and any lead a call creates. Not scheduled, and not on demand
Two runs at once
The call path holds a transaction lock. Concurrent imports are best effort
Normalized both ways
The stored key and the incoming one are built by the identical routine, so a match cannot depend on which side was typed first

More in Leads & Sales CRM

12 capabilities

The system of record the phone writes to directly - nothing to sync.

Deals & Pipelines

Each stage carries its own odds, so where a deal sits is already most of a forecast. Unlimited pipelines, seven seeded, every stage change written down.

Lead Stages

Name the stages your floor actually argues about, color them and rate them hot, warm or cold. Six fixed categories keep last quarter comparable with this one.

Lead Sources

The same source can never arrive spelled three ways. Ten come seeded and sealed, yours sit beside them, and renaming one carries every lead holding it.

Custom Fields

The thing your business tracks that no CRM ships with. Eleven types on leads, deals, products and vendors, no migration to schedule and nobody to wait on.

Field Groups & Layouts

Some of what you collect is not for everyone on the floor. Close a whole section once per profile instead of opening and shutting a hundred fields one by one.

Saved Views

Hand a list to a CRM role rather than a person and the question outlives whoever first asked it. A new hire opens the board instead of rebuilding it daily.

Advanced Filtering

Ask the same question tomorrow and the list narrows the same way, because the server settles it. Eighteen operators, fitted to the kind of field they sit on.

Activities & Timeline

Nobody writes this up. A field change keeps both readings, before and after, beside the notes, mail and tasks, so it still means something in six months.

Touchpoints

Every exchange with this lead on one line: calls, voicemails, mail and text. A call lands on the right record by the number it reached, linked by nobody.

Tasks & Reminders

A thing owed, by a named person, by a date. At the hour you set it leaves the product to find them, rather than sitting in a list waiting to be spotted.

Roles & Permissions

The rep two desks over cannot open the book you are working, and one BPO client never sees the next. Sixteen permissions, sharing rules across branches.

Goals & Leaderboards

A number, a window, and somebody standing against it. Attainment is worked out from won deals and logged work as you open it, so nothing sits going stale.

Leads & Sales CRM

See duplicate detection on your own floor.

Thirty minutes, your numbers and your data. We will set duplicate detection up live and you can decide from the thing itself rather than from this page.

See pricing

14-day trial · no card · migration included