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

  • Autoloop Introduces Instant Online Leads

    New Feature Alerts Dealers to Best Online Leads in Real-Time Clearwater, FL –  9/22/2014 – AutoLoop, LLC, announced today that its Essentials product now includes Instant Online Leads, a new feature that alerts sales personnel when ready-to-buy prospects are generated from dealership web traffic, in real-time. “As more and more people turn to the internet for car shopping, dealers need the ability to engage them immediately,” said Matt Rodeghero, AutoLoop’s Chief Product Officer. “They are a dealership’s most viable customers because they’ve already expressed interest in a specific vehicle online. If sales reps aren’t alerted to inquiries in real-time, however, they can’t follow up…and the sale may be lost.” The potential sale begins with a customized form that allows online shoppers to easily request follow-up through the dealership website. When a customer submits an inquiry, the Instant Online Leads feature immediately notifies a specific salesperson via ...Read post

  • Gubagoo is a Finalist for Most Innovative Dealership Solution of 2014

    ‘Gubagoo Behavioral Engagement & Analytics Technology (BEAST), and Chat and Call Centers’ selected by dealers as DrivingSales Innovation Cup Award finalist; Gubagoo to present onstage at DrivingSales Executive Summit   West Palm Beach, FL and Salt Lake City, UT – September 22, 2014 – ‘Gubagoo Behavioral Engagement & Analytics Technology (BEAST), and Chat and Call Centers’ has been named a finalist for the DrivingSales Innovation Cup Award for the Most Innovative Dealership Solution of 2014. Gubagoo’s solution was selected by a panel of dealer judges from a very competitive field and will be presented onstage at the 2014 DrivingSales Executive Summit (DSES), held October 12-14, 2014 at the Bellagio Las Vegas.   “We are very honored to have been selected as a finalist for one of our industry’s most coveted awards, especially as we were selected by those who benefit from our solution - auto dealerships,” said Brad Title, CEO of Gubagoo Inc. “We look for...Read post

  • “Honey, Get the Camping Gear – We’re Going to the Dealership!”

    Ask yourselves if you are, in any piece of your processes, choosing blind dedication to tradition over functionality. Is there anything you can do, is there any technology available to you that speeds up the process for you and your customers? The meet and greet, the needs and assessment qualification, the walk-around, the write-up – all of the steps on the road to the sale have changed. You may get pushback on this concept from the veterans, or you may be the one pushing back, but it does not change the facts. Your customers will not stand for an in-store process that takes them back 20 years. Chances are they researched you and your competitors online, sent in a lead, scheduled an appointment and found your location all by using their tablet or smartphone. So what might their reaction be to your sales process if it involves a Sharpie and a photocopied 4-square? Think about how the use of technology can turn your sales staff into true state-of-the-art, cutting-edge sales professionals. If you don’t honestly feel that technology can accomplish this, then talent acquisition may be a process in and of itself that needs to be examined. Read post

  • Boost Sales by Lowering Turnover

    There’s one thing majority of U.S. dealerships all have in common: turnover. Don’t believe so? According to the NADA, turnover at American auto dealerships is nearly 62%. That’s a pretty high percentage for an industry that focuses on numbers. When you’re constantly hiring, firing, letting go and re-hiring employess, it can take a heavy toll on your bank account. There’s no need to continue this unwanted, costly routine when it can be fixed, especially when it comes to hiring salespeople. Taking control of your recruiting process is crucial if you want to lower turnover. Sure, it’s difficult to have a 0% turnover rate, but with the proper help it’s easily obtainable to severely lower this percentage and retain quality employees. Hireology has developed a completely complimentary and educational ebook based on research from our customers and the current state of the auto industry. In this insightful eBook, you’ll discover the following: Reasons for high turnover To...Read post

  • 5 Reasons Our New Vehicle Merchandising SUCKS Online!

    Is it just me or are we missing the boat on how we present our vehicles online? Especially in the new vehicle inventory department. Check out this quick and dirty review on why we SUCK at marketing our new vehicles online!Read post

  • Fall into Customer Loyalty with an Event

    Can you feel it? Autumn is in the air. For some of the country, it is starting to get cooler and even the leaves are beginning to change. If you aren’t experiencing the spirit of fall yet, you can still celebrate the official start to the autumn season on September 23rd. Regardless of your climate, fall provides a perfect opportunity to market to customers. Here are three ways you can drive traffic and build customer loyalty with a fall event. Support Local Sports The autumn season is synonymous with football and soccer. If you are a dealership that is actively involved with your local school district or sports organizations, think about hosting a tailgating party at your dealership. You could have food, music, and even a car decorating station. This type of fall event shows your commitment to the community, provides additional foot traffic to your lot, and builds loyalty for your dealership. Eat Pumpkin and Apples People love fall because of the food and nothing brings people toge...Read post

  • 3 Reasons Responsive Websites are Better for SEO

    Web developers started touting the benefits of the responsive website content since the dawn of smartphones, but it was more for functionality rather than increased visibility. It wasn't until 2011 and 2012 when large companies like Google started promoting the concept that the SEO world opened their eyes to the search ranking benefits. We believe wholeheartedly in responsive websites for dealers, not just because Google likes them, but because they present a better experience for your customers. Still, the SEO aspect cannot be ignored, so I've put together a small list of reasons that responsive website design is a strong play for improving your organic search engine rankings. Every Page Visible Dealers and vendors can debate about whether Google is truly "promoting" responsive website design or if they're simply listing them as the first option when discussing mobile website interfaces, but one this that Google and Bing have said that cannot be debated is that they like a 1-to-1...Read post

  • The Two Sides to Social Media

    Everyone knows about the front-facing part of social media. Some of us use it every day. Whether we're checking updates, following a story, or simply looking into what our friends are doing, we go to our favority social media app on our phones or visit the sites on our computers and explore the world socially. The other side of social media is more mysterious. It's not that it's a secret; many discussions have been had about it right here on Driving Sales. It's that few dealers are talking about it, fewer vendors are offering it, and the social media sties themselves are doing a terrible job at getting the word out. That's fine by us. The longer that it's a secret, the better it is for our dealers. This other side, the "dark side" of sites like Facebook and Twitter, rely on their number one asset to help businesses spread their message to the right audience. That asset is targeting, and the methodology that these social networks employ are can be downright powerful. Let's take a...Read post