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

  • The dealership sales and finance process has been built by dealers for dealers. Not consumers.

    There’s got to be a better way to sell a car. Everyone seems to think so.  In our recent dealer survey, 8 in 10 dealers agreed the time it takes to buy a car ought to take two hours or less but most say the average transaction time today is 3-4 hours from meet & greet to funded. The clear majority of these same dealers say that the biggest opportunity for change is to capture more information from the customer earlier in the process.   With the endless eCommerce sites available today, empowered ‘electronic’ shoppers have come to expect the transparency and immediate gratification made possible by the internet. It’s difficult for them to understand why buying a car still has to take so long. Most car shoppers today want to know what their payment terms will be while deciding on a vehicle, so it's completely illogical that dealerships make it virtually impossible for car shoppers to find financing information online.    Dealers should want to provide an easy, seamless...Read post

  • CallSource Automotive Brings Industry-Leading Call Tracking and Management System to Australia

    Company to help Australian dealers improve call-to-conversion ratios with U.S.-patented system that generates an average of $320K+ in additional annual earnings for US dealers; Hyundai Australia first to roll out system to dealer network   San Francisco, Calif. - January 23, 2015 - CallSource, the U.S. leader in call tracking, management and training, announced today at the 2015 National Automobile Dealer Association Convention in San Francisco that it has launched its patented system in Australia. This will give Australian auto dealers access to the same tools US dealerships are using to significantly improve their call-to-conversion rates. Partnering with Australia’s Dealer Solutions, CallSource’s initial rollout is with Hyundai Australia’s dealer network. Dealers and OEMs spend billions of dollars generating leads – a vast majority of which come in as phone calls. CallSource data shows that a mishandled call results in the customer defecting to another brand more than 50...Read post

  • Why 'Irrelevant' Content on a Dealer's Website is Relevant

    Once you get over the beauty of the 1970 Dodge Charger in the picture, you might ask yourself, "What does a 45-year-old muscle car have to do with automotive content?" We've been asked the same type of question multiple times pertaining to content we publish on dealer websites. Sometimes, it's dealers asking. Other times, it's other vendors wondering what we're doing or "tattling" to the dealer about it. The funny part is that when compared to the automotive marketing "gurus" who question it, the dealers tend to understand the philosophy much more quickly than the vendors. I'm not here to insult anyone. I totally understand why it's hard for many vendors to get, especially the larger ones who have mechanized content, search, and social strategies. The reality is that based upon the most modern algorithms for Google, Bing, and Facebook (amongst others), robust and potentially popular content influences the visibility of standard lead-generating pages, inventory, and landing pages....Read post

  • DMEautomotive’s Driver Connect Collects Two More Top Honors: AWA Award and 2015 Digital Edge 25 Award

      DMEautomotive’s groundbreaking mobile app for dealerships wins Automotive Website Award for second year in a row, and is an honoree in the prestigious Digital Edge 25 Awards   San Francisco, Calif. – January 23, 2015 – DMEautomotive (DMEa) today announced that its groundbreaking dealer-branded mobile app, Driver Connect, has received two of the most prestigious honors in the automotive and technology industries: an Automotive Website Award (Automotive Mobile Apps category) and a Digital Edge 25 Award.  This is the second year in a row that Driver Connect has received an AWA and its first as an Honoree in the prestigious Digital Edge 25 Awards, which recognize enterprises that have leveraged digital technologies to transform their business.   Driver Connect was presented with the AWA at the National Automobile Dealers Association (NADA) Conference in San Francisco on Thursday, January 22nd.  The Automotive Website Awards are presented each year by PCG Consulting to re...Read post

  • 3 Reasons to Take Content Seriously for Better SEO (with Bonus Infographic)

    SEO is a complicated practice, especially if you're just starting in 2015. Things have changed a lot in the past 10 years, making it more difficult than ever for small businesses to compete against businesses with large marketing budgets. But as one of the most important parts of a business's digital marketing strategy, you can't ignore SEO.   Content is easily one of the best ways for businesses to take control of their rankings and build up authority with Google and other search engines. It's the simplest strategy, but it's also one of the most effective.   Let's explore the three reasons why your business should be serious about the content it's producing if your goal is to improve search rankings.   Great Content Attracts Links   Links make the web go round. They tell search engines how your site relates to other sites, what your site is about, and lets them know which pages on your site are the most important.   By creating great content, you'll naturally attract li...Read post

  • Why “Transparency” is Just Like Hard-Core Porn

    Writing a decision in a 1964 Supreme Court pornography case, Justice Potter Stewart wrote that some things are hard to put into words, hard to accurately define – and this is especially true of abstract ideas. So Stewart wrote one of the most famous phrases in court history “…I know it when I see it”. It’s interesting to note, that Stewart went on to say that the film question was not hard-core pornography. I think it is often easier to define what an abstract idea is not, than what it is.Read post

  • CallSource CallTrack® Presented with DrivingSales Dealer Satisfaction Award

    CallSource receives a “Top Rated” Award for Dealer Satisfaction in Call Management Category   San Francisco, CA – January 23, 2015 – CallSource’s CallTrack® is the recipient of a “Top Rated” Call Management award in the sixth annual DrivingSales Dealer Satisfaction Awards, presented at a special event today in conjunction with the 2015 National Automobile Dealers Association (NADA) Convention & Expo.   “We are very honored to be acknowledged by dealers as a top-rated call management provider and thrilled to receive this prestigious award for the fifth year in a row,” said Andrew Price, President of CallSource Automotive. “And the biggest reward is the benefit we are delivering to dealers by improving their call-to-conversion ratios and helping them recoup revenue from mishandled calls.”   CallTrack® is the leading call tracking service for automotive retailers. CallTrack captures every caller’s phone number, identifies the advertising source and ...Read post

  • Make a Resolution to Provide Vehicle Education

    At OneCommand, we pride ourselves on developing new, creative ways for our clients to reach out, connect, and attract business. Several years ago, we developed a great way for our clients to accomplish this - providing vehicle education. Now I know what you’re thinking, “How will educating consumers about their vehicle bring more business to my store?” Check out these great tips to make a resolution to provide vehicle education. Be Relevant When providing vehicle education tips, be sure the content is relevant to your customers. Think about applicable services needed for a given season or time of year and be sure the information is pertinent to their specific model of vehicle. The more relevant you make your communication to the recipient, the more likely you’ll get your desired response. Include DIY Now this tip may seem like a complete oxymoron. The truth is, some services that need to be done on a vehicle a consumer can do without ever bringing it to a shop. However, an ev...Read post