The Question
DesignAd Click Aggregation Pipeline
Design a distributed, real-time system to ingest and aggregate advertisement clicks at a scale of billions of daily events. The system must support exactly-once processing for accurate billing, handle out-of-order events using time-windowed aggregations, and provide low-latency query access for advertiser performance dashboards.
Kafka
Flink
ClickHouse
Redis
Protobuf
RocksDB
March 4, 2026