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	The maximum length of the character data in octets (bytes). This applies to string-based fields within datasets, as defined by XDM schemas and accessed via Query Service.	dimension
character_set_catalog	character_set_catalog	The catalog in which the character set is defined. This is metadata related to character encoding for text-based data within datasets.	dimension
character_set_name	character_set_name	The name of the character set used for the data. This defines how textual data in AEP datasets is encoded.	dimension
character_set_schema	character_set_schema	The schema in which the character set is defined. This is metadata related to character encoding for text-based data within datasets.	dimension
collation_catalog	collation_catalog	The catalog in which the collation is defined. This is metadata related to sorting and comparison rules for text data within datasets.	dimension
collation_name	collation_name	The name of the collation used for character data. This specifies the rules for sorting and comparing textual data in AEP datasets.	dimension
collation_schema	collation_schema	The schema in which the collation is defined. This is metadata related to sorting and comparison rules for text data within datasets.	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	The catalog in which the data domain is defined. This could refer to a logical grouping or type definition within the data schema.	dimension
domain_name	domain_name	The name of the data domain. In a database context, a domain is a user-defined data type with optional constraints. In AEP, this might relate to custom data types or reusable schema components.	dimension
domain_schema	domain_schema	The schema in which the data domain is defined. This could refer to a logical grouping or type definition within the data 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 (computed) column. This is relevant for derived attributes or calculated fields within an XDM schema or Query Service view.	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 will cycle through its sequence of values. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
identity_generation	identity_generation	Specifies how the values for an identity column are generated, such as ‘ALWAYS’ or ‘BY DEFAULT’. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
identity_increment	identity_increment	The increment step for an identity column. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
identity_maximum	identity_maximum	The maximum value an identity column can reach. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
identity_minimum	identity_minimum	The minimum value an identity column can reach. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
identity_start	identity_start	The starting value for an identity column. Relevant for auto-incrementing fields in datasets accessed via Query Service.	dimension
interval_precision	interval_precision	The precision of a time interval data type, specifying the number of digits in the leading field of the interval.	dimension
interval_type	interval_type	The type of time interval, such as ‘YEAR TO MONTH’ or ‘DAY TO SECOND’. Relevant for time-based data fields.	dimension
is_generated	is_generated	Indicates whether the value of the field is automatically generated, for example, a computed attribute or a system-generated ID.	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	Indicates if a data element or table contains references to itself, common in hierarchical data structures within a data model.	dimension
is_typed	is_typed	Indicates whether the field has a specific data type assigned to it. XDM schemas enforce strict typing for data fields.	dimension
is_updatable	is_updatable	Indicates whether the value of the field can be modified after its initial creation.	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	The maximum number of elements allowed in a collection or array-type field within an XDM schema.	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	The name of the column used to establish a self-referencing relationship within a dataset, typically for hierarchical data.	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) is defined. XDM schemas can be considered a form of UDTs.	dimension
udt_name	udt_name	The name of the User-Defined Type (UDT). This refers to custom data types or schema definitions, such as those created using XDM.	dimension
udt_schema	udt_schema	The schema in which the User-Defined Type (UDT) is defined. XDM schemas can be considered a form of UDTs.	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 is defined. This refers to the metadata for custom schema elements or data types within AEP.	dimension
user_defined_type_name	user_defined_type_name	The name of the user-defined type. This refers to custom data structures or schema components, such as those defined with XDM.	dimension
user_defined_type_schema	user_defined_type_schema	The schema in which the user-defined type is defined. This refers to the metadata for custom schema elements or data types within AEP.	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