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 |
adjusted_actualized_spend |
adjusted_actualized_spend |
The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations. |
metric |
attributed_cost |
attributed_cost |
metric |
|
audience |
audience |
Information about the target audience segments leveraged for advertising campaigns, potentially including custom audiences based on first-party data. |
dimension |
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 allocated financial resources for an advertising campaign or a specific flight. |
metric |
campaign_group |
campaign_group |
The identifier or name for a collection of related advertising campaigns. |
dimension |
campaign_type |
campaign_type |
The categorization of an advertising campaign, such as sponsored product ads, display, or video. |
dimension |
clicks |
clicks |
The total number of times users clicked on an advertisement. |
metric |
combined_reach |
combined_reach |
metric |
|
ctr |
ctr |
The Click-Through Rate, calculated as the number of clicks an advertisement receives divided by the number of impressions it generates. |
dimension |
days_in_market |
days_in_market |
The number of days an advertising campaign or flight has been active. |
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 users were exposed to an advertisement. |
metric |
flight_category |
flight_category |
dimension |
|
flight_duration |
flight_duration |
metric |
|
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.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 |
The identifier or name for a collection of related advertising campaigns to which a specific flight belongs. |
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 |
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 |
The daily progress of an advertising flight’s spend relative to its daily budget. |
dimension |
flight_level_metrics.days_in_market |
flight_level_metrics.days_in_market |
The number of days a specific advertising flight has been active. |
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 |
The monthly progress of an advertising flight’s spend relative to its monthly budget. |
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 from sales attributed to a specific advertising flight. |
metric |
flight_start_date |
flight_start_date |
The scheduled commencement date for an advertising campaign component or flight. |
dimension |
flight_status |
flight_status |
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 |
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 |
media_channel |
media_channel |
The specific platform or channel where an advertising campaign is running (e.g., Target.com, Mobile App, Google, Social Media). |
dimension |
media_id |
media_id |
dimension |
|
no_of_days_left |
no_of_days_left |
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 |
pacing_percentage |
pacing_percentage |
A metric indicating how closely an ad campaign’s spend is aligning with its budget over a given period. |
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 revenue generated for each dollar spent on media advertising, also known as ROAS. |
metric |
roas |
roas |
Return on Ad Spend, a metric that measures the revenue generated for each dollar spent on advertising. |
metric |
search_type |
search_type |
The specific type of search advertisement, such as sponsored search or product listing ads. |
dimension |
social_engagements_(se) |
social_engagements_(se) |
The total number of interactions with social media advertisements, including clicks and shares. |
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, influenced by advertising efforts. |
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 |
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 percentage of ad interactions that result in a desired action, such as a purchase or sign-up. |
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. |
metric |
total_units |
total_units |
The aggregate number of product units sold, combining both online and in-store quantities. |
metric |
vendor_cost |
vendor_cost |
metric |
|
video_100 |
video_100 |
The number of times a video advertisement was watched to 100% completion. |
metric |
video_25 |
video_25 |
The number of times a video advertisement was watched to at least 25% completion. |
metric |
video_50 |
video_50 |
The number of times a video advertisement was watched to at least 50% completion. |
metric |
video_75 |
video_75 |
The number of times a video advertisement was watched to at least 75% completion. |
metric |
video_average_watch_time |
video_average_watch_time |
The average duration, in seconds, that users spent watching a video advertisement. |
metric |
video_plays |
video_plays |
The total number of times a video advertisement or content was initiated. |
metric |
watch_time_seconds |
watch_time_seconds |
The cumulative time, in seconds, that users spent watching video advertisements. |
metric |