Merge Duplicates allows you to search for duplicates in your Contacts collection and combine them into a single Contact record. You choose which Contact fields to keep from each of the duplicates, as well as the Tags and Sequences to which the merged Contact will be subscribed. In order to make the process manageable certain decisions are made for you:
If both are on the same Sequence the merged Contact will be subscribed to the Sequence on the latest step (no step is repeated)
Open Orders (including subscriptions and payment plans) are merged
- Sales, payment and transaction history can be merged
The credit card with the last successful transaction will be merged
Partner Programs: The oldest Contact record is retained. If both Contacts are in a Partner Program only the Promo Tools from the oldest Contact record will continue to work
- WordPress Memberships: All memberships are copied to the merged Contact. If each duplicate Contact has a membership both memberships will appear in the merged Contact record. We do not merge memberships using different usernames into one membership
- After the merge operation, the information you have selected is merged into the oldest contact record and the newer, duplicate record is deleted
In the Contacts collection click Settings and Merge Duplicates
Select the Fields to match for the duplicate Contact records and click Next
To be considered a duplicate, each field you select here must be an exact match
Selecting a single field such as the Email field will find the most duplicates
Tips for Finding Duplicates
The more Contact Fields you add to the Match by Following Fields selection the fewer duplicate records will be returned. Consider the Contact records for the following duplicate contacts (a husband and wife sharing the same last name and email address):
|Email Address||Last Name||First Name|
Match on Email: Contacts are shown as duplicates
Match on Email and Last Name: Contacts are shown as duplicates
Match on Email and First Name: Contacts do not show up as duplicates (First Name is different)
Match on Email, Last Name and First Name: Contacts do not show up as duplicates (First Name is different)
Follow steps 1 through 3 above to find the duplicates you want to merge. When satisfied with the criteria, click Next. A recap of the duplicate contacts is shown. To reset the criteria, click Back.
To download a CSV of the duplicate Contacts select them, click the Actions menu, then Export Contacts. To delete any of these Contacts permanently, select them and click Delete in the Actions menu.
To continue to the Merge screen click Next
The first duplicate Contacts are shown. One is in the left column, and one in the right column. In the center is the information you want to keep in the merged Contact record.
Click the Skip button to keep these two Contacts in the database without modifying them, and go to the next duplicate pair.
Click an individual value in either the left or right column to add that value to the merged Contact (the center column).
Click Replace All to move all the data from that section into the merged Contact record, overwriting any blank or populated data in the fields
Click Combine All to fill blank fields with the data from that section but not overwrite any data already added from the other Contact record
Add new values into the new Contact using drop downs or typing the information.
When satisfied with the information shown in the center column click Merge and continue to merge the information and present the next set of duplicates.
ONTRAPORT merges the information into the oldest Contact record and deletes the newer Contact record.
Repeat the process for each set of duplicate Contacts. For the final set of duplicate Contacts click the Finish button.
- The Automation Log in the Contact Record will include the details of the merge operation.
Q. I have a specific question about this process that is not covered in the article. Where can I get a quick answer?
A. Check at the ONTRAPORT Community Q&A Forum. During Support hours, you can chat our Support team for assistance (see the link in the help menu inside the app).
Q. Why can't you just automatically merge all duplicates?
A. We know your customer data is extremely valuable to you and want you to have the most control over the process as possible. We’re huge fans of automation but some things require human judgement.
Q. Why are duplicates allowed anyway?
A. There are many situations where a duplicate might be wanted, such as a husband and wife or a small business team sharing the same email account. We allow duplicates entered manually, added programmatically via the API, or imported with the Create New Entry option for those cases.
Articles in this section
- Contact Management Overview
- Importing Contacts
- Best Practices for Preparing a CSV File for Import
- Contact Management Segmentation (Groups)
- Contact Tags
- Add Custom Fields & Sections
- Formatting Merge Fields
- Merge Duplicate Contacts
- Managing Contact Transactions
- Managing Contact Credit Cards