Scenario: Global ads revenue fell sharply last week. Potential culprits include auction dynamics, inventory shifts, seasonality, or UX changes. Your mission is to triage data sources, isolate the drivers, and brief executives with actionable next steps.
Question 1: Total ads revenue is down—outline steps to diagnose root causes. (Hint: bid CPM shifts, inventory, fill‑rate, seasonality)
Quick Answer: Evaluates ads-marketplace revenue-drop diagnosis using revenue decomposition and executive triage. Strong answers check data quality, seasonality, bid CPM, inventory, fill rate, auction dynamics, segmentation, and actions.
You are a data scientist supporting a large ads marketplace. Last week, global ads revenue declined sharply. Potential drivers include auction dynamics, bid CPM shifts, supply or inventory changes, fill-rate issues, seasonality, and recent UX, ML, or product changes.
Outline a practical step-by-step approach to diagnose root causes and brief executives with actionable next steps.
Constraints & Assumptions
Decompose revenue into key marketplace drivers.
Use clean baselines and normalize for time, currency, and seasonality.
Check data quality before interpreting business movement.
Include executive-ready quantification of driver contributions.
Clarifying Questions to Ask Guidance
Which revenue definition is used: booked, recognized, gross, or net?
Which placements, formats, geographies, advertisers, and auctions are affected?
Were there recent ranking, pacing, policy, UX, logging, or pricing changes?
Are late revenue posting, exchange rates, or billing issues possible?
Part 1 - Baseline and Data Quality
How would you frame and verify the revenue decline?
What This Part Should Cover Guidance
Define scope, time window, comparison baseline, time zone, and currency normalization.
Check pipeline health, missing logs, delayed posting, billing issues, and reconciliation with finance.
Compare week-over-week, year-over-year, and expected seasonality.
Part 2 - Revenue Decomposition
How would you use bid CPM, inventory, fill rate, and seasonality?
What This Part Should Cover Guidance
Decompose revenue into impressions or inventory, fill rate, auction participation, bid CPM, win rate, price, CTR/CVR where relevant, and advertiser budget.
Segment by geo, placement, format, advertiser vertical, campaign objective, device, and app version.
Use waterfall or contribution analysis to quantify drivers.
Part 3 - Root Cause and Actions
How would you isolate root causes and recommend next steps?
What This Part Should Cover Guidance
Link driver movements to product releases, ML model changes, policy changes, advertiser demand shifts, supply shifts, and incidents.
Use holdouts, experiments, rollback checks, or counterfactual forecasts where available.
Recommend immediate mitigation, owner, expected recovery, and monitoring.
Follow-up Questions Guidance
What if revenue drops but ad impressions rise?
How would you distinguish demand-side from supply-side problems?