Uploading attributes via CSV file

When uploading your .csv file, an email column is the minimum requirement. All additional columns besides the email will automatically be uploaded as contact attributes.

Formats of Attribute Names and Values

Any data uploaded can only contain alphanumeric characters:

Example

letters “a - z” / ”A - Z

“plan” , “ID”, “Company”

numbers 0 - 9

009, 49, 1234, 200.13

underscores ( _ )

“region_024”, “company_name"

spaces ( )

“Plan Name”, “company name”

Dates as Attribute Values

Date/times must be in the “yyyy-mm-ddThh:mm:ss” format “ISO 8601” format to be recognized as dates for filtering purposes.

✔ Correct:

2017-09-23

2017-09-23T15:25

2017-09-23 15:25

2017-09-23T15:25:45

2017-09-23T15:25:45Z

X Incorrect:

9-23-17

9/23/17

23/09/17

2017-9-23

09-23-2017

Case Sensitivity

Attribute names and values are case sensitive. Be consistent in naming and formatting your attributes.

Ex: "Plan" and "plan" are seen as two different attributes.

If you need to clean up any duplicate attributes, this can be done in the Attributes management section of your account.

Uploading attributes via API

Attributes can also be attached to your contacts via the API when using the 'Survey a contact' or 'Update a contact' call under the 'attributes' section.

Did this answer your question?