Setting Up Workflow - Contact Deduplication

Tyler Nguyen Updated by Tyler Nguyen

Overview

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

merge_key

Used for testing to validate the matching is working.

loser_id

The Contact ID to be merged into a winning record.

winner_id

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

Contact