How to remove duplicate customer records for outreach

A customer appears twice in your outreach list, so they could get the same email or call more than once. But rows that look similar are not always duplicates: two customers may share a name, or one customer may have different contact details in separate records.

Before removing anything, decide what counts as the same customer and which record should stay. You can review and clean a working copy with the CSV Editor, which can find, edit, sort, and remove duplicates in large CSV files.

Clean a customer CSV safely

1. Make a copy of the original CSV so you can restore it if the cleanup removes a record you need. Open the copy in the CSV Editor.
2. Check the column headings and look at a few rows. Identify fields such as customer ID, email address, phone number, name, last contact date, and opt-out status.
3. Choose a match key before removing anything. A customer ID is usually the clearest key. If there is no ID, an email address or a normalized phone number may work better than a name alone.
4. Sort or find likely matches, then inspect the editor's duplicate removal options. Check which fields it compares before using the removal feature. If it only removes identical rows, it will not necessarily catch two rows for the same person with different details.

After cleanup, check the affected records and the total row count. Keep the original file until you have confirmed that the cleaned list is ready for the campaign.

What the matching rows mean

Every field in two rows is identical

These are exact duplicate rows. Removing one is often safe, but check that the duplicate is not serving a separate purpose, such as showing that the customer joined two different campaign segments. Keep a copy of the original if you may need that history.

The email address matches, but other fields differ

The rows may refer to the same person, but one could contain a newer phone number, a different name, or a more recent contact date. Do not delete one automatically. Compare the fields and decide which details to keep. If the CSV has an opt-out or suppression field, preserve the opt-out so that a duplicate active record cannot put that person back on the outreach list.

The name matches, but contact details differ

A matching name is not enough to identify a duplicate. Customers can share a name, and one person may use different email addresses. Look for another reliable field, such as a customer ID or a verified phone number, before merging or removing either row.

The phone numbers look different but may belong to the same person

Formatting can make one number appear several ways, for example with spaces, parentheses, or a country code. Compare the actual digits and account for country codes and extensions. Do not strip digits blindly if that could make two different numbers look alike.

How to avoid removing the wrong customer

1. Keep an untouched copy. Save the original CSV separately before editing. This gives you a way to check a removed row or restore the starting list.
2. Use the strongest identifier available. Prefer a unique customer ID. If you use an email address, check the full address, not just the part before the at sign. Avoid using a name by itself as the duplicate rule.
3. Review contact details before combining records. Decide whether the newest record should supply the phone number or address, and check the last-updated date if one is available. A newer row is not automatically more accurate, so verify unusual changes.
4. Keep opt-outs and suppression records. If any version of a customer record says the person opted out, do not let a duplicate active row override that status. Confirm the final list against your campaign's suppression rules before sending.
5. Remove only duplicates that meet your rule. In the CSV Editor, use the duplicate removal feature only when its matching behavior fits your chosen key. If the feature compares whole rows, it is suitable for exact duplicates, not every repeat of the same person.
6. Check the cleaned list. Find the key values you reviewed and confirm that unwanted repeats are gone. Compare the row count with your starting copy and inspect a few records near the top, middle, and end of the file.

Choose a rule that fits the campaign

For a one-time email list, the goal may be one send per verified email address. For a phone campaign, the relevant key may be a normalized phone number. For account-based outreach, a customer ID may be the right choice even when several contacts belong to one company. The correct rule depends on who should receive a message, not only on whether two rows look alike.

Be careful with households and shared inboxes. Two people may use the same family email address but need separate records, while one person may have several addresses. If the campaign should contact each person once, deduplicating by email alone could remove a legitimate recipient. Review the purpose of the list before choosing a key.

Also check whether repeated rows represent separate permissions, campaign history, or segments. Removing a row can discard useful context even when the contact details match. If you need to retain that context, keep it in a separate field or record before cleaning the recipient list.

The CSV Editor works in your browser, and the file you open stays on your device.