Q2’26 Revenue Dashboard

Property:

Channel:

All Media Properties

QTD $29.6M+$0.7M +2.6%

Implied Q $299.6M+$6.7M vs budget

YoY vs Q2’25+22.0%

COO Group

QTD $25.1M+$0.3M +1.1%

Implied Q $252.7M$-7.5M vs budget

YoY vs Q2’25+28.5%

Mail

QTD $18.1M+$1.3M +7.9%

Implied Q $181.4M+$11.7M vs budget

YoY vs Q2’25+36.2%

News Group

QTD $7.0M$-1.0M (-12.9%)

Implied Q $71.3M$-19.2M vs budget

YoY vs Q2’25+12.2%

YMG

QTD $4.5M+$0.5M +11.3%

Implied Q $46.9M+$14.2M vs budget

YoY vs Q2’25(-5.1%)

Finance

QTD $2.3M+$0.2M +8.6%

Implied Q $22.6M$-0.1M vs budget

YoY vs Q2’25(-20.8%)

Sports

QTD $2.2M+$0.3M +14.1%

Implied Q $24.3M+$14.3M vs budget

YoY vs Q2’25+19.8%

Mail Display Day 9 of 91

$10.7M

QTD Actual

$11.6M

QTD Budget

$-0.9M (-7.9%)

vs Budget

$106.4M

Implied Q

$119.4M

Q Budget

$-13.0M (-10.9%)

Implied vs Q

▼ $-8.5M W/W YoY: +23.4% vs Q2'25

Mail Native Day 9 of 91

$7.3M

QTD Actual

$5.0M

QTD Budget

+$2.3M +45.5%

vs Budget

$73.8M

Implied Q

$48.7M

Q Budget

+$25.1M +51.5%

Implied vs Q

▼ $-1.2M W/W YoY: +58.2% vs Q2'25

Mail Direct Sold Day 9 of 91

$0.1M

QTD Actual

$0.2M

QTD Budget

$-0.1M (-32.2%)

vs Budget

$1.1M

Implied Q

$1.6M

Q Budget

$-0.5M (-30.2%)

Implied vs Q

▲ +$0.1M W/W YoY: +670.5% vs Q2'25

News Group Display Day 9 of 91

$5.4M

QTD Actual

$6.5M

QTD Budget

$-1.2M (-17.7%)

vs Budget

$54.9M

Implied Q

$73.6M

Q Budget

$-18.7M (-25.4%)

Implied vs Q

▲ +$2.7M W/W YoY: +13.2% vs Q2'25

News Group Native Day 9 of 91

$1.0M

QTD Actual

$1.1M

QTD Budget

$-0.0M (-3.7%)

vs Budget

$10.7M

Implied Q

$11.9M

Q Budget

$-1.2M (-9.8%)

Implied vs Q

▲ +$0.6M W/W YoY: (-11.7%) vs Q2'25

News Group Video Day 9 of 91

$0.2M

QTD Actual

$0.2M

QTD Budget

+$0.0M +24.6%

vs Budget

$2.3M

Implied Q

$2.1M

Q Budget

+$0.2M +9.3%

Implied vs Q

▲ +$0.3M W/W YoY: +27.2% vs Q2'25

News Group Direct Sold Day 9 of 91

$0.4M

QTD Actual

$0.2M

QTD Budget

+$0.1M +48.0%

vs Budget

$3.4M

Implied Q

$2.9M

Q Budget

+$0.4M +15.5%

Implied vs Q

▼ $-1.3M W/W YoY: +175.0% vs Q2'25

Finance Display Day 9 of 91

$1.3M

QTD Actual

$1.2M

QTD Budget

+$0.1M +11.1%

vs Budget

$12.8M

Implied Q

$12.2M

Q Budget

+$0.5M +4.5%

Implied vs Q

▼ $-3.0M W/W YoY: (-13.2%) vs Q2'25

Finance Native Day 9 of 91

$0.2M

QTD Actual

$0.2M

QTD Budget

$-0.0M (-17.4%)

vs Budget

$1.9M

Implied Q

$2.3M

Q Budget

$-0.4M (-17.7%)

Implied vs Q

▼ $-0.3M W/W YoY: (-27.6%) vs Q2'25

Finance Video Day 9 of 91

$0.1M

QTD Actual

$0.1M

QTD Budget

+$0.0M +15.8%

vs Budget

$1.0M

Implied Q

$0.9M

Q Budget

+$0.1M +6.8%

Implied vs Q

▼ $-0.2M W/W YoY: +18.4% vs Q2'25

Finance Direct Sold Day 9 of 91

$0.7M

QTD Actual

$0.6M

QTD Budget

+$0.1M +13.0%

vs Budget

$7.0M

Implied Q

$7.2M

Q Budget

$-0.3M (-3.8%)

Implied vs Q

▲ +$0.5M W/W YoY: (-33.6%) vs Q2'25

Sports Display Day 9 of 91

$0.8M

QTD Actual

$0.5M

QTD Budget

+$0.3M +59.2%

vs Budget

$8.1M

Implied Q

$5.8M

Q Budget

+$2.3M +38.6%

Implied vs Q

▲ +$1.1M W/W YoY: +52.0% vs Q2'25

Sports Native Day 9 of 91

$0.1M

QTD Actual

$0.1M

QTD Budget

+$0.0M +3.3%

vs Budget

$0.8M

Implied Q

$0.7M

Q Budget

+$0.1M +7.4%

Implied vs Q

▲ +$0.1M W/W YoY: +217.3% vs Q2'25

Sports Video Day 9 of 91

$0.1M

QTD Actual

$0.1M

QTD Budget

+$0.0M +14.4%

vs Budget

$0.7M

Implied Q

$0.5M

Q Budget

+$0.2M +48.8%

Implied vs Q

▲ +$0.1M W/W YoY: (-39.4%) vs Q2'25

Sports Direct Sold Day 9 of 91

$1.3M

QTD Actual

$1.3M

QTD Budget

$-0.0M (-2.0%)

vs Budget

$14.7M

Implied Q

$2.9M

Q Budget

+$11.8M +403.4%

Implied vs Q

▲ +$8.2M W/W YoY: +7.5% vs Q2'25

Daily Revenue — All Segments

View:

Overlay:

$29.6M

QTD Actual

$28.9M

QTD Budget

+$0.7M +2.6%

QTD vs Budget

$299.6M

Implied Q

$292.9M

Q Budget

+$6.7M +2.3%

Implied vs Q Budget

—

7-Day Shift

—

YoY vs Q2’25

Show: 960×360px panels • Screenshot or Ctrl+P to print

Mail Display | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$10.7M

Budget $11.6M

$-0.9M (-7.9%)

Q2'25 $8.7M

+23.4% YoY

Implied Q (7-day)

$106.4M

Budget $119.4M

$-13.0M (-10.9%)

7-Day Shift

▼ $-8.5M W/W

Mail Native | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$7.3M

Budget $5.0M

+$2.3M +45.5%

Q2'25 $4.6M

+58.2% YoY

Implied Q (7-day)

$73.8M

Budget $48.7M

+$25.1M +51.5%

7-Day Shift

▼ $-1.2M W/W

Mail Direct Sold | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.1M

Budget $0.2M

$-0.1M (-32.2%)

Q2'25 $0.0M

+670.5% YoY

Implied Q (7-day)

$1.1M

Budget $1.6M

$-0.5M (-30.2%)

7-Day Shift

▲ +$0.1M W/W

News Group Display | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$5.4M

Budget $6.5M

$-1.2M (-17.7%)

Q2'25 $4.8M

+13.2% YoY

Implied Q (7-day)

$54.9M

Budget $73.6M

$-18.7M (-25.4%)

7-Day Shift

▲ +$2.7M W/W

News Group Native | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$1.0M

Budget $1.1M

$-0.0M (-3.7%)

Q2'25 $1.2M

(-11.7%) YoY

Implied Q (7-day)

$10.7M

Budget $11.9M

$-1.2M (-9.8%)

7-Day Shift

▲ +$0.6M W/W

News Group Video | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.2M

Budget $0.2M

+$0.0M +24.6%

Q2'25 $0.2M

+27.2% YoY

Implied Q (7-day)

$2.3M

Budget $2.1M

+$0.2M +9.3%

7-Day Shift

▲ +$0.3M W/W

News Group Direct Sold | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.4M

Budget $0.2M

+$0.1M +48.0%

Q2'25 $0.1M

+175.0% YoY

Implied Q (7-day)

$3.4M

Budget $2.9M

+$0.4M +15.5%

7-Day Shift

▼ $-1.3M W/W

Finance Display | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$1.3M

Budget $1.2M

+$0.1M +11.1%

Q2'25 $1.5M

(-13.2%) YoY

Implied Q (7-day)

$12.8M

Budget $12.2M

+$0.5M +4.5%

7-Day Shift

▼ $-3.0M W/W

Finance Native | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.2M

Budget $0.2M

$-0.0M (-17.4%)

Q2'25 $0.3M

(-27.6%) YoY

Implied Q (7-day)

$1.9M

Budget $2.3M

$-0.4M (-17.7%)

7-Day Shift

▼ $-0.3M W/W

Finance Video | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.1M

Budget $0.1M

+$0.0M +15.8%

Q2'25 $0.1M

+18.4% YoY

Implied Q (7-day)

$1.0M

Budget $0.9M

+$0.1M +6.8%

7-Day Shift

▼ $-0.2M W/W

Finance Direct Sold | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.7M

Budget $0.6M

+$0.1M +13.0%

Q2'25 $1.0M

(-33.6%) YoY

Implied Q (7-day)

$7.0M

Budget $7.2M

$-0.3M (-3.8%)

7-Day Shift

▲ +$0.5M W/W

Sports Display | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.8M

Budget $0.5M

+$0.3M +59.2%

Q2'25 $0.5M

+52.0% YoY

Implied Q (7-day)

$8.1M

Budget $5.8M

+$2.3M +38.6%

7-Day Shift

▲ +$1.1M W/W

Sports Native | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.1M

Budget $0.1M

+$0.0M +3.3%

Q2'25 $0.0M

+217.3% YoY

Implied Q (7-day)

$0.8M

Budget $0.7M

+$0.1M +7.4%

7-Day Shift

▲ +$0.1M W/W

Sports Video | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$0.1M

Budget $0.1M

+$0.0M +14.4%

Q2'25 $0.1M

(-39.4%) YoY

Implied Q (7-day)

$0.7M

Budget $0.5M

+$0.2M +48.8%

7-Day Shift

▲ +$0.1M W/W

Sports Direct Sold | Q2’26 Daily Performance vs Budget

Through 2026-04-09 • Day 9 of 91 • 7-day pace

QTD Actual

$1.3M

Budget $1.3M

$-0.0M (-2.0%)

Q2'25 $1.2M

+7.5% YoY

Implied Q (7-day)

$14.7M

Budget $2.9M

+$11.8M +403.4%

7-Day Shift

▲ +$8.2M W/W

Scope & Exclusions

This dashboard covers advertising revenue only across Yahoo O&O (owned & operated) properties. The following revenue streams are excluded:

Search — Yahoo Search (Bing-powered) TAC and revenue are reported separately
Commerce / Shopping — affiliate and transaction-based revenue is excluded
AOL / Partner properties — aol_webmail, aol, aol_client_hp, aol_client_mail, aolhomepage, aol_login, aolgames are not included
Engadget — excluded from property scope

Property Definitions

Dashboard Label	BQ content_site_name values	Notes
Mail	yahoo_mail, mail, yahoo_login	yahoo_mail = desktop/tablet; mail = Yahoo Mail mobile (100% Native/Taboola); yahoo_login = sign-in page
HNEL (News Group)	news, frontpage, fp, entertainment, lifestyle, creators, shopping, style, health, autos, travel, yahoo_games, tech, weather, att, superapp, games, local, movies	Home, News, Entertainment, Lifestyle and related O&O surfaces
Finance	finance	Yahoo Finance
Sports	sports, sports-fantasy, fullfantasy, fantasy	Yahoo Sports including Fantasy Football/Baseball

Channel Definitions

Channel	Classification Logic	Notes
Native	billing_use_case IN ('TABOOLA', 'TABOOLA_NATIVE_IO')	All Taboola-served native placements across properties
Direct Sold	billing_component_id = 105 OR billing_use_case = 'GAM_GUARANTEED'	IO-based guaranteed deals; also captured as All Formats / Direct Sold in budget file
Display	All remaining impressions where configured_media_type is null, 'display', 'banner', or 'rich_media'	Programmatic display via GAM open auction and PG/PD deals
Video	configured_media_type IN ('video', 'instream_video', 'outstream_video')	Instream and outstream video; outstream is small share

Revenue Definition

Actuals: SUM(billing_bill_amount / 1,000,000,000) where billable_status = 3 (billed impressions only). Source table: data-revads-p.revads_vw.v_preagg_oo_daily. Filtered to valid = TRUE to exclude duplicate/test rows.

Budget: Finance Consumer GAAP Budget from 2025_2026 Daily Budget.xlsx, sheet Q2 FY26 Daily Budget. Filtered to Device = "All Devices" to avoid double-counting desktop/mobile/TW/HK splits. Native LLF (large format) is combined with standard Native budget.

YoY (Q2 2025): Same query and channel logic applied to 2025-04-01 through 2025-06-30. Cached locally after first pull; re-pulled only on explicit refresh.

Metric Definitions

Metric	Definition
QTD Actual	Sum of daily revenue from Q2 start (Apr 1) through latest available date
QTD Budget	Sum of daily budget from Q2 start through same latest date
QTD vs Budget	QTD Actual minus QTD Budget, in $M and as % of QTD Budget
Q Budget	Full-quarter budget (Apr 1 – Jun 30) for the segment
Implied Q	QTD Actual + (average of last 7 days × remaining days in quarter). Represents where the quarter would land if recent run-rate holds.
Implied vs Q Budget	Implied Q minus full-quarter budget
7-Day Shift	Change in the 7-day average daily revenue vs the prior 7-day period, as a %
YoY	QTD Actual vs same date range in Q2 2025, as a %
Trajectory chart	Each plotted point = Implied Q as-of that date (QTD through that day + 7-day avg × remaining days). Shows how the implied landing has evolved over the quarter.

Group Definitions

Group	Properties Included	Context
COO Group	Mail + HNEL (News Group)	Properties under COO org reporting
YMG	Finance + Sports	Yahoo Media Group properties
All Media Properties	Mail + HNEL + Finance + Sports	Full O&O advertising footprint covered by this dashboard

Event Annotations

Vertical dashed lines on all charts mark known demand-driving events. Q2 2026 events appear on the current-year bars; Q2 2025 events appear at the equivalent day-of-quarter position (for YoY context).

Event	Date	Year	Revenue Impact
NCAA Championship (March Madness)	Apr 6	2026	Sports Display & Native spike; broader News Group lift
NCAA Championship (March Madness)	Apr 7	2025	Same pattern in prior year — useful YoY comp anchor
Liberation Day (tariff announcement)	Apr 2	2025	Broad ad market pullback; demand uncertainty across all channels
Tax Filing Deadline	Apr 15	Both	Finance Display & Native surge; Mail Native (Taboola) elevated from tax-season advertiser spend

To add or edit events: update the EVENTS list in build_daily_dash.py and re-run python build_daily_dash.py.

Data Freshness & Refresh

BQ data lag: v_preagg_oo_daily typically reflects the prior day by mid-morning. Dashboard always pulls through yesterday's date.

Refresh cadence: Run manually each morning after GCP authentication (bq_auth.ps1 — requires PIN + Yubikey). Two commands: python refresh_daily_dash.py then python build_daily_dash.py.

Q2 2025 YoY cache: Historical Q2 2025 data is cached locally after first pull and reused on subsequent refreshes. To force a re-pull: python refresh_daily_dash.py --refresh-yoy.

Last updated: 2026-04-10 01:10 PM