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

  • kelley blue book rv

    There are many luxuries to owning a recreational vehicle. This type of travel allows the person to take their home with them. There is no need to acquire a hotel room. When visiting all the places this world has to hold, the person will always feel like they are still living in a home away from home. When looking to purchase or sell a recreational vehicle, also known as an RV, the first thing that must be known is what an RV is really worth. This is also important to know when someone is trying to sell their RV. No one wants to be taken advantage of, so the RV value should be considered from both sides, selling and buying. The first thing that any responsible person trying to purchase or sell an RV should know is how to use the Kelley Blue Book RV. This book is essential when doing business with an RV. This guide is extremely reliable in telling the true RV value. It has also become a very popular tool used by many in the RV industry. The KBB RV guide is recommended by most financia...Read post

  • Using Moneyball Strategies to Win the Content Marketing Game

    In a recent article published on Marketing Land, an author used the famous concept of Moneyball and applied it to content marketing. If you aren’t familiar with the Moneyball concept, it began when Billy Beane became manager of the 2001 Oakland Athletics. Mr. Beane hypothesized that a team doesn’t necessarily need a superstar to win games. The key to winning in baseball is scoring. To score runs, a team must have players that can get on base. Rather than allocate millions of dollars (which the organization couldn’t afford) for superstar players, Mr. Beane used data and algorithms to identify players who may have been considered sub-par, but had high on-base percentages (i.e.: they could hit and get on base consistently). Using this strategy, he was able to put together a team that went on to win against stacked teams of superstars. The author of the Marketing Land article went on to explain how successful content marketing paralleled the Moneyball strategy. Marketers shouldnRead post

  • How to Make Hyper-Targeting Your Social Media Secret Weapon

    If you're like many, you're sick of hearing how big social media is. It's huge. We get it. That's not the real "juice" that comes through utilizing social media for automotive advertising. The greatest benefit that social media currently offers to car dealers is through hyper-targeting. More dealers every day are taking advantage of the standard targeting components of sites like Facebook and Twitter - targeting by location, age, income, education, and any combination of these and many other demographic components available. Very few dealers are taking advantage of the stronger data that's available through a plethora of very specific data sets. First and foremost, the use of your customer database is absolutely imperative. You might be sending direct mail to your customers. You're probably emailing them. Unfortunately, your also probably missing a large number of them because of spam filters and a general distaste for junkmail. Social media offers a very direct way to get your me...Read post

  • There's No Need to Make Reputation Management Complicated

    One of my biggest complaints about some vendors in our industry is that they make reputation management seem like it requires extremely specialized talents in order to make it work for car dealers. They would have you believe that you cannot manage, monitor, or influence your own reputation and that it takes extreme talent and a complex strategy to make it happen. As much as I would love to pitch our own reputation management solution here, I'll keep it simple. Reputation management isn't hard. In fact, it's the complicated measures through which many vendors attempt to manipulate your reputation that gets dealers and other businesses in trouble. Here, I'll break down the steps that make up a real reputation management system: Deliver Great Customer Service - Just as we do with our own clients, dealers that are treating their customers fairly and with respect have a better chance of maintaining a positive reputation online. That doesn't mean that great service will definitely yi...Read post

  • You Need to Repeat Yourself (in marketing) to Your Past Customers

    Repetition can get annoying. When we see the same message over and over again, it has a tendency to get on our nerves. That's not what you're trying to do by putting out consistent messages multiple times through diverse channels. In today's ever-shifting world, it's important to risk repetition for the sake of having them see your message at all. I originally published this article over at AutomotiveSocial.com but thought it would fit in nicely at DrivingSales: Customer loyalty is a tough cookie to crack nowadays. It's not like before when things were more predictable, when you could make assumptions about timing and situations. Today, you never know when the situation will change to where someone is in the market to buy a car immediately. The standard buying cycle has been replaced by a chaotic weaving of changes to job, relationships, and circumstance. Another thing has changed. People are not inherently loyal to any particular dealership. Sure, there are regular customers who...Read post

  • Find Used Car Prices using Edmunds TMV Calculator

    If You are thinking of buying a car, but you don’t want to have to babble with the salesperson. Sure you have a fair idea of the type of car you want, size, shape, color. You may not be sure about one thing though. There is this one burning question that lingers at the forefront of your mind, “how much will I have to pay?” You can relax and put your anxiety to rest because Edmunds True Market Value is here to help when you go through moments of doubt like these. Whether you are the buyer or the seller, exchange of ownership of a car is all about a mutually respectful partnership. For the buyer, it is common to find yourself in a position where the seller retorts “how much are you offering for this lovely car today?” Without an idea of Edmunds used car prices you may end up plucking a price out of thin air. You’d have to be a Vegas gambler to even land close to what the dealer has in mind. If you land too high the dealer will smile and informally crown you his “buyer of t...Read post

  • How important is a title?

    My dealership firmly believes in a culture of *teamwork* - and by not having a title - I can be the utility player on the team.Read post

  • Get Your Customers Properly Engaged with Your Dealership

    I know. It's a buzzword. It's impossible to keep track of number of times experts in the car business have used the word "engagement" when describing how to get more customers. Engage on social. Engage on search. Engage on YouTube. Engage on your website. It's a mess but it's still important to be engaged with potential customers. On the other hand, it's even more important to be engaged with your past and present customers. The people who just bought a car from you, the people in your service waiting lounge, even the people who bought a vehicle from you a couple of years ago - these are the people that could really use some engagement with you immediately. It gets frustrating to see so many dealers focused on driving new business and conquest business while pretty much taking their eyes off of the low hanging fruit in their database. It's as if the industry has given up on loyalty. It's true that loyalty numbers are lower than ever before. Between the internet allowing further re...Read post