Data Cleaning – An Integral Part of Direct Marketing?

I am always surprised that undertaking a data audit and cleansing exercise before every direct marketing or digital marketing campaign is not a standard requirement when customer and prospect data is to be used. I hear comments such as:-

  • “We haven’t budgeted for data cleaning”
  • “We cleaned the data last year”
  • “We updated our database from the mailing returns”
  • We know our customers, they would have told us if their circumstances had changed”

Ignoring requirements upon us all under data protection legislation to keep data accurate and current, ignoring the environmental benefits, ignoring the impact on customers and prospects and their view as to the mailer’s competence, cost alone should be a driver to  undertake comprehensive data cleaning on every occasion. The savings made on print, fulfilment and postage costs both for the current campaign and future campaigns with the same data will outweigh the costs of data cleaning. In these difficult economic times where every penny has to be spent wisely and where return on investment is a key measure of success or failure of a campaign, data cleaning your customers and prospects regularly is essential.

So what are the key elements of any data cleaning exercise?

Address Validation & Correction. Comparing addresses against the Royal Mail Postal Address File (or “PAF”) to ensure the address and postcode are valid. This ensures your mailing arrives at its intended destination and on time. In addition discounts in relation to postage costs only apply to correctly addressed items.

Deduplication. Avoid sending the mailing more than once to the same recipient or possibly the same household. Its wasteful and looks bad. Deduplication is the process of identifying possible duplicates in the mailing and then actioning to reduce these duplicates to a single record.

Mortality Cleaning. Comparing the name and addresses against databases of people who have died(mortality registers) enables you to remove these from your database. Failure to do this can cause distress and hurt to he family of the intended recipient, and there is always an assumption on their part that you should have known. Businesses also stop trading, so checking your Company data against registers of dissolved businesses can also be undertaken.

Goneaways & Change of AddressPeople and businesses move and there are databases of people no longer at their old address to compare your records against. Why mail to someone who is not there? Some databases also know where the individual or business has move to and so a new address can be obtained to enable you to follow the customer or prospect to their new location.

MPS & TPS Cleaning. The Mailing Preference Scheme (“MPS”) and the Telephone Preference Scheme (“TPS”) are national registers where consumers can record whether they wish to receive certain types of communications by post or telephone. If you do not know whether your customer or prospect wishes to receive the intended communication then you should check against these registers and remove the record if the consumer has indicated no desire to receive it.

These are the key elements of any data cleansing exercise, there are other cleansing and data enhancements that can be made at the same time.

There are three prime benefits resulting from keeping data clean.

  • Economic. The costs for having data cleaned are not extortionate.  When compared with immediate savings that will be made from mailing your data, in most cases the savings will outweigh these costs. Further the costs are known in advance of committing to the cleansing through the use of a data audit. This process evaluates the data and works out what records it needs to modify or change and what the costs will be to achieve this. This audit is usually undertaken free of charge.
  • Environmental. Cleaning data reduces the environmental impact of a mailing. Removing records where the recipient has died, moved away or simply asked not to receive the marketing material reduces the amount of print and packaging used for the mailing. It also reduces the carbon footprint of the mail piece being delivered from mailer to recipient and then back again as a gone-away.
  • Brand Perception. Impact of your brand upon the recipient is not damaged by more than one mailing being received at the same time or by the mailing arriving late due to poor addressing, or through upsetting family members through not knowing the recipient had died.

In summary, my advice is to audit your data before every mailing and clean when and as indicated by the data audit. Remember not just to make the cleansing changes to the mailing about to take place but apply the changes back to your database to ensure all future direct marketing activity takes into account this new customer or prospect knowledge.

One thought on “Data Cleaning – An Integral Part of Direct Marketing?

  1. Pingback: 15 Seconds To Make A Connection | DDL Group

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s