Oneview: Most-used fields#
The table below gives information about most-used fields that you can import from Oneview. 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.
activity_transaction_price Dimension
The price associated with a specific transaction activity within the advertising platform.
advertiser Dimension
Represents the advertiser associated with the campaign data.
advertiser_uid Dimension
The unique identifier for the advertiser.
agency Dimension
Represents the agency managing the advertising campaigns.
agency_group Dimension
Represents the group to which the agency belongs.
agency_group_uid Dimension
The unique identifier for the agency group.
agency_uid Dimension
The unique identifier for the agency.
algorithm Dimension
The specific algorithm or bidding strategy used for campaign optimization.
app Dimension
The mobile application where the ad was displayed.
audience Dimension
The audience segment targeted by the ad campaign.
billable_add_on_costs Metric
Additional costs incurred that are billable to the advertiser, beyond media spend.
billable_media_spend Metric
The portion of media spend that is billable to the advertiser.
billable_total_spend Metric
The total amount of billable spend, including media and add-on costs.
browser Dimension
The web browser used on the device where the ad was served.
campaign Dimension
Represents the advertising campaign.
campaign_7day_pacing Metric
The pacing of spend for a campaign over the last 7 days, indicating how it aligns with its budget goals.
campaign_7day_spend Metric
The total amount of money spent on a campaign over the past 7 days.
campaign_7day_spend_rate Metric
The rate at which the budget is being spent for a campaign over the past 7 days.
campaign_actions Metric
The total number of actions recorded for the campaign.
campaign_budget Metric
The total budget allocated for the advertising campaign.
campaign_click_actions Metric
The number of actions attributed to clicks on the campaign.
campaign_click_hh_conversion Metric
Conversions attributed to a click event at the household level for a specific advertising campaign.
campaign_click_hh_conversions Dimension
The number of household conversions attributed to clicks on the campaign.
campaign_click_id_conversions Metric
The number of ID-based conversions attributed to clicks on the campaign.
campaign_clicks Metric
The total number of clicks recorded for the campaign.
campaign_cpa_goal Metric
The Cost Per Action (CPA) goal set for the advertising campaign.
campaign_cpm_target Metric
The Cost Per Mille (CPM) or cost per thousand impressions target set for the advertising campaign.
campaign_currency_uid Dimension
A unique identifier for the currency used in the campaign.
campaign_days_remaining Metric
The number of days remaining until the campaign concludes.
campaign_end_time_ctz Dimension
The end date and time of the advertising campaign, specified in the campaign's timezone.
campaign_impression_cap Metric
The maximum number of impressions allowed for the entire advertising campaign.
campaign_spend_through_yesterday Metric
The cumulative spend for the campaign up to and including yesterday.
campaign_start_time_ctz Dimension
The start date and time of the advertising campaign, specified in the campaign's timezone.
campaign_total_actions Metric
The total number of actions across all types for the campaign.
campaign_total_hh_conversions Metric
The total number of household conversions for the campaign.
campaign_total_id_conversions Metric
The total number of ID-based conversions for the campaign.
campaign_uid Dimension
The unique identifier for the campaign.
campaign_view_actions Metric
The number of actions attributed to views of the campaign.
campaign_view_hh_conversions Metric
The number of household conversions attributed to views of the campaign.
campaign_view_id_conversions Metric
The number of ID-based conversions attributed to views of the campaign.
campaign_yesterday_pacing Metric
The pacing of spend for a campaign for yesterday, indicating how it aligned with its daily budget goals.
campaign_yesterday_spend Metric
The total amount of money spent on an advertising campaign for yesterday.
country Dimension
The country where the ad impression occurred.
cpa Metric
The Cost Per Action, calculated as total spend divided by the number of actions.
cpc Metric
The Cost Per Click, calculated as total spend divided by the number of clicks.
cpm Metric
The Cost Per Mille (CPM) or cost per thousand impressions.
creative_duration Dimension
The duration of the creative content.
creative_format Dimension
The format of the creative (e.g., video, image).
creative_media_type Dimension
The type of media used for the creative, such as display, video, or native.
creative_size Dimension
The size specifications of the creative.
creative_type Dimension
The type of creative used in the campaign.
ctr Metric
The Click-Through Rate, calculated as clicks divided by impressions, indicating the effectiveness of an ad.
data_spend Metric
The cost associated with using third-party data for targeting.
date Dimension
The specific date for which the data is reported.
deal Dimension
Represents the advertising deal.
deal_id Dimension
The unique identifier for the advertising deal.
device_carrier Dimension
The mobile carrier of the device on which the ad was served.
device_connection_type Dimension
The type of internet connection used by the device, e.g., Wi-Fi, cellular (4G, 5G).
device_environment Dimension
The environment of the device where the ad was shown, such as mobile app or mobile web.
device_frequency Metric
The average number of times an ad was shown to a unique device.
device_os Dimension
The operating system of the device where the ad was served.
device_reach Metric
The total number of unique devices that saw an ad.
device_type Dimension
The type of device on which the ad was displayed, e.g., mobile, tablet, desktop, CTV.
device_vendor Dimension
The manufacturer or vendor of the device where the ad was displayed.
domain Dimension
The domain name of the website where the ad impression occurred.
exchange Dimension
The ad exchange where the impression was bought.
exchange_app_id Dimension
The unique identifier for the mobile application within the ad exchange where the ad was served.
exchange_publisher_id Dimension
The unique identifier for the publisher within the ad exchange.
exchange_site_id Dimension
The unique identifier for the website within the ad exchange where the ad was served.
flight Dimension
Represents an advertising flight within a campaign.
flight_7day_pacing Metric
The rate at which ad impressions or spend is being delivered for an advertising flight over a 7-day period, indicating performance against planned goals.
flight_7day_spend_rate Metric
The average daily rate of ad spend for a specific advertising flight over the past 7 days.
flight_budget Metric
The total budget allocated for a specific ad flight.
flight_ctr_goal Metric
The Click-Through Rate (CTR) goal set for a specific ad flight.
flight_days_remaining Metric
The number of days remaining until the ad flight concludes.
flight_end_time_ctz Dimension
The end date and time of the ad flight, specified in the campaign's timezone.
flight_ideal_spend Metric
The ideal amount that should have been spent on the ad flight by a given point in time, based on pacing.
flight_impression_cap Metric
The maximum number of impressions allowed for a specific ad flight.
flight_past_7_day_spend Metric
The total monetary amount spent on a specific advertising flight over the last 7 days.
flight_projected_budget_remaining_7day Metric
The estimated remaining budget for an advertising flight, projected over the next 7 days based on current pacing.
flight_spend_through_yesterday Metric
The cumulative spend for the ad flight up to and including yesterday.
flight_start_time_ctz Dimension
The start date and time of the ad flight, specified in the campaign's timezone.
flight_uid Dimension
The unique identifier for the advertising flight.
flight_yesterday_pacing Metric
The pacing of spend for an ad flight for yesterday, indicating how it aligned with its daily budget goals.
flight_yesterday_spend Metric
The total monetary amount spent on a specific advertising flight during the previous day.
hour Dimension
The hour of the day when the activity occurred.
household_frequency Metric
The average number of times an ad was shown to a unique household.
household_impressions Metric
The total number of impressions delivered to unique households.
household_reach Metric
The total number of unique households that saw an ad.
impressions Metric
The total number of times an ad was displayed.
media_plan Dimension
The name or identifier of the media plan.
media_plan_uid Dimension
A unique identifier for the media plan.
mediaplan_actions Metric
The total number of conversion actions attributed to the media plan.
mediaplan_click_actions Metric
The total number of conversion actions attributed to clicks on ads within the media plan.
mediaplan_click_hh_conversion Metric
Conversions attributed to a click event at the household level across an entire mediaplan.
mediaplan_click_id_conversions Metric
Conversions attributed to a click event, identified at an individual user level, across an entire mediaplan.
mediaplan_clicks Metric
The total number of clicks recorded for ads within the media plan.
mediaplan_total_actions Metric
The sum of all conversion actions across the media plan.
mediaplan_total_hh_conversions Metric
The total number of conversions recorded at the household level for an entire mediaplan, regardless of attribution method.
mediaplan_total_id_conversions Metric
The total number of conversions recorded at an individual user level for an entire mediaplan, regardless of attribution method.
mediaplan_view_actions Metric
The total number of conversion actions attributed to impressions (views) of ads within the media plan.
mediaplan_view_id_conversions Metric
Conversions attributed to an ad view (impression), identified at an individual user level, across an entire mediaplan.
metrocode Dimension
The designated market area (DMA) or metro code associated with the ad impression.
month Dimension
The month when the activity occurred.
postal_code Dimension
The postal code associated with the geographic location of the ad impression.
quarter Dimension
The quarter of the year when the activity occurred.
region Dimension
The geographic region or state where the ad impression occurred.
schedule_budget Metric
The total budget allocated for a specific advertising schedule.
schedule_end_time_ctz Dimension
The end date and time of the advertising schedule, specified in the campaign's timezone.
schedule_start_time_ctz Dimension
The start date and time of the advertising schedule, specified in the campaign's timezone.
tactic Dimension
Represents the specific advertising tactic used.
tactic_budget Metric
The total budget allocated for a specific advertising tactic.
tactic_impression_cap Metric
The maximum number of impressions allowed for a specific advertising tactic.
tactic_uid Dimension
The unique identifier for the advertising tactic.
total_spend Metric
The total amount of money spent on advertising.
unbillable_add_on_costs Metric
Additional costs incurred that are not billable to the advertiser.
unbillable_media_spend Metric
The portion of media spend that is not billable to the advertiser.
unbillable_total_spend Metric
The total amount of non-billable spend, including media and add-on costs.
user_local_day Dimension
The day of the week based on the user's local timezone.
user_local_dt Dimension
The date and time of the activity based on the user's local timezone.
user_local_hour Dimension
The hour of the day based on the user's local timezone.
vcr Metric
The Video Completion Rate, calculated as video completes divided by video starts.
video_complete_count Metric
The number of times a video ad played to 100% completion.
video_midpoint_count Metric
The number of times a video ad played to its midpoint (50% completion).
video_one_quarter_count Metric
The number of times a video ad played to 25% completion.
video_start_count Metric
The number of times a video ad began playing.
video_three_quarter_count Metric
The number of times a video ad played to 75% completion.
week Dimension
The week of the year when the activity occurred.
year Dimension
The year when the activity occurred.