Uspacy Knowledge Base
All materialsCRM and salesWork in CRM

Work with duplicates in CRM

Work with duplicates in CRM

In this article, we will tell you how to manually merge CRM elements in your database, and avoid duplicates in such a way

One of the keys to effective work in CRM is a properly organized client and sales database. But duplicates can significantly influence it.

If there are a lot of contacts, companies, leads or deals, then the data in them can definitely be duplicated. This happens for many reasons. For example, managers entered the data of the same client into the database, because this client contacted the company using different accounts in the social network.

Therefore, it is important to know how to work with possible duplicates and unload your CRM database.

How to merge duplicate CRM elements?

🌟The possibility to merge CRM elements is available only on commercial plans. You can read more about the plans on this page.

First, go to the page of the entity you plan to work with.

AD_4nXes_NREuaIewBobvU9dbTyH8msoyW7J54nYmc9gn8RVtPx1HPmR7h1jOuaoo0LbKwp5k6cQxzk0e3q6HDs4LUp_Wkl42MBuuNGVoTjo3e17u7P79BhqKcgii2fqi1C1F9Hu3lxJj94Dl43ug3xawFfe5_Y

Next, mark the duplicates.

AD_4nXdrnzGd1oL5yCTw2RxXwS_uxbwgiqEsMrdrVCmFurzJKWvnd6KTW5TgX_k4nRRNqnzNXwZqAw_yK_rvGyu9kj3AkEmxI727Ak3bwTrKM6i9iHZDj8ejrwl5WGtWO-4nQ8ang-AuM1YM3AXU3D3NR4CEQOnU

And click on the Merge button.

🌟Please note that this possibility depends on the user's access to edit or delete entity elements:

🟣 if there is a complete ban on these actions, then it will not be possible to merge;

🟣 if the user can both edit or delete, then merging will be available.

🟣 if access to the above actions is given only to "own" elements, then only they can participate in the merging. If you mark elements of other persons responsible, then there will be a restriction on them.

Administrators and the Space owner can merge elements with no restrictions.

AD_4nXcTM2-5TxVeOyw2m33N89-mUmynUs0tN31GeVlo7C5Oo9c8uKwqZId-WfIKiZ4n4C9v8tfQRWD2rDZk_H_eMmv_wwwwkEpQd-PM7b3lB9qXqEEeCG1d3VHhLa2uo2Vsg4lgJuW6gn6sA4B2jy0u2Dm7u8o9

💡Please note that only 10 elements can be merged at the same time.

AD_4nXcoSaUtoHcyUKLcfWJJskLRAEqUPxv1NeOef8lVpeJxN5COjN-2CYrlHjlwuXZXkCJA_qGD5Gt8TMPvbgEZtgchcXoooJuWG1uCiRhneuQtTSYUPIS7GEuuNEV7p2lbzgfJLCCU2mROBz-ZUCDRo8-PtU7w

A window will open where you need to:

🟣 Select an element that will become the main one. This means that it will remain in the database as a result of merging. It will have its ID and will be edited.

AD_4nXfMbEhlYeU_m7VN5VHLsP7IlIEmkABnOudTvxIWs8V2f8NpGjolHa7ovDDs72zzCUBMhG8LaTkghTOLdEocuMwfe0FLtmMAdIusrivKQcg_l9BwgGSNTSfoo4UxxWpiiBkcORv67qjooa0NTz173-i1nos

Such an element will become the initial Result of merging.

AD_4nXcg0SEqi0IBd-4H6IDIRV6dz62J9A0By822DYDVYTJ_HVwKG7pZdcFEGxzJGuwgz7XJpwcitHHlzmSF2zDFkpIzesUEUOGJYpipegOSIAcs0v-_SjpysMfsYV4UdiGjTl3bRcxLr8pkCtMfOzcGf9AO4ytj

💡In addition, the values ​​of the immutable fields will be taken from the main element. This is certain system information about its creation and update date, as well as UTM tags.

AD_4nXfXlWCdT7X_iXujvhPhFHLnMRFDJvnO4rzZxLvA1TaBwcPuhqqLEjgQVMZHqqTxqP4SMv0YR99Nl9wdfUIBfw-VlfSu33c6cfSAfThAn4tIrNXFV1JvZPxDh21QuielCRwQhihCnf_tgOl-Jq0Kw1dG8ae-

🟣 Select the desired values ​​for specific fields, except for immutable ones. That is, you can drag information from all existing duplicates into the element that will remain as a result.

For some fields that are not multiple (have a dot as a mark), the value is replaced completely.

AD_4nXeQ_GSIb8f_JvooWLvsIuFkF9NKl1OFKudi-Mbp4-ZzjIy_0-rUS4P5RQWglznM8N7FewYTXsDNdo7Fdxiua6mej8oogQMw4Y_w9nhYBBjfTr2Jxe9XG1ggljw2VuUnjWRGeVTz3s8F5RQT36z18YJP5o_5

For those that are multiple (have a tick), just new data is added. For example, standard fields such as Phone and Email can contain multiple values.

AD_4nXctjfcnovagNWsYnt6O25lpoHFhrTGWZ86EHXj-TMSU6DSCR8rlJsC4tnP0vmQdpB9Q9P0zsPw2-hu0SEEH9cNIC2RewISRzjZ_Fyo7YJONtJ6jmbP95gVm1DFlmgNIS4s0Bp1MwPMZXhYE1yROZW3GxSY3

💡For convenience, you can use a special button to activate the Only differences mode and show those fields that are different for all duplicates. And hide those that completely match the values.

For example, if there are some empty fields in all duplicates, they will not be shown in this mode. As well as those containing the same values ​​for all elements which take part in merging.

AD_4nXe7YB9Bd8uNVRkUsbj_QGXomQrwSjuD00_7CvEfdcWoN6K9togxriMOVNBCZrYOBAp1zRHI6gQULoGcbJZ4vIu8muWpMLb6EbGY2Wn80uDU_UDxr0suZlIhufNT7A4q7GOX-qWNpv-2nHfOccaBTMXu-XlP

When it is ready, just click Merge.

AD_4nXf4RIqQGwfmAFn5s5EY_dwp4luNOEFZurwJPbvnivGLGLcnI82zqEfvrA5ZptUBDsR7i3zv96FDtn5m7STX-IniDMUD3vo_Tx1JBBDN2iL4n9KT8w749Ld2jZ-UEy2hWMNoIFGthTBzXunzibj3rjGJC8Wp

The system will quickly process the data and there will be only one element left in the list as a result.

AD_4nXcomAaamaw5zzJfwbZdWJngdorckldPbwd5lsNzLOC7059YSW61m4AR6XJjj0UK1HAcow148v8bzb1JzIFxyCRwFRKhYPxGYzUGa9pZX6rCuG_AZCQJBcIPWB-r84cye5s6GQG4zLnc1t29lDWmve9wkRrv

Features of merging duplicates

🟣 After merging, all activity records, i.e. notes, events, activities, tasks, files, documents, chats, calls, etc. are transferred from duplicates to the card of the element left in the database.

🟣 After merging contacts or companies from duplicates, the deals attached to them are also transferred to the left element.

🟣 After merging, for elements of other entities that are related to the element left in the base, the binding will be updated. That is, if there was a binding to duplicates, now they will exist with the current element.

For example, smart object elements Project 1 and Project 2 have Tom and Jerry contacts

AD_4nXddRVBPDCOg1LQMNtw7hlqGtGxxBb_R40zIDbsKR1De1cCIsRH292z5LDbC3vVvVuPv_MbLNiGwNGyjBKLQa22T5amWz1FaOOo3mcZUK_9V_akGvlCiGR82AVZKHFP1sLPpQbGm4-l0g_guJ-wF2w4gaLzh

We decided to merge them.

AD_4nXdsGPv_PtvziJarcjEQz_xtScInkmOsqx5iU3DvH-hEVVMBU4YLA1TCaFCzpttMUASwC3itlwyEWEtdpsyabjNUv8O--_vRvVgjhyonZaHTuKsgpyf8e5UMMLq5Ni_wGqikM-P3RHkAMofC1QP3lEXB5fQ

We select Tom as the main contact.

AD_4nXd_KCqmP00JUgado0gIEIBl6A2o5yLHz0r3jm2ftPYC8pDkFp4qOXgnfHgKYrFVSsZ1zD-rpcZ3OHdSqWTPBwLg0x5rUvhHBGSgepfmzEGEdfIKQimjIxyz1ojhYXcI0K8dtiPOLVPJIKTRis6emGKzcgV1

The result of merging is the contact named Tom. It will still be bound to Project 1, but will now also be bound to Project 2. This binding is transferred from the duplicate Jerry that has already been removed from the system.

AD_4nXf93Yfv_gLDw5WN2nAXiXL5LYyvMEoOMB90xDf_6MfsuvX-BrT_kMRTRcc4G4YzYVFPXULFs3SnJpjnFtORFWwFycMZFDPmU9JTfqa_uwQ59y_5WzRXBBd37JDiC_uXmeuczPV03g0reAbRBJwDTghHQTFr

Duplicate search when adding elements

In addition to merging existing duplicates in the database, you can also control for duplicates when adding elements (leads, contacts, companies). The built-in search feature will assist you with this.

🌟 This option is only available on commercial plans. You can find more details about the features of all plans on the pricing page.

If the system finds an exact match by phone number, you will see a corresponding notification next to the field.

AD_4nXfL_eh27MrlO36vgU2Vh0e937xnmloQdX7bu3D52CDq7OcLzIXBADvr2u_i3zKWuurA1z42O6l5ArWVrU1bwrpPg0drG1S9ATOH5RhBZMI8YmR1QrDmm_0LDnuGoG7zul1hsweXiBTP4-PaJq97NKNXjFU

The same applies to email addresses.

AD_4nXd0hGEY7RWjsGsnuBvN8tRKeCmKi7vuSICxVYGHEUfwyzYp7xFaWxdomvv8d4n6KseymGLEQQaCmmVJASEabYNk1ZoAQo8nAyfYqHsIvJoBP90n6EINLEmelb4DGYGNpzKkgkTND_CGnDVvGCBXvHwkVMMD

Thus, at the stage of filling out the form, you will already know if there is an element or elements with that phone number or email in your database.

💡 Please note that the duplicate search during creation is conducted within the entity you are currently working with. For example, if you are adding a lead, the system will show leads with the same phone number or email.

However, if you decide to save the new element despite the existing contact data in the database, you will receive an additional warning about a potential duplicate.

AD_4nXfjDOAUqnK3Os3_xbQveWgjby2D-YkpEVnPMWv7uNOECHG9dxFhTm0-9G-r65FPagd8_ns0pi6tdfCVaU5JD9B_erol9HlZ29uzKQd6kknrdKGT0M19A3DgAnEHTlxQUoxoEh-YcT-g1wXPg53WIUUY4EeK

After clicking the Create a duplicate button, another element will appear in your database that will replicate the contact details of other contacts (companies or leads).

Monosnap+Uspacy+—+єдиний+робочий+простір+для+організації+щоденних+процесів+компанії+2024-10-03+15-13-07.pngAD_4nXeXlTfEbpv-GyeFQ1LbWe-VoV11akcvFlmBJliwRw9nox1DwB7MB8FpgkMBYmIRK2Z-lsO8KwvJjZFptmPIW9rbSA7QgXzQx5zBb7Fv2AIwjrbx2ymLMnZOwo-g7QPORzh3XELW6XZrt9Eh6xuBD8G-V1tG

If you have additional questions or you need to contact the support, send a request to this email [email protected]

Created: May 20, 2024 / Updated: October 8, 2024