DataGlue

Customer data

How to recognise the same customer across your systems

Understand why duplicate customer records appear, which identifiers can connect them and how to keep uncertain matches visible.

By DataGlue · · 3 min read

Who this is for

Teams whose customers appear under different records across their systems.

The useful starting point

Agree which identifiers justify a link. Check confirmed, possible, conflicting and unmatched records before using a customer history to make a decision.

One person can look like several customers

A customer visits your site, books a call, signs a contract and pays an invoice. Each system may create its own record. When a team counts those records without checking the links between them, a returning customer can appear new and parts of the relationship disappear from view.

A shared customer view begins with identity resolution: deciding which records belong together. It is not simply a matter of putting every export in the same place. The business needs a clear basis for each match and a way to inspect disagreements.

List the identifiers your systems already use

Start with your CRM, website, booking system and payments. Note which customer IDs, account IDs and email addresses each source records. Check whether an identifier follows the customer into the next system or gets replaced with a new one.

Then look at exceptions. An organisation may have several contacts. A family may share an email. An employee may book on behalf of another person. An account, a person and an order are different things; a common detail should not silently erase that distinction.

  1. List the record types: people, accounts, bookings and orders.
  2. Record the identifiers each source provides.
  3. Check whether each identifier is unique and stable in that source.
  4. Agree which combinations justify a confirmed match.

Keep ambiguous records separate

An exact email match can be useful, but two CRM contacts with the same email still create a conflict. Similar names or a shared device do not establish that two records are one person. Treat these as questions to investigate, not proof that a merge is correct.

DataGlue distinguishes confirmed CRM links from possible links, conflicts and unmatched records. That gives your team a way to see what is known and where another trusted detail is needed. Website profiles sharing an email may merge automatically; CRM links have their own explicit match states.

Test the view against real customer questions

Choose a question such as: which clients have signed more than once? Follow a small sample back to the contracts and contact records. Check a confirmed customer, an ambiguous match and an unmatched record. Your team should be able to explain each case without guessing.

Once those rules are dependable, the same joined history can support sales preparation, repeat-customer analysis and reporting. DataGlue starts with one decision and the records it needs, so identity work has a business purpose from the beginning.

Your next step

Start with a customer your teams already know.

Use a familiar history to check how the records join and where another trusted detail is still needed.

Explore customer identity