Whether you want to perform an initial import of contacts from another platform or update your customer data, you can use Connectif's contact import tool.
In this article you’ll learn how to import contacts and their properties.
When to use it: To import contacts when setting up your account or to update customer data.
Before you start: what to consider
Before importing contacts, you must have:
- Previously created the fields in Connectif. If you import a CSV with fields that do not exist in Connectif, they will not be imported.
- A CSV file with the contacts you want to import, where:
- There is only one Email field.
- The Date and Telephone fields are in their corresponding format:
- Date: its format is ISO 8601 yyyy-mm-dd (year-month-day).
Telephone: can be with or without international prefix and must be without spaces in both cases. If no prefix is added, the configured international prefix will be used. Two examples are:
- With prefix: +34651234567
- Without prefix: 651234567.
- Integer-type fields start with a number between 1 and 9. It is not possible to include fields whose first number is 0.
- No fields including numbers (telephone, date, integer, decimal and radius) are empty.
For example, if we are importing contacts with a phone number, there cannot be contacts in the same file with information in the Telephone field and others that have it empty. If a contact has a phone number, all other contacts must have a phone number assigned to them for the import of that field to occur.
- The CSV fields must contain a value that matches the ID of the corresponding value in Connectif.
For example, if we are importing the newsletter subscription status, the information in the CSV must match one of the values in the Newsletter subscription status field in Connectif, i.e. "subscribed", "unsubscribed" or "none".
- Checkbox fields can have multiple options for a contact. In such cases, the "|" character must be used to delimit the text.
STEP 1: Preparing the CSV file for import
1. Open a blank file in a spreadsheet such as Excel or Google Sheets.
2. In the first column, create a label for the email field.
3. Add as many columns and their corresponding labels as fields you want to import into Connectif.
4. Complete the information for each contact in the appropriate column.
5. Save the file in comma-separated CSV format.
STEP 2: Importing the file into Connectif
6. Go to “Contacts > See all” and click Import.
7. Under Select a data source check Import from file.
8. Select the CSV file to be imported and load it into Connectif.
9. (Optional). Indicate whether the CSV file has a header with the column names, as well as the cell delimiter (comma) and the column delimiter (semicolon).
10. Check the appropriate checkboxes:
Overwrite existing: to overwrite with the data from the file if a contact exists in Connectif with any of the imported email addresses, and other fields of the contact are also being imported.
Update only empty fields: in the case of overwriting, to update any empty fields.
Add to segment: to add the imported contacts to a previously created static segment.
11. Click Next .
STEP 3: Selecting the fields to be imported
12. In the menu of data available for import (left-hand column) select the data to be imported from the CSV and drag it to the central block so that it matches the corresponding Connectif field.
13. Once you have associated the data with the fields, click Next to start the import process.
STEP 4: Import and Summary
14. In the summary screen, click Go to import list to check the status of the import, the contacts that have been successfully imported, and those that have had a problem (along with the reason for the problem).
To make the most of your Connectif account, we recommend reading these articles next:
- Contact sheets and digital footprint, to visualize all the information collected by Connectif about your ecommerce site’s registered and anonymous contacts.
- Exporting contacts and activities, to transfer information about contacts and their activity to a CSV file for use outside Connectif.
- Access a dynamic segment when identifying an anonymous contact, for an in-depth look at how dynamic segments work.
- Delete contacts, to delete a contact's information and activity, individually or in bulk.