Share your automotive expertise

2 Write a Blog Post

The Importance of Clean Data

By Hunter Swift on May 2, 2013

There has been much talk recently about “Big Data” which, to me, only emphasizes the importance of "Clean" Data. According to Kurt Bollacker, “Data that is loved tends to survive.” Having clean data is necessary for you to extract revenue from your most precious resource: your customer and prospect database. Clean data increases opportunities, saves money, and helps you maintain a positive reputation with satisfied customers. Luckily, there are tools available to dealers that can help keep data clean and updated with the NCOA, CASS, DNC, Phone/Email Validation and Phone/Email Append.

Increased Opportunities Come When:

The mailer you recently sent doesn’t go to the customer’s old address, as your customer recently moved to a new address. Your mailer arrived at the proper address because your data has been updated with the National Change of Address (NCOA).

Your mailer for the huge tent sale this weekend is received prior to the event, not after, because your data has gone through the CASS Standardization process with the USPS.

Your BDC or Salesperson can set that appointment instead of throwing away the lead due to lack of phone numbers.  Ensure you have appended cell numbers and landlines that are incorrect or missing in your database.

You are able to append/add email addresses to customer records, helping your next email marketing campaign be successful. 

Money Is Saved When:

You recently sent a mailer; a few weeks later, you don’t have a huge pile of returned mail sitting on your desk because your data was scrubbed against the NCOA.

Your BDC or Call Center is not wasting time calling bad numbers because your database has had the phone numbers validated.

You can now send an email to your customer/prospect instead of a letter due to the appended email addresses you now have because of email appends.

Your Reputation is Maintained When:

Your mailers are making it directly to their intended recipient, rather than being forwarded from their previous address, or thrown away by the new homeowner at the old address.

Your Sales or BDC Team is not calling on customers and prospects that are on the “Do Not Call List.”

Invalid email addresses are eliminated, effectively reducing the number of “hard bounces” on transmission. 

The email validation process helps protect the broadcasting IP from domain-level filtration and IP “blacklisting.”


If hundreds of thousands, even millions, are spent annually to market to prospects and get them in your database, shouldn’t a fraction of that money be budgeted to show your data the love?


Hunter Swift is the Manager of Market Development at DealerSocket and has been with the company since 2005. In addition to his current role he has fulfilled the responsibilities of customer support, consulting, training, and sales. He specializes in helping dealerships improve processes through the use of CRM technology. Prior to DealerSocket he sold cars and is a graduate of Pepperdine University.

Follow him: @HunterSwift


Great comments Hunter, having been in the retail Auto industry since 1980 and over the last 12 years in Auto marketing, this is the key to any Dealers marketing success. There are some proactive teams within Dealerships, that clean data as they go. Others have horrible data and do nothing about it. Having launched a large initiative with a major OEM in 2009, we would send service communications to the DMS database. The OEM records would be fairly accurate for estimating the cost, but the DMS database would be overblown with duplicate customer numbers, obsolete addresses and vehicles that no longer exist for one reason or another. This would result in a Dealer who was upset that 5 times the number of communications were sent and the bill was enormous. The activity of cleansing the DMS has to be a process that is across all departments within the facility. Every employee who handles data, must verify every customers record and de-duplicate with every customer visit. Now you can pay some DMS companies to do this, but remember this is your DMS data. Do you really want someone else to clean up the mess? I say, put the process in place, then inspect what you expect to be done and do it daily. Over a period of time it will take care of itself.

May 3, 2013

Hey Hunter, what do you tool do you recommend to dealers using Reynolds?

May 3, 2013

Postal Soft and NCOA and standard list tools used by most mailing houses. However, keep a tab on if your mail house is sending your list through NCOA every mailing. This will cost your mail house money to do so some only do it every once in a while. When 1% of the population moves a month, it is vital to have this done every time you mail.
in addition to cleaning the list for accurate addresses every month it is vital to pull you current file from your database each month. Especially if you are sending a sales letter. Don't you hate it when someone calls you to tell you they just bought a car from you and you sent them a more aggressive offer this month?

May 3, 2013

We actually just signed up with VinSolutions for Data Appends yesterday. I'm not sure who they use I just know it is a new company for them. I'm curious now however. We have about 10-years of CRM data that we have never had it cleansed so I'm looking forward to seeing some marked improvement in our ability to properly market our current data base.

May 3, 2013

Keep in mind that NCOA only goes back 48 months. So if your customer requested a change of address through the Post Office it will only stay in the system for 48 months. If your address was not cleansed during this time then you may not receive the new address.

May 3, 2013

Thanks Cassie. I'm more interested in the email address than snail mail address.

May 3, 2013


May 3, 2013

I dont know which CRMs and DMS companies offer Data Cleaning. But I do know that if you can, it is most important to clean the data out of the CRM or the tool you are using for marketing to your customers and prospects. DMS data is notorious for duplicates and bad data. Most CRMs usually take the data from the DMS and clean it up and de-dupe it. Once it is in the CRM you need a tool to update it, and continue to update it monthly to stay as current as possible.

May 3, 2013

Great post Hunter.

Dirty customer data isn't the only thing. I constantly see dirty vehicle data as well. This can affect the data posted to a dealer's website (vehicle title, meta info, URL).

This data (content) is then indexed by Google and displayed in the search results.

Imagine your customers searching for a "corvette coupe" and the data on your website is displaying "corvette cpe".

This can happen anywhere down the line of vehicle information, whether it be the make, model or trim of a vehicle.

Keep your vehicle data clean too!

May 6, 2013

Comments 1 - 9 of 9

You must be logged in to comment

Login Create an account

Add your comments:


Hunter Swift's Recent Posts

Related Posts

  • David Metter, President of AutoHook, Heads DSES Panel of Auto Industry Experts Discussing Latest Trends in Mobile Marketing

    David Metter, President of AutoHook powered by Urban Science, will head a panel of leading automotive industry digital marketing experts at the seventh annual DrivingSales Executive Summit (DSES), Monday, October 19, at 9:30 am. Joining Metter on the panel, “The Evolution of Mobile Marketing in the Automotive Industry,” will be Erik Lukas, Retail Digital Operations Manager at Subaru of America, Alan Krutsch, Director of Marketing and E-Commerce at Apple Autos, Benjamin Blanco, Webmaster at the Andy Mohr Automotive Group and Ray Green, VP Enterprise Solutions at Verve Mobile. The panel will focus on mobile marketing, data, and trends. Panelist will contribute unique insights into how their field can best enable the marketing process to be successful for both dealerships and consumers. Attendees will learn how mobile trends affect marketing strategies and gain mobile insights from key experts across multiple tiers. Read post

  • Finding Brand Advocates in the Hispanic Marketplace

    Hispanic Marketing is Powerful You already know you need your brand advocates. In fact, in today’s market, their participation with your brand is absolutely necessary in order for others to recognize and engage with your products. Chances are, you have several strong brand advocates working on your behalf on your various social media sites, but how do you go about branching out and growing a more diverse group of brand advocates? How do you find your strongest brand advocates in an increasingly multicultural market? Your Hispanic brand advocates are important to your dealership for many reasons. They are the key to reaching an entire audience and cultural segment that relates to them and trusts their judgement regarding products and services. In fact, as active as brand advocates are in the marketplace, Hispanic brand advocates have been shown to be even more active than their non-Hispanic counterparts. Known as super consumers in the marketplace, Hispanic consumers are highly a...Read post

  • OEM's, Dealer Associations, and Dealers Align in Go-to-Market Planning

    When I introduced this column a few months ago, I deliberately started by taking an outside-in approach to OEM-dealer alignment. I focused first on the importance of independent research sites, followed by the power of enterprise solutions. Today, I’m taking a different tack—one of alignment across OEM’s, dealer associations, and individual dealers themselves—alignment across Tiers 1, 2, and 3 in go-to-market efforts. Aligning media across brand-building to brand-selling tactics and multiple stakeholders can be challenging for any OEM. The greater the number of agencies, dealer associations, and individual dealers involved the more daunting the task. Yet, alignment can - and does - happenRead post

  • DMEautomotive Presents New Digital Data Marketing Strategy at 2015 JD Power Automotive Marketing Roundtable

    The joint presentation, "Scale Your Business Profitably by Taking Digital Data and Retail Marketing Beyond New Vehicle Acquisition," offers a modern method to drive brand loyalty and fight the aftermarket bleed   DAYTONA BEACH, Fla., Oct. 12, 2015 -- DMEautomotive (DMEa) today announced that it will present a groundbreaking targeted digital advertising solution at the 2015 JD Power Automotive Marketing Roundtable that enables OEMs and their dealers to leverage first-party data to target and attract digital service shoppers to maximize measurable service volume lift and retain their most lucrative customers. Ryan Grokulsky, Digital Marketing Strategist for DMEautomotive, will present this breakthrough concept on behalf DMEa. Located at the Bellagio Hotel in Las Vegas, the 2015 JD Power Automotive Marketing Roundtable is the industry's leading marketing event with over 1,400 participants representing every facet of the automotive marketing profession. Covering information deemed ...Read post

  • The State of Automotive Digital Advising: More Vanilla, Please!

    Anyone who regularly reads out blog knows a few things. One, we tell it like it is. Two, we educate from fact and passion, not from the heart of from the pocketbook. Three, we do and cover what nobody else does across the entire scope of services. Four, we affect a sliver of the industry through the automotive social sphere. While none of these aspects alone are uniquely significant, it becomes more so when you consider what dealers are receiving from “advisors” today. Recently we had a high-line dealer visit that also included a regional sales director from the OEM, which is a rare pleasure. They wanted to review the new digital assessment package from their third-party partner. While we were extremely happy that the digital marketing consulting company that had previously provided in-field services for the OEM and their dealers was no longer doing so, and there was clearly an improvement in the standard deliverables, frustration quickly set in. In reviewing the report, it was ...Read post

  • Auto/Mate Announces Open/Mate Integration with StoneEagle F&I and Service Applications

    Albany, N.Y. – October 12th, 2015 – Auto/Mate Dealership Systems announced today that StoneEagle has completed integration with Auto/Mate's Dealership Management System (DMS). Auto dealership groups using Auto/Mate's DMS and StoneEagle's web-based applications will benefit from seamless and real-time data updates in both systems.   "Auto/Mate believes that the more technology vendors we integrate with, the more choices our dealers have, allowing them to lower costs and increase efficiencies," said Mike Esposito, President and CEO of Auto/Mate. "Our Open/Mate program offers vendors an affordable and easy way to integrate their applications with Auto/Mate's Automotive Management Productivity Suite (AMPS)."   StoneEagle offers a range of web-based applications to help dealers manage performance, accountability and production across their F&I and service departments. StoneEagle solutions are designed to automate manual tasks, deliver accurate information, increase profitabil...Read post

  • Emerging Interactive Content

    At the recent Content Marketing World 2015 event, many of the speakers highlighted the evolution of content marketing and how new interactive technologies create new engagement opportunities.   As more content is posted online, in emails, and presented in webinars to clients every day, it is becoming quite a challenge to reach and create an impact on any target audience.  Companies need to work closely with their communications teams and agencies to make sure the solutions they implement are right for their particular needs.    We would like to share with our readers some of the new functionalities that are emerging in the market.   In this issue we highlight five interactive content components: * Surveys * Interactive White Papers * Configurators * Quizzes * Lookbooks    Surveys Surveys are showing up more on websites, Facebook, and in webinars. Market changes, media reports and a customer’s past experiences can all influence your audience’s perception of th...Read post

  • Get Creative with Halloween

    You may have noticed Halloween and fall decorations adorning your favorite retail stores or maybe you’ve seen the random Halloween outlet stores popping up in shopping centers near you. With the excitement building around this much anticipated holiday, you may want to get in on the fun. Halloween is the time of year for goblins and ghouls, but it’s also a time to get creative. Demonstrate your creative side to customers and prospects with one of these Halloween marketing ideas. Host a Costume Contest People who spend money and time on their Halloween costumes want to show them off, that’s why hosting a Halloween costume contest is a great way to bring top-of-mind awareness to your dealership. You could run a traditional contest and incentivize people to dress up and come to your dealership, or you could take a simpler approach and host the costume contest on your social media channels. Leveraging social media for your contest improves your dealership’s online reputation, reac...Read post