Dealership CRM Data Cleanup: Duplicates, Bad Numbers and Consent Flags

Dealership CRM data cleanup is a scheduled review that merges duplicate customer records, fixes or flags bad phone numbers and emails, confirms every opt-out sits in a structured field, and reassigns leads with no active owner. A quarterly pass, measured with five simple numbers, keeps a dealership CRM usable for follow-up and consent rules.

At a glance

• Most CRM data problems at a dealership fall into five groups: duplicate customers, bad phone numbers and emails, missing consent and opt-out flags, orphaned leads, and missing lead sources.
• Five numbers show whether a CRM cleanup worked: duplicate rate, contactable rate, opt-out match rate, orphaned lead share and missing-source share.
• When two customer records are merged, the most restrictive consent setting should survive, so a recorded opt-out is never lost in the merge.
• Since April 11, 2025, FCC rules require callers and texters to honor an opt-out made by any reasonable means within 10 business days, which makes opt-out flags the highest-risk field in a dealership CRM.
• A cleanup only lasts if intake rules change too: match before creating a record, require a lead source, and reassign leads the day a salesperson leaves.

What dealership CRM data cleanup covers

Dealership CRM data cleanup covers five kinds of bad records, and each one breaks a different part of follow-up. Ranking guides on CRM data hygiene, including DriveCentric's dealer guide and CDK Global's article on clean CRM data, agree on duplicates and contact details. Consent flags and orphaned leads get less attention, yet they cause the most avoidable trouble.

• Duplicate customers. The same buyer appears two or three times, often once from an internet lead, once from a walk-in and once from service. Two salespeople may follow up on the same person, and reports count one shopper as several leads.
• Bad phone numbers and emails. Numbers typed wrong, landlines on a texting list, numbers that have been disconnected and given to someone else, and emails that bounce.
• Missing consent and opt-out flags. A customer texted STOP in the texting tool or unsubscribed from email, but the CRM record still shows them as contactable, or the opt-out is written in a note instead of a field.
• Orphaned leads. Open leads owned by a salesperson who has left, or leads with no activity and no next task for weeks.
• Missing lead source and required fields. Leads with a blank or "other" source, which makes cost per sold unit by source impossible to calculate.

A CRM cleanup does not replace the DMS as the record of sold vehicles and repair orders. Decide which system is the source of truth for each field before changing anything: usually the DMS for sold status and service history, and the CRM for leads, follow-up and communication preferences. The guide to what a DMS does and what a CRM does explains the split.

Five numbers to measure CRM data health

Five numbers, taken from a CRM export before and after each cleanup, show whether the data is getting better or worse. No public industry benchmark for these numbers was found during research for this article, so the useful comparison is your own store against last quarter, not against other dealers. The formulas below are a suggested method, not a standard.

1. Duplicate rate = extra records in duplicate sets ÷ total customer records. If three records describe one person, two of them are extra.
2. Contactable rate = records with at least one working mobile number or deliverable email ÷ total customer records.
3. Opt-out match rate = opt-outs that also appear as a flag on the CRM record ÷ all opt-outs held in your texting, email and calling tools. The target is 100 percent.
4. Orphaned lead share = open leads with an inactive owner, no owner, or no activity in the last 30 days ÷ all open leads.
5. Missing-source share = leads created in the last 12 months with a blank, "unknown" or "other" source ÷ all leads created in that period.

The 30-day and 12-month windows are suggestions. Use whatever window matches your store's sales cycle, then keep it the same each quarter so the numbers stay comparable. An RV or marine store with long buying cycles may use 60 days for the orphaned lead check.

Step 1: Merge duplicate customer records safely

Duplicate customer records should be merged, not deleted, because each copy may hold history, notes or a consent record that the others lack. Merging in bulk without rules is how stores lose opt-outs and service history.

How to find duplicate customers

Duplicate customers are easiest to find by matching on normalized contact details. Strip spaces, dashes and country codes from phone numbers, lowercase email addresses, then match on:

• the same mobile number;
• the same email address;
• the same last name and street address, sent to a person for review rather than merged automatically.

DriveCentric's guide advises against using the VIN alone to identify a person, which fits dealer reality: one vehicle can pass through several owners, and one household can share a vehicle.

Merge rules that protect consent and history

• The most restrictive consent wins. If any copy of the record carries an opt-out or do-not-contact flag, the merged record keeps it, with the date it was recorded.
• Keep the evidence. Keep the original consent date and source (for example, the web form or credit application) from whichever record has them.
• Keep all activity. Calls, texts, notes and appointments from every copy should move to the surviving record.
• One owner. Decide ownership with your written lead rules. The guide to lead distribution and ownership rules includes a duplicate rule that can be reused here.
• Log the merge. Record who merged which records and when, so a mistaken merge can be traced.

Step 2: Fix invalid and stale phone numbers and emails

Invalid and stale contact details should be corrected where possible and flagged where not, rather than deleted, so the record still shows what was tried. Work through phone numbers first, because calls and texts carry the strictest rules.

• Format. Put every phone number in one format and flag numbers with the wrong number of digits.
• Line type. Mark which numbers are mobile and which are landlines, so landlines are left out of texting lists.
• Reassigned numbers. A number that was valid when the customer gave it may now belong to someone else. The FCC's Reassigned Numbers Database, live since November 1, 2021, lets registered callers enter a number and a consent date and returns whether the number has been disconnected, and possibly reassigned, since that date. Subscribers pay a fee, and the FCC page describes a safe harbor from liability when the database gives a wrong "no" answer. Checking matters most for older leads, as covered in the aged lead reactivation method.
• Email. Flag addresses that hard-bounce in your email platform and match them back to the CRM record. Ask for an updated address at the next service visit or call instead of guessing.

Mailing addresses age too, but they matter less for daily follow-up. Correct them when the customer next visits or when a mailing comes back.

Step 3: Audit consent and opt-out flags

Consent and opt-out flags need the most care in a dealership CRM cleanup, because an opt-out lost between systems can lead to a message the customer asked not to receive. This section summarizes federal rules as reported by the FCC, the FTC and a law firm; it is not legal advice, and state rules can add more. Have counsel confirm what applies to your store.

What the federal rules say

• Calls and texts. FCC consent revocation rules that took effect on April 11, 2025 require callers to honor an opt-out made by any reasonable method within a reasonable time not exceeding 10 business days, according to a January 12, 2026 summary by law firm Hunton. The same summary reports that the separate "revoke-all" provision, which would apply an opt-out from one type of message to unrelated messages, has been delayed to January 31, 2027.
• Email. The FTC's CAN-SPAM compliance guide says senders must honor an opt-out within 10 business days, keep the opt-out mechanism working for at least 30 days after sending, and may not sell or transfer the addresses of people who opted out.
• Telemarketing calls. Since January 1, 2005, the FTC has required telemarketers to remove newly registered numbers from their call lists every 31 days, according to the FTC's December 2004 announcement. Exceptions, such as an existing business relationship, have their own conditions that counsel should confirm.

The consent audit checklist

• Export the opt-out lists from every tool that contacts customers: texting, email, calling, and any lead vendor that sends messages for you.
• Match each opt-out to a CRM record and set a structured do-not-text, do-not-call or do-not-email flag with the date. Notes do not count, because lists and automations cannot read them.
• Calculate the opt-out match rate. Any gap means some system can still reach a customer who said no.
• Search notes and message history for opt-out wording that never became a flag, such as "please stop texting me" or "take me off your list".
• Check that consent dates and sources are filled in for customers on texting lists. The dealership text messaging guide covers what consent texting usually needs.
• Keep opt-out records even when a customer record is cleaned up or archived. The suppression record is what stops a re-imported lead from being contacted again.

Step 4: Reassign or close orphaned leads

Orphaned leads should be reassigned to an active salesperson or closed with a reason, because a lead with no working owner receives no follow-up at all. Run three filters on open leads:

• the owner is inactive or has left the store;
• no call, text, email or note in the last 30 days;
• no next task or appointment scheduled.

For each lead found, a manager decides: reassign with a next task due within two business days, move it to a long-term nurture list with consent checked, or close it with a reason such as "bought elsewhere" or "no longer in market". Closing with a reason keeps the pipeline honest and gives the sales manager's daily CRM review fewer stale leads to sort through.

If you want an outside view of where leads and follow-up are slipping at your store, the Revenue Leak Audit from Shiftix Cloud is complimentary and looks at lead response, follow-up and accountability.

Worked example: one quarterly CRM cleanup

The worked example below uses illustrative numbers for a hypothetical store, not data from a real dealership, to show how the five numbers are calculated and read. The store exports 9,400 customer records, 380 open leads and 4,200 leads created in the last 12 months.

• Duplicate rate. Matching finds 610 duplicate sets containing 1,320 records. Merging leaves 610 records, so 710 were extra: 710 ÷ 9,400 = 7.6 percent.
• Contactable rate. 8,050 records have a working mobile number or deliverable email: 8,050 ÷ 9,400 = 85.6 percent.
• Opt-out match rate. The texting tool holds 212 opt-outs, but only 171 are flagged in the CRM: 171 ÷ 212 = 80.7 percent. The 41 missing flags are fixed first, before any campaign goes out.
• Orphaned lead share. 64 of the 380 open leads have an inactive owner or no activity in 30 days: 64 ÷ 380 = 16.8 percent.
• Missing-source share. 1,150 of the 4,200 leads have no usable source: 1,150 ÷ 4,200 = 27.4 percent.

Read in order of risk, the 41 unflagged opt-outs come first, the 64 orphaned leads second, and duplicates third. The missing-source share does not cause harm to customers, but at 27.4 percent it means more than a quarter of the store's leads cannot be tied to the money spent on them. In this example, the store makes lead source a required field and repeats the measurement next quarter.

Keeping CRM data clean between cleanups

CRM data stays clean between quarterly cleanups only when the way records enter the CRM changes. Most guides stop at the cleanup itself; these intake rules are what keep the next quarter's numbers lower.

• Search before creating. Train salespeople, BDC agents and service advisors to search by mobile number and email before adding a new customer.
• Require a lead source. Use a fixed list of sources, not free text, and remove "other" or limit who can choose it.
• Record opt-outs where they happen. When a customer says "don't text me" on the phone or at the counter, the person who heard it sets the flag that day.
• Reassign on the day someone leaves. Make lead reassignment part of the exit checklist, alongside removing CRM access. Removing access promptly is also part of the safeguards covered in the FTC Safeguards Rule checklist for dealerships.
• Give one person ownership. A BDC manager or CRM administrator owns the five numbers. The BDC manager's weekly scorecard is a natural place to report them.
• Do a 15-minute monthly spot check. Pull ten new records and ten recent opt-outs and confirm they look right. Problems found monthly are smaller than problems found quarterly.

Where Shiftix Cloud fits in CRM data cleanup

Shiftix Cloud's CRM and Unified Customer Inbox address some of the intake problems above, and the published product pages describe the following. The CRM page says customer details, lead source, vehicle interest, ownership and recent activity are kept together in the opportunity record, and that ownership changes are tracked as opportunities move through the business. The Unified Customer Inbox page says STOP, UNSUBSCRIBE and equivalent keywords are recognized, persisted and honored permanently for Shiftix-managed messaging, and that the first message to a new contact automatically gets the business name and opt-out disclosure. The same page notes that dealers still need their own consent policies.

Shiftix Cloud is not a DMS; it works alongside one. The integrations page lists DMS platforms such as CDK (Drive), Reynolds & Reynolds, Dealertrack and Tekion, and says availability, data direction and permissions are confirmed during implementation. The product pages read for this article do not describe duplicate detection or record merging, so ask how duplicates are handled, in Shiftix Cloud or any CRM, before relying on it for Step 1.

Next steps

The right first step depends on which of the five numbers is worst at your store today.

• If you do not know your numbers, run one export and calculate all five before changing anything.
• If opt-outs do not match across systems, fix that before the next text or email campaign, then follow the consent checks in the aged lead reactivation guide before contacting older leads.
• If orphaned leads are the problem, write ownership rules using the lead distribution guide and add reassignment to the staff exit checklist.
• If lead sources are missing, make source a required field, then use the cost per sold unit method once a quarter of clean data exists.
• If texting registration is part of the problem, the 10DLC registration guide covers how consent wording affects carrier approval.

Frequently asked questions

How often should a dealership clean its CRM data?

A dealership should run a full CRM data cleanup at least once a quarter, with a short monthly spot check in between. CDK Global suggests auditing the database monthly or quarterly, and a 2021 Digital Dealer article recommends quarterly maintenance. Opt-out flags are the exception: they should be recorded the same day a customer asks, not saved up for the next cleanup.

Who should own CRM data quality at a dealership?

One named person should own CRM data quality, usually the BDC manager or a CRM administrator. Everyone who enters data shares the work, but a single owner runs the quarterly cleanup, reports the five health numbers to the general manager, and fixes intake rules when the same problem keeps coming back. Without a named owner, cleanup tends to happen only before a CRM switch.

Does a STOP text in one tool opt the customer out of every dealership system?

A STOP text opts the customer out only in the tool that received it unless that tool shares the opt-out with your other systems. That is why the consent audit compares opt-out lists across texting, email and calling tools. Separately, the FCC's revoke-all provision, which would extend one opt-out to unrelated message types, has been delayed to January 31, 2027.

Find where follow-up is slipping before the next campaign

Clean CRM data is the starting point for faster lead response and steadier follow-up. The Revenue Leak Audit from Shiftix Cloud is complimentary, carries no obligation and requires no software purchase. It looks at lead response, follow-up, conversion, customer retention, accountability and workflow, and Shiftix walks through the findings with you.

Sources

• DriveCentric, 7 CRM Data Hygiene Best Practices for Auto Dealers (May 26, 2026)
• CDK Global, article on clean CRM data and car sales by Mary Guo (July 7, 2026)
• Digital Dealer, dirty CRM data article by Billy Reynolds (September 21, 2021)
• Federal Communications Commission, Reassigned Numbers Database
• Hunton, Portion of TCPA Global Revocation Rules Further Extended (January 12, 2026)
• Federal Trade Commission, CAN-SPAM Act: A Compliance Guide for Business
• Federal Trade Commission, Telemarketers Required to Scrub Their Call Lists Every 31 Days (December 2004)
• Shiftix Cloud, CRM
• Shiftix Cloud, Unified Customer Inbox
• Shiftix Cloud, Integrations
• Shiftix Cloud, Revenue Leak Audit