Yahoo DSP: Most-used fields

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

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

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 ad impressions that reached 25% 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 ad impressions that reached 50% 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 ad impressions that reached 75% completion.

metric

ad_id

ad_id

The unique identifier for the ad.

dimension

ad_name

ad_name

The name of the ad.

dimension

ad_serving_cost

ad_serving_cost

A variable cost tracking expenses related to third-party storage, tracking, and delivery of ad assets, including per-impression charges and fees.

metric

advertiser_ecpm

advertiser_ecpm

The effective cost per thousand impressions (eCPM) for the advertiser. It is calculated as (Ad Spend / Impressions) * 1000.

metric

advertiser_group_id

advertiser_group_id

The identifier for a customized group of advertisers.

dimension

advertiser_group_name

advertiser_group_name

The name of a customized group of advertisers, as defined by the user.

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

age_name

age_name

The name of the age group, expressed as a range (e.g., ‘25-34’), used for audience targeting and reporting.

dimension

audience_impressions

audience_impressions

The total number of times an ad associated with a specific audience was displayed.

metric

budget_schedule_budget

budget_schedule_budget

The budget amount allocated for a specific budget schedule within a campaign.

dimension

campaign_id

campaign_id

The unique identifier for the campaign.

dimension

campaign_name

campaign_name

The name of the campaign.

dimension

city_name

city_name

The name of the city where the ad impression occurred.

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 rate at which users convert after clicking on an ad, calculated as conversions divided by clicks.

metric

clicks

clicks

The total number of times an ad was clicked.

metric

connection_type

connection_type

The active connection type for the device when the ad was displayed, such as Wifi or Cellular.

dimension

conversion

conversion

The total number of conversions, where a conversion is a user action defined by a conversion rule.

metric

country_name

country_name

The name of the country where the ad impression occurred.

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

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.

metric

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

deal_id

deal_id

A unique identifier for a private deal or programmatic guaranteed deal.

dimension

deal_name

deal_name

The name of the deal.

dimension

deal_type

deal_type

The type of deal used by the DSP to win impressions. Examples include No Deal, Standard Deal, or Guaranteed Deal.

dimension

device_category_id

device_category_id

The unique identifier for the device category.

metric

device_category_name

device_category_name

The name of the device category, often referring to the mobile operating system.

dimension

device_type_id

device_type_id

The unique identifier for the device type used by the consumer. Examples include Desktop, Phone, Tablet, or Connected TV.

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 of the website or app where the ad was displayed.

dimension

estimated_billable_amount

estimated_billable_amount

The estimated total costs and fees associated with lines or campaigns, including inventory cost, platform fee, total data fee, seat management fee, total vendor fee, order management fee, programmatic guaranteed deal fee, and total tax (if applicable).

metric

exchange_deal_id

exchange_deal_id

The unique identifier of the exchange deal received from the supply partner.

dimension

exchange_id

exchange_id

The unique identifier for the ad exchange.

dimension

exchange_name

exchange_name

The name of the ad exchange.

dimension

gender_id

gender_id

A programmatic identifier for the gender of the audience targeted or measured.

metric

gender_name

gender_name

The name of the gender (e.g., ‘MALE’, ‘FEMALE’, ‘UNKNOWN’) used for audience targeting and reporting.

dimension

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_ecpm

inventory_ecpm

The effective cost per thousand impressions paid to publishers. This was previously known as Publisher eCPM.

metric

landing_page_domain

landing_page_domain

The domain of the final landing page where the ad directs users.

dimension

landing_page_url

landing_page_url

The URL of the page where users are directed after clicking an ad.

dimension

line_channel_type_name

line_channel_type_name

Categorizes lines by channel type (e.g., Audio, CTV, DOOH, Native, Standard Display, Standard Video).

metric

line_goal_type_id

line_goal_type_id

The unique identifier for the type of goal set for an advertising line item, indicating its optimization objective.

dimension

line_goal_type_name

line_goal_type_name

The name of the goal type defined for a line (e.g., CPC, CPA, eCPM).

dimension

line_id

line_id

The unique identifier for the line item.

metric

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

network_profit

network_profit

Tracks network profit based on inventory costs, excluding data costs, data verification services costs, and other fees.

metric

non_measurable_impressions

non_measurable_impressions

The number of ad impressions that could not be measured for viewability or other metrics.

metric

non_viewable_impression

non_viewable_impression

The number of ad impressions that were deemed not viewable according to industry standards.

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

A unique identifier for the pixel used for tracking events or audience segments.

dimension

pixel_name

pixel_name

The name of the pixel used for tracking conversions or audience segments.

dimension

platform_fee

platform_fee

The technical fee charged for using the Yahoo DSP. This was previously known as Seat Tech Fee.

metric

postal_code_id

postal_code_id

The consumer’s zip or postal code.

dimension

region_id

region_id

The ID for the geographical region or state where an event occurred.

dimension

region_name

region_name

The name of the geographical region or state (e.g., California, Quebec) where an event occurred.

dimension

seat_id

seat_id

The unique identifier for the DSP seat.

metric

seat_name

seat_name

The name of the DSP seat.

dimension

skipped_ads

skipped_ads

The total number of video ads that users chose to skip before completion.

metric

start_views

start_views

The number of times a video ad started playing.

metric

subdomain

subdomain

The subdomain of a website included in a supply list for targeting or exclusion.

dimension

total_data_fee

total_data_fee

The total fee charged for using audience data. This was previously known as Seat Data Fee.

metric

total_vendor_fee

total_vendor_fee

The total cost of third-party vendor services purchased in the Vendor Store, such as targeting, inventory quality, and measurement services.

metric

video_content_length

video_content_length

The length of a video in predefined intervals, such as ‘Up to 2 mins’ or ‘2-5 mins’.

dimension

view_through_conversion

view_through_conversion

Tracks view-through conversions, which occur when a user views an ad impression and then converts without clicking.

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 measured impressions that were viewable. This corresponds to ‘Yahoo+ Viewable Rate’ in the API documentation.

metric