In just a few quick clicks you can import from a CSV or Act-On Marketing List into your Audience Center All contacts database.

Import

1. 1. Navigate to Audience Center > All Contacts.
   2. Expand the menu at the top right of the page.
   3. Click Import Contacts:

Import A CSV File

You can import a CSV file in two different ways:

• By clicking on select your CSV file or,
• Drag & drop a CSV file onto the screen, and click Next.

Once the file is imported, proceed to Import Options.

Import a Marketing List

Import your existing Marketing Lists into All Contacts to add contacts and segments.

1. From the import screen, select Import an existing list.
2. Choose the Marketing List you wish to import, then click Map Fields.

Import Options

The Import Options screen allows you to configure settings for your import.

If you want to track the contacts that were added with this import, you can create a direct-select segment during the import process. To create a segment, check the Add records to a segment box and give the segment a name (or select an existing segment). If you wish the segment to update as contact profiles or behaviors change, you should create a query-based segment in All Contacts instead.

Advanced Options

The Advanced Options let you specify how your .csv file is imported. This section is only available when importing a .csv file (not a Marketing List). These options include:

• Line 1 contains: Field names or field values.
• Fields are separated by: Commas, tabs, or semi-colons.
• Field values are: Single-quoted / double-quoted.
• Default Merge rule: Fill if blank or overwrite. This will determine if imported data that matches an existing contact will overwrite the existing data. You can change this on a per-field basis on the next screen.
• Match existing contacts on: Email is the default and will be used to prevent duplicates.
• Contact Preference: Use this to set imported contacts as bounced, opted out, etc.

Review Act-On's Import Policy at the bottom of the page to ensure your file meets our Acceptable Use Policy.

Field Mapping

Next, map the fields from your file or list to your All Contacts database fields:

For each field in your import:

1. Select the matching field from Act-On Contacts, or check the box to Create a new field to add a new field to your All Contacts database schema.
   • If you are adding a new field, you must also choose a corresponding data type. Accepted formats include Text, Date, Email, Score, Number, Boolean, and Date Time.
   • If you have questions about your data format, hover near the column name and view the Data Preview section on the right to see sample data.
2. Choose a Merge Rule: Fill if Blank, or Overwrite.
3. If a field is mapped to the wrong Contacts field, use the "x" to unmap it, and pick a different field. Fields present in your file/list that you do not wish to import to All Contacts can be left unmapped.
   Data Validation
   When importing data, Act-On will validate data types for your records. Use the Data Preview feature to view the results. A warning may appear if greater than 10% of your records don't match the data type.

4. Click Next to proceed. 

Import Summary

The import summary will show you how many fields are mapped and unmapped.

When you are ready to proceed, click Import Contacts.

You will receive an email when the import is complete. If there are any problems, the message includes a file with any failed or rejected records and the reason.

View your Import History

The Import Log (available from the top of the screen) will show you a history of imports. You can also download a report that includes errors (if any).