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.
account_id Dimension
A unique identifier for the business partner or advertiser account.
actualized_media_spend Metric
The actual amount of money spent on advertising media campaigns.
actualized_vendor_spend Metric
The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.
ad_format Dimension
The specific format of the advertisement used in a campaign, such as video, display, or native.
adjusted_actualized_media_spend Metric
The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.
adjusted_actualized_spend Metric
The actual amount of money spent on a campaign or placement, considering any adjustments or recalculations.
booked_impressions Metric
The number of advertising impressions that were planned or reserved for a campaign.
bp_id Dimension
A unique identifier for the Business Partner, scoping all interactions.
budget Dimension
The allocated financial resources for an advertising campaign or a specific flight.
campaign_group Dimension
A classification or grouping applied to advertising campaigns for organizational and reporting purposes.
campaign_id Dimension
A unique identifier for an advertising campaign or flight within the Roundel platform.
campaign_platform Dimension
The primary platform or specific environment where an advertising campaign is executed.
campaign_type Dimension
The specific type of advertising campaign being run, such as Target Product Ads (TPAs) or Precision Plus.
clicks Metric
The total number of times users clicked on an advertisement.
combined_reach Metric
The total number of unique users exposed to an advertising flight across all included channels or platforms.
contracted_media_spend Metric
The amount of money formally agreed upon in a contract for advertising media spending.
creative_id Dimension
A unique identifier for a specific ad creative asset used in an advertising campaign.
ctr Metric
The click-through rate, representing the percentage of people who clicked on an ad after seeing it.
days_in_market Metric
The number of days an advertising flight has been active since its launch date.
days_remaining Metric
The number of days remaining until the scheduled conclusion date of an advertising campaign or its components.
email_bounces Metric
The total number of emails that could not be successfully delivered to the intended recipients, often indicating invalid addresses or temporary delivery issues.
email_opens Metric
The total number of times emails sent as part of a campaign were opened by recipients, reflecting engagement with the email content.
email_sends Metric
The total number of emails dispatched or sent out as part of an advertising or marketing campaign.
end_date Dimension
The scheduled conclusion date for an advertising campaign or its components.
event_day Dimension
The specific calendar day on which a particular event or metric occurred.
exposures Metric
The total number of times an advertisement was displayed or presented to users, also known as impressions.
flight_category Dimension
The category or type associated with an advertising flight. An advertising flight is a specific period an ad campaign runs.
flight_duration Dimension
The length of time, or duration, that an advertising campaign (often referred to as a 'flight') is scheduled to run or has been active.
flight_end_date Dimension
The scheduled conclusion date for an advertising campaign component or flight.
flight_id Dimension
A unique identifier for an advertising flight.
flight_level_metrics.actualized_vendor_spend Dimension
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.
flight_level_metrics.booked_impressions Dimension
The total number of ad impressions that were planned or reserved for a specific advertising flight.
flight_level_metrics.budget Dimension
The allocated financial resources for a specific advertising flight.
flight_level_metrics.campaign_group Dimension
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.
flight_level_metrics.clicks Dimension
The total number of times users clicked on advertisements within a specific advertising flight.
flight_level_metrics.combined_reach Dimension
The total number of unique users exposed to an advertising flight across all included channels or platforms.
flight_level_metrics.ctr Dimension
The Click-Through Rate for a specific advertising flight.
flight_level_metrics.daily_pacing Dimension
A metric indicating how an advertising flight's budget or impressions are being consumed on a daily basis relative to its schedule.
flight_level_metrics.days_in_market Dimension
The number of days an advertising flight has been active since its launch date.
flight_level_metrics.frequency Dimension
The average number of times a unique user was exposed to advertisements within a specific advertising flight.
flight_level_metrics.impressions Dimension
The total number of times advertisements within a specific advertising flight were displayed to users.
flight_level_metrics.influenced_orders Dimension
The total number of orders (online and/or in-store) attributed to the influence of a specific advertising flight.
flight_level_metrics.influenced_sales Dimension
The total sales revenue (online and/or in-store) attributed to the influence of a specific advertising flight.
flight_level_metrics.monthly_pacing Dimension
A metric indicating how an advertising flight's budget or impressions are being consumed on a monthly basis relative to its schedule.
flight_level_metrics.pacing_percentage Dimension
A metric indicating how closely a specific advertising flight's spend is aligning with its budget over a given period.
flight_level_metrics.roas Dimension
Return on Ad Spend for a specific advertising flight.
flight_revenue Dimension
The total revenue generated that is attributed to an advertising flight, combining sales from both online and in-store purchases.
flight_start_date Dimension
The scheduled commencement date for an advertising campaign component or flight.
flight_status Dimension
The current state of an advertising flight, indicating whether it is active, paused, completed, or in another defined state.
frequency Metric
The average number of times a unique user was exposed to an advertisement.
impressions Metric
The total number of times an advertisement was displayed.
impressions_remaining Metric
The number of advertising impressions still required to reach a campaign's target or booked goal.
influenced_online_orders Metric
The number of online orders attributed to the influence of the advertising campaign.
influenced_online_sales Metric
The online sales revenue attributed to the influence of the advertising campaign.
influenced_online_units Metric
The number of online product units sold that were influenced by the advertising campaign.
influenced_orders Metric
The total number of orders (online and/or in-store) attributed to the influence of the advertising campaign.
influenced_sales Metric
The total sales revenue (online and/or in-store) attributed to the influence of the advertising campaign.
influenced_store_orders Metric
The number of in-store orders attributed to the influence of the advertising campaign.
influenced_store_sales Metric
The in-store sales revenue attributed to the influence of the advertising campaign.
influenced_store_units Metric
The number of in-store product units sold that were influenced by the advertising campaign.
influenced_units Metric
The total number of product units sold (online and/or in-store) attributed to the influence of the advertising campaign.
is_google_search_campaign Dimension
Indicates whether the advertising campaign is specifically a Google Search campaign integrated with the Roundel platform.
measurable_cost Metric
The quantifiable expenses associated with an advertising campaign or specific ad activity.
measurable_media_cost Metric
The quantifiable expenses associated with a specific advertising campaign or ad activity that can be tracked and reported.
media_channel Dimension
The type of channel through which the advertising media is delivered, such as display, video, search, or social.
media_id Dimension
A unique identifier for a specific media placement or asset within an advertising campaign.
month Dimension
The calendar month associated with the reported data for a campaign.
no_of_days_left Dimension
The number of days remaining until the scheduled conclusion date of an advertising campaign or its components.
objective Dimension
The primary goal of an advertising campaign, such as driving awareness, consideration, or sales.
online_orders Metric
The total number of orders placed through online channels.
online_sales Metric
The total revenue generated from sales made through online channels.
online_units Metric
The total number of product units sold through online channels.
platform_name Dimension
The name of the advertising platform or channel where the campaign or media is running (e.g., Target.com, Mobile App, Google, Social Media).
platform_names Dimension
The names of the advertising platforms or channels where the campaign media is displayed (e.g., Target.com, Target app, Pinterest, Google Search).
return_on_media_spend Metric
A key performance indicator that measures the revenue generated for every dollar spent on advertising media.
roas Metric
Return on Ad Spend, a metric that measures the revenue generated for each dollar spent on advertising.
start_date Dimension
The scheduled commencement date for an advertising campaign or its components.
store_sales Metric
The total revenue generated from sales occurring in physical retail stores.
store_trans Metric
The number of transactions or purchases made in physical stores that are attributed to an advertising campaign.
store_units Metric
The total number of product units sold in physical retail stores.
store_visits Metric
The number of visits to a physical store that are attributed to an advertising campaign.
targeting_type Dimension
The specific method or criteria used to define and reach the target audience for an advertising campaign.
tcin Metric
The Target Commerce Item Number, a unique identifier for products sold at Target.
total_conversion_rate Metric
The percentage of users who complete a desired action, such as a purchase or sign-up, after interacting with an advertisement.
total_impressions Dimension
The total number of times an advertisement was displayed to users.
total_orders Metric
The aggregate number of orders, combining both online and in-store purchases.
total_sales Metric
The aggregate revenue generated from sales, combining both online and in-store figures.
total_spend Dimension
The cumulative monetary amount spent on an advertising campaign.
total_units Metric
The aggregate number of product units sold, combining both online and in-store quantities.
vendor_cost Metric
The actual amount of money spent with a vendor for a campaign or placement, considering any adjustments or recalculations.
video_100 Metric
The number of times a video advertisement was viewed completely from beginning to end.
video_25 Metric
The number of times a video advertisement was viewed up to 25% of its total duration.
video_50 Metric
The number of times a video advertisement was viewed up to 50% of its total duration.
video_75 Metric
The number of times a video advertisement was viewed up to 75% of its total duration.
video_average_watch_time Metric
The average amount of time, in seconds, that users spent watching a video advertisement.
video_plays Metric
The total number of times a video advertisement was initiated or started playing.
watch_time_seconds Metric
The total cumulative time, measured in seconds, that users spent watching video advertising content.
year Metric
The calendar year associated with the reported data for a campaign.