Community

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

Comments

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

Donnie,
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

Ahh.

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

  • How To Sell 24 Cars Every Month Online By Appointment [Graphic]

    Car Dealers: Each of your BDC Reps or Internet Salespeople can produce 24 sales every month each, working by appointment, by following simple math!Read post

  • Content Marketing for the Innovative Dealership

    Dealerships are facing an uphill battle in the fight to reclaim search rankings from third-party listings, as well as the attempt to win customers through social media. For both automotive SEO and social media marketing, however, content is the single most important factor for overall success. You can optimize your dealership’s site to compete for certain keywords, but that’s only going to get you so far with Google. In order to truly impact rankings, you need to acquire links to your site. The absolute best way to do that is to produce content worth linking to in the first place. That is the essence of content marketing. What is Content Marketing? Content marketing is the art of creating high-quality content for the purpose of building awareness about a product, service, brand, or company. This is typically accomplished without employing sales tactics or openly pushing an agenda, unlike other forms of advertisement. The idea is to create content that your target audience ...Read post

  • Inbound Marketing: How To Win Customers By Influencing People

    Lead > Contact > Show > Sell (LCSS). That is the very definition of Automotive Inbound Marketing. Have you ever noticed that the vendors in the automotive marketing space who are minimizing the importance of leads are also the same vendors that have never been able to generate them with any success? Marketing is a conversation. The start of that conversation is a lead. If you’re relying on lot traffic alone, you are not maximizing your sales potential. By not seeking those conversations prior to the customer coming onto your lot, there is no way to know their motivations for being there. If you don’t know their motivations, then you are simply along for the ride. It’s much easier to sell a vehicle when you have information prior to the customer arriving, wouldn’t you agree?  The dealerships that understand the LCSS process are the ones who are selling more cars. Ask yourself this question: “In today’s connected world, how do you expect to compete if you ar...Read post

  • You Shouldn't Buy Your Suits at Walmart

    There's nothing wrong with shopping at the local supercenter. The convenience of getting toilet paper, bananas, a video camera, and a package of socks for the kids all in the same place saves time and often saves money as well. However, there are lines that shouldn't be crossed. If you're looking for something as important as a suit, you probably want to go to a place that specializes in them. That's why it concerns me when I hear from dealers who are marketing to their customer database or even to conquest lists through their one-stop-shop providers like CRM companies. I'm not trying to start a way with any of these companies, but it simply doesn't make sense to perform one of the most important and detail-driven marketing practices through systems that simply aren't designed to handle them. Yes, many other companies throw in loyalty or conquest marketing into their tool set because they can, but that does not mean that it will be effective. There is an art and a science to appendin...Read post

  • User Experience Guru and Online Marketing Pioneer, Bryan Eisenberg, is Keynoting #DSES This Year!

    Dealers, managers and marketers will discover how to reconcile the creative process to data analysis; aligning metrics with previously hard-to-measure marketing, sales, and customer service processes to deliver quick and tangible results to boost your bottom line. Read post

  • (Video) Two Tech Startups Want To Cut Dealers Out Of the Used Car Business

    They want dealerships to become a thing of the past. Their goal is to move the consumer car buying experience into a different realm. For these groups, the days of walking onto the used car lot will be replaced with one that starts in the customer's driveway. Read post

  • Spark Additional Revenue with Vehicle Buy-Back

    If you’re like most dealers, acquiring quality pre-owned vehicles can be difficult and costly. You’ve probably experienced the hustle and bustle of the local auction floor or the endless hours of searching private party entries to leave yourself thinking, “There has to be a better way!” Well, there is. The truth is no one knows which vehicles are in high demand with your particular clientele and market area like you do. Plus, you know which ones you can mark up to achieve better ROI when they drive off your lot as a certified pre-owned. Most importantly, you and your staff are professionally trained to spot vehicle warning signs and access vehicle maintenance records to determine which ones have the highest resale value. Start by simply making a list of these vehicles and perform a database query to locate the highest desired vehicles. Once you’ve determined who you will target with your buy-back campaign, craft a marketing strategy. Here are three quick ideas to get you sta...Read post

  • The Facts on Asking for Additional Information in Lead Forms

    Recently, an article emerged stating that all optional fields should be eliminated from lead forms. This, according to the article, is a primary issue impacting conversion. That kind of information can be dangerous for dealers, so I’d like to provide a more holistic view of optional fields in lead forms. To start with, you don’t have a problem with your lead forms as long as the completion rate is high. Completion rate is a function of how much the shopper wants the information and what they need to do to get it.Read post