dA Docs
Tool
  • 🏠Welcome
  • Documentation
    • CRM Onboarding
      • 1. Prepare CSV File
      • 2. Format Your Data
      • 3. Onboard Your Data through Portal
    • Publisher Onboarding
      • Onboarding Setup
    • Updating Audiences
      • Prepare Your CSV File for Data Updates
    • Data Collaboration
      • How to Collaborate with Other Data Providers Through our Portal
    • SDK Implementation
  • Audience List
    • Adform
      • NL
      • SE
    • DV360
      • NL
      • SE
      • FI
    • P161
      • NL
      • SE
    • Xandr
      • NL
      • SE
      • FI
    • Trade Desk
      • NL
    • Bidtheatre
      • SE
    • Pubmatic
      • NL
      • SE
  • DMP integration
    • Piano segments
Powered by GitBook
On this page
  1. Documentation
  2. Updating Audiences

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

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)

PreviousUpdating AudiencesNextData Collaboration

Last updated 10 months ago

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

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

A 256-bit cryptographic hash derived from a normalized postal address, follow the for normalization.

formatting guidelines
formatting guidelines
formatting guidelines