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

  • Proactive PR & the NFL?

    While I love to be active myself, I certainly could not call myself a big fan of watching and keeping up with sports. It seems, however, that you cannot turn on a television, read a newspaper or use any social media recently without hearing about continuous misdeeds and wrongdoings of NFL players. I’m sure that you’ve seen them as well. So this is not designed to rehash, recap or discuss any of these controversies. Much of the attention and negative PR has been directed towards those players involved, as well as the NFL itself, as can be expected. Due to the ongoing controversy, sponsors have distanced themselves and some have even disassociated themselves with the league. One sponsor, however, seems to be taking a slightly different approach to the controversy… Verizon.   Let’s face it. Regardless of any controversy, football is not only uber-popular in America, but also big business. It brings massive exposure to its partners and sponsors. Just as in the real world, howe...Read post

  • "Going Viral" is a Dream, Not a Goal

    Over the years, I've worked with some of the best social media marketers in our industry. I've seen some posts that have hit incredible numbers on social media sites that were seen by tens, even hundreds of thousands of people. They were all memorable, not because the content was so incredibly awesome but because "going viral" on the internet is so hard. In fact, it's not just hard. It's what most would consider to be a fluke. It's for this reason that I want to warn dealers about the concept of going viral. Reference.com says that going viral is something "pertaining to or involving the spreading of information and opinions about a product or service from person to person, especially on the Internet or in e-mails." It sounds awesome! Wouldn't every dealer love for their messages on their website, blog, YouTube channel, or social media profiles to go viral and get spread from person to person in bulk? Unfortunately, it's not something that can be easily manufactured. I'm not going...Read post

  • Are You Available When Your Customers Are?

    The internet has changed our world. The concept of "business hours" has been turned on its head. People are buying things online at 2 in the morning. They're researching vehicles after the kids are in bed. They're planning out how to drop off their vehicle in your service department and still get to work on time at 4am. When they have questions, are you there for them? Chances are that you do not have a receptionist there to answer questions by phone overnight. A contact form or email simply won't fulfill all of their needs in the timely manner they expect. This is where 24-hour chat comes into play. In the example above, we described the person who wants to know about your service department and how she'll get to work. This isn't a hypothetical. It actually happens. We see chats all the time inquiring about hours and transportation. If you're not there to answer their questions, you're missing out on potential business. She can't wait until 7am to decide where to drop off her car ...Read post

  • Social Media Engagement is a Two-Way Street

    The most amazing part about the internet and social media is that it has opened up communication between people and businesses that was never possible before. We now have the ability to talk to our customers and for them to talk to us in an interactive fashion, allowing for clear lines of engagement that can be both public and private. For car dealers, this has translated into an incredible way for them to broadcast their messages and get feedback in real time. On Facebook, people can like, comment on, or share their posts when they appreciate them... and even when they do not. The world is completely different than it was a decade ago when the most powerful method of online communication, the email, was still relegated to being private. This all means that dealers can receive interaction, but it also means that they're required to deliver interaction right back at their customers. Every day, we see dealers who are not taking advantage of this. People will comment on their Facebook...Read post

  • Dealer Solutions: Catching Red Flags on Millennial Resumes

    Does it ever feel like the term “millennials” is an annoying buzzword or something that the American workforce can’t stop mentioning? Regardless of how this may make you feel, this is a term that won’t be going away anytime soon. You probably keep hearing something about “Generation Y is the future” or “right now is the time to attract millennials at your organization”—although it might seem repetitive, it’s true. This generation currently makes up approximately 23% of the dealership workforce, according to a report released by the NADA last year. Additionally, the percentage of millennials in the workforce is only going to increase in the years to come. This also means that there’s a good chance you’ve had a decent influx of resumes coming from this specific generation at your dealership. While hiring millennials is essential to growing business, it’s also important to make sure you’re hiring the best-fit candidates. One way to avoid poor hiring decisions is by scanning resumes for certain warning signs. The following are several red flags on millennial resumes that hiring managers should search for in order to avoid hiring a potential turnover candidate at your dealership: Careless Grammar & Spelling—This is an obvious red flag to spot on any resume. If a potential candidate is lazy enough to not carefully proofread his or her resume, then it’s likely that same candidate will not perform to the best of his or her ability. Full Sentences—Resumes should never be writRead post

  • AutoLoop Welcomes Sales Rep Sean Donovan

    Clearwater, FL--October 21st, 2014--AutoLoop LLC, a leading developer of sales-generation and customer-retention software for auto dealers, today announced the addition of Sean Donovan as Sales Representative for western North America. Donovan brings nearly 20 years of automotive marketing, technology, and analytics experience to the team, and his new position emphasizes AutoLoop’s continued expansion into the western U.S. market.   “Sean’s an exciting addition,” said John Bottone, AutoLoop’s Vice President of National Sales. “He has a deep understanding of our products and the ways dealers can benefit from them. Having him on the team will be a tremendous asset to our ongoing success in the west coast markets.”   Before joining AutoLoop, Donovan served at dealerships throughout the western U.S., and has watched how the rise of mobile devices has affected the consumer purchasing process. “Today’s dealers must focus stronger efforts on engaging and retaining cust...Read post

  • 3 Halloween Ideas for Car Dealerships

    Trick or treat! There’s a little less than two weeks until Halloween! Does your dealership have a plan for how to bring more shoppers into the showroom and service bays during this fun and hopefully-not-too-scary time? You should! Holidays are always an opportune time to foster some community spirit and be the host to memorable events for your customers and prospects. If you’re struggling with coming up with ideas for how to celebrate Halloween while bringing in more sales, I’ve put together a few ideas below that are sure to get your community excited to come see you.   Throw a Community Halloween Party Everyone loves a party, right? Provide food, drinks, and music, have a costume contest with prizes, set up a haunted house, hayrides pulled by a truck (to show off the impressive strength of your vehicles) give out candy, and make sure everyone has a good time. Events like these build community bonds and even if the attendees don’t buy a car while they are there, theyRead post

  • Dealerbaby Announces Newest Customer – Blevins Brothers

    Dealerbaby Announces Newest Customer - Blevins Brothers Blevins Brothers Launch Their First Native Mobile App  Saratoga Springs, NY: Dealerbaby (www.dealerbaby.com), a custom mobile app platform for auto dealerships, is proud to announce that Blevins Brothers, an auto group in Ogdensburg, NY has launched their first native mobile app via the Dealerbaby mobile platform.  “Dealerbaby allows us to connect with our customers like never before.  It puts our store literally in the palm of their hands, anywhere, anytime,” said Marc Blevins, Sales Manager at Blevins Bros. Blevins Brothers, a Chrysler, Dodge, Jeep and Ram dealership, serving Gouverneur, Canton, Watertown, Potsdam and Fort Drum, NY, has been a family run business since 1983. Last year, Blevins Brothers, began looking for a new way to reach current and potential customers. After a thorough review of options, Blevins Brothers, choose to invest in mobile for the following reasons: reach, loyalty, and the future of car bu...Read post