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

  • Email Conquest Marketing Guide

    Every business needs customers, right? Keeping customers loyal to your business and ensuring they come back to you for future purchases involves a retention marketing strategy. Although this type of strategy is incredibly important and needed for a successful business, today we are going to focus on developing a conquest marketing strategy. Now I know what you’re thinking, “You tell us all the time - it costs five times more to acquire a new customer than to keep an existing one.” This is a very true statement; however, there comes a time for every business when you have to look outside of your current database and acquire new business to grow your current customer pool and increase revenue. What if I told you that acquiring new business doesn’t have to be so costly? In fact, dealers who use OneCommand’s conquest email solution have seen a $15 return on investment for every one dollar spent. Today I’ll share a cost effective conquest marketing strategy that brings addition...Read post

  • Impress top candidates in your community

    Here is the daily hiring and getting hired tip: Want to impress top candidates in your community, start with your employment page on your own website. Always be hiring! Take the time to detail the benefits of working at your store like income, work environment, flexible schedule. Highlight some key employees with tenure, and give descriptions of each of the positions in your store. Even if you are not actively looking at the moment give the community the ability to pursue a position.Read post

  • Are You A Part Of The Smartphone Revolution?

    In a very short 6 years, the iPhone and Android mobile platforms have come to represent over 90% of the smartphone market. In both design and operation, the iPhone has lead to a wildfire of smartphone adoption. While the open-platform Android has provided smartphone access to the masses by providing cost effective devices. So what does all of this mean for you? Let’s first take a look at mobile websites. Many dealerships consider a mobile website a helpful tool to help drive traffic into their store. However, here’s a look at why mobile websites simply aren’t enough to keep up and could actually be driving traffic away: 1) A “mobile website” is a condensed version of a “full” website – a website built to be viewed on a computer screen – not a mobile screen.  A mobile website wasn’t built to integrate with the underlying technology that drives mobile apps and does not take full advantage of unique smartphone capabilities like push notifications, GPS, o...Read post

  • Why is Marketing Automation Superior to Plain Old Email Marketing?

    Lots of automotive shops and car dealerships use email marketing to run special promotions, increase repeat customers and advertise new vehicles. But when everyone else also uses email marketing, and uses the same old email techniques, how do you make your messages stand out?Read post

  • Hiring at Dealerships: 5 Signs It’s Time for a Facelift

    Whether you’re an aging celebrity in Hollywood or the storefront of a 50-year-old mom and pop store, facelifts are sometimes necessary for business. The same can be said about the hiring process at your dealership—if it’s seems outdated, then it’s probably time to restructure your system. Old habits die hard, but they can still go away. One of the most unwanted and hardest habits to kick at dealerships everywhere is turnover. According to an annual report conducted by the National Automobile Dealers Association, sales turnover at dealerships is around 62%. Although this is a serious issue amongst dealerships, it doesn’t have to be a permanent one. Just like solving any problem, you have to find the source first. Who you hire affects your turnover rate and therefore, makes your hiring process the main source. The first step towards refurbishing the way you operate hiring at your dealerships starts with identifying your main issues. The following are five signs that will tell you it’s time to update your hiring process: 1. You realize your turnover rate is high, yet you’re not concerned—if you’re worried about making money at your dealership, then you should be concerned about turnover. You actually spend more money on turnover than you ever would if you used a hiring management system. It pays off to research and analyze your potential employees. 2. You’re swimming in a pool of resumes—ok so maybe not an actual pool, but if you have a file packed with resumes, then yourRead post

  • It’s All a Matter of Perspective

    When did you last walk through the customer entrance of your dealership and look at what is truly being experienced by the customer?   Forget for a moment whether a sales consultant’s work area is messy, or if there are smudges on the windows. Let’s look a little closer at what a customer could see, hear or feel when they interact with your dealership in any department. What’s really taking place behind the doors may be a real surprise to you. Taken from a customer’s perspective, you just might be failing to meet their most basic expectations. As a result, you could be damaging your dealership simply by being unaware of what happens on a daily basis down in the trenches.                                                                Have you made an anonymous phone call to your dealership lately? Almost every store now utilizes some form of inbound call tracking. These systems all provide the ability to record...Read post

  • Help The Bargain Brothers Change the Public's Opinion of our Industry

    It is no secret that our industry is negatively viewed in the general populace. That people consider us no better than a 1920’s Snake Oil Salesman. This is why the Bargain Brothers reality TV show is so important for all of us in the automotive industry to get behind. Watch New Episodes of The Bargain Brothers Tuesdays at 7 (EST) on the BNN Network, or watch all the aired episodes online right now at http://www.bnn.ca/shows/bargain-brothers.aspx or on the BNN GO Mobile App http://www.bnn.ca/bnn-go-app.aspx.Read post

  • How to Use DrivingSales.com - A How-To Guide For New Users

    I wanted to write something for first-time users to DrivingSales, to ease them into the culture and experience that is found here. My goal is that, if new users are more comfortable on their first experience, we will convert a higher percentage into active users. After all, we are in the business of conversions, and the more people we have contributing, the more we will all get back from it. We are all in this together.Read post