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

  • This Week in Social Media with @seekristintweet

    News for the Week of August 31 Guest Blogger today: Kristin Huntley, Director of Content and Marketing You Don’t Have to Be Square!  Thanks Instagram! This week, Instagram announced they are expanding their format to allow for portrait and landscape photos and videos, as well as the traditional square posts users are accustomed to. Instagram stated that one in five posts shared is not in square format, prompting this update in order to make posting easier and more fun for all users. To maintain its clean grid feel, posts will appear as center-cropped squares. For video formats on Instagram, this newest update allows for an even more cinematic experience than ever before. Dealerships can now take advantage of panoramic views to display all of the curves and features of their vehicles, or showcase more inventory for consumers. Clipping on LinkedIn/SlideShare LinkedIn and SlideShare recognized the fact that it’s difficult to keep track of all the content that’s available tod...Read post

  • Blogging for Car Dealers: How to Get Started

    Blogging for business is by no means a new phenomenon. It's been talked about for years now, and I'm sure most of you reading this have tried blogging, whether in your free time or for a business. But while the craze around blogging has died down as it becomes more acceptable, there are still plenty of people out there skeptical about blogging and its potential benefits. In this post, I'll show you how to get started so you can be on your way to developing a more advanced and successful digital marketing strategy. Every business's site should have a set of main pages that act as the gatekeepers of information. These offer information about your business, its services, and help assure potential customers that they're choosing the right business based on their needs. With these pages, you're doing the bare minimum. For some businesses, that's fine. But if you're looking to go above and beyond in order to drive traffic and increase leads, a few pages just isn't going to cut it. You ...Read post

  • Strength in Numbers: The Power of Network Solutions and Personalized Shopper Experiences

    In my last post, I talked about how independent 3rd party research sites can help foster collaboration between dealers and OEM’s by uniting them through a more seamless customer experience.  Continuing with an eye on the customer experience, today’s post focuses on another “outside-in” approach to OEM-dealer alignment:  network solutions.  Specifically, how network solutions can deliver a seamless and personalized shopper experience while benefiting both OEM’s nationally, and dealers locally. An OEM-scaled effort across a dealer network can be a powerful go-to-market strategy, where deliberate and thoughtful coordination come to life in real-time.  Whether it’s through shared customer insights, or personalized shopper experiences, a network-wide approach can have many benefits.   A network-wide approach uses key data and insights to: Create a deeper, shared understanding of the customer that both dealers and OEM’s can act on. Deliver the right message to the right...Read post

  • Navigating SEO: Why You Should Create Content for Social and How to Do It

    While an extremely critical component to modern SEO, content is also a critical part of a balanced social media strategy. That's great and all, but you're probably asking: "What does creating content for social media have to do with SEO?" Let's find out!Read post

  • Be Your Own Life Coach, Continued-Part 2

    What are the ways I sabotage myself? [Getting honest] Here’s some honest for you. I avoided writing this post because I’ve been going through a lot of change over the past 4 years and I’m tired. I crave the blissful ignorance of imagining I don’t have any major blind spots at the moment. I want to not knowwhat I need to work on for a hot second…but that is not the path I’ve committed myself to, and it’s not the path to growth or success. I’m all in on becoming the best version of myself and there’s no turning back. So who’s with me?  Let’s get started. Ch-ch-ch-Changes I said it in my session, and I will say it again…there is only one thing every woman who wants to be successful must fully commit herself to, and that is embracing change. Change is really the only constant in life. And change requires focused mental, emotional and spiritual energy…in other words STRESS. I know it’s very 21st century to seek opportunities to de-stress, but without stre...Read post

  • Does Your Service Department Know How to Set Appointments?

    Phone calls are on the rise to both Sales and Service departments– but the average dealer only converts a little over 30% of their inbound Service leads to appointments, leaving up to 70% of those leads for their competitors.   It’s difficult to calculate how much revenue your Fixed Ops department is actually missing out on, but it’s a good bet that one of your nearest competitors is reaping the benefits of your loss.  Effective call handling can increase conversion rates from an average of 30% up to 90%, meaning your dealership’s Fixed Ops department could be generating three times as much business without increasing its marketing spend. We recently fielded a study on how dealers nationwide handle inbound Service calls and were able to pinpoint the most important phone skills that help service departments set appointments. This is the largest study we’re aware of that looked primarily at incoming Service Department calls.  We analyzed data across 2,464 phone calls and ...Read post

  • Understanding Customers

    Many businesses are great at making and/or selling products and services.  Most can succeed at getting their message in front of their target market and getting some clientele.  However, a critical point that is tough to perfect is retaining those customers - especially in today's business climate where much of the reputation and engagement is carried out online.  The key to making a lasting enough impression for return business is understanding customers. Rather than treating customers as simply a source of revenue, today's successful businesses give customers a more rounded-out experience.  The first step generally involves getting shoppers to listen to the sales message.  If a business is good at understanding customers, it should be able to devise a few messages based on the different types of buyers it has and get those messages specifically in front of those that are best to respond. Step two in the process that leads to retention is emotionally connecting with shoppers. Read post

  • "That Guy" is Alive and Well!

    The good news: The stereotypical car salesman (slicked back hair, in-your-face attitude, pinky rings, gold chains, smooth-talking…you know the guy) has been mostly eradicated from the industry. “That guy” is mostly used these days for parody advertisements, memes and SNL skits. Why isn’t he effective anymore? Because consumers say he isn’t. Our methods and processes are driven by how our consumers want to shop and purchase. They have to be!Read post