You are here: Home > Data Cleansing > De Duplication
De-duplicationDe-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





