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

  • Honor Loyal Customers to Keep Them Coming Back

    Whether you believe it or not, your customers are your dealership’s most valuable asset. Especially the loyal ones who continue to come back regularly for service work and purchase multiple vehicles from your dealership. If you’re under the belief that all customers should be treated equally, then this post may not be for you. In fact, we believe your most loyal customers deserve extra savings and attention to ensure they continue to come back to your dealership for future vehicle needs. Here are three easy to implement ideas to honor your customers. Offer a First Class Experience If you identify loyal customers who are scheduled to visit your Service Department, think about rolling out the red carpet. Start by having one of your Service Advisors greet them with a small gift upon arrival. Then, have refreshments and free goodies ready to satisfy them as they wait for their vehicle’s service work to be performed. Maybe even offer free shuttle services, free car wash and vacuum, o...Read post

  • Pinterest - It’s Not Just for Women

    If you asked a room full of women how many of them were on Pinterest, it wouldn’t be surprising to have most of them raise their hand.  They love the recipes, crafts and clothing ideas.  But there’s so much more to it.  What is Pinterest?  Think of it as an online cork board, where you have pinned photos of your favorite things.  When you are online doing research and you find something you like, you can pin it to a board and keep track of it.  A board is a way of organizing the things you’ve collected, something like placing it in a file cabinet.  And now all those favorite things are online, in one place.  How’s that for organization! Let’s say you’re planning a wedding.  You can create a “My Fabulous Day” board on Pinterest and pin your ideas that you find online.  You can also find inspiration from others on Pinterest and pin those ideas on your own boards as well.  Everything is organized and ready for planning. Pinterest launched in 2010 and has over...Read post

  • First-Ever Women in Automotive Convention to Debut in 2015 – Industry Pioneer named as Keynote Speaker

    Orlando, FL – The inaugural Women in Automotive Convention will take place this summer with the purpose assisting the automotive community in recruiting, retaining and developing female employees and leaders. Women make up just 17% of employees at auto dealerships according to NADA – and organizers of the conference are working diligently to raise this number, beginning with this event. The conference is set for Tuesday-Thursday, August 18-20 at the Ballroom at Church Street in Downtown Orlando. The three-day conference includes speakers, breakout sessions, workshops and booth displays – all centered on the goal of educating and inspiring women in all areas of the automotive industry. Keynote speaker, Lisa Copeland, has been a pioneer in the field of automotive marketing and management for more than 25 years. She is currently Managing Partner of Fiat of Austin, the top Fiat retailer in North America since the brand’s return. “The topic of women in the automotive industry h...Read post

  • CRM Decisions and Disasters - Part 3

    Now that we’ve covered the problems with CRMs, possible solutions, what to look for in a new one and how to prepare your team, this part will cover getting ready for your launch and making sure it’s properly structured. Let’s get started! A properly structured launch will make, or break the outcome of how effective the tool is used, along with how much damage in dollar loss is incurred during the change. I will continue to trumpet the fact that no loss of down time or money is needed if it’s done right. Money invested in doing this correctly will result in quicker acceptance and use by the staff. Read post

  • New Community Feature – Featured Columns

    ​Our mission at DrivingSales is to bring you the network, education and practical insights to advance your careers and your business’ performance. I am pleased to announce a new program to support this mission – featured columnists from leading research houses and consultancies who will bring insights from all aspects of automotive to the community for discussion, debate and application. Read post

  • Dealer Currency Helps Grow Gross Revenue on Every Sale While Retaining Customers

    I recently had the pleasure to work with a very innovative dealer who implemented the concept of “dealer currency” in his dealership with great success. Dealer currency allows you to eliminate cash discounts on sales (in both Variable & Fixed Ops) by instead issuing a form of “dealer dollars,” redeemable anywhere in the dealership for the future purchase of parts, service, accessories, or towards a future vehicle purchase.  This creates a true “win-win.” It satisfies the customer -- as they feel they have received the value of the discount. And the dealer -- because it ties the customer to the dealership for future purchases, without having to give away any profit up front in the deal.   For example, instead of discounting a vehicle sale as follows: Selling Price $20,000 $40,000 $60,000 Purchase Discount $750 $1,500 $3,000 Adjusted Selling Price $19,250 ...Read post

  • DMEautomotive’s Driver Connect Selected As Finalist In 2015 American Business Awards(SM)

    Auto dealer-branded, consumer-facing mobile app is recognized for its exceptional value in the business-to-business product category: Driver Connect is increasing appointments, visit frequency and incremental revenue for auto dealership service departments   Jacksonville, FL – May 19, 2015 – DMEautomotive’s groundbreaking mobile app for auto dealerships, Driver Connect, was named a Finalist today in the Business-to-Business Products category in The 2015 American Business Awards, and will ultimately be a Gold, Silver, or Bronze Stevie® Award winner in the program.   The American Business Awards are considered the nation’s preeminent business awards program. All organizations operating in the U.S.A. are eligible to submit nominations – public and private, for-profit and non-profit, large and small.    Launched in 2012, and designed with the customer to dealer relationship in mind, the award-winning Driver Connect mobile app provides auto dealers with a powerful mobil...Read post

  • Six Ways for Internet Managers to Look Beyond Leads

    Website leads have been a part of selling cars since dealerships went digital. They are a tradition, easy to quantify, and demonstrative of a website’s effectiveness. They are also emotionally resonant: Leads are comforting because we can point to them as an impact that we are making. As fond of tradition as we are, times are most certainly changing. The demographics of our customers are shifting, and shopping for cars on mobile devices is quickly becoming the norm, not the exception. With these digital trends generated by a new breed of shopper, we, as digital marketers, are in a position to begin looking beyond leads to better assess a wider perspective on digital engagement and its effects on the car-buying process. But what does this look like?Read post