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.
When loading Audiences(Users or Lists) into ZMP using the CSV format, columns with following header names will be treated exceptionally:
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.
email: This is email contact of the user and is used for all communications on email channel.
first_name: This is the first name of the user record and can be used to personalize messages.
last_name: This is the last name of the user record and can be used to personalize messages.
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].
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.
If a value contains a comma, a newline character or a double quote, then the string must be enclosed in double quotes.
"Newline char in this field \n"
A double quote must be escaped with another double quote.
"This double quote character "" is escaped."