Data reference - Adriel Knowledge Base

Introduction

Yahoo DSP (Demand-Side Platform) is a programmatic advertising platform that lets advertisers buy and manage digital inventory across Yahoo’s network and third-party publishers. The connector pulls campaign architecture and performance across display, video, native, connected TV (CTV), and digital out-of-home (DOOH) inventory. As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration. To connect this data source, see How to connect Yahoo DSP to Adriel.

Data refresh strategy

Architecture data

Architecture covers ad accounts, campaigns, ad sets (line items), and ads (creatives). It refreshes twice daily at 4:00 PM UTC and 5:00 AM UTC. When the data source is created, the cache fills with 730 days of historical architecture data for the ad account, campaign, ad set, and ad levels.

Reports data

Reports include daily performance for ad accounts, campaigns, ad sets, and ads. Cache-only. Report data comes from cached daily performance snapshots produced by an asynchronous report pipeline (create a report job, poll until it completes, download the resulting CSV). Live fetch is not supported, so every dashboard query reads the most recent cached snapshot. Refresh schedule. Reports refresh every 6 hours, at 0 minutes past the hour (UTC). Each refresh syncs the last 10 days for the ad account, campaign, ad set, and ad levels. Data is considered reliable within the cache sync period; data outside this range may be incomplete or not fully accurate due to legacy caching behavior.

Metrics based on uniqueness, such as reach and unique households, can be overstated when viewed across a date range longer than one day, because daily snapshot values are summed.

Architecture levels

Yahoo DSP → Ad account → Campaign → Ad set (line item) → Ad (creative)

Date range limits

Breakdown	Max range
Daily	93 days
Weekly	1 year
Monthly	2 years

Data requested outside a breakdown’s maximum range may be truncated. Longer historical ranges remain available through the quarterly and yearly breakdowns.

Metrics

How to read the columnsData type uses Adriel’s vocabulary — Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. API Key in code style like Ad Serving Cost is the literal Yahoo DSP report column the connector maps; italic marks a value Adriel computes or derives on its side rather than a single report column. Currency values are reported in each ad account’s configured Yahoo DSP currency.

Campaign Attributes

Metric	Description	Data type	API Key
Active Status	Whether the campaign, ad set, or ad is currently active.	Text	Adriel-side
Ad Account Name	Name of the Yahoo DSP ad account.	Text	Adriel-side
Ad Name	Name of the ad (creative).	Text	Adriel-side
Ad Set Name	Name of the ad set (line item).	Text	Adriel-side
Ad Spend	Total spend for the reporting period, in the ad account’s currency.	Currency	Adriel-side
Bid Cap	Maximum bid configured for the campaign or ad set.	Currency	Adriel-side
Bid Strategy	Bidding strategy configured for the campaign or ad set.	Text	Adriel-side
Budget	Configured budget amount and type (daily or lifetime) for the campaign or ad set.	Text	Adriel-side
Campaign Name	Name of the campaign.	Text	Adriel-side
Channel Type	Marketing channel type reported for the campaign, such as display, video, native, CTV, or DOOH.	Text	Adriel-side
Creative Type	Creative format classification for the ad, such as display, video, or native.	Text	Adriel-derived
Creative URL	Image or video URL associated with the ad creative when available.	URL	Adriel-side
Daily Budget	Daily budget amount for the campaign or ad set.	Currency	Adriel-side
Ends	Scheduled end date for the campaign or ad set.	Date	Adriel-side
Landing URL	Destination URL people reach when they click the ad.	URL	Adriel-side
Lifetime Budget	Total lifetime budget configured for the campaign or ad set.	Currency	Adriel-side
Objective	Campaign objective (goal type) configured in Yahoo DSP.	Text	Adriel-side
Starts	Scheduled start date for the campaign or ad set.	Date	Adriel-side
Status (Text)	A human-readable label for the current delivery status.	Text	Adriel-side
Status (Toggle)	Current delivery status of the campaign, ad set, or ad.	Text	Adriel-side
UTM Campaign	UTM campaign value parsed from the ad’s tracking settings or landing URL when present.	Text	Adriel-side
UTM Content	UTM content value parsed from the ad’s tracking settings or landing URL when present.	Text	Adriel-side
UTM Medium	UTM medium value parsed from the ad’s tracking settings or landing URL when present.	Text	Adriel-side
UTM Source	UTM source value parsed from the ad’s tracking settings or landing URL when present.	Text	Adriel-side
UTM Term	UTM term value parsed from the ad’s tracking settings or landing URL when present.	Text	Adriel-side

Campaign Structure

Metric	Description	Data type	API Key
Ad Account ID	Identifier of the Yahoo DSP ad account.	Text	Adriel-side
Ad ID	Identifier of the ad (creative).	Text	Adriel-side
Ad Set ID	Identifier of the ad set (line item).	Text	Adriel-side
Campaign ID	Identifier of the campaign.	Text	Adriel-side
Channel	Marketing channel classification applied for cross-connector rollup.	Text	Adriel-side

Click Performance

Metric	Description	Data type	API Key
Clicks (All)	Total ad clicks during the reporting period.	Number	Adriel-side
CPC	Cost per click — spend divided by clicks.	Currency	Adriel-computed
CPM	Cost per thousand impressions.	Currency	Adriel-computed
CTR	Click-through rate — clicks divided by impressions.	Percentage	Adriel-computed
Impressions	Number of times the ads were displayed.	Number	Adriel-side
Link Clicks	Number of clicks on the ad’s link during the reporting period.	Number	Adriel-side

Computed Metrics

Metric	Description	Data type	API Key
ROAS	Return on ad spend — conversion value divided by spend.	Ratio	Adriel-computed
Video Played To 100% (%)	Plays reaching 100% of video length as a share of video impressions.	Percentage	Adriel-computed
Video Played To 25% (%)	Plays reaching 25% of video length as a share of video impressions.	Percentage	Adriel-computed
Video Played To 50% (%)	Plays reaching 50% of video length as a share of video impressions.	Percentage	Adriel-computed
Video Played To 75% (%)	Plays reaching 75% of video length as a share of video impressions.	Percentage	Adriel-computed
View Rate	Video views as a share of video impressions.	Percentage	Adriel-computed

Conversion Performance

Metric	Description	Data type	API Key
Conversion Value	Total monetary value of attributed conversions.	Currency	Adriel-side
Conversions	Total attributed conversion events.	Number	Adriel-side
Result Indicator	The metric used to represent the result for the campaign’s objective.	Text	Adriel-derived
Results	Result summary reported for the campaign’s configured objective.	Text	Adriel-derived
Revenue	Total revenue attributed to conversions.	Currency	Adriel-side

Custom conversion events are imported automatically. Any conversion event tracked in the ad account is imported and appears on dashboards only while the underlying event is active. For each imported conversion, Adriel also generates derived KPIs such as ROAS, CPA, and conversion rate, including dynamic custom conversions defined by the user.

Creative Attributes

Metric	Description	Data type	API Key
Creative Image	A reference to the ad’s creative image.	Text	Adriel-side

Engagement

Metric	Description	Data type	API Key
Video Impressions	Estimated video impressions used to calculate video completion metrics.	Number	Adriel-side

Video Performance

Metric	Description	Data type	API Key
Video Played To 100% (Views)	Number of video plays that reached 100% of video length.	Number	Adriel-side
Video Played To 25% (Views)	Number of video plays that reached 25% of video length.	Number	Adriel-side
Video Played To 50% (Views)	Number of video plays that reached 50% of video length.	Number	Adriel-side
Video Played To 75% (Views)	Number of video plays that reached 75% of video length.	Number	Adriel-side
Views	Number of video views.	Number	Adriel-side

Yahoo DSP-specific

These metrics exist only for Yahoo DSP and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Metric	Description	Data type	API Key
100% Completion Rate	Tracks the percentage of video starts that resulted in a 100% completed video.	Percentage	`100% Completion Rate`
25% Completion Rate	Tracks the percentage of video starts that resulted in at least a 25% completed video.	Percentage	`25% Completion Rate`
3rd Party	Reports the number of conversions that were received from SKAdNetwork or real time Honor Claims/Arbitration Results conversions for supported Mobile Measurement Partners (MMPs).	Number	`Third Party Conversions`
50% Completion Rate	Tracks the percentage of video starts that resulted in at least a 50% completed video.	Percentage	`50% Completion Rate`
75% Completion Rate	Tracks the percentage of video starts that resulted in at least a 75% completed video.	Percentage	`75% Completion Rate`
Ad Serving Cost	A variable cost that tracks expenses associated with the third-party storage, tracking, and delivery of assets including per-impression charges and fees.	Currency	`Ad Serving Cost`
Ad Spend	Total spend for the reporting period, in the ad account’s currency.	Currency	Adriel-side
Ad Verification Cost	A cost associated with the measurement and verification of target delivery.	Currency	`Ad Verification Cost`
Audience Impressions	A unit of measure that includes the total number of times people passing Digital-Out-Of-Home screens are likely to notice a message.	Number	`Audience Impressions`
Audience Measurement Cost	A variable cost that tracks expenses associated with the identification and measurement of delivery to specific audiences, segments, or devices.	Currency	`Audience Measurement Cost`
Average Frequency Per Household	For Connected TV (CTV) lines, this is defined as the average impressions per household (Impressions / Unique Households). European Union (EU) advertisers may have access to limited data due to privacy restrictions.	Number	`Average Frequency per Household`
Average Impression Multiplier	Tracks the average impression multiplier on Digital-Out-Of-Home screens.Average Impression Multiplier [448] = Audience Impressions [329] / Impressions [1]	Number	`Average Impression Multiplier`
Average People Frequency	Tracks the number of measurable impressions by people per Unique people: Average People Frequency [523] = Measurable impressions by people [522] / Unique people [430]	Number	`Average People Frequency`
Brand Safety Cost	A variable cost that tracks expenses related to inventory quality, brand safety, and fraud avoidance.	Currency	`Brand Safety Cost`
Click Through	Tracks click-through conversions. A click-based conversion occurs when a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad.	Number	`Click Through Conversion`
Click Through Dynamic: Conversion Value	The monetary value of each dynamic click-through conversion to the advertiser. The advertiser enters this value when they create a new line.	Currency	`Click Through Dynamic Conversion Value`
Click Through: Conversion Value	The monetary value of each click-through conversion to the advertiser. The advertiser enters this value when they create a new line.	Currency	`Click Through Conversion Value`
Click Through: CPA	Tracks the click-through CPA rate, the cost per click-through conversion:Click Through CPA [114] = Advertiser Spending [44] / Click Through Conversions [110]	Currency	Adriel-computed
Click Through: CVR	Tracks the percentage of click-through conversions.	Percentage	`Click Through Conversion Rate`
Click Through: ROAS	Tracks the return on ad spend:Click Through ROAS [472] = Click Through Conversion Value [471] / Advertiser Spend [44]	Ratio	Adriel-computed
Companion Clicks	The number of clicks recorded for companion creatives.	Number	`Companion Clicks`
Companion Impressions	The number of impressions recorded for companion creatives.	Number	`Companion Impressions`
Cost Per Valid Video View (CPV)	A Cost per View (CPV) goal tracks the advertiser cost as it relates to the number of times end users view an ad:Advertiser Spending [44] / Yahoo Viewable Impressions [101]	Currency	`Cost Per Valid Video View (CPV)`
CPCV	When a viewer watches a video to completion.	Currency	`CPCV`
Cross Device Conversions	Tracks the number of cross-device conversions.	Number	`Cross-device Conversions`
Drop Rate At 0%	Tracks the percentage of video starts that were not dropped at all.	Percentage	`Drop Rate at 0%`
Drop Rate At 25%	Tracks the percentage of video starts that were dropped before at least 25% completion.	Percentage	`Drop Rate at 25%`
Drop Rate At 50%	Tracks the percentage of video starts that were dropped before at least 50% completion.	Percentage	`Drop Rate at 50%`
Drop Rate At 75%	Tracks the percentage of video starts that were dropped before at least 75% completion.	Percentage	`Drop Rate at 75%`
Estimated Billable Amount	Tracks the The costs and fees associated with lines or campaigns.Estimated Billable Amount [426] = Inventory Cost + Platform fee + Total data fee + Seat Management fee [129] + Total Vendor Fee + Order Management Fee [188]+ Programmatic Guaranteed Deal Fee + Total Tax (if applicable)Note: You can request the Estimated Billable Amount using the Advertiser Currency, Seat Currency or Campaign Currency. Check out Report Option Object for details.	Currency	`Estimated Billable Amount`
Impression Distribution Nonmeasurable	Tracks the percentage of impressions that were not measured:Impression Distribution Nonmeasurable [108] = Non-Measured Impressions [104] / Impressions [1]	Percentage	`Impression Distribution Nonmeasurable`
Impression Distribution Nonviewable	Tracks the percentage of impressions that were not viewable:Impression Distribution Nonviewable [107] = Non-Viewable Impressions [103] / Impressions [1]	Percentage	`Impression Distribution Nonviewable`
Impression Distribution Viewable	Tracks the percentage of impressions that were viewable:Impression Distribution Viewable [106] = Viewable Impressions [101] / Impressions [1]	Percentage	`Impression Distribution Viewable`
Inventory E CPM	Tracks the effective cost per thousand impressions that is paid to publishers:Inventory eCPM [48] = (Inventory Cost / Advertiser Spending [44]) * 1000	Currency	`Inventory eCPM`
Mail Ad Click Outs	The number of users who clicked a link to out the advertiser landing page.	Number	`Mail Ad Click Outs`
Mail Ad Click Outs Rate	The rate of mail click outs over mail opens.	Percentage	`Mail Ad Click Outs Rate`
Mail Ad Form Submits	When you use the Sponsored Mail Form-Fill format, the number of completed forms.	Number	`Mail Ad Form Submits`
Mail Ad Forward Rate	The rate of mail forwards over mail opens.	Percentage	`Mail Ad Forward Rate`
Mail Ad Forwards	The number of email addresses the email was forwarded to.	Number	`Mail Ad Forwards`
Mail Ad Opens	The number of impressions of the Mail Ad asset.	Number	`Mail Ad Opens`
Mail Ad Saves	The number of mail users who clicked Save.	Number	`Mail Ad Saves`
Mail Ad Saves Rate	The rate of mail saves over mail opens.	Percentage	`Mail Ad Saves Rate`
Mail Ad Submit Rate	When a user interacts with sponsored mail form-fill ads, the rate at which those users completed the form for submission.	Percentage	`Mail Ad Submit Rate`
Moat Group M Viewability Rate	The percentage of video impressions Moat records as meeting the GroupM standard for viewability relative to the number of Moat-measurable impressions.	Percentage	`Moat GroupM Viewability Rate`
Moat Measurable Impressions	Tracks Moat measurable impressions for display metrics.	Number	`Moat Measurable Impressions`
Moat Viewable Impressions	Tracks Moat viewable impressions for display metrics.	Number	`Moat Viewable Impressions`
Moat Viewable Rate	Tracks Moat viewable rate for display metrics:Moat Viewable Rate [163] = Moat Viewable Impressions [166] / Moat Measurable Impressions [167]	Percentage	`Moat Viewable Rate`
Network E CPM	Tracks the network eCPM, the effective cost per thousand impressions paid by the network:Network eCPM [45] = (Advertiser Spending [44] - Publisher Earnings [46]) * 1000	Currency	`Network eCPM`
Network Profit	Tracks network profit based on inventory costs.Note: Network Profit does not take into account data costs, data verification services costs, and other fees.	Currency	`Network Profit`
Network Profit %	Tracks the percentage of Advertiser Spending that is profit.Note: Network Profit % does not take into account data costs, data verification services costs, and other fees.	Percentage	`Network Profit %`
Order Management Fee	Tracks the order management fee.	Currency	`Order Management Fee`
Other Cost	A custom fee type that you define at the line level for margin management calculations of miscellaneous costs associated with running digital media campaigns.	Currency	`Other Cost`
Programmatic Guaranteed Deal Fee	The fee charged for running programmatic guaranteed lines using DSP.	Currency	`Programmatic Guaranteed Deal Fee`
Publisher Earnings	Tracks the amount paid to publishers.	Currency	`Publisher Earnings`
Publisher Earnings %	Tracks the publisher earnings percentage.	Percentage	`Publisher Earnings %`
Seat Data Fee	Tracks the fee charged for using Yahoo audience data.	Currency	`Seat Data Fee`
Seat Management Fee	Tracks the cost/fee charged for professional services provided by the platform account team.	Currency	`Seat Management Fee`
Seat Tech Fee	Tracks the technical fee charged for using the Yahoo DSP.	Currency	`Seat Tech Fee`
Skipped Ads	Tracks the total number of skipped ads.	Number	`Skipped Ads`
Third Party Segment Fee	The data fee applied for the use of third party Data Management Platform (DMP) audiences (BlueKai, Axion, etc.)	Currency	`Third Party Segment Fee`
Total Variable Cost	The total amount of your variable costs (ad serving costs, verification, audience measurement, brand safety, viewability and other).	Currency	`Total Variable Cost`
Total Vendor Fee	The total cost of the third-party vendor services you purchase in the Vendor Store, such as targeting, inventory quality and measurement services.	Currency	`Total Vendor Fee`
Tracked Actions	Pixel rules that are used for tracking events. Note: The API name is currently named Tracked Conversions and will be updated to Tracked Actions.	Number	`Tracked Actions`
Unique Households	For CTV lines, the number of unique households. EU users may have access to limited data because of privacy restrictions.	Number	`Unique Households`
VCPM	The Viewable CPM (vCPM) price. Some video advertisers determine ROI by looking at the cost to deliver only viewable impressions. These advertisers may use vCPM to bid the maximum amount they want to pay for a viewable ad.	Currency	`VCPM`
Very First	Includes only the first conversion attributed to an event and ignores any subsequent conversions that map to the same event.	Number	`Very First Conversion`
Very First Click Through	Tracks the count of click-through conversions generated where the ad was the user’s first click exposure.	Number	`Very First Click Through Conversion`
Very First Click Through: Conversion Value	(Yahoo Native Only) The monetary value of a user’s first click-through conversion.	Currency	`Very First Click Through Conversion Value`
Very First Click Through: CPA	Tracks the cost per very first click through conversion: Very First Click Through CPA [464] = Advertiser Spending [44] / Very First Click Through Conversions [462]	Currency	Adriel-computed
Very First Click Through: ROAS	Tracks the return on ad spend:Very First Click Through ROAS [476] = Very First Click Through Conversion Value [475] / Advertiser Spend [44]	Ratio	Adriel-computed
Very First View Through	Tracks the count of view-through conversions generated where the ad was the user’s first view exposure.	Number	`Very First View Through Conversion`
Very First View Through: Conversion Value	(Yahoo Native Only) The monetary value of a user’s first view-through conversion.	Currency	`Very First View Through Conversion Value`
Very First View Through: CPA	Tracks the cost per very first view through conversion: Very First View Through CPA [463] = Advertiser Spending [44] / Very First View Through Conversions [461]	Currency	Adriel-computed
Very First View Through: ROAS	Tracks the return on ad spend:Very First View Through ROAS [474] = Very First View Through Conversion Value [473] / Advertiser Spend [44]	Ratio	Adriel-computed
View Through	Tracks view-through conversions. A view-based conversion occurs when a user views an ad impression.	Number	`View Through Conversion`
View Through Dynamic: Conversion Value	The monetary value of each dynamic view-through conversion to the advertiser. The advertiser enters this value when they create a new line.	Currency	`View Through Dynamic Conversion Value`
View Through: Conversion Value	The monetary value of each view-through conversion to the advertiser. The advertiser enters this value when they create a new line.	Currency	`View Through Conversion Value`
View Through: CPA	Tracks the view-through CPA rate, the cost per view through conversion:View Through CPA [113] = Advertiser Spending [44] / View Through Conversions [109]	Currency	Adriel-computed
View Through: CVR	Tracks the percentage of view-through conversions.	Percentage	`View Through Conversion Rate`
View Through: ROAS	Tracks the return on ad spend:View Through ROAS [470] = View Through Conversion Value [469] / Advertiser Spend [44]	Ratio	Adriel-computed
Viewability Cost	The cost of third-party viewability targeting services you opt in to in the Vendor Store.	Currency	`Viewability Cost`
Yahoo Demo Fee	In cases where Yahoo charges a demographic fee, this is the fee for all impressions with age and gender targeting.	Currency	`Yahoo Demo Fee`
Yahoo Measurable Impressions	Tracks the number of impressions measured for viewability.Note: Not all impressions may be measured because of technical limitations or publisher page design.	Number	`Yahoo Measurable Impressions`
Yahoo Measurable Rate	Tracks the percentage of impressions measured for viewability:Yahoo Measurable Rate [105] = Measured Impressions [100] / Impressions [1]	Percentage	`Yahoo Measurable Rate`
Yahoo Non Measurable Impressions	Tracks the number of impressions where viewability could not be measured:Non-Measurable Impressions [104] = Impressions [1] - Yahoo Measurable Impressions [100]	Number	`Yahoo Non-Measurable Impressions`
Yahoo Nonviewable Impressions	Tracks the number of impressions that were not viewable:Non-Viewable Impressions [104] = Impressions [100] - Yahoo Viewable Impressions [101]	Number	`Yahoo Nonviewable impressions`
Yahoo Segment Fee	The data fee applied for the use of the following types of Yahoo audiences (Mail Domain, POI Location, Purchase Receipt, Search Keyword, Tailored Audience, Lookalike Audience and Predictive Audiences).	Currency	`Yahoo Segment Fee`
Yahoo Viewable Impressions	Tracks the viewable impressions per MRC Viewable Impression Guidelines.Yahoo Viewable Impressions [101] = Impressions [1] - Measured Impressions [100]	Number	`Yahoo Viewable Impressions`
Yahoo Viewable Rate	Tracks the percentage of measured impressions that were viewable:Yahoo Viewable Rate [102] = Yahoo Viewable Impressions [101] / Measured Impressions [100]	Percentage	`Yahoo Viewable Rate`

Breakdowns

Campaign Structure

Breakdown	Description	API Key
Ad	Ad (creative) associated with the row.	Adriel-side
Ad Account	Ad account associated with the row.	Adriel-side
Ad Name	Groups results by ad name.	Adriel-side
Ad Set	Ad set (line item) associated with the row.	Adriel-side
Ad Set Name	Groups results by ad set (line item) name.	Adriel-side
Campaign	Campaign associated with the row.	Adriel-side
Campaign Name	Groups results by campaign name.	Adriel-side
Channel	Marketing channel associated with the row.	Adriel-side
Objective	Groups campaigns by their objective.	Adriel-side
Platform	Groups results by advertising platform.	Adriel-side
Status (Toggle)	Current delivery status of the campaign, ad set, or ad.	Adriel-side

Creatives

Adriel post-processes ad creatives to generate these breakdowns.

Breakdown	Description	API Key
Ad Copy	Word extracted from the creative text.	Adriel-side
Color Clustering	Dominant color cluster detected in the creative.	Adriel-side
Creative Image	Image hash used to group visually identical or similar creatives.	Adriel-side
Emoji Analysis	Emoji detected in the creative text or image analysis.	Adriel-side

Date

Yahoo DSP returns daily records; Adriel groups them into these views, so all time breakdowns are Adriel-side aggregations of the same underlying daily data.

Breakdown	Description	API Key
Auto Time Breakdown	Automatically selected time bucket based on the requested date range.	Adriel-side
Daily Breakdown	Calendar day for the reported data.	Adriel-side
Monthly Breakdown	Calendar month for the reported data.	Adriel-side
Quarterly Breakdown	Calendar quarter for the reported data.	Adriel-side
Week Date Breakdown	Start date of the week bucket for the reported data.	Adriel-side
Week Number Breakdown (W#)	Week number in the year for the reported data.	Adriel-side
Weekly Breakdown (Start: Mon)	Calendar week for the reported data, starting Monday.	Adriel-side
Weekly Breakdown (Start: Sun)	Sunday-through-Saturday week bucket for the reported data.	Adriel-side
Yearly Breakdown	Calendar year for the reported data.	Adriel-side

Others

This grouping is provided by Adriel for organizing and rolling up report rows.

Breakdown	Description	API Key
No Grouping	Single combined bucket across the selected date range.	Adriel-side

Target

Breakdown	Description	API Key
Age	Audience age-range segment for the reported data.	Adriel-side
Gender	Audience gender segment for the reported data.	Adriel-side
Location	Location segment for the reported data, such as country, region, or city.	Adriel-side

Limitations

Cache-only reporting — reports come from cached daily snapshots, not live fetch. Every dashboard query reads the most recent snapshot, and values outside the 10-day rolling sync window (within the 730-day backfill) may be incomplete or not fully accurate.
Uniqueness metrics can be overstated — reach, unique households, and similar metrics are summed from daily snapshots, so multi-day ranges can overcount unique audiences.
No long-lived refresh token — Yahoo DSP’s JWT-bearer flow does not issue a refresh token. A fresh JWT is constructed and exchanged for a new access token (1-hour TTL) on demand whenever the current one expires. The exchange is invisible to dashboards.
Metric availability depends on access type — Seat access exposes the full metric set, including video completion counts and rates, viewability (Yahoo and Moat), frequency, and seat fees. General Access Network (GAN) access is limited to core delivery, click, conversion, VCPM, CPCV, and tracked-action metrics.
Channel-specific metrics — CTV metrics, such as unique households and average frequency per household, and DOOH metrics, such as audience impressions and average impression multiplier, appear only on those placement types; average frequency per household may be limited for EU audiences due to privacy restrictions. Yahoo Native mail-ad and tile metrics apply only to Yahoo Native placements under Seat access.
Date range caps per breakdown — daily breakdowns are capped at 93 days, weekly at 1 year, and monthly at 2 years; longer ranges rely on quarterly and yearly breakdowns.

API references

Reports are retrieved through the Yahoo DSP extreport asynchronous reporting API (create a job, poll until it succeeds or fails, then download the CSV).
Authentication uses Yahoo DSP’s JWT-bearer OAuth2 client-credentials flow; a short-lived access token is passed in the X-Auth-Token header.
Yahoo DSP API documentation

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Campaign Attributes

​Campaign Structure

​Click Performance

​Computed Metrics

​Conversion Performance

​Creative Attributes

​Engagement

​Video Performance

​Yahoo DSP-specific

​Breakdowns

​Campaign Structure

​Creatives

​Date

​Others

​Target

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Campaign Attributes

Campaign Structure

Click Performance

Computed Metrics

Conversion Performance

Creative Attributes

Engagement

Video Performance

Yahoo DSP-specific

Breakdowns

Campaign Structure

Creatives

Date

Others

Target

Limitations

API references

See also