Import contacts
A file import is the fastest way to bring an existing audience into Contlo, for example subscribers from another tool or customers from an offline channel. You upload a CSV, match its columns to contact fields, and Contlo creates new contacts and updates the ones it already knows.
Les guides sont en anglais.
Before you start
- Only import people who agreed to hear from you. The import can mark contacts as subscribed, so it is your statement of their consent.
- Leave out anyone who has unsubscribed or asked not to be contacted.
- Create any custom properties you want to fill before you import. Only properties that already exist in your account are offered as columns. See Custom properties and tags.
- Decide whether the contacts should go into a list. A list makes it easy to send to exactly the people in this file later. See Lists.
- Your role needs access to Audience.
Prepare your file
Save your data as a CSV file with one contact per row and a header row at the top. Give every row an email address or a phone number, because that is how Contlo identifies a contact.
| Column | Format | Notes |
|---|---|---|
| A valid email address | Used to find an existing contact or create a new one. | |
| Phone Number | Digits, ideally with the country code, such as +14155550123 | Checked against your account's country. Dashes and brackets are removed. A 10-digit number without a country code gets your account country's dialing code. |
| Email Registration Status | true / false | Email subscription status. See Consent columns. |
| First Name | Text | Optional. |
| Last Name | Text | Optional. |
| Date Of Birth | MM/DD/YYYY | Optional. |
| SMS Registration Status | true / false | Offered only on accounts where SMS opt-in by import is enabled. |
| Whatsapp Registration Status | true / false | Offered only when WhatsApp is connected and enabled. |
| Your custom properties | Matches the property's type: text, number, true/false, or a date as MM/DD/YYYY | One column per custom property in your account. |
Consent columns
The registration status columns tell Contlo whether each contact is subscribed on that channel. These values count as subscribed: true, yes, y, 1, on, enabled. Any other value means not subscribed.
| Channel | Value says subscribed | Any other value | Cell left empty |
|---|---|---|---|
| Subscribed to email | Added as Not Verified | Subscribed to email | |
| SMS | Subscribed to SMS | Added as Not Verified | Added as Not Verified |
| Opted in to WhatsApp | Not opted in | WhatsApp status is left as it is |
- An import never downgrades an existing subscriber. If a contact is already subscribed to email or SMS, a
falsein your file does not unsubscribe them. To unsubscribe people, use the bulk actions in Contacts. - A status is only applied when the row has the field that channel needs: an email address for email, a phone number for SMS and WhatsApp.
Run an import
- Open Audience → All Contacts and click Add Contacts.
- Next to File Import, click Import. The importer opens over the page.
- Upload your CSV file.
- Match each column in your file to a Contlo field. Skip columns you do not need.
- Review the rows the importer flags, such as an invalid email, a phone number that does not fit your country or a date in the wrong format. Correct them or leave them out.
- Submit the import. The dialog closes and Contlo starts adding the contacts in the background.
Import into a list
An import started from All Contacts adds people to your audience without putting them in a list. To put everyone in the file into a list, start the import from the list instead:
- A new list: go to Audience → Lists, click Create List, name it and click Create. The list opens with the Add Contacts to List dialog ready. Click Import.
- An existing list: on the Lists tab, open the list's menu and choose Import Contacts, or open the list and click Add Contacts → Import.
Contacts in the file that already exist in your audience are added to the list too, so you can use an import to group existing contacts.
How duplicates are matched and merged
Contlo does not create a second contact for someone it already has. For each row it looks for an existing contact with the same email address, and if there is none, one with the same phone number. Accounts set up to identify contacts by phone check the phone number first.
| Situation | Result |
|---|---|
| No contact has that email or phone | A new contact is created. |
| A contact with that email or phone exists | That contact is updated. No duplicate is created. |
| The match was by email and the row has a phone number (or the other way round) | The missing or different value from your file is saved on the existing contact. |
| The row has a first or last name | The contact's name is updated. |
| A custom property cell has a value | That property is updated on the contact. |
| A cell is empty | The existing value is kept. An empty cell never erases data. |
| The contact is already subscribed | They stay subscribed, whatever the status column says. |
Track an import
Imports run in the background, so you can keep working. Large files take longer.
- Into a list: on the Lists tab the Members column shows In Progress until the import finishes. Inside the list you see We're adding your uploaded contacts. The member count will be updated shortly. The page refreshes by itself, and the Add Contacts button and list menu come back when the import is done.
- Into All Contacts: new contacts appear in the All Contacts tab as they are added. Search for a few addresses from your file to confirm.
- List uploads are recorded in Activity logs with the team member who ran them.
Common import problems
| Problem | Likely cause and fix |
|---|---|
| Rows are flagged for the phone number | The number does not fit your account's country. Add the country code with a leading +, and remove extensions or extra text. |
| Rows are flagged for a date | Dates must be MM/DD/YYYY, for example 03/27/1990. Reformat the column in your spreadsheet before exporting to CSV. |
| A custom property is not offered as a column | The property does not exist yet. Create it first in Custom properties and tags, then start the import again. |
| A custom property stayed empty after the import | The column was not matched to the property, or the cells were empty. Match the column to the property with the same name and import again. It is safe to import the same file twice. |
| Contacts were imported as email subscribers by mistake | The email status cell was empty. See Consent columns. Select the contacts and use Actions → Unsubscribe from Email. |
| Contacts are not subscribed to SMS after the import | The SMS Registration Status column is only available on accounts where SMS opt-in by import is enabled. Ask your account manager or write to hello@contlo.com. |
| The list still shows In Progress | The import is still running. Leave it and check back. The member count updates when it finishes. |
| Fewer new contacts than rows in the file | Rows that match an existing contact update that contact instead of adding a new one, and rows you left out during review are not imported. |
Guides associés
- ContactsFind, add, edit, subscribe, export and delete the people in your Contlo audience, and read a contact's profile.
- ListsCreate static lists of contacts, fill them from imports and forms, and use them to target campaigns and segments.
- SegmentsGroup contacts by who they are and what they did, using properties, events, orders and lists, then send to them.
- Custom properties and tagsAdd your own contact properties to store details Contlo doesn't track by default, and manage the tags you use to organize campaigns.