Overview

For all CSV files sent to Zeta, they should be formatted in compliance with rfc4180. Some tips can be found below.

They must be encoded in UTF-8.

  1. When loading Audiences(Users or Lists) into ZMP using the CSV format, columns with following header names will be treated exceptionally:

    1. user_id (Required): This is important to identify individual users. You can use email address as ‘user_id’ in most cases but it is recommended to use the identifier from your own system of record, if available.

    2. email: This is email contact of the user and is used for all communications on email channel.

    3. first_name: This is the first name of the user record and can be used to personalize messages.

    4. last_name: This is the last name of the user record and can be used to personalize messages.

    5. phone: This is the phone number of the user record and is used for all communications on SMS channel. Zeta strongly recommends E.164 number formatting which is usually written as follows: [+][country code][subscriber number including area code].

    6. Signed_up_at: This is the date when user had signed up with your business. The date should be in ISO-8601 format e.g. yyyy-MM-dd HH:mm:ss.

  2. If a value contains a comma, a newline character or a double quote, then the string must be enclosed in double quotes.

    1. i.e., "Newline char in this field \n"

  3. A double quote must be escaped with another double quote.

    1. i.e., "This double quote character "" is escaped."