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” |
Characters NOT accepted:
Example | |
|---|---|
dollar signs ($) | “MRR$”, “$plan” |
periods (.) | “MRR.1”, “plan.name” |
percentage signs (%) | “%revenue”, “% of data” |
Ampersand (&) | “Address & Phone” |
Dates as Attribute Values
Date/times must be in the “yyyy-mm-ddThh:mm:ss” format (“ISO 8601” format) to be recognized as dates.
✔ 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 Sensitive
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.
Updated about a year ago