What is Data Cleansing?
Regular data cleansing updates include simple processes (including field reformatting, standardizing addresses, phone and email data, and applying NCOA updates) that are required but may be intimidating to some.
At C.TRAC Direct, we deal with hundreds of customers and their databases each year. We find that many of our accounts are a little scared of their own data – and we understand why. When we work with an account, we often begin by asking questions that cover spooky topics such as data collection methods, the various sources of their data, and how data quality is (or is not) managed.
Data management can be scary. Whether you have employees input your data, or it’s collected on your website by prospects/clients, dirty data can easily run rampant in your system(s) and create chaos.
Simple Mistakes That Kill Communication Efforts
When keying in data, people can make small mistakes that cause big problems, such as:
- Adding too many digits
- Transposing numbers or characters
- Misunderstanding street names that are phonetically entered
- Using abbreviations that aren’t standard to mailing software
Data collected from a website can be much worse as customers don’t adhere to field formats (such as putting delivery directions in the address field or entering city-state-zip in the city field), leaving businesses with the information they can’t merge into an existing database or use for future communications with their customers.
Multiple Silos Make Marketing a Nightmare
Digital marketers, CRM managers, and database managers shudder when we ask about multiple silos of data. More often than not, CRMs are full of data cobwebs, such as incorrect segmentation, databases full of duplicates no one can figure out how to merge, and (the one EVERYONE has) secret lists that sales representatives, client service reps, HR departments, and even financial divisions maintain on their own and send over when they want to get “their list” included. These home-grown databases of names and prospects arrive unformatted – or don’t follow business rules. It can take hours to sort out. You never know how “well-maintained” these are and you run the risk of overwriting existing records with bad data—what a nightmare on Elm Street!
] Data quality updates can send managers screaming!
The mere mention of data quality updates can send data managers screaming. Many technical staff members have had terrifying experiences of overwriting existing contact data with “updated data” with bad results. They may become frightened of doing regular data hygiene and maintenance.
Regular data hygiene updates include simple processes (including field reformatting, standardizing addresses, phone and email data, and applying NCOA updates) that are required but may give your team the shivers. Managers hear comments like “We tried it once and it didn’t work,” or “Someone made a mistake last time, so why risk it?” This means your data ages and you are effectively not updating records and contacts. While the consequences of a mistake in updating is serious, so is the potential damage done to sales when you lose touch with your customers.
One of the most common assumptions people have about data quality is there is a permanent “fix” to your data once it’s implemented – a solution that doesn’t require repetitive work. Data maintenance is like car maintenance – if you don’t change the oil in your car regularly, you can expect trouble with the engine! Data hygiene is an on-going process – once you stop, your data will begin to decay within a month. Simply a scary thought.
We Found Skeletons in the Closet!
If you’re cringing right now, here’s a spooky tale. We visited a client to discuss their data and its impact on their returned mail. Upon asking to review some of their mail, they took us to a back area of their office and opened a door. There, literally in the closet, were stacks of postal trays filled with yellow-stickered returned mail.
Why in the closet? “Because we don’t want the management to see it,” they explained. “They get all wired up when they see this much mail coming back. So, we hide it in the closet. When we get a chance, we key it into the system and suppress those people from mailing again.” They went on to say that if they were really busy, they just threw it out, compounding the loss.
This business, similar to many, had “dirty data” secrets. By failing to ask for data hygiene services BEFORE they mailed, they didn’t have good records to send and paid (literally) for the mistakes to come back. They missed the opportunity to market to all those contacts and they were “suppressing” the records (or just tossing them out) rather than updating them for future marketing opportunities. Of course, this was a compounded loss including the missed opportunities, postage, and marketing budget wasted on bad data.
What data skeletons do you have in your closet?
Here's How We Fixed It:
We exorcised the closet of their trays of mail (while management was out) and key entered the data for them within a few days. Rather than suppress them from future mailings, we ran our ReDirect+ Return Mail Service which matches these records against a multitude of Change-of-address (COA) databases, including USPS NCOA-48 and proprietary industry mailing files to locate the latest address. ReDirect+ includes a deeper layer of address correction and deceased coding. On average, 40% - 50% of the returned records are corrected or updated with new address data to ensure these valuable customers are not lost.
We Can Put Your Fears to Rest:
An atmosphere of “data fear” has a profound impact. It prevents people from trying out new ideas, hampers productivity, and actually increases costs. You don’t need to be scared of your data any longer. Contact us and let us show you how we can help you with:
- Data hygiene
- Support services to enter data
- Data management solutions to help you create, update or merge databases
- Returned mail solutions to cut down on returns