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.
email_sha256
SHA-256
All
phone_sha256
SHA-256
All
address_sha256
SHA-256
All
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_sha256
SHA-256
SE
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)
custom
Raw
All
User identifier (like user ID, CRM ID, CDP ID or similar)
Last updated