Opengist

Explore

  • All gists
  • Topics
  • Users
Give feedback on the new UI Powered by Opengist ⋅ 168ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login Register
i

interview

Recently created Least recently created Recently updated Least recently updated

linkjobai / System Design Interview: Designing an Ad Click Aggregator

Last active 5 days ago interview

Interview prep notes

0 0 1

System Design Interview: Designing an Ad Click Aggregator

Advertisers are billed on click counts, so the numbers must be correct, and they want them within a minute.

Requirements

  • Ingest click events (ad_id, user, timestamp, ...) at ~50k per second, peaks of 5x.
  • Query clicks per ad per minute for the last N minutes, and top-K ads per minute.
  • Counts must be accurate for billing; late and duplicate events happen.