Design the Ads Data Model
Direct-sold means a person sold it. A sales team agrees a deal with a brand or its agency, say two million impressions on TVs in the US over November at a fixed price per thousand. The signed paper is an insertion order, which ad ops calls the IO. Trafficking is the work of entering that deal into the ad system so it serves. There's no auction anywhere in this prompt. The price is set in the contract, and the ad system's job is to deliver what was promised and bill for what it delivered. You'll draw some boxes in this round, but most of the grade comes from the schema: which entities exist, how they relate, where each field lives, and what happens to all of it when a deal changes halfway through. The boxes matter where the schema meets two very different workloads. The ad server reads the setup thousands of times a second, and the impression log writes billions of rows a day.
NetflixPremium lesson · System design round
The Netflix design, worked end to end.
- The API and data modelSystem design · Signature problem
- The design, drawn out1 diagram
- 6 deep divesWith the tradeoffs
$49 a year · all 107 companies · instant access
181 Netflix interview reports · guide updated
Netflix interview guideKnow what Netflix asks before you walk in.
20 coding · 9 system design · 19 behavioral questions
Get their questions first.
InterviewLegend is independent and not affiliated with or endorsed by any company it covers.