AMC data types, timestamp, and date formats - Amazon Marketing Cloud Uploader from AWS

AMC data types, timestamp, and date formats

Dataset columns can be defined with the following data types. Pay close attention to the accepted formats for TIMESTAMP and DATE columns. If values in CSV / JSON data do not meet the accepted format, the upload might fail.

Ensure all values in CSV / JSON data confirm the specified data type and format before uploading. Where possible, string values will be coerced to the corresponding numerical type and vice-versa, but no guarantees are made on the casting process.

Data type Format Example

STRING

UTF-8 encoded character data

My string data

DECIMAL

Numerical with two floating point level precision

123.45

INTEGER (int 32-bit)

32-bit numerical, no floating points

12345

LONG (int 64-bit)

64-bit numerical, no floating points

1233454565875646

TIMESTAMP

yyyy-MM-ddThh:mm:ssZ

2021-08-02T08:00:00Z

DATE

yyyy-MM-dd

8/2/2021