Data tables enable you to import data in a structured way that can be stored in and used by the Alida platform.
You can use data tables in Analytics, Customer Journeys, and Actions.
CSV file requirements
Ensure that your CSV files meet all formatting requirements to be imported successfully.
- The CSV file size cannot exceed 10MB.
- As long as the file does not exceed the maximum file size, there is no limit on the number of rows.
- The CSV file must include at least 2 rows of data—one row with the column headers and at least one row of data.
- The column identified in the data table structure as the Record ID column must be included and must have a value for each row.
- To import the CSV file successfully, each row must have values for required columns. The values cannot be empty.
- The values in each row for
a column must match the data type of the column.
Note: Numeric values specified for Singe Choice and Multi Choice columns are always interpreted as strings.
- Values specified for Single Choice and Multi Choice columns must match the allowed values defined in the data table structure.
- Any Single Choice values that include commas must be wrapped in double quotes. For example: "Listened to music from physical media (CDs, vinyl)"
- Multi Choice values can include commas and single quotes, but these characters cannot be beside each other. For example, "Fast food restaurants (Burger King, Wendy's, McDonald's)" is acceptable, but "Movie franchises ('Star Wars','James Bond', 'Fast and Furious')" is not.
- For Multi Choice columns the list of values can be included in any order, with each value separated by a comma.
- Date values must be formatted YYYY/MM/DD or YYYY-MM-DD.
- Avoid using any of these
unsupported column names:
-
JsonSchema -
application_id -
op -
id -
schema_id
-