Yuck! Is that your data you've left lying around? Ugh, it's all mouldy. And what's this? More data under the bed? Right, it's time to clean all this up.
Marketing data is used to give marketers a good look into their customers, from their personas to behaviours, attitudes to purchasing decisions. All of this will be kept in a database, in order to craft those all important personalised experiences.
However, when this is half-arsed, or not done correctly, the data can go from useful, to unusable.
In fact, Salesforce believes that 70% of incomplete recorded data becomes obsolete within the year.
Outdated, duplicate, or inaccurate data can lead to marketing that can be described in similar terms. Your customer might've been looking for "World's Biggest Game of Thrones fan" T-shirts before the finale, but if you're not updating their preferences, it'll hit a sore spot. All of this leads to missed opportunities, bad relationships, and loss of sales.
Between 2019-2021, over 40% of sales reps didn't have enough info about their leads to maker effective sales. So, you can see the real-life consequences of having poor data cleanliness.
But it's not all bad news. The University of Texas has estimated that if the data is just 10% more accurate, then revenue can be considerably boosted, not only for big enterprises, but also for small firms, B2B, and B2C organisations.
But first up: definitions.
Clean data needs to hit a few standard to be considered 'clean'. But, for the most part, 'high quality' data can be a very subjective term. It needs to be relative to its purpose, and agree with the data you already have. This tends to be pretty easy if you've created the data yourself, but if you source it externally, it'll be trickier.
Cleansing data, as a result, becomes a constant and frequent process, where you'll first need to focus on completeness, and then move onto the accuracy and relationships.
So, to judge tour data as 'clean', you'll have to consider it alongside the following five categories:
I know this seems like a bunch of work. And who wants that? The only thing is that inaccurate data is absolutely useless. The Data Warehousing Institute estimates that businesses in the United States lost $611 billion due to low quality customer data. That's billion with b.
And that's just the loss quantified; consider all the customers alienated and frustrated by poor data quality, and the effect this has on a company's credibility.
Dirty data is a database record that contains errors; exactly what you need to avoid. These data inaccuracies can come from the beginning or along the way, from inaccurate input or changes that have since occurred.
TDWI has even found that roughly 2% of the information on customers becomes obsolete within one month of collection, due to sudden life changes. Unfortunately, customers tend to do human things, like "die, divorce, marry, and move".
Good and accurate data is the foundation for any effective marketing campaign. Without it, companies are unable to interact with customers precisely, or respond to shifts in dynamics with speed. Other consequences of dirty data include:
It's not just a case of bringing out the Cillit Bang.
It's important to make a clear distinction between data cleaning with data purging. Clean data can be achieved with deleting old records, which can be used in a number of ways, such as reactivation campaigns or generating scoring models. So, it's more important to focus on cleaning, i.e. getting rid of useless data, and filling in the gaps.
Useless data can be scrubbed clean by:
So, what parts of cleaning your data should you focus on? Well, you'll need to:
Identify and eliminate duplicates. It's important to find duplicates and remove them from your database. Having a name or number feature more than once just inflates your email list and produces inaccurate figures. You don't even have to trawl through all these manually; there's plenty of tools that will work through your list for you.
Delete inactive and junk contacts. Sending all your well-crafted, made-with-love emails to spam accounts or dormant contacts is useless. Think how much time you spent picking out that perfect Parks and Rec gif, just wasted. This is another task you can sub a robot in for - there's email verification tools that will detect dummy accounts, and improve your sender score, within minutes.
But remember to study your email marketing metrics, like open rates and click-through rates. If these are incredibly low, it might not be the Lesley Knope gif. If you have a bunch of cold leads that aren't responding, it might be best to let them go, and focus on the ones that are responsive.
Sorting out missing data. Making sure all those missing values are filled in is vital for good quality data. Missing your customer's first name? Then all their emails are going to the highly valued customer Mr. *|FNAME|*. Missing a postcode? Your direct mail will never reach its target. These missing sections can be filled out using external parties.
Well, there's a few reasons. These can include: