InterviewLegend

Design the Ads Data Model

Signature problem
Alex Chen45 min readAdded 181 real interview reports

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.

The Netflix angle
Netflix Ads onsites often run a dedicated data modeling round beside the system design round. One L4 loop called it "Data modeling & business impact", so expect to say how a schema choice changes revenue. Netflix moved to its own ad tech in 2025, so your interviewer may well work on this.

NetflixPremium lesson · System design round

The Netflix design, worked end to end.

  1. The API and data modelSystem design · Signature problem
  2. The design, drawn out1 diagram
  3. 6 deep divesWith the tradeoffs
Get the Netflix questions

$49 a year · all 107 companies · instant access

181 Netflix interview reports · guide updated

Netflix interview guide

Know what Netflix asks before you walk in.

20 coding · 9 system design · 19 behavioral questions

Get Premium$49 a year · Instant access
Or start freeNo card.

Get their questions first.

Had your Netflix interview?How we research

InterviewLegend is independent and not affiliated with or endorsed by any company it covers.