When you import a file and add new Profiles to Audience make sure you have collected consent for all Profiles contained in the file.

Profiles take time to be created in your Audience and they may not be available right after an import. After a successful import, the file import requires at least (30) minutes before the Profiles can be used or accessed by any activities.

For the very first file import make sure you have a Subscription to place the Profiles. Read more about how to create a Subscription.

Use only simple text data. Remove any images, charts or decorative formatting (fonts, colors, etc.).

Review the format of the cells and make sure that there are no combined or split cells. It must look like a table, whenever formatted as columns.

Pay attention that the cells containing dates are set to have "text" as type.

Make sure that your file contains only one sheet, or that the data that you need is in the first sheet of your file.

The File Import Wizard does not support formulas. Remove any existing formulas or adjust the data in the cells to contain the result values.

Make sure the phone numbers contain the country code and phone number in the same column, with no spaces or zeros at the start. The country code is mandatory. Follow the MSISDN format, for example: 46793699558

For date-type Attributes, we accept all date formats listed here (Including Unix timestamps). However, we have limitations regarding timezones.

Date-type Attributes, like the Default Attribute Date of Birth will be converted. In example a date value like Tue, 07 Mar 1993 04:22:23 +0300 will be converted to 1993-03-07.

We support importing and storing Unix timestamps for Timestamp-type Attributes.

Timestamp-type Attributes, like a Custom Attribute "Member since" will be converted. In example: Values like Tue, 07 Mar 2017 04:22:23 +0300 will be converted to 1488844800 (07 Mar 2017 0:00:00 +0000).

Timestamps (1599116184) will me imported without milliseconds.

We support negative values for dates before 1970 (01-01-1970 is 0).

We support CSV files up to 10MB and XLS/XLSX files up to 3MB.

If the file is CSV, convert it to a UTF-8 format before import, to ensure that the characters are correctly converted.

For CSV files, we support these delimiters: , \t | ;

We also support Both Chinese and Cyrillic characters.

When saving your Microsoft Excel file, or exporting data from another system, pay close attention that the file is encoded as one of the following supported formats:

The Email Attribute must be formatted as a correct email address, containing a valid domain (ie gmail) and a valid domain extension (.com):

email_address@domain.com

Only public email addresses can be reached via email sendings.

The Mobile Attribute must have values in the MSISDN format, for example: 46793699558.

UTF-8 encoded text (string) value with a 1000-character limit. Chinese are Cyrillic characters are supported in APSIS One.

The number Attribute type accepts only number values.

For Attributes that require decimals, pick the number with decimals Attribute type instead.

The value for these Attributes or Event data can only be either true or false, in low caps.

ISO 3166-1 alpha-2 format (SE, US, for example).

For date-type Attributes, we accept all date formats listed here. Timezones will be disregarded.

When it comes to Date-type Attributes, like the Default Attribute Date of Birth:

a date value like Tue, 07 Mar 1993 04:22:23 +0300 will be converted to 1993-03-07.

We support importing and storing Unix timestamps for Timestamp-type Attributes.

When it comes to Timestamp-type Attributes, like a Custom Attribute Member since:

Values like Tue, 07 Mar 2017 04:22:23 +0300 will be converted to 1488844800 (07 Mar 2017 0:00:00 +0000).

Timestamps (1599116184) will me imported without milliseconds.

We also support negative values for dates before 1970.

File Import: Add & Update Profiles

File Import: Unsubscribe Profiles

File Import: Delete Profiles