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.

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