Similarly, if your database or CRM system is out of date then your marketing campaigns will be under-performing and resulting in costly, inaccurate mailings and campaigns.
Data cleansing (or data hygiene) is an effective way to check and correct your customer information, ensuring you always get the most from your database. You’ll also be able to make business decisions in confidence.
A cleansed and enhanced database:
- Reduces marketing costs
- Increases response rates
- Ensures legal compliance
- Eliminates duplication
- Improves accuracy
To ensure that your data does not let you down follow these 5 Top Tips:
Top Tip #1: Ensure regularity of data quality improvements
Two statistics that every marketer should be aware of are:
1. Data decays by more than 30% every year,
2. 90% of the world’s data has been collected in the past 2 years.
When you consider these two statistics it is paramount that you put in place a programme for continuous data cleansing and enhancement. As well as ensuring you remove non-relevant data, the exponential rise in Big Data collection from the ‘Internet of everything’ means that there are always new ways to analyse your customers and better engage with prospects.
Blue Sheep therefore recommend that you cleanse and enhance your full database every 3 to 6 months to ensure that you know precisely how many customers and prospects you’ve go, understand your data better and ensure that all your business decisions are well informed.
Ensure that Data Hygiene features in your marketing and budget plans each year and create a programme of continuous data cleansing and enhancement.
Top Tip #2: Do not be precious about legacy customers
When we look at customer or client databases we regularly come across historical customers that are retained by the business to use to promote a high customer number than they actually have.
If someone bought your products or services 6 years ago but are no longer in business, or in many cases we’ve seen are deceased, then this needs to be applied to the database.
We all want to boast about our large client base and show success, but when marketing produce upsell campaigns or spend weeks authoring customer newsletters you need to be sure that the time is well spent and ensure that the targets for responses and conversions are realistic.
In the example of one company selling products to SME construction companies with an average age of 45 to 65 business owners, we found that their customer file of 15,000 contacts included over 1,500 deceased business owners and almost 5,000 that had gone out of business during the recession. This equated to over 40% of their customers that were being included in email and mailing campaigns costing the business tens of thousands of pounds.
Top Tip #3: Put in place good de-duplication and merging techniques
Keeping a high quality of data can feel like a thankless task when data entry can be at the mercy of ‘sloppy salespeople’. Many CRM systems and databases include merge tools and de-duplication systems allowing you to match records that look similar. This is great BUT what happens if you merge two records that are not actually the same?
The one thing worse than ‘Duplicates’ is ‘False Positives’!
A False Positive is when you merge two records that are actually not the same person. This can happen when the existing data is not extensive but can lead to illegal practice if you merge an Opted Out recipient with an Opted in recipient. It also reduces the size of your customer/prospect list and often the information lost in the merging process cannot be reclaimed.
Spend time thinking about some strict processes and rules for de-duplication and merging. You’ll benefit in the long run.
Top Tip #4: If you’ve got Hard Bounce reports then USE THEM!
If you do lots of email marketing (most of us do) then make sure you are utilising the reports that come from most good email service providers (ESPs). If you generate hard bounces from your emails then use that information to remove email addresses. You probably generate a lot of information from your ESP about locations, devices used, Open times, click times and many other metrics. This is Big Data at your fingertips and hugely underused by many organisations that are too concerned with getting email, after email out of the door.
It is every marketer’s responsibility to keep their data cleansed and updated and hard bounces are another way to cleanse your own data. This helps your response rates, keeps data clean, provides you with better results and reduces costs. (If you send your data to Blue Sheep to get cleansed then you can probably remove lots of the email addresses yourself before sending it just by spending some time with the reports in your ESP! Again, you’ll spend less money on cleansing and save even more budget!)
Top Tip #5: Understand the '80:20 rule' when looking at data marketing
Data marketing takes time and resource to get it right. Data governance takes time to enforce, cleansing and enhancement can cost money and when marketing budgets are tight and under-resourced the temptation can be to continue as you are and keep running at a fast pace with conversions and response rates never quite hitting the desired level.
The Pareto Rule tells us that we should spend 80% of our time on 20% of our customers – the high spending, long lasting customers – however we often work in reverse and apply all our efforts to prospects that are going to yield very little. The most successful and profitable companies across the world undertake data segmentation to produce a profile of their most profitable customers and then spend their time going after those. This takes less effort, provides more revenue and ultimately more efficient.
My final Top Tip therefore is to look at data segmentation and data enhancement as a way of understanding your customers better and build a better profile of your BEST customer. Using that insight can inform all future marketing decisions allowing you to find the right prospects and exceed targets consistently.
If you would like a free Blue Sheep Data Quality Audit then give us a call on 01242 545 340 or visit our Data Quality pages on the website to submit an enquiry.