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_priceDimension
The price associated with a specific transaction activity within the advertising platform.
advertiserDimension
Represents the advertiser associated with the campaign data.
advertiser_uidDimension
The unique identifier for the advertiser.
agencyDimension
Represents the agency managing the advertising campaigns.
agency_groupDimension
Represents the group to which the agency belongs.
agency_group_uidDimension
The unique identifier for the agency group.
agency_uidDimension
The unique identifier for the agency.
algorithmDimension
The specific algorithm or bidding strategy used for campaign optimization.
appDimension
The mobile application where the ad was displayed.
audienceDimension
The audience segment targeted by the ad campaign.
billable_add_on_costsMetric
Additional costs incurred that are billable to the advertiser, beyond media spend.
billable_media_spendMetric
The portion of media spend that is billable to the advertiser.
billable_total_spendMetric
The total amount of billable spend, including media and add-on costs.
browserDimension
The web browser used on the device where the ad was served.
campaignDimension
Represents the advertising campaign.
campaign_7day_pacingMetric
The pacing of spend for a campaign over the last 7 days, indicating how it aligns with its budget goals.
campaign_7day_spendMetric
The total amount of money spent on a campaign over the past 7 days.
campaign_7day_spend_rateMetric
The rate at which the budget is being spent for a campaign over the past 7 days.
campaign_actionsMetric
The total number of actions recorded for the campaign.
campaign_budgetMetric
The total budget allocated for the advertising campaign.
campaign_click_actionsMetric
The number of actions attributed to clicks on the campaign.
campaign_click_hh_conversionMetric
Conversions attributed to a click event at the household level for a specific advertising campaign.
campaign_click_hh_conversionsDimension
The number of household conversions attributed to clicks on the campaign.
campaign_click_id_conversionsMetric
The number of ID-based conversions attributed to clicks on the campaign.
campaign_clicksMetric
The total number of clicks recorded for the campaign.
campaign_cpa_goalMetric
The Cost Per Action (CPA) goal set for the advertising campaign.
campaign_cpm_targetMetric
The Cost Per Mille (CPM) or cost per thousand impressions target set for the advertising campaign.
campaign_currency_uidDimension
A unique identifier for the currency used in the campaign.
campaign_days_remainingMetric
The number of days remaining until the campaign concludes.
campaign_end_time_ctzDimension
The end date and time of the advertising campaign, specified in the campaign's timezone.
campaign_impression_capMetric
The maximum number of impressions allowed for the entire advertising campaign.
campaign_spend_through_yesterdayMetric
The cumulative spend for the campaign up to and including yesterday.
campaign_start_time_ctzDimension
The start date and time of the advertising campaign, specified in the campaign's timezone.
campaign_total_actionsMetric
The total number of actions across all types for the campaign.
campaign_total_hh_conversionsMetric
The total number of household conversions for the campaign.
campaign_total_id_conversionsMetric
The total number of ID-based conversions for the campaign.
campaign_uidDimension
The unique identifier for the campaign.
campaign_view_actionsMetric
The number of actions attributed to views of the campaign.
campaign_view_hh_conversionsMetric
The number of household conversions attributed to views of the campaign.
campaign_view_id_conversionsMetric
The number of ID-based conversions attributed to views of the campaign.
campaign_yesterday_pacingMetric
The pacing of spend for a campaign for yesterday, indicating how it aligned with its daily budget goals.
campaign_yesterday_spendMetric
The total amount of money spent on an advertising campaign for yesterday.
countryDimension
The country where the ad impression occurred.
cpaMetric
The Cost Per Action, calculated as total spend divided by the number of actions.
cpcMetric
The Cost Per Click, calculated as total spend divided by the number of clicks.
cpmMetric
The Cost Per Mille (CPM) or cost per thousand impressions.
creative_durationDimension
The duration of the creative content.
creative_formatDimension
The format of the creative (e.g., video, image).
creative_media_typeDimension
The type of media used for the creative, such as display, video, or native.
creative_sizeDimension
The size specifications of the creative.
creative_typeDimension
The type of creative used in the campaign.
ctrMetric
The Click-Through Rate, calculated as clicks divided by impressions, indicating the effectiveness of an ad.
data_spendMetric
The cost associated with using third-party data for targeting.
dateDimension
The specific date for which the data is reported.
dealDimension
Represents the advertising deal.
deal_idDimension
The unique identifier for the advertising deal.
device_carrierDimension
The mobile carrier of the device on which the ad was served.
device_connection_typeDimension
The type of internet connection used by the device, e.g., Wi-Fi, cellular (4G, 5G).
device_environmentDimension
The environment of the device where the ad was shown, such as mobile app or mobile web.
device_frequencyMetric
The average number of times an ad was shown to a unique device.
device_osDimension
The operating system of the device where the ad was served.
device_reachMetric
The total number of unique devices that saw an ad.
device_typeDimension
The type of device on which the ad was displayed, e.g., mobile, tablet, desktop, CTV.
device_vendorDimension
The manufacturer or vendor of the device where the ad was displayed.
domainDimension
The domain name of the website where the ad impression occurred.
exchangeDimension
The ad exchange where the impression was bought.
exchange_app_idDimension
The unique identifier for the mobile application within the ad exchange where the ad was served.
exchange_publisher_idDimension
The unique identifier for the publisher within the ad exchange.
exchange_site_idDimension
The unique identifier for the website within the ad exchange where the ad was served.
flightDimension
Represents an advertising flight within a campaign.
flight_7day_pacingMetric
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_rateMetric
The average daily rate of ad spend for a specific advertising flight over the past 7 days.
flight_budgetMetric
The total budget allocated for a specific ad flight.
flight_ctr_goalMetric
The Click-Through Rate (CTR) goal set for a specific ad flight.
flight_days_remainingMetric
The number of days remaining until the ad flight concludes.
flight_end_time_ctzDimension
The end date and time of the ad flight, specified in the campaign's timezone.
flight_ideal_spendMetric
The ideal amount that should have been spent on the ad flight by a given point in time, based on pacing.
flight_impression_capMetric
The maximum number of impressions allowed for a specific ad flight.
flight_past_7_day_spendMetric
The total monetary amount spent on a specific advertising flight over the last 7 days.
flight_projected_budget_remaining_7dayMetric
The estimated remaining budget for an advertising flight, projected over the next 7 days based on current pacing.
flight_spend_through_yesterdayMetric
The cumulative spend for the ad flight up to and including yesterday.
flight_start_time_ctzDimension
The start date and time of the ad flight, specified in the campaign's timezone.
flight_uidDimension
The unique identifier for the advertising flight.
flight_yesterday_pacingMetric
The pacing of spend for an ad flight for yesterday, indicating how it aligned with its daily budget goals.
flight_yesterday_spendMetric
The total monetary amount spent on a specific advertising flight during the previous day.
hourDimension
The hour of the day when the activity occurred.
household_frequencyMetric
The average number of times an ad was shown to a unique household.
household_impressionsMetric
The total number of impressions delivered to unique households.
household_reachMetric
The total number of unique households that saw an ad.
impressionsMetric
The total number of times an ad was displayed.
media_planDimension
The name or identifier of the media plan.
media_plan_uidDimension
A unique identifier for the media plan.
mediaplan_actionsMetric
The total number of conversion actions attributed to the media plan.
mediaplan_click_actionsMetric
The total number of conversion actions attributed to clicks on ads within the media plan.
mediaplan_click_hh_conversionMetric
Conversions attributed to a click event at the household level across an entire mediaplan.
mediaplan_click_id_conversionsMetric
Conversions attributed to a click event, identified at an individual user level, across an entire mediaplan.
mediaplan_clicksMetric
The total number of clicks recorded for ads within the media plan.
mediaplan_total_actionsMetric
The sum of all conversion actions across the media plan.
mediaplan_total_hh_conversionsMetric
The total number of conversions recorded at the household level for an entire mediaplan, regardless of attribution method.
mediaplan_total_id_conversionsMetric
The total number of conversions recorded at an individual user level for an entire mediaplan, regardless of attribution method.
mediaplan_view_actionsMetric
The total number of conversion actions attributed to impressions (views) of ads within the media plan.
mediaplan_view_id_conversionsMetric
Conversions attributed to an ad view (impression), identified at an individual user level, across an entire mediaplan.
metrocodeDimension
The designated market area (DMA) or metro code associated with the ad impression.
monthDimension
The month when the activity occurred.
postal_codeDimension
The postal code associated with the geographic location of the ad impression.
quarterDimension
The quarter of the year when the activity occurred.
regionDimension
The geographic region or state where the ad impression occurred.
schedule_budgetMetric
The total budget allocated for a specific advertising schedule.
schedule_end_time_ctzDimension
The end date and time of the advertising schedule, specified in the campaign's timezone.
schedule_start_time_ctzDimension
The start date and time of the advertising schedule, specified in the campaign's timezone.
tacticDimension
Represents the specific advertising tactic used.
tactic_budgetMetric
The total budget allocated for a specific advertising tactic.
tactic_impression_capMetric
The maximum number of impressions allowed for a specific advertising tactic.
tactic_uidDimension
The unique identifier for the advertising tactic.
total_spendMetric
The total amount of money spent on advertising.
unbillable_add_on_costsMetric
Additional costs incurred that are not billable to the advertiser.
unbillable_media_spendMetric
The portion of media spend that is not billable to the advertiser.
unbillable_total_spendMetric
The total amount of non-billable spend, including media and add-on costs.
user_local_dayDimension
The day of the week based on the user's local timezone.
user_local_dtDimension
The date and time of the activity based on the user's local timezone.
user_local_hourDimension
The hour of the day based on the user's local timezone.
vcrMetric
The Video Completion Rate, calculated as video completes divided by video starts.
video_complete_countMetric
The number of times a video ad played to 100% completion.
video_midpoint_countMetric
The number of times a video ad played to its midpoint (50% completion).
video_one_quarter_countMetric
The number of times a video ad played to 25% completion.
video_start_countMetric
The number of times a video ad began playing.
video_three_quarter_countMetric
The number of times a video ad played to 75% completion.
weekDimension
The week of the year when the activity occurred.
yearDimension
The year when the activity occurred.