We Did: Customer Data Migration and Deduplication

Challenge

This customer offers a range of beauty and self-care products and services. The customer is using a 3rd party system to track the information of walk-in clients across the country. All of the clientele information is stored in a single system. This system requires human input which unfortunately leads to a lot of data duplication. In order to support their upcoming telemarketing campaign, the customer is looking for a better system to store and clean up their data.

Solution

The customer is planning on using Salesforce for their campaign marketing purposes. We have implemented the following:

• A custom object to store client information exported from 3rd party systems temporarily
• Created a duplicate and matching rule (8 combinations) against the custom object for deduplication purposes
• A simple integration process to consolidate duplicate records found as a unique contact

Additional Info