Your database may contain duplicates, for example when two contact records were created manually with the same email address. To centralize activity history and maintain a clean database, you can merge these records directly from the interface.
How can I tell if I have duplicate contacts? π΅οΈββοΈ
To easily identify duplicates in your database, you need to create a specific report by choosing Contacts as the data source. Here's how to configure this report from the Data tab:
- Columns: add the Email, Contact ID, Last Name, and First Name fields.
- Group by: select the Email field to group contacts sharing the same address.
- Calculated columns: add a COUNT function to the Contact Email column.
Once you have created and saved your report, extend the time range (the date range) to encompass your entire database. Then review the generated report and click the COUNT Email column header to sort the results. All rows displaying a number greater than 1 (for example, 2) indicate your duplicate contacts.
Β
How do I merge duplicate contacts? π
Your database may contain duplicates, for example if you created two contact records manually with the same email address. To centralize the history and maintain a clean database, you can merge these records. Here are the steps to follow:
- Go to one of the two contact records.
- In the top right, click the arrow next to the Edit button, then select Merge.
- In the window that opens, start typing the beginning of the email address of the contact you want to merge in the search field to filter the results.
- Then click the second field (showing Choose one...) to select the corresponding contact.
- Finally, click the Merge button in the bottom left to confirm.
Β
Data retention rules βοΈ
When you merge two contacts, priority rules are automatically applied to determine which information to retain:
- Primary contact: the remaining contact will always be the more recent of the two.
- Fields with multiple values: if the two contacts have different values in the same field, the value retained will be that of the more recent contact.
- Empty fields: if the more recent contact does not have a value in a field but the older contact does, that data will update the field in the final record.
Good to know: automatic deduplication π‘
As a reminder, there is no need to perform manual merges during your bulk processing. Contacts are automatically merged during imports or synchronizations when the unique identifier is the same (by default, this is the email address for email contacts and the name for companies).
Comments
0 comments
Please sign in to leave a comment.