Roundel: Most-used fields

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