Constant Contact duplicate contacts and duplicate emails, removed before you import

Constant Contact defines a contact by its email address, not by its name. Its knowledge base says there can be only one contact record for each unique email address, and that when a contact is added again with a different name but the same address, the existing record is updated with the new information. If a person sits on three of your lists, they are one contact with three list memberships, and a mailing sent to all three lists reaches them once.

That rule solves the exact duplicate and nothing else. A customer who signed up at work and later at home is two contacts. A trade show scan that captured a name, a company and a phone number but no email creates a record that can never match the one with the address. And because an import matches on email and replaces field contents with whatever the file holds, a messy file does not create a duplicate, it rewrites a good record with worse data.

There is no merge button either. Constant Contact documents two ways to combine records: copy the details from one record into the other by hand, or export the contacts, consolidate the rows in a spreadsheet and import the result. The second route is the one that scales, and it is the one this page is built for.

Yes, for exact addresses. Constant Contact will not hold two records with the same email, so an import that repeats an address updates the existing contact instead of adding a second one, and a contact on several lists receives one copy of a mailing. It does not detect the same person under two different addresses, and it does not flag contacts that have no email.

It also cannot tell which of two rows in one import file is the right one. If your file holds Dan Reyes at Summit Veterinary and Daniel Reyes at Summit Veterinary Clinic with the same address, both rows point at one contact, and the field values that end up on that record depend on the file, not on your judgment. Deciding that before the import is the part a person has to do.

Constant Contact bills active contacts: contacts with an email address who have given you permission to email them, including contacts who bounced but are still in the account. Unsubscribed contacts and contacts with no email address are inactive and are not billed. So the duplicates that cost money are the second addresses, the same person twice with permission on both.

The timing matters more than the count. Constant Contact states that your contact tier is based on the highest number of active contacts you have had in the account, and that removing contacts afterwards does not lower that tier. A webinar list imported with 400 duplicates on the last day of a tier can move the account into the next one, and cleaning up the week after does not bring the bill back. Deduplicating the file before the import is the only point where the cleanup changes what you pay.

For a handful, use the Search field on the Contacts page, which searches names, email addresses and email domains. For more than a handful, export all contacts and look at them in one file, because duplicates that do not share an address only show up side by side, sorted by last name and company.

A segment built on List Membership, one list AND another list, tells you who sits on both lists, but that is overlap rather than duplication: those people are already one contact. The duplicates worth finding are the ones the Search field cannot connect, and those need a matching pass on the export.

Most Constant Contact duplicate contacts arrive with a list rather than a signup form. When the address in the file matches a contact already in the account, Constant Contact replaces the fields with what the file holds. That is helpful when the file is better, and quietly destructive when it holds a lowercase name, a state written as california or a ZIP code that lost its leading zero in Excel.

So the same pass that finds duplicates also repairs formats before the import: names in consistent case, emails trimmed and lowercased, states as two letter codes, ZIP codes back to five digits and dates in one format. Doing that on every incoming file is the routine side of data hygiene, and it is what keeps a cleanup from having to be repeated next year.

The buyer is usually a marketing coordinator or an operations lead at a small or midsize US business, a nonprofit or an association, who owns the Constant Contact account and the monthly bill. They are about to import an event list, merge a second account or move a CRM export into email, and they need the contact count to be defensible afterwards.

If your contacts come out of a CRM, the same problem usually exists upstream too. Cleaning the CRM once, as described in CRM data cleansing, means every future sync into Constant Contact starts from one record per person instead of carrying the CRM duplicates into your email bill.

A pass on the export fits a project: an import to run, a second account to fold in, a contact bill to explain. A person reviews every merge and applies the result, and that is deliberate, because the decision about which of two addresses to keep belongs to someone who knows the contact.

If you need duplicates merged inside a CRM continuously, on a schedule and without an export, buy a product that connects to that system, and we compare those honestly on the Insycle alternative page. DataUntangler does not connect to your Constant Contact account and does not claim to. It is a data cleaning tool that gives you the matched file and a record of each decision, on the Analyst plan at 59 dollars a month with unlimited files. Ecommerce brands that send from Klaviyo meet a sharper version of the same bill, covered on Klaviyo duplicate profiles.