انتقل إلى المحتوى
Contlo by QuestionPro
تصفح المستندات

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.

Audience → All Contacts → Add Contacts → File ImportCSV uploadMaps to custom propertiesMerges duplicates

الأدلة متوفرة باللغة الإنجليزية.

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.

ColumnFormatNotes
EmailA valid email addressUsed to find an existing contact or create a new one.
Phone NumberDigits, ideally with the country code, such as +14155550123Checked 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 Statustrue / falseEmail subscription status. See Consent columns.
First NameTextOptional.
Last NameTextOptional.
Date Of BirthMM/DD/YYYYOptional.
SMS Registration Statustrue / falseOffered only on accounts where SMS opt-in by import is enabled.
Whatsapp Registration Statustrue / falseOffered only when WhatsApp is connected and enabled.
Your custom propertiesMatches the property's type: text, number, true/false, or a date as MM/DD/YYYYOne column per custom property in your account.

Run an import

  1. Open Audience → All Contacts and click Add Contacts.
  2. Next to File Import, click Import. The importer opens over the page.
  3. Upload your CSV file.
  4. Match each column in your file to a Contlo field. Skip columns you do not need.
  5. 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.
  6. 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.

SituationResult
No contact has that email or phoneA new contact is created.
A contact with that email or phone existsThat 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 nameThe contact's name is updated.
A custom property cell has a valueThat property is updated on the contact.
A cell is emptyThe existing value is kept. An empty cell never erases data.
The contact is already subscribedThey 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

ProblemLikely cause and fix
Rows are flagged for the phone numberThe 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 dateDates 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 columnThe 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 importThe 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 mistakeThe 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 importThe 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 ProgressThe import is still running. Leave it and check back. The member count updates when it finishes.
Fewer new contacts than rows in the fileRows that match an existing contact update that contact instead of adding a new one, and rows you left out during review are not imported.

أدلة ذات صلة

لم تجد ما تبحث عنه؟ راسلنا