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	activity_transaction_price	The price associated with a specific user activity or transaction driven by an advertising campaign.	metric
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	algorithm	The algorithm used for campaign optimization or delivery.	dimension
app	app	The application where the advertisement was displayed.	dimension
audience	audience	The target audience segment for the campaign.	dimension
billable_add_on_costs	billable_add_on_costs	The billable costs for additional services or features.	metric
billable_media_spend	billable_media_spend	The billable expenditure on media placements.	metric
billable_total_spend	billable_total_spend	The total billable expenditure for the campaign or flight.	metric
browser	browser	The web browser used by the audience.	dimension
campaign	campaign	Represents the advertising campaign.	dimension
campaign_7day_pacing	campaign_7day_pacing	The pacing of campaign spend over a 7-day period.	metric
campaign_7day_spend	campaign_7day_spend	The total campaign spend over a 7-day period.	metric
campaign_7day_spend_rate	campaign_7day_spend_rate	The rate of campaign spend over a 7-day period.	metric
campaign_actions	campaign_actions	The total number of actions recorded for the campaign.	metric
campaign_budget	campaign_budget	The allocated budget for the 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.	metric
campaign_click_id_conversions	campaign_click_id_conversions	The number of ID-based conversions attributed to clicks on the campaign.	dimension
campaign_clicks	campaign_clicks	The total number of clicks recorded for the campaign.	metric
campaign_cpa_goal	campaign_cpa_goal	The target Cost Per Action (CPA) for the campaign.	metric
campaign_cpm_target	campaign_cpm_target	The target Cost Per Mille (CPM) for the campaign.	metric
campaign_currency_uid	campaign_currency_uid	The unique identifier for the currency used in the campaign.	dimension
campaign_days_remaining	campaign_days_remaining	The number of days remaining in the campaign.	metric
campaign_end_time_ctz	campaign_end_time_ctz	The end time of the campaign in the campaign’s timezone.	dimension
campaign_id	campaign_id	The identifier for the campaign.	dimension
campaign_impression_cap	campaign_impression_cap	The maximum number of impressions allowed for the campaign.	dimension
campaign_spend_through_yesterday	campaign_spend_through_yesterday	The total campaign spend up to the end of yesterday.	metric
campaign_start_time_ctz	campaign_start_time_ctz	The start time of the campaign 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.	dimension
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.	dimension
campaign_yesterday_pacing	campaign_yesterday_pacing	The pacing of campaign spend for yesterday.	metric
campaign_yesterday_spend	campaign_yesterday_spend	The total campaign spend for yesterday.	metric
country	country	The country where the advertisement was displayed.	dimension
cpa	cpa	The Cost Per Action (CPA) for the campaign.	metric
cpc	cpc	The Cost Per Click (CPC) for the campaign.	metric
cpm	cpm	The Cost Per Mille (CPM) or cost per thousand impressions.	metric
creative_duration	creative_duration	The duration of the creative content.	metric
creative_format	creative_format	The format of the creative (e.g., video, image).	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
data_spend	data_spend	The expenditure on data used for targeting or analysis.	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_frequency	device_frequency	The frequency at which ads were shown on devices.	metric
device_os	device_os	The operating system of the device where the ad was shown.	dimension
device_reach	device_reach	The number of unique devices reached by the campaign.	metric
device_type	device_type	The type of device (e.g., mobile, desktop, tablet).	dimension
device_vendor	device_vendor	The vendor of the device where the ad was shown.	dimension
domain	domain	The domain where the advertisement was displayed.	dimension
exchange_app_id	exchange_app_id	The application ID on the ad exchange.	dimension
flight	flight	Represents an advertising flight within a campaign.	dimension
flight_ctr_goal	flight_ctr_goal	The target Click-Through Rate (CTR) for the flight.	metric
flight_days_remaining	flight_days_remaining	The number of days remaining in the flight.	metric
flight_end_time_ctz	flight_end_time_ctz	The end time of the flight in the campaign’s timezone.	dimension
flight_ideal_spend	flight_ideal_spend	The ideal spend allocated for the flight.	dimension
flight_spend_through_yesterday	flight_spend_through_yesterday	The total flight spend up to the end of yesterday.	metric
flight_uid	flight_uid	The unique identifier for the advertising flight.	dimension
flight_yesterday_pacing	flight_yesterday_pacing	The pacing of flight spend for yesterday.	metric
household_frequency	household_frequency	The frequency at which ads were shown to households.	metric
household_impressions	household_impressions	The number of impressions delivered to households.	metric
household_reach	household_reach	The number of unique households reached by the campaign.	metric
impressions	impressions	The total number of times an advertisement was displayed.	metric
media_plan	media_plan	The media plan associated with the campaign.	dimension
postal_code	postal_code	The postal code of the audience location.	dimension
quarter	quarter	The fiscal quarter for which the data is reported.	metric
region	region	The geographical region where the advertisement was displayed.	dimension
schedule_end_time_ctz	schedule_end_time_ctz	The end time of the schedule in the campaign’s timezone.	dimension
spend	spend	Represents the financial expenditure.	dimension
tactic	tactic	Represents the specific advertising tactic used.	dimension
tactic_budget	tactic_budget	The allocated budget for the advertising tactic.	dimension
tactic_impression_cap	tactic_impression_cap	The maximum number of impressions allowed for the tactic.	metric
tactic_uid	tactic_uid	The unique identifier for the advertising tactic.	dimension
total_spend	total_spend	The overall total expenditure.	metric
unbillable_add_on_costs	unbillable_add_on_costs	The unbillable costs for additional services or features.	metric
unbillable_media_spend	unbillable_media_spend	The unbillable expenditure on media placements.	metric
unbillable_total_spend	unbillable_total_spend	The total unbillable expenditure for the campaign or flight.	metric
user_local_day	user_local_day	The local day of the user when the ad activity occurred.	dimension
user_local_dt	user_local_dt	The local date and time of the user when the ad activity occurred.	dimension
user_local_hour	user_local_hour	The local hour of the user when the ad activity occurred.	metric
vcr	vcr	The Video Completion Rate (VCR).	metric
video_complete_count	video_complete_count	The number of times a video advertisement was watched to completion.	metric
video_midpoint_count	video_midpoint_count	The number of times a video advertisement was watched to its midpoint (50%).	metric
video_one_quarter_count	video_one_quarter_count	The number of times a video advertisement was watched to one quarter (25%) of its duration.	metric
video_start_count	video_start_count	The number of times a video advertisement started playing.	metric
video_three_quarter_count	video_three_quarter_count	The number of times a video advertisement was watched to three quarters (75%) of its duration.	metric
video_view_25pct	video_view_25pct	The percentage of video views that reached 25% completion.	dimension
video_view_50pct	video_view_50pct	The percentage of video views that reached 50% completion.	dimension
video_view_75pct	video_view_75pct	The percentage of video views that reached 75% completion.	dimension
week	week	The week for which the data is reported.	dimension
year	year	The calendar year for which the data is reported.	metric