Adobe Experience Platform: Most-used fields

The table below gives information about most-used fields that you can import from Adobe Experience Platform. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
AB test	AB test	Information related to A/B testing, used to define and track different variations of content or experiences for performance comparison.	dimension
_experience	_experience	A container for various experience-related data, including analytics, environmental details, and custom dimensions.	dimension
_id	_id	A unique, system-generated identifier for a record or event within the Experience Platform.	dimension
campaignName	campaignName	The name of the marketing campaign associated with an event or interaction.	dimension
channel	channel	The communication channel through which an event or interaction occurred (e.g., web, mobile, email).	dimension
character_maximum_length	character_maximum_length	For character-string data types, this indicates the maximum length of the column in characters. This is relevant for string data types like varchar and char in SQL queries within Adobe Experience Platform Query Service.	dimension
character_octet_length	character_octet_length	For character-string data types, this indicates the maximum length of the column in octets (bytes). This is typically the same as character_maximum_length for single-byte character sets, but can differ for multi-byte character sets.	dimension
character_set_catalog	character_set_catalog	The catalog in which the character set of the column is defined. This is standard SQL metadata for character set management, implicitly handled by the Query Service.	dimension
character_set_name	character_set_name	The name of the character set used for the column. This is standard SQL metadata for character set management, implicitly handled by the Query Service.	dimension
character_set_schema	character_set_schema	The schema in which the character set of the column is defined. This is standard SQL metadata for character set management, implicitly handled by the Query Service.	dimension
collation_catalog	collation_catalog	The catalog in which the collation of the column is defined. This is standard SQL metadata related to text sorting rules, implicitly handled by the Query Service.	dimension
collation_name	collation_name	The name of the collation used for the column. This is standard SQL metadata related to text sorting rules, implicitly handled by the Query Service.	dimension
collation_schema	collation_schema	The schema in which the collation of the column is defined. This is standard SQL metadata related to text sorting rules, implicitly handled by the Query Service.	dimension
column_default	column_default	The default value assigned to the column if no value is explicitly provided during an insert operation in the Query Service.	dimension
column_name	column_name	The name of the column within a table. This is a fundamental identifier for data fields in Adobe Experience Platform datasets.	dimension
commerce	commerce	A container for all commerce-related data, including order details, product interactions, and transactions.	dimension
commit_action	commit_action		dimension
country	country	The full name of the country associated with a geographic location or user setting.	dimension
country_code	country_code	The ISO 3166-1 alpha-2 country code associated with a geographic location.	dimension
dataSource	dataSource	An identifier for the source system from which the data originated.	dimension
data_type	data_type	The data type of the column, such as string, integer, or datetime, as supported by the Adobe Experience Platform Query Service.	dimension
date	date	A generic date field, representing a specific calendar date.	dimension
datetime_precision	datetime_precision	For datetime data types, this specifies the precision of fractional seconds, indicating the level of detail for time values.	dimension
deliveryName	deliveryName	The name of a specific delivery within a marketing campaign.	dimension
device	device	A container for technical details about the device used for an interaction, such as screen dimensions and device type.	dimension
directMarketing	directMarketing	A container for data related to direct and outbound marketing activities, including email, direct mail, texts, and in-app notifications.	dimension
domain_catalog	domain_catalog		dimension
domain_name	domain_name		dimension
domain_schema	domain_schema		dimension
dtd_identifier	dtd_identifier		dimension
endUserIDs	endUserIDs	A container for various identifiers associated with the end-user, such as device IDs or other primary identifiers.	dimension
environment	environment	A container for details about the digital environment where an event occurred, including browser, operating system, and IP address.	dimension
eventType	eventType	A string indicating the type or category of the recorded experience event (e.g., ‘product view’, ‘add to cart’).	dimension
first_seen_date	first_seen_date	The date when a customer or entity was first observed or interacted with the brand, providing a key timestamp for customer journey analysis within Adobe Experience Platform’s Real-Time Customer Profile.	dimension
generation_expression	generation_expression	The expression used to compute the value of a generated column. While the Query Service can derive columns using SELECT statements, explicit ‘generated columns’ as a DDL feature are not highlighted.	dimension
identityMap	identityMap	A map of identity values and their associated namespaces, used to uniquely identify individuals across different systems.	dimension
identity_cycle	identity_cycle	Indicates whether an identity column can cycle through its sequence of values once the maximum or minimum is reached.	dimension
identity_generation	identity_generation	Specifies how values for an identity column are generated, such as ‘ALWAYS’ or ‘BY DEFAULT’.	dimension
identity_increment	identity_increment	The increment value used for generating sequential numbers in an identity column.	dimension
identity_maximum	identity_maximum	The maximum value that an identity column can generate.	dimension
identity_minimum	identity_minimum	The minimum value that an identity column can generate.	dimension
identity_start	identity_start	The starting value for an identity column’s sequence generation.	dimension
interval_precision	interval_precision		dimension
interval_type	interval_type		dimension
is_generated	is_generated	Indicates whether the column is a generated column, meaning its value is computed from an expression or other columns.	dimension
is_identity	is_identity	Indicates whether the column is an identity column (e.g., auto-incrementing), supported in Adobe Experience Platform Query Service via ALTER TABLE ADD CONSTRAINT PRIMARY IDENTITY.	dimension
is_insertable_into	is_insertable_into	Indicates whether data can be inserted into this column. In Query Service, INSERT INTO is supported for adding new records.	dimension
is_nullable	is_nullable	Indicates whether the column can store NULL values. This is a standard SQL property for column definitions.	dimension
is_self_referencing	is_self_referencing		dimension
is_typed	is_typed		dimension
is_updatable	is_updatable	Indicates whether the values in the column can be modified after initial creation. While Query Service supports INSERT INTO, explicit UPDATE operations are not available.	dimension
language	language	The preferred language of the customer, represented as an IETF Language Tag (RFC 5646), aiding in personalized content delivery within Adobe Experience Platform.	dimension
language_code	language_code	A standardized code representing the language (e.g., ‘en’ for English).	dimension
market	market	The specific market segment or geographical region associated with the customer, enabling targeted marketing and localized experiences within Adobe Experience Platform.	dimension
marketing	marketing	A container for various marketing-related data and attributes.	dimension
marketing_channel	marketing_channel	The specific channel used for a marketing activity, e.g., email, social media, paid search.	dimension
maximum_cardinality	maximum_cardinality	For array or set-like data types, this specifies the maximum number of elements the column can contain. XDM schemas can handle array structures for complex data.	dimension
numeric_precision	numeric_precision	For numeric data types, this represents the total number of digits that can be stored in the column, both before and after the decimal point.	metric
numeric_precision_radix	numeric_precision_radix	For numeric data types, this specifies the base or radix of the precision (e.g., 2 for binary, 10 for decimal).	metric
numeric_scale	numeric_scale	For exact numeric data types, this represents the number of digits allowed to the right of the decimal point.	metric
orders	orders	Represents information related to a customer’s purchase orders, including details like order ID, products purchased, and total value. This data is crucial for understanding customer behavior and personalization within Adobe Experience Platform.	metric
ordinal_position	ordinal_position	The sequential position of the column within the table, starting from 1.	metric
personalEmail	personalEmail	The technical email address of an individual, such as name@domain.com, as defined by RFC2822 standards within the XDM Field Dictionary. This is often used as a primary identifier for customer profiles.	dimension
placeContext	placeContext	A container for geographic context information related to an event, including location details and timezone offset.	dimension
productListItems	productListItems	An array of product items included in a list, such as a shopping cart or order, each containing details about a specific product.	dimension
quantity	quantity	The number of units for a specific product item.	metric
receivedTimestamp	receivedTimestamp	The timestamp when the data or event was received by the processing system.	dimension
reference_generation	reference_generation		dimension
scope_catalog	scope_catalog		dimension
scope_name	scope_name		dimension
scope_schema	scope_schema		dimension
search	search	Data related to user search activities, including search terms, results, and referrer information.	dimension
self_referencing_column_name	self_referencing_column_name		dimension
sendDate	sendDate	The date when a marketing communication, such as an email, was sent.	dimension
senddate	senddate	The date when a marketing communication, such as an email, was sent.	dimension
table_catalog	table_catalog	The catalog (database) where the table is located. Adobe Experience Platform Query Service supports CREATE DATABASE.	dimension
table_name	table_name	The name of the table in the Adobe Experience Platform data lake or accelerated store.	dimension
table_schema	table_schema	The schema where the table is organized within the Adobe Experience Platform data lake. Query Service supports CREATE SCHEMA.	dimension
table_type	table_type	The type of table, such as ‘BASE TABLE’ for a regular table, ‘VIEW’ for a virtual table, or ‘TEMPORARY’ for a temporary table.	dimension
timestamp	timestamp	The primary timestamp of when an experience event occurred.	dimension
total_clicks	total_clicks	The total number of clicks recorded for a marketing communication or campaign.	metric
total_opens	total_opens	The total number of times a marketing communication, such as an email, was opened.	metric
total_optins	total_optins	The total number of times users opted in or subscribed to a service or communication.	metric
total_optouts	total_optouts	The total number of times users opted out from a service or communication.	metric
total_unsubs	total_unsubs	The total number of unsubscribes from marketing communications.	metric
udt_catalog	udt_catalog	The catalog in which the user-defined type (UDT) of the column is defined. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
udt_name	udt_name	The name of the user-defined type (UDT) of the column. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
udt_schema	udt_schema	The schema in which the user-defined type (UDT) of the column is defined. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
unique_clicks	unique_clicks	The number of unique users who clicked on a link in a marketing communication.	metric
unique_opens	unique_opens	The number of unique users who opened a marketing communication.	metric
unique_sends	unique_sends	The number of unique recipients to whom a marketing communication was successfully sent.	metric
unique_unsubs	unique_unsubs	The number of unique users who unsubscribed from marketing communications.	metric
user_defined_type_catalog	user_defined_type_catalog	The catalog in which the user-defined type of the column is defined. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
user_defined_type_name	user_defined_type_name	The name of the user-defined type of the column. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
user_defined_type_schema	user_defined_type_schema	The schema in which the user-defined type of the column is defined. Adobe Experience Platform uses XDM schemas as its primary data modeling mechanism.	dimension
variant	variant	Represents a polymorphic data type, or a column capable of storing semi-structured data like JSON objects. Adobe Experience Platform Query Service supports handling complex fields and returning them as JSON strings.	dimension
web	web	A container for web-specific interaction data, including page details, referrer information, and navigation.	dimension