Prepare Your CSV File for Data Updates
When creating a CSV file, ensure it meets the following requirements:
Parameter | Allowed 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 Name | Value | Country | Description |
---|---|---|---|
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