Yahoo DSP: Most-used fields

The table below gives information about most-used fields that you can import from Yahoo DSP. 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
100%_complete	100%_complete	The number of video starts that resulted in 100% video completion.	metric
100p_complete	100p_complete	The number of video starts that resulted in 100% video completion.	metric
100p_completion_rate	100p_completion_rate	The percentage of video starts that resulted in a 100% completed video.	metric
25%_complete	25%_complete	The number of video starts that resulted in at least 25% video completion.	metric
25p_complete	25p_complete	The number of video starts that resulted in at least 25% video completion.	metric
25p_completion_rate	25p_completion_rate	The percentage of video starts that resulted in at least 25% completed video.	metric
50%_complete	50%_complete	The number of video starts that resulted in at least 50% video completion.	metric
50p_complete	50p_complete	The number of video starts that resulted in at least 50% video completion.	metric
50p_completion_rate	50p_completion_rate	The percentage of video starts that resulted in at least 50% completed video.	metric
75%_complete	75%_complete	The number of video starts that resulted in at least 75% video completion.	metric
75p_complete	75p_complete	The number of video starts that resulted in at least 75% video completion.	metric
75p_completion_rate	75p_completion_rate	The percentage of video starts that resulted in at least 75% completed video.	metric
Advertiser Name	Advertiser Name	The name of the advertiser associated with the campaign data.	dimension
Datasource	Datasource	The name of the data source login account used to authenticate against the data source.	dimension
Date	Date	The date of the report data, allowing for daily granularity.	dimension
End Date	End Date	The end date for the report data within a specified reporting period.	dimension
Exchange name	Exchange name	The name of the ad exchange.	dimension
Hour	Hour	The hour of the report data.	dimension
Month	Month	The month of the report data.	dimension
Report Type	Report Type	The type or granularity of the generated report, such as daily, weekly, or monthly.	dimension
Spend	Spend	The total amount of money spent on advertising.	metric
Start Date	Start Date	The start date for the report data within a specified reporting period.	dimension
Week	Week	The week corresponding to the report data, used for weekly reporting.	dimension
ad	ad	The name of the ad.	dimension
ad_id	ad_id	The unique identifier for the ad.	dimension
ad_name	ad_name	The name of the ad.	dimension
ad_position_id	ad_position_id	The unique identifier for the ad position.	dimension
ad_position_name	ad_position_name	The name of the position where the ad was displayed on a webpage or app.	dimension
ad_serving_cost	ad_serving_cost	The cost associated with serving the ad.	metric
ad_verification_cost	ad_verification_cost	The cost associated with ad verification services.	metric
advertiser	advertiser	The name of the advertiser.	dimension
advertiser_category_id	advertiser_category_id	The unique identifier for the category of the advertiser.	dimension
advertiser_currency	advertiser_currency	The currency used by the advertiser.	dimension
advertiser_currency_id	advertiser_currency_id	The currency identifier used for the advertiser’s financial data (e.g., USD, EUR).	dimension
advertiser_ecpm	advertiser_ecpm	The effective cost per thousand impressions from the advertiser’s perspective.	metric
advertiser_ecpm_advertiser_currency	advertiser_ecpm_advertiser_currency	The effective cost per mille (thousand impressions) for the advertiser, expressed in the advertiser’s local currency.	metric
advertiser_group_id	advertiser_group_id	The unique identifier for the advertiser group.	dimension
advertiser_group_name	advertiser_group_name	The name of the advertiser group.	dimension
advertiser_id	advertiser_id	The unique identifier for the advertiser.	dimension
advertiser_name	advertiser_name	The name of the advertiser.	dimension
advertiser_spending	advertiser_spending	The total amount spent by the advertiser.	metric
advertiser_spending_EUR	advertiser_spending_EUR	The total amount spent by the advertiser, expressed in Euros.	metric
advertiser_spending_advertiser_currency	advertiser_spending_advertiser_currency	The total amount spent by the advertiser, expressed in the advertiser’s local currency.	metric
advertiser_status	advertiser_status	The current operational status of the advertiser account.	dimension
advertiser_timezone	advertiser_timezone	The timezone configured for the advertiser’s account.	dimension
age_id	age_id	The unique identifier for the age group of the audience segment.	dimension
age_name	age_name	The age group of the audience segment, expressed as a range of ages.	dimension
audience_impressions	audience_impressions	The number of impressions delivered to a specific audience segment.	metric
audience_measurement_cost	audience_measurement_cost	A variable cost that measures the number of people exposed to advertising across any given media.	metric
average_frequency	average_frequency	The average number of times an ad was shown to a unique user within a given period.	metric
brand_safety_cost	brand_safety_cost	A variable cost that tracks expenses related to inventory quality, brand safety, and fraud avoidance.	metric
browser_type_id	browser_type_id	The unique identifier for the web browser used by the user.	dimension
browser_type_name	browser_type_name	The name of the web browser used by the user.	dimension
campaign_currency	campaign_currency	The currency used for the campaign’s financial metrics.	dimension
campaign_end_date	campaign_end_date	The scheduled end date of the campaign.	dimension
campaign_id	campaign_id	The unique identifier for the campaign.	dimension
campaign_name	campaign_name	The name of the campaign.	dimension
campaign_start_date	campaign_start_date	The scheduled start date of the campaign.	dimension
campaign_status	campaign_status	The current operational status of the advertising campaign.	dimension
city_id	city_id	The unique identifier for the city where the ad was displayed.	dimension
city_name	city_name	The name of the city where the ad was displayed.	dimension
click_through_conversion	click_through_conversion	The number of conversions that occurred after a user clicked on an ad.	metric
click_through_conversion_rate	click_through_conversion_rate	The percentage of click-through conversions.	metric
clicks	clicks	The total number of times an ad was clicked.	metric
connection_type	connection_type		dimension
conversion	conversion	The total number of conversions, where a conversion is a user action defined by a conversion rule.	metric
conversion_rate	conversion_rate	The rate at which ad impressions result in conversions.	metric
country_id	country_id	The unique identifier for the country where the ad was served.	dimension
country_name	country_name	The name of the country where the ad was served.	dimension
cpa	cpa	Cost Per Acquisition, the cost incurred for each conversion.	metric
cpc	cpc	Cost Per Click, the cost incurred for each click on an ad.	metric
created_date	created_date	The date when the advertising entity (e.g., campaign, creative) was created.	dimension
creative_id	creative_id	The unique identifier for the creative asset.	dimension
creative_name	creative_name	The name of the creative asset.	dimension
creative_size	creative_size	A string that specifies the name of the creative size, expressed in terms of its dimensions (e.g., ‘300x250’).	dimension
creative_size_id	creative_size_id	The unique identifier for the creative size.	dimension
cross_device_conversions	cross_device_conversions	The number of conversions attributed across multiple devices for a single user, supported by enhanced attribution capabilities.	metric
ctr	ctr	Click-Through Rate, the percentage of users who viewed an ad and clicked it.	metric
date	date	The date of the report data.	dimension
day	day	The day of the report data.	dimension
deal_id	deal_id	The unique identifier for the programmatic deal.	dimension
deal_name	deal_name	The name of the programmatic deal.	dimension
deal_type	deal_type	The type of deal used for ad inventory (e.g., private marketplace, programmatic guaranteed).	dimension
desktop_os_name	desktop_os_name	The name of the desktop operating system used by the user.	dimension
device_category_id	device_category_id	The unique identifier for the device category.	dimension
device_category_name	device_category_name	The name of the device category (e.g., Desktop, Mobile, Tablet).	dimension
device_type_id	device_type_id	The unique identifier for the device type.	dimension
device_type_name	device_type_name	The name of the specific device type (e.g., Android Phone, iPhone).	dimension
domain	domain	The domain name where the ad was displayed.	dimension
dynamic_conversion_value	dynamic_conversion_value	The monetary value of a conversion event that can vary dynamically, often tracked via the Conversion API.	metric
endDate	budget_schedule_end_date	The end date for the budget schedule.	dimension
estimated_billable_amount	estimated_billable_amount		metric
exchange_deal_id	exchange_deal_id	The unique identifier for a private deal negotiated on an ad exchange.	dimension
exchange_id	exchange_id	The unique identifier for the ad exchange.	dimension
exchange_name	exchange_name	The name of the ad exchange.	dimension
filtered_impressions	filtered_impressions	The number of impressions that were filtered out due to various reasons (e.g., fraud, viewability).	metric
gender_id	gender_id	The unique identifier for the reported gender of the user.	dimension
gender_name	gender_name	The reported gender of the user who was shown the ad.	dimension
id	budget_schedule_id	The unique identifier for the budget schedule.	dimension
impression_dist_non_measurable	impression_dist_non_measurable	The distribution of impressions that could not be measured for viewability.	metric
impression_dist_non_viewable	impression_dist_non_viewable	The distribution of impressions that were not considered viewable.	metric
impression_dist_viewable	impression_dist_viewable	The distribution of impressions that were considered viewable.	metric
impressions	impressions	The total number of times an ad has been loaded and displayed.	metric
inventory_cost	inventory_cost	The cost of the ad inventory, calculated from inventory eCPM and impressions.	metric
inventory_cost_EUR	inventory_cost_EUR	The cost of the ad inventory, expressed in Euros.	metric
inventory_cost_api	inventory_cost_api	The cost associated with the ad inventory purchased through the API.	metric
inventory_ecpm	inventory_ecpm	The effective cost per mille (thousand impressions) for the ad inventory.	metric
inventory_type	inventory_type	The classification of ad inventory (e.g., web, app, mobile web, video).	dimension
landing_page_domain	landing_page_domain	The domain of the landing page where users are directed after clicking an ad.	dimension
landing_page_url	landing_page_url	The URL of the landing page where users are directed after clicking an ad.	dimension
line	line	The name of the line item.	dimension
line_billing_method_id	line_billing_method_id	The unique identifier for the billing method applied to the advertising line item.	dimension
line_billing_method_name	line_billing_method_name	The name of the billing method applied to the advertising line item.	metric
line_channel_type_name	line_channel_type_name	The name of the channel type associated with the advertising line item (e.g., Display, Video, Native).	dimension
line_goal_type_id	line_goal_type_id	The unique identifier for the goal type defined for the advertising line item.	dimension
line_goal_type_name	line_goal_type_name	The name of the goal type defined for the advertising line item (e.g., clicks, impressions, conversions).	dimension
line_id	line_id	The unique identifier for the line item.	dimension
line_name	line_name	The name of the line item.	dimension
measurable_impressions	measurable_impressions	The number of impressions that were measured for viewability.	metric
native_type	native_type	The specific type or format of the native ad creative.	dimension
network_profit	network_profit		metric
non_measurable_impressions	non_measurable_impressions	The number of impressions for which viewability could not be measured.	metric
non_viewable_impression	non_viewable_impression	The number of impressions that were not considered viewable.	metric
order_management_fee	order_management_fee	The fee charged for managing orders.	metric
other_cost	other_cost		metric
package_id	package_id	The unique identifier for the package.	dimension
package_name	package_name	The name of the package.	dimension
pixel_id	pixel_id	The unique identifier for the Yahoo Pixel used for conversion tracking and audience building.	dimension
pixel_name	pixel_name	The name associated with the Yahoo Pixel.	dimension
platform_fee	platform_fee	The fee charged for using the advertising platform.	metric
postal_code_id	postal_code_id	The unique identifier for the postal code where the ad was displayed.	dimension
publisher_earnings_advertiser_currency	publisher_earnings_advertiser_currency	The amount paid to publishers, expressed in the advertiser’s local currency.	metric
region_id	region_id	The unique identifier for the geographical region where the ad was displayed.	dimension
region_name	region_name	The name of the geographical region where the ad was displayed.	dimension
roas	roas	Return on Ad Spend, a measure of advertising campaign effectiveness.	metric
roas_action_value	roas_action_value	The conversion value used to calculate Return on Ad Spend (ROAS).	metric
roas_action_value_advertiser_currency	roas_action_value_advertiser_currency	The Return on Ad Spend (ROAS) conversion value, expressed in the advertiser’s local currency.	metric
roas_advertiser	roas_advertiser	The Return on Ad Spend (ROAS) metric from the advertiser’s perspective.	dimension
scheduleBudget	budget_schedule_budget	The total budget amount for the campaign’s schedule.	dimension
scheduleBudgetType	budget_schedule_type	The type of budget schedule (e.g., daily, total).	dimension
scheduleDailyBudget	budget_schedule_daily_budget	The daily budget amount for the campaign’s schedule.	metric
seat_data_fee	seat_data_fee	The data fees associated with the advertising seat.	metric
seat_data_fee_EUR	seat_data_fee_EUR	The data fees associated with the advertising seat, expressed in Euros.	metric
seat_id	seat_id	The unique identifier for the DSP seat.	dimension
seat_management_fee	seat_management_fee	Fees associated with managing the advertising seat on the DSP platform.	metric
seat_management_fee_EUR	seat_management_fee_EUR	The fees associated with managing the advertising seat, expressed in Euros.	metric
seat_name	seat_name	The name of the DSP seat.	dimension
seat_tech_fee	seat_tech_fee	The technical fee charged for using the Yahoo DSP.	metric
seat_tech_fee_EUR	seat_tech_fee_EUR	The technical fee charged for using the Yahoo DSP for a specific seat, expressed in Euros.	metric
skipped_ads	skipped_ads	The number of video ads that were skipped by users.	metric
startDate	budget_schedule_start_date	The start date for the budget schedule.	dimension
start_views	start_views	The number of times a video ad started playing.	metric
subdomain	subdomain	The subdomain where the ad was displayed.	dimension
third_party_data_fees	third_party_data_fees	Fees associated with using third-party data in advertising campaigns.	metric
total_data_fee	total_data_fee	The total cost incurred for data usage in advertising campaigns.	metric
total_variable_cost	total_variable_cost		metric
total_vendor_fee	total_vendor_fee		metric
unique_viewers	unique_viewers	The number of unique users who viewed an ad.	metric
video_ad_placement	video_ad_placement	The specific placement of a video ad within content (e.g., pre-roll, mid-roll, post-roll).	dimension
video_content_length	video_content_length	The duration or length of the video creative.	dimension
video_player_size	video_player_size	The dimensions or size of the video player in which the ad was displayed.	dimension
view_through_conversion	view_through_conversion	The number of conversions that occurred after a user viewed an ad, without clicking.	metric
viewability_cost	viewability_cost	The cost associated with ensuring or measuring ad viewability, related to Viewable CPM (vCPM).	metric
viewable_impressions	viewable_impressions	The number of impressions that were considered viewable according to MRC Viewable Impression Guidelines.	metric
viewable_rate	viewable_rate	The percentage of impressions that were viewable.	metric
yahoo_data_fees	yahoo_data_fees	Fees specifically charged by Yahoo for data usage in advertising campaigns.	metric
yahoo_data_fees_EUR	yahoo_data_fees_EUR	Fees specifically charged by Yahoo for data usage in advertising campaigns, expressed in Euros.	metric