Database Cleaning

Your Data is your important Asset are you managing it?

A quality database is as much an asset to a company as highly skilled employees. Statistics tell us that business data can deteriorate at over 40% per year, so it is vital to not only clean your data, but regularly maintain it. Businesses need to realise that a well maintained company databases is the key to the success of marketing campaigns, sales and profitability.

What is Data cleansing and what does it involve?

The first step is an Audit of your existing database, identifying the following information:

• Duplicate Data
• Invalid Post Codes
• Postcode and Address Data Mismatch
• Invalid E-Mail Addresses
• Incomplete / Missing Data

Our objective is to upgrade the quality of your database or mailing list to make it ready for marketing activities or customer insight analysis. We will do this in the following ways:

De Duplicate the database using criteria agreed with the client. This will cover Contact Names, Company Names, Mobile Phone numbers and other key fields.

Address standardisation ensures consistency in your customer database with not only accurate, but data positioned where you would expect to see it. We will use the post codes stored in your database to validate the address data, and auto correct where required.

Where email addresses are stored, our tools identify invalid accounts, question possible validity and give a green signal on successful ones. Legitimate email addresses save time, effort, costs and ensures that you are meeting rules and regulations for email marketing!

We will also indentify records that have incomplete or missing key fields this is essential if for example you would like to find all Managers in your database and the Title field hasnt been updated.

Finally, we offer best practices for maintaining high quality of data entry, including user training and use of technology where beneficial (validation of data, mandatory fields etc).