Batch file
To update profile data in bulk, create a batch file. The batch file is a text file with values separated by commas similar to the following sample file.
batch=pcId,param1,param2,param3,param4
123,value1
124,value1,,,value4
125,,value2
126,value1,value2,value3,value4
The
batch=
parameter is required and must be specified at the beginning of the file.You reference this file in the POST call to Target servers to process the file. When creating the batch file, consider the following:
- The first row of the file must specify column headers.
- The first header should either be a
pcId
orthirdPartyId
. The Marketing Cloud visitor ID is not supported. pcId is a Target-generated visitorID.thirdPartyId
is an ID specified by the client application, which is passed to Target through an mbox call asmbox3rdPartyId
. It must be referred to here asthirdPartyId
. - Parameters and values you specify in the batch file must be URL-encoded using UTF-8 for security reasons. Parameters and values can be forwarded to other edge nodes for processing through HTTP requests.
- The parameters must be in the format
paramName
only. Parameters are displayed in Target asprofile.paramName
. - If you are using Bulk Profile Update API v2, you need not specify all parameter values for each
pcId
. Profiles are created for anypcId
ormbox3rdPartyId
that is not found in Target. If you are using v1, profiles are not created for missing pcIds or mbox3rdPartyIds. - The size of the batch file must be less than 50 MB. In addition, the total number of rows should not exceed 500,000. This limit ensures that servers don’t get flooded with too many requests.
- You can send multiple files. However, the sum total of the rows of all the files that you send in a day should not exceed one million for each client.
- There is no restriction on the number of attributes you can upload. However, the total size of the external profile data, which includes Customer Attributes, Profile API, In-Mbox profile parameters, and Profile Script output, must not exceed 64 KB.
- Parameters and values are case-sensitive.