The Desi Architect
Notes / Design Interview Problems / Design Ad Click Aggregator (Google Ads / Meta Ads)
Track 5 · Design Interview Problems

Design Ad Click Aggregator (Google Ads / Meta Ads)

Scale an ad click tracking and aggregation engine to 100,000 clicks per second during IPL matches. API contracts, database schemas, deduplication, 1-minute windowing, and fraud defense.

Interview problem25 min read
On this page
  1. Problem framing
  2. Questions I ask before drawing anything
  3. Requirements and scope
  4. Capacity estimation and sizing
  5. Core entities and data models
  6. API design
  7. High-level architecture and build-up
  8. Deep dives into hard problems
  9. Edge cases and failure recovery
  10. Interview rubric: What separates levels