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

metric

audience

audience

Information about the target audience segments leveraged for advertising campaigns, potentially including custom audiences based on 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.

metric

campaign_group

campaign_group

The identifier or name for a collection of related advertising campaigns.

dimension

campaign_type

campaign_type

The categorization of an advertising campaign, such as sponsored product ads, display, or video.

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.

dimension

days_in_market

days_in_market

The number of days an advertising campaign or flight has been active.

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 users were exposed to an advertisement.

metric

flight_category

flight_category

dimension

flight_duration

flight_duration

metric

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.booked_impressions

flight_level_metrics.booked_impressions

The total number of ad impressions that were planned or reserved for a specific advertising flight.

dimension

flight_level_metrics.budget

flight_level_metrics.budget

The allocated financial resources for a specific advertising flight.

dimension

flight_level_metrics.campaign_group

flight_level_metrics.campaign_group

The identifier or name for a collection of related advertising campaigns to which a specific flight belongs.

dimension

flight_level_metrics.clicks

flight_level_metrics.clicks

The total number of times users clicked on advertisements within a specific advertising flight.

dimension

flight_level_metrics.combined_reach

flight_level_metrics.combined_reach

dimension

flight_level_metrics.ctr

flight_level_metrics.ctr

The Click-Through Rate for a specific advertising flight.

dimension

flight_level_metrics.daily_pacing

flight_level_metrics.daily_pacing

The daily progress of an advertising flight’s spend relative to its daily budget.

dimension

flight_level_metrics.days_in_market

flight_level_metrics.days_in_market

The number of days a specific advertising flight has been active.

dimension

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.

dimension

flight_level_metrics.impressions

flight_level_metrics.impressions

The total number of times advertisements within a specific advertising flight were displayed to users.

dimension

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.

dimension

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.

dimension

flight_level_metrics.monthly_pacing

flight_level_metrics.monthly_pacing

The monthly progress of an advertising flight’s spend relative to its monthly budget.

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.

dimension

flight_level_metrics.roas

flight_level_metrics.roas

Return on Ad Spend for a specific advertising flight.

dimension

flight_revenue

flight_revenue

The total revenue generated from sales attributed to a specific advertising flight.

metric

flight_start_date

flight_start_date

The scheduled commencement date for an advertising campaign component or flight.

dimension

flight_status

flight_status

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 channel where an advertising campaign is running (e.g., Target.com, Mobile App, Google, Social Media).

dimension

media_id

media_id

dimension

no_of_days_left

no_of_days_left

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

A metric indicating how closely an ad campaign’s spend is aligning with its budget over a given period.

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 specific type of search advertisement, such as sponsored search or product listing ads.

dimension

social_engagements_(se)

social_engagements_(se)

The total number of interactions with social media advertisements, including clicks and shares.

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, influenced by advertising efforts.

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 select and reach a target audience for an ad campaign.

dimension

tcin

tcin

The Target Commerce Item Number, a unique identifier for products sold at Target.

metric

total_conversion_rate

total_conversion_rate

The percentage of ad interactions that result in a desired action, such as a purchase or sign-up.

metric

total_impressions

total_impressions

The total number of times an advertisement was displayed to users.

metric

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.

metric

total_units

total_units

The aggregate number of product units sold, combining both online and in-store quantities.

metric

vendor_cost

vendor_cost

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

The average duration, in seconds, that users spent watching a video advertisement.

metric

video_plays

video_plays

The total number of times a video advertisement or content was initiated.

metric

watch_time_seconds

watch_time_seconds

The cumulative time, in seconds, that users spent watching video advertisements.

metric