Keywords: Address quality, Data quality, Addresses, Address database, CRM, Duplicates, Duplicate check, De-duplication, Consolidation, Selectivity, Software.
The address files (e.g. CSV, Excel, Access) or database tables (e.g. Microsoft SQL Server, Oracle) are checked and cleaned in 3 steps:
If address lists are prepared for mailing, then the processing results in most cases can be used immediately without further reviewing.
If the addresses should be cleansed from the address database of a CRM-, Marketing- or ERP-Systems (so called “Basic database cleansing”), then the task often fails: The results have to be loaded into the database and a solution has to be found for handling the duplicates. Since duplicates cannot regularly be marked as deleted or removed entirely, because more information is attached to them: offers, invoices, marketing information, and contact persons, which in turn may have individual data records.
The search for duplicates is a kernel technology for a larger number of applied tasks:
The product name for the module duplicate check is “DC” (“DublettenCheck”)
Duplicate check (for cleansing address files) is available in: