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
account_id	account_id	A unique identifier for the business partner or advertiser account.	dimension
actualized_media_spend	actualized_media_spend	The actual amount of money spent on advertising media campaigns.	metric
actualized_vendor_spend	actualized_vendor_spend	The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.	metric
ad_format	ad_format	The specific format of the advertisement used in a campaign, such as video, display, or native.	dimension
adjusted_actualized_media_spend	adjusted_actualized_media_spend	The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.	metric
adjusted_actualized_spend	adjusted_actualized_spend	The actual amount of money spent on a campaign or placement, considering any adjustments or recalculations.	metric
booked_impressions	booked_impressions	The number of advertising impressions that were planned or reserved for a campaign.	metric
bp_id	bp_id	A unique identifier for the Business Partner, scoping all interactions.	dimension
budget	budget	The allocated financial resources for an advertising campaign or a specific flight.	metric
campaign_group	campaign_group	A classification or grouping applied to advertising campaigns for organizational and reporting purposes.	dimension
campaign_type	campaign_type	The specific type of advertising campaign being run, such as Target Product Ads (TPAs) or Precision Plus.	dimension
clicks	clicks	The total number of times users clicked on an advertisement.	metric
combined_reach	combined_reach	The total number of unique users exposed to an advertising flight across all included channels or platforms.	metric
contracted_media_spend	contracted_media_spend	The amount of money formally agreed upon in a contract for advertising media spending.	metric
ctr	ctr	The click-through rate, representing the percentage of people who clicked on an ad after seeing it.	metric
days_in_market	days_in_market	The number of days an advertising flight has been active since its launch date.	metric
days_remaining	days_remaining		metric
email_bounces	email_bounces		metric
email_opens	email_opens		metric
email_sends	email_sends		metric
end_date	end_date	The scheduled conclusion date for an advertising campaign or its components.	dimension
event_day	event_day	The specific calendar day on which a particular event or metric occurred.	dimension
exposures	exposures	The total number of times an advertisement was displayed or presented to users, also known as impressions.	metric
flight_category	flight_category	The category or type associated with an advertising flight. An advertising flight is a specific period an ad campaign runs.	dimension
flight_duration	flight_duration	The length of time, or duration, that an advertising campaign (often referred to as a ‘flight’) is scheduled to run or has been active.	dimension
flight_end_date	flight_end_date	The scheduled conclusion date for an advertising campaign component or flight.	dimension
flight_id	flight_id	A unique identifier for an advertising flight.	dimension
flight_level_metrics.actualized_vendor_spend	flight_level_metrics.actualized_vendor_spend	The actual amount of money spent with a vendor for a campaign or placement, taking into account any adjustments or recalculations. This reflects the real cost incurred.	dimension
flight_level_metrics.booked_impressions	flight_level_metrics.booked_impressions	The total number of ad impressions that were planned or reserved for a specific advertising flight.	dimension
flight_level_metrics.budget	flight_level_metrics.budget	The allocated financial resources for a specific advertising flight.	dimension
flight_level_metrics.campaign_group	flight_level_metrics.campaign_group	A grouping or categorization of related advertising campaigns (flights) for organizational and reporting purposes. This allows for performance metrics to be aggregated and analyzed across a defined set of campaigns.	dimension
flight_level_metrics.clicks	flight_level_metrics.clicks	The total number of times users clicked on advertisements within a specific advertising flight.	dimension
flight_level_metrics.combined_reach	flight_level_metrics.combined_reach	The total number of unique users exposed to an advertising flight across all included channels or platforms.	dimension
flight_level_metrics.ctr	flight_level_metrics.ctr	The Click-Through Rate for a specific advertising flight.	dimension
flight_level_metrics.daily_pacing	flight_level_metrics.daily_pacing	A metric indicating how an advertising flight’s budget or impressions are being consumed on a daily basis relative to its schedule.	dimension
flight_level_metrics.days_in_market	flight_level_metrics.days_in_market	The number of days an advertising flight has been active since its launch date.	dimension
flight_level_metrics.frequency	flight_level_metrics.frequency	The average number of times a unique user was exposed to advertisements within a specific advertising flight.	dimension
flight_level_metrics.impressions	flight_level_metrics.impressions	The total number of times advertisements within a specific advertising flight were displayed to users.	dimension
flight_level_metrics.influenced_orders	flight_level_metrics.influenced_orders	The total number of orders (online and/or in-store) attributed to the influence of a specific advertising flight.	dimension
flight_level_metrics.influenced_sales	flight_level_metrics.influenced_sales	The total sales revenue (online and/or in-store) attributed to the influence of a specific advertising flight.	dimension
flight_level_metrics.monthly_pacing	flight_level_metrics.monthly_pacing	A metric indicating how an advertising flight’s budget or impressions are being consumed on a monthly basis relative to its schedule.	dimension
flight_level_metrics.pacing_percentage	flight_level_metrics.pacing_percentage	A metric indicating how closely a specific advertising flight’s spend is aligning with its budget over a given period.	dimension
flight_level_metrics.roas	flight_level_metrics.roas	Return on Ad Spend for a specific advertising flight.	dimension
flight_revenue	flight_revenue	The total revenue generated that is attributed to an advertising flight, combining sales from both online and in-store purchases.	dimension
flight_start_date	flight_start_date	The scheduled commencement date for an advertising campaign component or flight.	dimension
flight_status	flight_status	The current state of an advertising flight, indicating whether it is active, paused, completed, or in another defined state.	dimension
frequency	frequency	The average number of times a unique user was exposed to an advertisement.	metric
impressions	impressions	The total number of times an advertisement was displayed.	metric
impressions_remaining	impressions_remaining	The number of advertising impressions still required to reach a campaign’s target or booked goal.	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
measurable_cost	measurable_cost	The quantifiable expenses associated with an advertising campaign or specific ad activity.	metric
measurable_media_cost	measurable_media_cost	The quantifiable expenses associated with a specific advertising campaign or ad activity that can be tracked and reported.	metric
no_of_days_left	no_of_days_left	The number of days remaining until the scheduled conclusion date of an advertising campaign or its components.	dimension
objective	objective	The primary goal of an advertising campaign, such as driving awareness, consideration, or sales.	dimension
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
platform_name	platform_name	The name of the advertising platform or channel where the campaign or media is running (e.g., Target.com, Mobile App, Google, Social Media).	dimension
return_on_media_spend	return_on_media_spend	A key performance indicator that measures the revenue generated for every dollar spent on advertising media.	metric
roas	roas	Return on Ad Spend, a metric that measures the revenue generated for each dollar spent on advertising.	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_trans	store_trans	The number of transactions or purchases made in physical stores that are attributed to an advertising campaign.	metric
store_units	store_units	The total number of product units sold in physical retail stores.	metric
store_visits	store_visits	The number of visits to a physical store that are attributed to an advertising campaign.	metric
targeting_type	targeting_type	The specific method or criteria used to define and reach the target audience for an advertising campaign.	dimension
tcin	tcin	The Target Commerce Item Number, a unique identifier for products sold at Target.	metric
total_conversion_rate	total_conversion_rate	The percentage of users who complete a desired action, such as a purchase or sign-up, after interacting with an advertisement.	metric
total_impressions	total_impressions	The total number of times an advertisement was displayed to users.	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_spend	total_spend	The cumulative monetary amount spent on an advertising campaign.	dimension
total_units	total_units	The aggregate number of product units sold, combining both online and in-store quantities.	metric
vendor_cost	vendor_cost	The actual amount of money spent with a vendor for a campaign or placement, considering any adjustments or recalculations.	metric
video_100	video_100	The number of times a video advertisement was viewed completely from beginning to end.	metric
video_25	video_25	The number of times a video advertisement was viewed up to 25% of its total duration.	metric
video_50	video_50	The number of times a video advertisement was viewed up to 50% of its total duration.	metric
video_75	video_75	The number of times a video advertisement was viewed up to 75% of its total duration.	metric
video_average_watch_time	video_average_watch_time	The average amount of time, in seconds, that users spent watching a video advertisement.	metric
video_plays	video_plays	The total number of times a video advertisement was initiated or started playing.	metric
watch_time_seconds	watch_time_seconds	The total cumulative time, measured in seconds, that users spent watching video advertising content.	metric