Prepare Your CSV File for Data Updates

When creating a CSV file, ensure it meets the following requirements:

ParameterAllowed Values

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.

Header NameValueCountryDescription

email_sha256

SHA-256

All

A 256-bit cryptographic hash derived from a normalized email address, follow the formatting guidelines for normalization

phone_sha256

SHA-256

All

A 256-bit cryptographic hash derived from a normalized phone number, follow the formatting guidelines for normalization

address_sha256

SHA-256

All

A 256-bit cryptographic hash derived from a normalized postal address, 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_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