Ad click aggregation: fast, and right enough to bill
One strong interview answer to counting a billion ad clicks a day: a Flink stream for minute-fresh dashboards and an hourly Spark recompute for the billed truth, exactly once as a chain from signed click_id to an overwriting sink, event-time windows with watermarks for late clicks, and salted two-stage aggregation for hot ads.
01 · Every click is money
IP-16 · Design an Ad Click Aggregation System
Every click is money.
Paid per click
Every click on an ad is money.
0:00 / 13:37