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 |
The expenses associated with an advertising campaign or activity that are directly linked to a specific outcome or conversion. |
metric |
audience |
audience |
The specific group of consumers selected and targeted for an advertising campaign based on certain criteria, often leveraging Target’s 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. |
dimension |
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 |
metric |
|
ctr |
ctr |
The Click-Through Rate, calculated as the number of clicks an advertisement receives divided by the number of impressions it generates. |
metric |
days_in_market |
days_in_market |
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 audience member was exposed to an advertisement. |
metric |
flight_category |
flight_category |
A classification or grouping for an advertising flight, used to categorize different ad placements or campaign components. |
dimension |
flight_duration |
flight_duration |
The total length of time, typically in days, that an advertising flight is scheduled to run. |
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. |
metric |
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. |
metric |
flight_level_metrics.budget |
flight_level_metrics.budget |
The allocated financial resources for a specific advertising flight. |
metric |
flight_level_metrics.campaign_group |
flight_level_metrics.campaign_group |
A grouping or categorization of related advertising campaigns, allowing for aggregated reporting and analysis at a higher level than individual campaigns. |
dimension |
flight_level_metrics.clicks |
flight_level_metrics.clicks |
The total number of times users clicked on advertisements within a specific advertising flight. |
metric |
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. |
metric |
flight_level_metrics.ctr |
flight_level_metrics.ctr |
The Click-Through Rate for a specific advertising flight. |
metric |
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. |
metric |
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. |
metric |
flight_level_metrics.impressions |
flight_level_metrics.impressions |
The total number of times advertisements within a specific advertising flight were displayed to users. |
metric |
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. |
metric |
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. |
metric |
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. |
metric |
flight_level_metrics.roas |
flight_level_metrics.roas |
Return on Ad Spend for a specific advertising flight. |
metric |
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 |
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 medium through which an advertisement is delivered, such as display, video, search, or social media. |
dimension |
media_id |
media_id |
dimension |
|
no_of_days_left |
no_of_days_left |
The remaining number of days until an advertising flight is scheduled to conclude. |
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 |
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 category or type of search advertisement, such as sponsored product ads or general search ads. |
dimension |
social_engagements_(se) |
social_engagements_(se) |
The total number of interactions users have with social media advertisements, including likes, shares, comments, and clicks. |
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 |
targeting_type |
targeting_type |
The specific methodology or criteria used to define and reach a 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 |
metric |
|
total_impressions |
total_impressions |
The total number of times an advertisement was displayed to users. |
dimension |
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 on media for a campaign or placement, considering any adjustments or recalculations. |
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 |
metric |
|
video_plays |
video_plays |
The total number of times a video advertisement or content was initiated. |
metric |
watch_time_seconds |
watch_time_seconds |
metric |