ActiveCampaign duplicate contacts and merge contacts before import

ActiveCampaign treats the email address as the unique identifier of a contact. Two rows with exactly the same address become one contact, on a form, an import or the API. Anything that is not an exact match is a new contact, so the same buyer under a work and a personal address, or a name typed differently at a trade show, is two contacts from the first day.

Phone only contacts added a second door. Once an admin switches the feature on, and ActiveCampaign notes that the switch is permanent, a phone number can identify a contact on its own. The help center is plain about the side effect: a phone number entered in a different format is not recognized, and a phone number that matches a contact who already has an email address creates a new phone only contact. Only exact matches count as the same contact.

Imports add their own share. When a CSV holds the same email or phone number twice, ActiveCampaign imports the first row and skips the others, so whichever row sits higher in the file wins, even when the lower one had the newer phone number or the correct company.

Yes. ActiveCampaign prices on unique contacts, so a person on ten lists is one contact, but the same person under two email addresses is two. On accounts created on or after November 3, 2025, every contact counts toward the limit regardless of list status, including unsubscribed and bounced ones. Accounts created on or before November 2, 2025 count only active contacts.

That change makes cleanup a billing task, not only a tidiness task. On a newer account a duplicate that unsubscribed years ago still takes a seat in your plan. Archiving is the lever ActiveCampaign gives you: archived contacts do not count toward the limit, are kept read only for up to a year, and can only be restored manually after 30 days.

For a few, search the Contacts page by last name and open each result. For more than a handful, export all contacts into one file and sort by last name and organization, because duplicates that share no email only show up side by side. Look hardest at rows with a phone number and no email next to rows with an email and no phone number. Those are the phone only duplicates the help center warns about.

Include the list you are about to import in the same file. Most new duplicates arrive with the next event list or webinar export, and catching them before the import costs nothing, while catching them afterwards means one manual merge per pair.

No. ActiveCampaign merges two contacts at a time, and each merge is permanent. A person with three records takes two merges, and there is no bulk merge on the Contacts page. That is why the order of work matters: settle which records belong together in a file first, then run the merges in the account from that list, rather than deciding case by case inside the merge window.

The merge also asks you to pick one side for all conflicting fields at once, and one side for all shared automations. If the destination has the better email but the source has the newer phone number, fix the field on the destination before you merge, or you lose one of them.

Because an import keeps the first row for each email or phone number and skips the rest, the order of your file decides what survives. Sort it so the most complete and most recent row comes first, or better, merge the duplicates in the file so there is only one row per person to import.

The same pass repairs formats that break segments: 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 list is the routine side of data hygiene. If part of your audience also lives in Mailchimp, the same file pass is on Mailchimp duplicate contacts.

The buyer is usually the marketing ops lead or the agency that runs ActiveCampaign for a US small business, who owns the invoice and is about to import an event list, switch on phone only contacts for SMS, or move a list over from another platform. They need the contact count to stay inside the plan and to be able to explain why it moved.

When the contacts come from a CRM, fixing the source once pays off on every sync. CRM data cleansing covers that file, and HubSpot deduplication covers the most common CRM that sits next to ActiveCampaign.

A pass on the export fits a project: an import to run, a plan limit to stay under, a list move with a deadline. A person reviews every merge and applies the result, and that is deliberate, because deciding whether two contacts are one buyer belongs to someone who knows the customers.

If you need contacts merged continuously inside the account without an export, look for an app that connects to ActiveCampaign directly. DataUntangler does not connect to your ActiveCampaign 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, or 348 dollars a year, with unlimited files.