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

  • Customer Loyalty Isn't Dead. It Can't Be. It Simply Needs a Revival.

    There is doom and gloom in the statistics. Fewer people are staying loyal to a single brand of vehicle. Fewer people are staying loyal to a particular dealership. We've been hearing about it since the rise of the digital age and it can push dealers to focus on generating new sales and service customers at all costs. Since we're a vendor that specializes in search and social marketing, one might think that this is the type of shift in the industry that we would embrace. The reality is that our roots as car people and our focus on being a partner for our dealers supersedes the benefits we receive from the trend. We want our clients to succeed and the lowest hanging fruit - customer retention - is the one measure that we see slipping through the fingers of so many dealers out there. One of the things that we've been investigating is the (seemingly) lost art of turning the one-time sales mentality that has been growing in our industry into the good ol' "customer for life" paradigm that...Read post

  • 2014 DrivingSales Executive Summit Recap

    For the sixth year in a row, DrivingSales Executive Summit (DSES) sold out to an enthusiastic and progressive-minded audience. With the Bellagio Hotel as our venue, we were all treated to an impressive main stage, plenty of space, and exquisite food catering—and, of course, the most advanced content in the industry!   Day One We began the conference earlier than ever before, kicking off at 1:30pm on Sunday, October 12th—and that's not considering our Canadian breakout session sponsored by e-Dealer, Glovebox, and SCI Marketview that started at 8:30am or the Cox Automotive brunch and panel presentation that commenced at 10:30am. DSES indeed had a packed schedule! And then, the audience was shown the 2014 DSES Kickoff Video: Introduced by event emcee, Charlie Volgleheim, the founder and CEO of DrivingSales, Jared Hamilton, provided a high-level overview of Executive Summit, what the attendees could expect from the conference, and a brief look at the auto industry as a whole....Read post

  • Mobile Search Rank Study Shows It's Good to Be #1

    If you've spent any time on the marketing side of your dealership, you know how valuable organic search traffic is. But in order to receive a large amount of search traffic, you need to rank for a variety of different keywords, which means having a properly-optimized website, high-quality content, and inbound links from authoritative sites.   Now, on the desktop side, there have been plenty of studies that prove that the #1 organic result on Google receives the brunt of the clicks. As Google users become more familiar with searching for information online, and Google updates its algorithm to provide better overall results, though, the number of people who click on the first result has gone down significantly.   (This is also a sign that your metadata--which is the information displayed about your page on Google and other search engines--needs to be optimized so users can understand what your content is about, which will increase clickthroughs to your dealership's website.) Read post

  • Stand Out by Thanking Veterans

    The spirit of the holidays is in the air. Halloween is next week and before you know it, Thanksgiving and the end-of-the- year holidays will be here. With all the excitement of these upcoming holidays, many retail companies will glaze over a very important tribute, Veterans Day on November 11th. This day of remembrance and thanks to veterans for their commitment and sacrifice to defend our nation deserves a place in your end-of-the-year marketing strategy. Here are two ways you can honor veterans, drive traffic and revenue, and STAND OUT from your competition. Offer Exclusive Veterans Savings This idea seems like a no brainer because it is! Put together valuable discounts, something you’d typically offer your most loyal customers, and advertise them exclusively to veterans and active duty military personnel who visit your store during the month of November. You could also decorate your showroom or service drive with red, white, and blue to show your support of these brave men and wo...Read post

  • Going Beyond All-You-Can-Eat In Loyalty

    When consumers think of loyalty programs, they typically think of racking up miles, or frequenting a business in exchange for rewards, perks or freebies. No matter what business you patronize, there is a good chance that it is offering some sort of loyalty incentive. In fact, many argue that loyalty programs are so prevalent nowadays that they are losing some of the initial qualities that attracted consumers to them back some 45 years ago. Namely, that feeling of being treated special in exchange for the customer’s ongoing business and continued loyalty. Today, some loyalty programs choose not to even offer rewards. Instead they just provide the concept of receiving lower prices. Many grocery store chains have the regular price and then a loyalty member price. Sale prices are reserved just for members of their loyalty program.  Your information and transaction histories are exchanged with the grocery store for a slightly lower total at the checkout counter.   Loyalty programs h...Read post

  • Dealers Shouldn’t Abandon Third-Party Sites Just Yet

    If you've been following the trends for the last year in the automotive industry, you’ll note that there are some dealers that are pushing all of their advertising dollars towards driving traffic to their websites. It’s a strategy that was made popular when a large dealer group declared that they were going to focus on generating their own leads and wrote an interesting piece about why they were doing it. Unfortunately, the strategy that they’re adopting has been misunderstood by many. The idea is that they wouldn't be buying leads from other sites anymore. They never declared that their inventory wouldn't be available on other sites. It’s a concept that makes sense – generate your own leads, whether they’re coming from third-party sites or the dealership’s website. In an article titled, Why Car Dealers Should Adopt a Modern Digital Merchandising Strategy, we went into detail about why many consumers prefer to shop on third-party sites rather than on a dealership’s ...Read post

  • Why Customers Leave Without Buying A Car And What To Do About It

    What's the most creative reason you've heard from a customer who is leaving your dealership lot without purchasing? Sure there are the typical, "have to check with my spouse," and "have to pick up my kids at their soccer game." Then there are the more atypical reasons: "I have a dentist appointment," or "My mother-in-law's in town." If it's one of the latter, warning bells should be ringing. Who would rather go to a dentist appointment or visit with their mother-in-law than buy a car?   According to AutoLoop Engage's call center statistics, only three percent of customers who leave without purchasing give the salesperson the real reason. Our agents have connected and engaged with thousands of unsold customers and here is why they're really leaving, according to our data:   55 percent leave because of payments/price/trade-in issues 26 percent leave because of inventory issues; your dealership didn't have the exact color or model they wanted 16 percent left because they had a bad...Read post

  • How to Find Out What Women Want and Reach The Modern Female Car Buyer

    A woman’s vehicle path to purchase needs may be prioritized differently than a man’s, and in order to sell to women, stores can benefit by understanding and caring about what women want when it comes to cars. They should ask Mel Gibson (about what women want…)Read post

    By Cobalt on October 23, 2014