Bulk clean-up and deduplication of an exhaustive list of contacts in a custom CRM
The company, an energy provider with a large customer database, was looking for a solution to clean up and deduplicate records for better account management, consistent communications with clients, and to provide accurate contextual information to customer support, sales and marketing teams.
Duplicate account data was problematic because:
The CRM contained different types of duplicate records and duplicate groups relating to customer personal details and preferences.
There were both exact match duplicates as well as partial matches (partial data overlap between records), and no indication for a standard or pattern for master records at the beginning, therefore particular attention was needed to identify this.
At the client’s request, PROCESIO team debriefed the company’s account manager to provide an overview of the scope of the solution and expected results.
Following this, the account manager proceeded with implementation: a process that automatically identified the different types of duplicates, determined master records, and provided a clean list at the end. The process included the following steps:
Ready to deduplicate your own data? Follow the step-by-step guides outlined in the following links and you’ll be able to build a custom process fit for your scenario: