Prepare Your CSV File for Data Updates
When creating a CSV file, ensure it meets the following requirements:
Encoding
UTF-8
Line separator
CRLF
Values delimiter
Comma
File extension
.CSV
Headers
Yes
Ensure your CSV file includes a minimum of one data row and, at the least, one of the columns listed in the table below.
Adhere to the specified naming conventions for proper processing of the columns.
Please remember that at the moment is not possible to oboard a file with an hashed address in it from the portal.
Raw / SHA-256
All
Email addresses / A 256-bit cryptographic hash derived from a normalized email address, follow the formatting guidelines for normalization
phone
Raw / SHA-256
All
Phone numbers / A 256-bit cryptographic hash derived from a normalized phone number, follow the formatting guidelines for normalization
postal code
Raw
All
Postal code, mandatory if raw address details are provided
house number
Raw
All
House number, optional
extension
Raw
All
House number extension, optional
apartment
Raw
SE
Apartment number, optional
street
Raw
SE
Street name, optional
personal id
Raw / SHA-256
SE
Personal identifier /
A 256-bit cryptographic hash derived from a normalized personal identifier
aaid
Raw
All
Android Advertising ID (Google)
idfa
Raw
All
Identifier for Advertising (Apple)
extra
Raw
All
User identifier (like user ID, CRM ID, CDP ID or similar)
Last updated