Uploading profile properties from a CSV file

Import multiple profile properties at once by uploading a CSV file on the Profile Properties page.

Before you begin

Note:
This page is available for CDM-enabled tenants.
Prepare a CSV file with a header row and one row for each property. Each column corresponds to the field of the same name in the Profile Property Details dialog box. For field descriptions, see Adding custom profile properties.
Table 1. CSV columns
Column Allowed values
Property Unique internal identifier
Display Name Display name in segmentation
Source Column custom
Source Type dataingestionapi, analyze_post
Data Type String, Number, Date Time, Date, Array of Strings, Array of numbers and Array of dates
Key Type Primary, Secondary, none
Segmentable, Enumerable True, False
Format Type Number, Date
Payload Mapping JSON field path in the ingestion payload

Procedure

  1. Go to CDP > Profile Management > Profile Properties, and then click Upload.
  2. Select the CSV file, and then upload it.

Results

The properties in the file are added to the Profile Properties list.

Example: CSV file

Property,Display Name,Source Column,Source Type,Data Type,Key Type,Segmentable,Enumerable,Format Type,Payload Mapping
Profile,Customer test,custom,dataingestionapi,STRING,none,True,True,,email
CustomerAge,Customer Age,custom,dataingestionapi,NUMBER,Secondary,True,True,Number,age
Signup,Signup Date,custom,analyze_post,DATE,,True,False,Date,signup_date