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 advertiser’s account.	dimension
actualized_media_spend	actualized_media_spend	The actual amount of money spent on media campaigns within the platform.	metric
ad_format	ad_format	The specific presentation style or layout of an advertisement (e.g., banner, video, sponsored product).	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 total amount of money spent on a campaign or media placement, after any adjustments have been applied.	metric
attributed_cost	attributed_cost	The cost specifically allocated or linked to a particular conversion or action.	metric
audience	audience	Information pertaining to the target demographic or segment for an advertising campaign.	dimension
average_order_value	average_order_value	The average monetary value of each order placed.	metric
average_unit_price	average_unit_price	The average selling price of a single product unit.	metric
booked_impressions	booked_impressions	The total number of ad 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 total financial resources allocated for an advertising campaign or flight.	metric
campaign_group	campaign_group	A classification or grouping of related advertising campaigns.	dimension
campaign_platform	campaign_platform	The specific advertising platform or channel where the campaign is delivered.	dimension
campaign_type	campaign_type	The primary classification of a campaign based on its objective, e.g., awareness, consideration, or conversion.	dimension
clicks	clicks	The total number of times users clicked on an advertisement.	metric
combined_reach	combined_reach	The total unique audience exposed to an advertisement across all channels.	metric
contracted_media_spend	contracted_media_spend	The pre-agreed or contracted amount of money allocated for media spending.	metric
cost_per_1000_impressions_(cpm)	cost_per_1000_impressions_(cpm)	The cost incurred for one thousand views or impressions of an advertisement.	metric
cost_per_unit	cost_per_unit	The cost incurred for each unit of product sold or influenced by advertising.	metric
creative_version	creative_version	The specific version or variant of an ad creative used in a campaign.	dimension
ctr	ctr	The Click-Through Rate, calculated as the ratio of clicks to impressions.	metric
days_in_market	days_in_market	The number of days an advertising campaign has been actively running.	metric
days_remaining	days_remaining	The number of days left until the scheduled end of a campaign or flight.	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 ad, content, or message was displayed to a user.	metric
flight_category	flight_category	A categorization or grouping applied to a specific advertising campaign flight or period.	dimension
flight_duration	flight_duration	The total length of time, in days, that an advertising flight is scheduled to run.	metric
flight_end_date	flight_end_date	The scheduled end date for a specific advertising flight.	dimension
flight_id	flight_id	A unique identifier for an advertising flight.	dimension
flight_level_metrics.booked_impressions	flight_level_metrics.booked_impressions	The total number of impressions planned or reserved for a specific campaign flight.	metric
flight_level_metrics.budget	flight_level_metrics.budget	The financial budget specifically allocated for a particular campaign flight.	metric
flight_level_metrics.campaign_group	flight_level_metrics.campaign_group	The campaign group to which a specific advertising flight belongs.	metric
flight_level_metrics.clicks	flight_level_metrics.clicks	The total number of clicks recorded for a specific campaign flight.	metric
flight_level_metrics.combined_reach	flight_level_metrics.combined_reach	The total unique audience reached across all advertising channels for a specific campaign flight.	metric
flight_level_metrics.ctr	flight_level_metrics.ctr	The Click-Through Rate for a specific campaign flight, measuring the effectiveness of ad clicks relative to impressions.	metric
flight_level_metrics.daily_pacing	flight_level_metrics.daily_pacing	The daily progress of spend or impressions for a campaign flight relative to its planned schedule.	metric
flight_level_metrics.days_in_market	flight_level_metrics.days_in_market	The number of days a campaign flight has been live and active.	metric
flight_level_metrics.frequency	flight_level_metrics.frequency	The average number of times a unique user was exposed to an ad within a specific campaign flight.	metric
flight_level_metrics.impressions	flight_level_metrics.impressions	The total number of times an ad from a specific campaign flight was displayed.	metric
flight_level_metrics.influenced_orders	flight_level_metrics.influenced_orders	The number of orders attributed to the influence of a specific advertising flight.	metric
flight_level_metrics.influenced_sales	flight_level_metrics.influenced_sales	The sales revenue attributed to the influence of a specific advertising flight.	metric
flight_level_metrics.monthly_pacing	flight_level_metrics.monthly_pacing	The monthly progress of spend or impressions for a campaign flight relative to its planned schedule.	metric
flight_level_metrics.pacing_percentage	flight_level_metrics.pacing_percentage	The percentage of a campaign flight’s budget or impressions that has been delivered compared to the target.	metric
flight_level_metrics.roas	flight_level_metrics.roas	The Return on Ad Spend for a specific campaign flight, measuring its financial effectiveness.	metric
flight_revenue	flight_revenue	The total revenue generated as a result of a specific campaign flight.	metric
flight_start_date	flight_start_date	The scheduled start date for a specific advertising flight.	dimension
flight_status	flight_status	The current operational state of a campaign flight (e.g., active, paused, completed).	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 quantity of ad impressions yet to be delivered based on the booked amount.	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 total cost specifically related to media placements and advertising, which can be tracked and measured.	metric
media_channel	media_channel	The specific medium or channel through which advertising content is delivered (e.g., display, video, audio).	dimension
media_end_date	media_end_date	The calendar date on which a media campaign or placement is scheduled to conclude.	dimension
media_id	media_id	A unique identifier assigned to a specific media asset, campaign, or placement.	dimension
media_start_date	media_start_date	The calendar date on which a media campaign or placement is scheduled to begin.	dimension
no_of_days_left	no_of_days_left	The number of days remaining until the scheduled end date of an advertising campaign or flight.	metric
objective	objective	The primary goal or aim of an advertising campaign (e.g., brand awareness, consideration, conversion).	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
pacing_percentage	pacing_percentage	The percentage of a campaign’s budget or impressions that has been delivered compared to the target.	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	The financial return generated for every dollar spent on media advertising.	metric
roas	roas	Return on Ad Spend, a metric indicating the revenue generated for every dollar spent on advertising.	metric
search_type	search_type	The specific classification of a search advertisement, such as sponsored product or brand search.	dimension
social_engagements_(se)	social_engagements_(se)	The total number of interactions (e.g., likes, comments, shares) with social media advertisements.	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 that occurred in physical retail stores.	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 physical stores that can be attributed to advertising efforts.	metric
tactic_type	tactic_type	The specific method or approach used in advertising, such as programmatic display or sponsored search.	dimension
targeting_type	targeting_type	The specific methodology or criteria used to select and reach a target audience for an ad 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 overall percentage of users who completed a desired action (conversion) out of the total audience reached.	metric
total_impressions	total_impressions	The cumulative count of times an advertisement was displayed across its entire campaign duration.	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 total amount of financial resources expended on an advertising campaign.	metric
total_units	total_units	The aggregate number of product units sold, combining both online and in-store quantities.	metric
video_100	video_100	The number of times a video ad was watched to 100% completion.	metric
video_25	video_25	The number of times a video ad was watched to at least 25% completion.	metric
video_50	video_50	The number of times a video ad was watched to at least 50% completion.	metric
video_75	video_75	The number of times a video ad was watched to at least 75% completion.	metric
video_average_watch_time	video_average_watch_time	The average duration, in seconds, that users watched a video advertisement.	metric
video_plays	video_plays	The total number of times a video ad or content was initiated.	metric
watch_time_seconds	watch_time_seconds	The cumulative total time, measured in seconds, that users spent watching video content.	metric