ActiveCampaign
Salesforce Leads11 fieldsHow to import ActiveCampaign data into Salesforce Leads
Import your ActiveCampaign contacts into Salesforce. This template maps name, email, phone, org, title, and full address to Salesforce lead fields. Two things to know before you start: Salesforce requires LastName and Company on every lead, and ActiveCampaign exports often have blanks in both columns. The Before you start section below explains how to handle both.
Field-by-field mapping
This is the complete column mapping from ActiveCampaign to Salesforce Leads. The left column is the header in your CSV export. The right column is the Salesforce Leads field it should map to.
Before you start
This template's destination has 2 required fields that need attention before upload. You can still use this template. The steps below tell you what to add and where.
- Last NameLastName
Salesforce requires LastName on every lead. ActiveCampaign exports the column, but subscribers who signed up with only an email leave Last Name blank, and Salesforce rejects those rows.
What to do. Before upload, fill any blank Last Name cells with a placeholder like 'Unknown' so every row passes Salesforce's import validation.
- Company
Salesforce requires Company on every lead. Email-marketing subscribers often have no organization set, leaving Organization blank.
What to do. Before upload, fill blank Organization cells with a placeholder like 'Unknown'. Or set a default Company in Salesforce after import using bulk-edit on the new leads.
| ActiveCampaign column | Salesforce Leads field | |
|---|---|---|
| First Name | First NameFirstName | |
| Last Name | Last Name*LastName | |
| Email TransformLowercased and trimmed | ||
| Phone | Phone TransformStandardized to international format (+1, +44, etc.) | |
| Organization | Company* | |
| Job Title | Title | |
| Mailing Address 1 | Street | |
| Mailing City | City | |
| Mailing State | State/ProvinceState | |
| Mailing Zip | Zip/Postal CodePostalCode | |
| Mailing Country | Country |
Required by Salesforce Leads.
Columns we don't use
Your ActiveCampaign export includes 3 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Salesforce Leads.
- Tags
ActiveCampaign tags export as a comma-separated string. Salesforce Leads use list views and custom picklists rather than free-form tags.
If you need it. After import, build Salesforce list views filtered by source, or add Tags to a custom multi-select picklist field on the Lead.
- Status
ActiveCampaign's Status column records subscription state (Active, Unsubscribed, Bounced). Salesforce uses the HasOptedOutOfEmail field, which is set per-lead and not directly mappable from a status string.
If you need it. Filter out unsubscribed and bounced rows before upload. For the rest, set HasOptedOutOfEmail in Salesforce after import based on subscription preference.
- Date Unsubscribed
ActiveCampaign records the date a contact unsubscribed in this column. Salesforce Leads don't have an unsubscribe-date field by default.
If you need it. Filter out rows with a Date Unsubscribed value before upload to avoid importing unsubscribed leads. If you need the date preserved, create a custom date field on the Lead called Unsubscribed Date and map this column to it.
Formatting and cleanup
ActiveCampaign exports rarely match the format Salesforce Leads expects. Fix these before you import.
- 1.Lowercases and trims email addresses
- 2.Standardizes phone numbers to international format (+1, +44, etc.)
- 3.Maps ActiveCampaign's Organization to Salesforce's Company field
- 4.Converts Mailing Address 1 to Salesforce's Street field
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your ActiveCampaign export and download a clean, import-ready file for Salesforce Leads.
ActiveCampaign to Salesforce Leads FAQ
How do I export contacts from ActiveCampaign?
Go to Contacts, select your list or apply filters, click Export, and choose CSV format.
What if Organization is blank for some contacts?
Salesforce requires Company on every lead. See the Before you start section above for the workaround.
How do I avoid importing unsubscribed contacts?
Filter out rows where Status is Unsubscribed or Bounced, or where Date Unsubscribed has a value, before uploading. See 'Columns we don't use' below for the full handling pattern.
What happens to ActiveCampaign tags?
Tags don't map to a default Salesforce lead field. See 'Columns we don't use' below for two ways to handle them.
What about custom ActiveCampaign fields?
Custom fields appear in the CSV export but aren't included in this template's mapping. Add them manually in Operelio after uploading if you need them in Salesforce.
Will this create duplicate leads?
Salesforce checks for duplicates based on your org's matching rules. Review your duplicate settings before importing to control how matches are handled.
