Data Cleaning for Auto Dealer CRM Systems: DMS Exports, Internet Lead Databases, Service Department Records and Multi-Franchise Dealership Groups
On this page
The Dealership Data Problem
Auto dealerships generate more customer data per transaction than almost any other retail business. A single vehicle purchase creates records in the dealer management system (DMS), the CRM, the finance system (if the customer financed through the dealership), the service scheduling system, the manufacturer's customer database, and potentially the dealership's internet lead system and marketing platform. Each system stores slightly different information in slightly different formats, and none of them talk to each other as cleanly as the vendor promised.
The result is data chaos. A customer who bought a vehicle in 2020, had it serviced six times over four years, traded it in for a new vehicle in 2024, and also submitted an internet lead on a third vehicle they did not buy might exist as four or more separate records across the dealership's systems: a sales record from 2020, a service record (possibly under their spouse's name because the spouse dropped it off), an internet lead record with a different email address, and a new sales record from 2024.
This fragmentation creates real business problems. The dealership cannot see the customer's full relationship history in one place. Marketing campaigns go to stale email addresses while valid ones sit in a different system. Equity mining campaigns (identifying customers with positive trade-in equity for targeted offers) are inaccurate because the system does not know the customer already traded in their vehicle. Service retention campaigns go to customers who sold their car three years ago.
Exporting from Dealer Management Systems
The DMS is the backbone of dealership operations, and the primary source of customer and vehicle data.
CDK Global (formerly ADP Dealer Services) is the most widely used DMS, powering roughly 30,000 dealerships. CDK exports customer data through its reporting module, with fields for customer name, address, phone, email, vehicle information (VIN, year, make, model, mileage at last service), purchase date, service history, and finance contract details. CDK's data structure separates sales and service records, which means the same customer may have different customer IDs in the sales module and the service module.
Reynolds and Reynolds (the second-largest DMS provider) exports customer data with similar fields. Reynolds' ERA platform stores customer, vehicle, parts, and service data. Reynolds historically has been more restrictive about data exports than CDK, so extraction may require working with your Reynolds representative or using the platform's built-in reporting tools.
DealerSocket (now part of Solera) functions as both a CRM and a light DMS for many dealerships. Exports include customer contact information, deal history, communication logs (emails, calls, texts), and lead source tracking. DealerSocket's CRM data is often richer in communication history than DMS data but may lack the detailed service and parts records that a full DMS provides.
VinSolutions (a Cox Automotive product) is a CRM platform widely used alongside CDK or Reynolds as the DMS. VinSolutions exports include customer profiles, vehicle interests, communication history, and lead source attribution. Because VinSolutions is a CRM rather than a DMS, its records focus on the sales process (leads, follow-ups, appointments, deals) rather than the full ownership lifecycle (service, parts, warranty).
Export customer data from all systems the dealership uses. This typically means exporting from the DMS (sales and service records), the CRM (lead and communication records), and any separate marketing platforms (email marketing, loyalty programs, customer satisfaction survey tools).
Deduplication Across Sales and Service
The most critical deduplication task at a dealership is matching sales records with service records. When a customer buys a vehicle, a sales record is created. When they bring the vehicle in for service, a service record is created -- often by a different person at a different time, potentially with slightly different contact information (the service advisor may have the customer's cell phone while the sales record has their home phone, or the service record may use the spouse's name and email).
Upload all exports to Email Extractor to extract and deduplicate email addresses across the sales and service databases. The deduplication reveals customers who exist in both systems (which should be the majority of service customers, since most service at a franchise dealer is from customers who bought there), customers who appear only in service records (these are conquest service customers who bought elsewhere -- a valuable segment for sales outreach), and customers who appear only in sales records but not in service records (these are customers who are not returning for service -- a retention problem).
After email deduplication, match remaining unmatched records by VIN (Vehicle Identification Number). A VIN links a vehicle to every transaction in which it appears: sale, service, trade-in, and warranty. If the same VIN appears in a sales record under "John Smith" and a service record under "Jane Smith," these are likely household members associated with the same vehicle. Link them as a household rather than treating them as duplicates.
Internet Lead Database Cleaning
Dealership internet lead databases are notoriously dirty. Web form submissions come from customers who are genuinely shopping for a vehicle, customers who submitted a form by accident, competitors researching your inventory, and bots that fill out forms with fake information. Many internet lead forms ask only for name, email, and phone -- and customers frequently provide fake or incomplete information to get a price quote without committing to a conversation.
Export your internet lead database (from VinSolutions, DealerSocket, or whatever CRM handles your internet leads). Upload to Email Extractor to extract valid email addresses and remove obviously invalid entries. Internet lead databases typically have 15-30% invalid email addresses, compared to 5-10% in a sales or service database.
After extraction and deduplication, segment internet leads by age and status. Leads from the past 30 days are still potentially active shoppers. Leads from 30-90 days ago may still be in the market but have likely visited other dealerships. Leads older than 90 days are cold -- the customer has likely either purchased elsewhere or is no longer in the market. Each segment warrants a different follow-up approach: active leads get a sales follow-up, 30-90 day leads get a "checking in" email with a compelling offer, and cold leads go into a long-term nurture sequence or are archived.
Equity Mining Preparation
Equity mining is the process of identifying current customers whose vehicles have positive trade-in equity -- meaning their vehicle is worth more than their remaining loan balance -- and targeting them with upgrade offers. This is one of the most profitable marketing strategies for franchise dealerships because it generates high-intent leads from existing customers (who already trust the dealership) for both a sale (the new vehicle) and a trade-in (which becomes used inventory).
Equity mining requires clean data because it depends on accurate vehicle information (current vehicle year, make, model, mileage estimate, remaining loan balance) matched to accurate customer contact information. If the customer record has an old email address, or if the vehicle was already traded in but the record was not updated, the equity mining campaign wastes money on unreachable or irrelevant contacts.
Clean your customer database before running equity mining lists. Export the combined sales, service, and finance database. Upload to Email Extractor to deduplicate and verify email addresses. Cross-reference with recent sales records to remove customers who have already traded in their vehicles (this is a surprisingly common error -- the old ownership record persists in the DMS even after the trade-in is processed, and equity mining tools sometimes pick it up).
Multi-Rooftop Consolidation
Dealer groups that operate multiple franchise rooftops (a Honda store, a Toyota store, and a Chevrolet store, for example) need consolidated customer databases to avoid the common problem of the same customer receiving separate outreach from each rooftop. A customer who bought a Honda from the group and later bought a Toyota from the same group should be recognized as one customer with two vehicles, not as two unrelated customers.
Export customer data from each rooftop's DMS and CRM. Upload all exports to Email Extractor for cross-rooftop deduplication. The "CSV with sources" download shows which rooftop(s) each customer appears in, making it easy to identify cross-shopping customers and households that own vehicles from multiple brands within the group.
After consolidation, assign a "home rooftop" for each customer (the rooftop where they most recently purchased or serviced a vehicle) and share the consolidated database with the group's marketing team for coordinated outreach. This prevents the embarrassing and wasteful scenario of three rooftops independently emailing the same customer in the same week.
