Get a Quote  More


Free Data Audit

Get a Free Data Audit!

Get a Data Count

Request a Free Data Count!

Savings Calculator

How much could you Save?

Submit an Enquiry

We are here to help you!

News Reel

What's New? Find out!

Data Protection

Your data is in safe hands at CNM. We uphold the highest level of information handling in accordance with the Data Protection Act 1998.   

Data Encryption

If your business requires it we can send and receive data encrypted with PGP/GPG. Click here for more information.   
Understanding your business needs

You are here: Home > Data Cleansing > De Duplication

De-duplication

De-duplication is an integrated function of name and address processing that allows us to build highly refined matchkeys at premise, family and individual level on consumer databases or premise, business, department or individual contact level on business to business databases.

Comprehensive reports are provided to keep you fully informed and enable you to have full visibility and control of your data.

Merge-Purge

This is the process of merging two or more mailing files to produce one net mailing file.  Detecting duplicates in this process is particularly important, either when using in-house databases to avoid duplicate mailings, or when renting mailing lists to reduce costs and again avoid duplicate mailings.

The De-Duplication service (dedupe) forms part of our Data Cleansing Service, an example of what you can expect from this service is shown below:-

Example

You have the following data in your database:

Title Forename Surname Address1 Address2 Address3 Address4 Postcode
Before Data Cleansing for Duplicate records
Mr Joe Bloggs 12 Appleton Court Wakefield West Yorkshire WF2 7AR
Mrs Joanna Bloggs 12 Appleton Court Wakefield West Yorkshire WF2 7AR
Mr Joe Smith 18 Calder Park Wakefield West Yorkshire WF2 7AR

This data is cleansed by the dedupe service to:

Title Forename Surname Address1 Address2 Address3 Address4 Postcode
After Data Cleansing for Duplicates
Mr Joe Bloggs 12 Appleton Court Wakefield West Yorkshire WF2 7AR
Mr Joe Smith 18 Calder Park Wakefield West Yorkshire WF2 7AR

As you can see from the example above the first 2 records are matched at Family level as they have the same surname and address so we keep the first record and remove any other family members at the same address. You have the choice of removing matches at Family Level (Surname & Address), Household Level (Address) and Individual Level (Full Name & Address).

Contact CNM to get a FREE audit

Latest News