Skip to content
Book a demo

Connect documentation

All documentation
Documentation

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.

FieldAdverity UI nameType
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.