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_idDimension
A unique identifier for the business partner or advertiser account.
actualized_media_spendMetric
The actual amount of money spent on advertising media campaigns.
actualized_vendor_spendMetric
The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.
ad_formatDimension
The specific format of the advertisement used in a campaign, such as video, display, or native.
adjusted_actualized_media_spendMetric
The actual amount of money spent on media for a campaign or placement, considering any adjustments or recalculations.
adjusted_actualized_spendMetric
The actual amount of money spent on a campaign or placement, considering any adjustments or recalculations.
booked_impressionsMetric
The number of advertising impressions that were planned or reserved for a campaign.
bp_idDimension
A unique identifier for the Business Partner, scoping all interactions.
budgetMetric
The allocated financial resources for an advertising campaign or a specific flight.
campaign_groupDimension
A classification or grouping applied to advertising campaigns for organizational and reporting purposes.
campaign_idDimension
A unique identifier for an advertising campaign or flight within the Roundel platform.
campaign_typeDimension
The specific type of advertising campaign being run, such as Target Product Ads (TPAs) or Precision Plus.
clicksMetric
The total number of times users clicked on an advertisement.
combined_reachMetric
The total number of unique users exposed to an advertising flight across all included channels or platforms.
contracted_media_spendMetric
The amount of money formally agreed upon in a contract for advertising media spending.
creative_idDimension
A unique identifier for a specific ad creative asset used in an advertising campaign.
ctrMetric
The click-through rate, representing the percentage of people who clicked on an ad after seeing it.
days_in_marketMetric
The number of days an advertising flight has been active since its launch date.
days_remainingMetric
The number of days remaining until the scheduled conclusion date of an advertising campaign or its components.
email_bouncesMetric
The total count of emails that were undeliverable to recipients in an advertising or marketing campaign, indicating delivery failures.
email_opensMetric
The total number of times emails sent as part of a campaign were opened by recipients, reflecting engagement with the email content.
email_sendsMetric
The total number of emails dispatched or sent out as part of an advertising or marketing campaign.
end_dateDimension
The scheduled conclusion date for an advertising campaign or its components.
event_dayDimension
The specific calendar day on which a particular event or metric occurred.
exposuresMetric
The total number of times an advertisement was displayed or presented to users, also known as impressions.
flight_categoryDimension
The category or type associated with an advertising flight. An advertising flight is a specific period an ad campaign runs.
flight_durationDimension
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_dateDimension
The scheduled conclusion date for an advertising campaign component or flight.
flight_idDimension
A unique identifier for an advertising flight.
flight_level_metrics.actualized_vendor_spendDimension
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_impressionsDimension
The total number of ad impressions that were planned or reserved for a specific advertising flight.
flight_level_metrics.budgetDimension
The allocated financial resources for a specific advertising flight.
flight_level_metrics.campaign_groupDimension
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.clicksDimension
The total number of times users clicked on advertisements within a specific advertising flight.
flight_level_metrics.combined_reachDimension
The total number of unique users exposed to an advertising flight across all included channels or platforms.
flight_level_metrics.ctrDimension
The Click-Through Rate for a specific advertising flight.
flight_level_metrics.daily_pacingDimension
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_marketDimension
The number of days an advertising flight has been active since its launch date.
flight_level_metrics.frequencyDimension
The average number of times a unique user was exposed to advertisements within a specific advertising flight.
flight_level_metrics.impressionsDimension
The total number of times advertisements within a specific advertising flight were displayed to users.
flight_level_metrics.influenced_ordersDimension
The total number of orders (online and/or in-store) attributed to the influence of a specific advertising flight.
flight_level_metrics.influenced_salesDimension
The total sales revenue (online and/or in-store) attributed to the influence of a specific advertising flight.
flight_level_metrics.monthly_pacingDimension
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_percentageDimension
A metric indicating how closely a specific advertising flight's spend is aligning with its budget over a given period.
flight_level_metrics.roasDimension
Return on Ad Spend for a specific advertising flight.
flight_revenueDimension
The total revenue generated that is attributed to an advertising flight, combining sales from both online and in-store purchases.
flight_start_dateDimension
The scheduled commencement date for an advertising campaign component or flight.
flight_statusDimension
The current state of an advertising flight, indicating whether it is active, paused, completed, or in another defined state.
frequencyMetric
The average number of times a unique user was exposed to an advertisement.
impressionsMetric
The total number of times an advertisement was displayed.
impressions_remainingMetric
The number of advertising impressions still required to reach a campaign's target or booked goal.
influenced_online_ordersMetric
The number of online orders attributed to the influence of the advertising campaign.
influenced_online_salesMetric
The online sales revenue attributed to the influence of the advertising campaign.
influenced_online_unitsMetric
The number of online product units sold that were influenced by the advertising campaign.
influenced_ordersMetric
The total number of orders (online and/or in-store) attributed to the influence of the advertising campaign.
influenced_salesMetric
The total sales revenue (online and/or in-store) attributed to the influence of the advertising campaign.
influenced_store_ordersMetric
The number of in-store orders attributed to the influence of the advertising campaign.
influenced_store_salesMetric
The in-store sales revenue attributed to the influence of the advertising campaign.
influenced_store_unitsMetric
The number of in-store product units sold that were influenced by the advertising campaign.
influenced_unitsMetric
The total number of product units sold (online and/or in-store) attributed to the influence of the advertising campaign.
measurable_costMetric
The quantifiable expenses associated with an advertising campaign or specific ad activity.
measurable_media_costMetric
The quantifiable expenses associated with a specific advertising campaign or ad activity that can be tracked and reported.
media_channelDimension
The type of channel through which the advertising media is delivered, such as display, video, search, or social.
media_idDimension
A unique identifier for an individual media asset, ad creative, or product item associated with an advertising campaign.
monthDimension
The calendar month associated with the reported data for a campaign.
no_of_days_leftDimension
The number of days remaining until the scheduled conclusion date of an advertising campaign or its components.
objectiveDimension
The primary goal of an advertising campaign, such as driving awareness, consideration, or sales.
online_ordersMetric
The total number of orders placed through online channels.
online_salesMetric
The total revenue generated from sales made through online channels.
online_unitsMetric
The total number of product units sold through online channels.
platform_nameDimension
The name of the advertising platform or channel where the campaign or media is running (e.g., Target.com, Mobile App, Google, Social Media).
return_on_media_spendMetric
A key performance indicator that measures the revenue generated for every dollar spent on advertising media.
roasMetric
Return on Ad Spend, a metric that measures the revenue generated for each dollar spent on advertising.
start_dateDimension
The scheduled commencement date for an advertising campaign or its components.
store_salesMetric
The total revenue generated from sales occurring in physical retail stores.
store_transMetric
The number of transactions or purchases made in physical stores that are attributed to an advertising campaign.
store_unitsMetric
The total number of product units sold in physical retail stores.
store_visitsMetric
The number of visits to a physical store that are attributed to an advertising campaign.
targeting_typeDimension
The specific method or criteria used to define and reach the target audience for an advertising campaign.
tcinMetric
The Target Commerce Item Number, a unique identifier for products sold at Target.
total_conversion_rateMetric
The percentage of users who complete a desired action, such as a purchase or sign-up, after interacting with an advertisement.
total_impressionsMetric
The total number of times an advertisement was displayed to users.
total_ordersMetric
The aggregate number of orders, combining both online and in-store purchases.
total_salesMetric
The aggregate revenue generated from sales, combining both online and in-store figures.
total_spendDimension
The cumulative monetary amount spent on an advertising campaign.
total_unitsMetric
The aggregate number of product units sold, combining both online and in-store quantities.
vendor_costMetric
The actual amount of money spent with a vendor for a campaign or placement, considering any adjustments or recalculations.
video_100Metric
The number of times a video advertisement was viewed completely from beginning to end.
video_25Metric
The number of times a video advertisement was viewed up to 25% of its total duration.
video_50Metric
The number of times a video advertisement was viewed up to 50% of its total duration.
video_75Metric
The number of times a video advertisement was viewed up to 75% of its total duration.
video_average_watch_timeMetric
The average amount of time, in seconds, that users spent watching a video advertisement.
video_playsMetric
The total number of times a video advertisement was initiated or started playing.
watch_time_secondsMetric
The total cumulative time, measured in seconds, that users spent watching video advertising content.
yearMetric
The calendar year associated with the reported data for a campaign.