How should a dealership handle duplicate customer records?

Name the master

Identity has to resolve somewhere. Usually the DMS holds the transactional truth and the CRM or CDP holds the marketing view. Whichever you choose, write it down, because unstated ownership is what produces conflicting records.

Define matching before buying a tool

What makes two records the same person: exact email, phone, name plus address, household? The rule set determines the results far more than the software does.

Merging must be reversible and logged

Merges destroy information. Require an audit trail and the ability to unpick a bad merge, and restrict who can perform one.

Fix the intake

Duplicates are created at write-up and lead capture. Validation at the point of entry prevents more duplicates than any periodic cleanup.

Measure the problem first

Run a report to estimate the share of customers with more than one record, using a simple rule such as the same phone or email. Sample fifty pairs and check by hand whether they are true duplicates.

This gives an error rate to use in deciding the effort. It also shows which processes create the duplicates, such as lead forms, walk-ins or imports.

Merging safely

Decide the surviving record's rules, for example the record with the most recent transaction, and which fields carry over. Preserve history from both, keep opt-out flags from either, and log every merge with the person and time.

Merge in small batches, check results, and keep a way to reverse. Avoid automatic merges based on a single weak match such as a common name.

Preventing new duplicates

Add a search step before creating a new customer, require a phone or email where possible and standardize address formats. Train staff on the search step and review duplicates created each month by user.

Ask the CRM and DMS vendors how they detect matches at entry. Prevention at the front desk is cheaper than repeated cleanup projects.

Questions to ask systems providers

How does each system detect a possible duplicate at entry? Can we set our own matching rules?

Is there a merge tool with an audit trail? How are merged records shared with connected systems?

Can a merge be reversed? Answers differ between systems, and mismatches cause duplicates to reappear after cleaning.