Bulk Data Insertion API column reference

Adobe supports the following columns in batch files. Each column maps to an Adobe Analytics variable or dimension, and most have a queryString equivalent that you can use inside the queryString column. For file requirements, the two row modes, and examples, see File format. For the customerID columns, see Use a customer ID to identify visitors.

Column header name
queryString equivalent
Description
aamlh
aamlh
Integer that represents the Adobe Audience Manager location hint. Valid values:<br/>• 3: Hong Kong/Singapore (apse.demdex.net)<br/>• 6: Amsterdam/London (irl1.demdex.net)<br/>• 7: US Central/East (use.demdex.net)<br/>• 8: Australia (apse2.demdex.net)<br/>• 9: US West (usw2.demdex.net)<br/>• 11: Tokyo (tyo3.demdex.net)
browserHeight
bh
The Browser height dimension.
browserWidth
bw
The Browser width dimension.
campaign
v0
The Tracking code dimension.
channel
ch
The Site section dimension.
colorDepth
c
The Color depth dimension.
connectionType
ct
The Connection type dimension.
contextData.key
c.[key]
contextData implementation variables.
cookiesEnabled
k
The Cookie support dimension.
currencyCode
cc
The currencyCode implementation variable.
customerID.[customerIDType].id
cid.[customerIDType].id
The id used in the Visitor ID Service setCustomerIDs method.
customerID.[customerIDType].authState
cid.[customerIDType].as
The authState used in the Visitor ID Service setCustomerIDs method. String values are not case sensitive. Supported values:<br/>• 0, UNKNOWN, or an empty string: Not logged in<br/>• 1 or AUTHENTICATED: Logged in<br/>• 2 or LOGGED_OUT: Logged out
customerID.[customerIDType].isMCSeed
cid.[customerIDType].ismcseed
An integer boolean that lets you use customerID.[customerIDType].id as the hit's identifier. Use 1 for true and 0 for false. See Use a customer ID to identify visitors.
eVar1 - eVar250
v1 - v250
eVar dimensions.
events
events
The events implementation variable.
hier1 - hier5
h1 - h5
Hierarchy variables.
hints.architecture
h.architecture
Client Hints: The underlying architecture for the device.
hints.bitness
h.bitness
Client Hints: The "bitness" of the user-agent's CPU architecture; typically 64 or 32.
hints.brands
h.brands
Client Hints: List of browser brands and their significant version, formatted as a serialized JSON object array: [{"brand":"Chromium","version":"104"}, {"brand":"Google Chrome","version":"104"}]
hints.mobile
h.mobile
Client Hints: Boolean indicating if the browser is on a mobile device.
hints.model
h.model
Client Hints: The device model.
hints.platform
h.platform
Client Hints: The platform for the device, usually the operating system (OS).
hints.platformversion
h.platformversion
Client Hints: The version for the platform or OS.
hints.wow64
h.wow64
Client Hints: Boolean indicating if a 32-bit user-agent application is running on a 64-bit Windows machine.
ipaddress
N/A (only available with column header)
The visitor's IP address.
javaEnabled
v
The Java enabled dimension.
language
N/A (only available with column header)
The Language dimension.
linkName
pev2
The Download link, Exit link, or Custom link dimension, depending on the value in the linkType column. If this column contains a value, pageName is ignored.
linkType
pe
The type of link. Defaults to o if this field is empty and linkName contains a value. Valid values when using the linkType column:<br/>• d: Download link<br/>• e: Exit link<br/>• o: Custom link<br/>When using the pe query string, use:<br/>• lnk_d: Download link<br/>• lnk_e: Exit link<br/>• lnk_o: Custom link
linkURL
pev1
The link URL.
list1 - list3
l1 - l3
List variables.
marketingCloudVisitorID
mid
The unique identifier used with the Adobe Experience Cloud Identity Service.
pageName
pageName
The Page dimension.
pageType
pageType
The pageType implementation variable. Set to the string value "errorPage" on any error pages, such as a 404 or 503 error.
pageURL
g
The Page URL dimension.
products
products
The products implementation variable.
prop1 - prop75
c1 - c75
Prop dimensions.
purchaseID
purchaseID
The purchaseID implementation variable.
queryString
This column provides information for this field.
Key/value pairs that provide an alternative to using header columns. This column must be fully URL encoded, including any multi-byte characters. Adobe encodes the query string in UTF-8 by default.
referrer
r
The referrer implementation variable.
reportSuiteID
N/A (only available with column header)
Specifies the report suite(s) where you want to submit data. Separate multiple report suite IDs with a comma.
resolution
s
The Monitor resolution dimension.
server
server
The Server dimension.
timestamp
ts
The date and time that the data was collected. Unix Time and ISO 8601 are supported. Milliseconds are not allowed.
tnta
tnta
Target data payload. Used with Analytics for Target integrations.
trackingServer
N/A (only available with column header)
The trackingServer implementation variable.
transactionID
xact
The transactionID variable.
userAgent
N/A (only available with column header)
The device's user agent string.
visitorID
vid
The visitorID implementation variable.
zip
zip
The Zip code dimension.

The preceding table lists the only column headers that Adobe supports. If you upload a file with a column header that is not included in the table, that column is ignored.