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

  • Vendor Partnerships and the Importance of Making Ego Begone

    The word "begone" is such a funny word. It has a powerful meaning but is so rarely used outside of board games and exocisms. We're going to use it today, mostly because it fits in nicely with the topic of discussion. As fate would have it, one of our team members was picked for jury duty. While he is fulfilling his civil responsibility as a citizen of this wonderful country, I'm filling in for him on the social side. It's good to roll your sleeves up and get to work sometimes (which is why I believe even general managers should take ups every now and then) just to get a feel for what's happening in the trenches. Facebook is all about momentum, which is why I normally do not like our posts to run over others. Conversely, I don't like other people's posts to run over ours. Collaboration is an important key to a strong social media strategy that takes some thigns from the dealership and some content that we create, so we like to time everything out to maximize things. Today, I had a ...Read post

  • Dealerships Must Reinvent the Car Showroom

    Spending more time engaging the customer helps build trust and pave the way for a better upsell process. If your dealership hasn’t integrated mobile tablets into your processes, now is the time. Read post

  • Phone Interview Questions: 6 Tips for Running the Show at Your Dealership

    Want to hear something crazy? 103 years ago the Titanic sank. Want to hear something even crazier and completely irrelevant to the first question? Most people do not know how to conduct a proper interview, yet alone a phone interview. Meeting someone face-to-face allows for natural interaction and initial conversation. On the other hand, meeting someone over the phone calls for a bit of effort from the caller (in this case, the hiring manager) to get the conversation going. Therefore, it’s essential to have a guideline or some format to follow when writing up phone interview questions; otherwise the interview is bound to fall apart and lose its purpose. 6 Tips for Phone Interview Questions 1.) MAKE A SCRIPT—Following the same script for every interview helps avoid bias and inconsistency. You want to make sure every candidate has the same opportunity to a fair interview process; this means asking everyone the same basic questions. Plus, this helps you stay on track and keep the interview flowing within your respective time limit. 2.) INTRODUCTION—This means more than just a simple, “Hey, how’s it going?” Introduce yourself, your background and your company first. Then give your candidates an overview of how the interview will flow so they know what to expect. Make sure they understand your interview process. This will help ensure a smooth transition to the next stage of the process, like a face-to-face interview or polite rejection. 3.) CAREER PLAN—Ask the candidates aRead post

  • Spring into Revenue with Sports Marketing

    With warmer weather in the air, many athletes, old and young, are starting their spring sports. From the professional level to little league, athletes, their families, and sports enthusiasts everywhere are excited about the upcoming sports season. For this reason, now is the perfect time to utilize sports marketing to build brand awareness, drive traffic, and spring into revenue. Here are two ideas to help you get started. Leverage Sports Theme Spring sports are gearing up, from soccer to softball, baseball to lacrosse, golf to tennis, track and field to swimming, and many more. Depending on your specific area of the country, you may be able to utilize excitement from local professional teams or little league teams. This time of year presents the perfect opportunity to leverage sports themed marketing, like Home Run Savings, Go for the Goal Deals, or even Hole-in-One Incentives to promote your dealership. Whatever sport you decide to highlight in this month’s marketing, you can leve...Read post

  • Your Director of Marketing Has Gone Rogue

    The Director of Marketing going rogue can be a blessing or a curse. Here's how to identify which it is for your dealership.Read post

  • New PostRequired Packaging Material for an Effective Shift

      Packers and Movers in Gurgaon Transferring in addition to changing will be dedicated to supplying. The actual useful you taking, the effective the go will be. Ones packing determines no matter whether you should use your own owed since it is at the modern location or perhaps definitely not. In addition to to the perfect packing you will need ideal the labels materials at the same time. Providing is an fine art, as well as the perfect swings from it make it a lavish success. The labels product is easily obtainable with market as well as if you're clever ample then you can definitely furthermore makes use of the one available at your home.   Although element the labels source will depend on the material that you are having, but still you can find several quite standard product packaging requirements, which might be necessary all over the place. In particular carton field, bubble wraps massive Polyethene luggage, cello tapes, scissor along with several sturdy threads to link issue...Read post

  • Mobile friendly websites and Google

    A constant mantra of digital marketing is “mobile-friendly".  The reason is quite simple - a majority of users access the web via a smartphone or tablet.  Because this includes shoppers, having a mobile-friendly site is key to creating an attractive shopping experience.   Google is acknowledging this trend with its most recent updates.  Sites that are deemed as not “mobile-friendly" by Google will theoretically be penalized in search engine rankings.  If your site is not mobile-friendly yet, it might suffer a hit in ranking on mobile devices.   Google’s recommended approach is responsive web design.  Besides that, some key factors Google looks at include font size, page width, whether or not flash is used (avoid it) and how close together links are.   If a business can't get their site up to Google's standards right away, they can still make changes down the line and rebuild their rankings.  How are you all coping with Google's algorithm change? ...Read post

  • DrivingSales is Heading Across the Border to Canada

    We are very excited to announce our first international conference in Canada. DrivingSales is will host the Canadian Dealer Forum in Calgary, Alberta on June 22 – 23, 2015. For the last two years, the Canadian Breakout Session at DrivingSales Executive Summit has sold out. We have heard from many dealers that they would like to see a conference in Canada. You spoke and we listened.Read post