Back to problems

Design an ad-click aggregation and enrichment pipeline

System Design · Rippling · Hard

Design the measurement layer for a digital advertising analytics platform. Mobile applications and web pages produce an event each time an ad impression or click happens. Consumers require both live operational dashboards and historical reports. Functional requirements: Receive impression and click events from mobile and web clients. Compute click, impression, and CTR aggregates where $$CTR = \frac{\text{clicks}}{\text{impressions}}$$. Support aggregation windows of 1…

Checking your access…