Roundel: Most-used fields

The table below gives information about most-used fields that you can import from Roundel. 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
bp_id	bp_id	A unique identifier for the Business Partner, scoping all interactions.	dimension
clicks	clicks	The total number of times users clicked on an advertisement.	metric
end_date	end_date	The scheduled conclusion date for an advertising campaign or its components.	dimension
flight_id	flight_id	A unique identifier for an advertising flight.	dimension
impressions	impressions	The total number of times an advertisement was displayed.	metric
influenced_online_orders	influenced_online_orders	The number of online orders attributed to the influence of the advertising campaign.	metric
influenced_online_sales	influenced_online_sales	The online sales revenue attributed to the influence of the advertising campaign.	metric
influenced_online_units	influenced_online_units	The number of online product units sold that were influenced by the advertising campaign.	metric
influenced_orders	influenced_orders	The total number of orders (online and/or in-store) attributed to the influence of the advertising campaign.	metric
influenced_sales	influenced_sales	The total sales revenue (online and/or in-store) attributed to the influence of the advertising campaign.	metric
influenced_store_orders	influenced_store_orders	The number of in-store orders attributed to the influence of the advertising campaign.	metric
influenced_store_sales	influenced_store_sales	The in-store sales revenue attributed to the influence of the advertising campaign.	metric
influenced_store_units	influenced_store_units	The number of in-store product units sold that were influenced by the advertising campaign.	metric
influenced_units	influenced_units	The total number of product units sold (online and/or in-store) attributed to the influence of the advertising campaign.	metric
online_orders	online_orders	The total number of orders placed through online channels.	metric
online_sales	online_sales	The total revenue generated from sales made through online channels.	metric
online_units	online_units	The total number of product units sold through online channels.	metric
start_date	start_date	The scheduled commencement date for an advertising campaign or its components.	dimension
store_sales	store_sales	The total revenue generated from sales occurring in physical retail stores.	metric
store_units	store_units	The total number of product units sold in physical retail stores.	metric
tcin	tcin	The Target Commerce Item Number, a unique identifier for products sold at Target.	metric
total_orders	total_orders	The aggregate number of orders, combining both online and in-store purchases.	metric
total_sales	total_sales	The aggregate revenue generated from sales, combining both online and in-store figures.	metric
total_units	total_units	The aggregate number of product units sold, combining both online and in-store quantities.	metric