Setting Up Workflow - Contact Deduplication

Tyler Nguyen Updated by Tyler Nguyen


Deduplication is the process of merging duplicate data to a single record. The CaliberMind platform connects with your CRM to extract data. As it is extracting the data, the CM platform will automatically check for duplicate records. If it finds duplicate records it will merge the records (If there is matching information) to reduce redundancies in your data.

Because CaliberMind merges the records, you aren’t left with orphaned tasks or opportunities. Having a deduplicated database is a critical step in accurate reporting and efficient processes.

Contact 1 (loser)

Contact 2 (winner)

Final Merged Contact

First Name: David

Last Name: Johnson

Title: <missing>

First Name: David

Last Name: Johnson

Title: Marketing Manager

First Name: David

Last Name: Johnson

Title: Marketing Manager

Setting up Contact Deduplication workflow:

  1. Create a Custom list in CaliberMind, for example: “FLOW - Contact Deduplication” 
  2. Copy and paste the below SQL found in THIS LINK into the list and save.
Setting Up CaliberMind Contact Deduplication Workflow
  1. Hit "Test" and confirm if the data is shown correctly


Used for testing to validate the matching is working.


The Contact ID to be merged into a winning record.


The Contact ID to receive partial data from a losing record.

  1. Create a new flow:
    1. Select “Merge records in Salesforce”
    Select CaliberMind Merge Records in Salesforce
    1. Select the list you created in step 2
    2. Select the "Contact" object
    3. Set a schedule and/or limit (optional)
      Set a CaliberMind  Schedule and/or Limit
  2. Launch flow!
  3. Check the log file after the workflow has been completed to see if there were any errors from Salesforce.

How did we do?

Creating Sales Campaigns from Salesloft and Outreach Activities