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	Catalog of the character set used for data storage and retrieval in the database.	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	Schema of the character set used for data storage and retrieval.	dimension
collation_catalog	collation_catalog	Catalog of the collation sequence used for sorting and comparing character strings in the database.	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	Schema of the collation sequence used for sorting and comparing character strings.	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	Specifies the action taken upon committing a transaction, such as preserving or deleting resources, in the Query Service API.	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 logical database or catalog where domain-specific data assets are organized within Adobe Experience Platform. This helps in grouping related data for management and querying.	dimension
domain_name	domain_name	The specific name or identifier for a domain within the data catalog. Domains typically represent a logical grouping of data related to a particular business area or concept.	dimension
domain_schema	domain_schema	The schema within the domain catalog (database) where domain-specific data structures and tables are defined. Schemas provide a blueprint for how data is organized and validated.	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’s sequence will cycle (restart) when its maximum value is reached. This is relevant for identity constraints in 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 level of detail or exactness for a time interval, such as seconds, minutes, or hours. This is relevant for defining durations or time-based segmentation in data processing.	dimension
interval_type	interval_type	The unit of time used for a duration or time interval, such as milliseconds, seconds, minutes, hours, or days. This helps in specifying time-based attributes for metrics or journey orchestration.	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 table or column has a relationship, such as a foreign key, that references a column within the same table.	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	A boolean indicator of whether a dataset or view is modifiable. Adobe Experience Platform Query Service primarily supports append-only operations via INSERT INTO, with no direct support for UPDATE or DELETE statements.	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	Describes how relationships and foreign key constraints between different data entities or tables are established and managed within the platform.	dimension
scope_catalog	scope_catalog	The logical database or catalog that defines the boundaries or context for a specific set of data assets within Adobe Experience Platform. This aids in data segmentation and access control.	dimension
scope_name	scope_name	The specific name or identifier for a data scope within the platform. A scope typically denotes a logical grouping of data for particular use cases or access patterns.	dimension
scope_schema	scope_schema	The schema within the scope catalog (database) where data structures pertinent to a specific data scope are defined, ensuring data consistency and adherence to defined boundaries.	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 that is part of a self-referencing relationship within the same table, often used with foreign key constraints.	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 (database) where user-defined data types (UDTs), often referred to as ‘data types’ in XDM, are stored and managed. These UDTs are reusable fields that contain multiple sub-fields.	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 within the UDT catalog (database) where user-defined data types (UDTs) are defined, outlining their structure and properties within the Experience Data Model (XDM).	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 (database) specifically for storing and managing custom or reusable data types (User-Defined Types) within the Experience Data Model (XDM) schema registry.	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 within the user-defined type catalog (database) where the definitions of custom, reusable data types for XDM schemas are maintained.	dimension
variant	variant	Represents a flexible field that can hold data of various types or a specific variation of a data object, often found in extensible data models like those handled by Adobe Experience Platform Query Service.	dimension
web	web	A container for web-specific interaction data, including page details, referrer information, and navigation.	dimension