De-duplication

Quick Info

De-duplicate all the records in your database quickly and accurately
Link duplicates with a master record identifier so that you can merge them back into your database or completely remove them
Target a certain customer or prospect once with every campaign
Part of our data cleansing range of services

As the sources of customer data within your organisation multiply, that information can become replicated or distorted. Identifying unique customers not only cuts out duplicated communications, but allows their true value to be revealed - several customers become one valuable customer who buys multiple products from you.

Deduplication is provided as part of our Data8Online data cleansing service. Register now and upload your file to receive your FREE data quality audit report straight away - no technical knowledge or signup fees required!

Many commercial CRM and proprietary customer database systems include deduplication systems, but most of these are very limited and will only detect exact duplicates. Our system employs a number of powerful fuzzy matching techniques to quickly identify duplicates where the name or address is misspelt.

See an example of the Deduplication service in action.

Benefits

Do not waste your marketing budget by sending multiple mail-shots to the same person
Avoid upsetting certain people when telemarketing to them more than once with the same message
Analyse the true value of a certain individual to your organisation
Enhance your green credentials by reducing waste

Examples

The following data in your customer database:

Forename	Surname	Address 1	Address 2	Address 3	Postcode
John	Smith	5 High Street	London		NW6 4ED
Jon	Smith	5 High St		Hampstead
John	Smith	5	High Street	London	NW6 4EE
Mary	Lloyd	Rose Cottage	Derby Road	Colwyn Bay	LL28 5RH

can be cleansed by this service to:

Forename	Surname	Address 1	Address 2	Address 3	Postcode	ID	Duplicate	Duplicate IDs	Keep Record
John	Smith	5 High Street	London		NW6 4ED	1	Dup	2;3	1
Jon	Smith	5 High St		Hampstead		2	Dup	1;3	0
John	Smith	5	High Street	London	NW6 4EE	3	Dup	1;2	0
Mary	Lloyd	Rose Cottage	Derby Road	Colwyn Bay	LL28 5RH	4			1

Each record is assigned a unique ID to identify it. The Duplicate column indicates that the record is a duplicate of other records, and the Duplicate IDs column lists the IDs of those duplicates. Finally, the Keep Record column indicates if the record should be kept after deduplication (1) or discarded (0). The first record in a set of duplicates is kept, while the others are discarded.