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

  • LotLinx...Does It Measure Up To The Hype

    LotLinx has exploded in 2014 right when the progressive dealers started to migrate away from form submissions to VDP's to establish ROI. LotLinx deeplinks your new and used inventory to 3rd party partners and routes the VDP click thru to your VDP thus bypassing 3rd party VDP's and form submissions. Uncovered are concerns about Lotlinx reporting issues and inconsistent daily referral resulting in a unusual spike monthly. Can LotLinx resolve this and turn this good tool into a great tool as toutedRead post

  • 4 Tip and Tricks to Drive Engagement On Your Dealership Website

    We recently completed a usability study with REAL in-market car shoppers to determine how they engage with inventory on dealer websites while researching their next purchase. Participants in the study were recruited from the local Seattle area and consisted of people currently in-market for a new vehicle. The goal was simple— to find out directly from the mouths and mouses of real shoppers what makes car shoppers click when browsing your vehicle details pages (VDPs) and vehicle search results pages (VSRs).Read post

    By Cobalt on November 25, 2014

  • How To Maximize Your Dealership Black Friday Sales

    It's the holiday season, that means one thing, you only have a few weeks left to hit your year end sales quotas. While this turns into a very stressful time for many dealerships, it doesn't have to be this way; so put away your Grinch costume and use that shiny little device (smartphones) all you customers have to turn your inventory into perfectly wrapped presents that constantly keep driving off your lot. Everyone's Online According to PunchTab 90% of consumers plan to shop online this holiday season,and with consumers spending more than 15 hours per week researching on their smartphones capturing capturing your customers pre-purchase is essential to ultimately gaining their business.   You want to capture all these customers as they look for vehicles don't you?   Step 1: Simplify Their Search Shoppers make store visits after searching, and if they find all the information they are looking for they are 75% more likely to visit the store.   Take control of how your custom...Read post

  • Join social media groups to find your next great job

    Here is the daily hiring and getting hired tip: Get social to find your next dream job. In today's connected world many of the best positions are filled before they ever get advertised. Social media is not just a place to catch up with friends, business owners and managers are connecting with potential candidates. The best place to find these hidden opportunities are in groups on Facebook and LinkedIn. Join five or six groups specific to your industry and contribute. Comment when there is a topic you have an opinion on, or pose a question to the group. These groups are one of the first places management goes to hunt for fresh talent. Sometimes they will even post right in the group that they need a new employee and ask who knows someone. Most importantly start engaging in groups now. It can take time to be noticed as a contributor, and you want to build those connections before you need to use them to find an employer.Read post

  • Content Marketing Strategy: How to Create a Winning Company Blog

    Content marketing, in general, can provide many valuable benefits. It can help create and maintain a brand presence; assist in search engine optimization; and position executives as thought leaders. It can also serve as a valuable source of information for both customers and potential customers.   There are many types of content marketing. Technically speaking, everything your business creates and publishes is content marketing. This can include such items as marketing pieces, videos, blog articles, articles published in trade magazines, social media posts -- you name it. If your audience sees it, chances are that it’s content marketing.   While most businesses understand the importance of content marketing, many get stuck when trying to make it an ongoing reality. Think of it as an extreme case of writer’s block. Someone is tasked to create this “content” but they don’t know what to create on a regular and ongoing basis. Some companies create comprehensive content ma...Read post

  • New Google transparency requirements hold 3rd party partners more accountable for AdWords Mgmt fees

    Google is introducing two new requirements aimed at increasing transparency and accountability of third-party partners. Starting in November, agencies and other third-party firms and individuals that manage Google advertising for customers will need to conform to new third-party policies. The current policy mandates that third-parties disclose Ad Words media costs, clicks, and impressions at the account level. Now all management fees must be disclosed on invoices and be itemized to show the net cost of the Google portion separate from any management fees or mark-up. The days of ‘black box’ digital advertising packages appears to be coming to a close. Black box refers the idea that you pay your digital vendor or agency a monthly amount to provide a host of online services and they ‘optimize’ it among various digital elements such as paid search through Google and Bing, retargeting ads, banner ads, in banner video, search retargeting, or any of a host of other types of digital advertising. While there are positive points to this approach, it has also presented an opportunity for vendors to provide less than full disclosure regarding the ‘third-party’ fees they are actually charging to manage these services.Read post

  • "Selling" at the Zero-Moment-of-Truth

    As an industry, we often activate a vast array of tools...shiny widgets....and systems in which to be effective to the modern consumer….. HOWEVER....do our systems: Target - Communicate – Integrate together; As-One; in order to ensure Buyers are delivered at the ‘Zero Moment’ through a direct-path to OUR specific Stores? Websites? Telephones? As Dealers = "WE reserve the right, to Market OUR Brands, OUR Stores, OUR Inventory - with a single and direct connection to OUR stores, everytime!" Automotive News | Dealers > Best Practices ( Nov. 24, 2014 ) Cardinale Group makeover flexes digital Muscle http://www.autonews.com/article/20141124/RETAIL07/311249996/cardinale-group-makeover-flexes-digital-muscle   ...Read post

  • Does your dealership catch customers at zero moment of truth?

    As Digital Dealers we should all be familiar with the Google’s study that shows the behavior of a current ZMOT Auto buyer: – The majority of shoppers for automobiles are quite thoughtful – starting the process about 2-3 months before. Still, 14% of shoppers actually report spending less than a week on the decision making process. – Auto shoppers use on average 18.2 different sources of information – from TV, news articles, online, family, etc. to finally form their decision. – 97% of auto shoppers will be influenced by ZMOT-style advertising. Marketers should be thinking about how to use ZMOT to drive shoppers right into the dealership. – 71% of auto buyers used a search engine to help find a dealership At ZMOT we have proven that a dealership group that embraces digital marketing focused on targeting zero moment of truth buyers with systems that Target - Communicate – Integrate together as one in order to ensure Buyers are delivered at the "Zero Moment" throu...Read post