How does deduplication work for Trujay?

The majority of CRMs have certain deduplication rules for importing data by API. Trujay follows these rules during the migration process by identifying existing records in your CRM and assigning duplicate related data to them.

Here is a list of the most popular CRMs and their respective deduplication rules for importing records by API:

  • HubSpot 
    • Contacts (by “Email” field)
    • Campaigns (by “Name” field)
    • Attachments (by “Name” field)
    • Custom fields (by field name)
  • Salesforce 
    • Custom field (by field name) 
    • Tag (by “Name” field)

Accounts, Contacts, Leads, and other objects can have custom validation rules set up. 

For the standard Salesforce validation rules, click here.

Salesforce can also validate the record which is migrated as a duplicate to records in other objects. 

As an example, say you migrate a “Lead” record. Salesforce can validate the record as a duplicate to the contact according to the validation rules setup. The migration tool then skips the “Lead” record and its related data (opportunities, activities, etc) during the migration process. 

To have duplicate records migrated, make sure you`ve disabled this validation rule.

  • Vtiger 

Custom validations within this CRM can be set up using unique values in any of the following fields: 

    • Accounts
    • Contacts
    • Opportunities 
    • Activities 

If these custom validation rules are enabled in Vtiger, the migration tool considers all records with the same value in validated fields as duplicates and excludes them from the migration process. 

  • ZohoCRM 

Custom validation rules can be set up within this CRM, and you are able to define if a field is required to be unique or not for both native and custom fields. 

This feature is available for the following fields:

    • Companies
    • Contacts 
    • Opportunities
    • Activities

If custom validation is set up, and certain fields contain only unique values, the migration tool considers all records with the same value in validated fields as duplicates and excludes them from the migration process. Duplicate-related records are migrated to the existing records with unique field values in ZohoCRM.

  • BaseCRM
    • Tags (by “Name” field)
  • CapsuleCRM
    • Accounts (by “Name” field)
    • Сustom fields (by field name)
  • FreshSales 
    • Accounts (by “Name” field)
    • Contacts (by “Email” field)
  • Microsoft Dynamics 
    • Products (by “Code” field)
    • Emails (by “____MessageId” field)
  • Pipedrive
    • Users (by “Email” field)
  • ProsperWorks
    • Accounts (by “____email_domain” field)
    • Contacts (by “email” field)

How does deduplication work?

Consider the following situation: You perform a Salesforce to HubSpot CRM migration and there are several contact records in the source CRM (Salesforce) that have the same email addresses, with multiple opportunities and activities assigned to them. Trujay can successfully move all related items to the target CRM (HubSpot).

Specifically, one of the Salesforce contacts with the duplicate emails will be migrated into HubSpot CRM, and items related to all contacts with the duplicate email will be assigned to it.

Note: Trujay also offers three options on how duplicates can be handled during a custom migration:

  1. A replacement strategy is used in order to substitute existing data on the target CRM with information from the source CRM.
  2. A merging strategy where duplicate information is merged into one unique record based on specific fields criteria.
  3. You can flag certain objects fields which will then be checked by our data experts in order to identify duplicates and then proceed with options #1 and/or  #2, or just preserve the existing records and assign duplicate-related records to the fields.

To learn more about our duplicate handling options, contact our experts here.