PracHub
QuestionsPremiumLearningGuidesCheatsheetNEWCoaches
|Home/System Design/Netflix

Model data for an ads platform

Last updated: Apr 28, 2026

Quick Overview

This question evaluates proficiency in data modeling and database schema design for advertising systems, including entity-relationship modeling, privacy-aware user identifier handling, and delivery/tracking log representation.

  • medium
  • Netflix
  • System Design
  • Software Engineer

Model data for an ads platform

Company: Netflix

Role: Software Engineer

Category: System Design

Difficulty: medium

Interview Round: Onsite

Design a **data model** (logical schema) for an advertising platform. Include core entities such as: - Business/account (advertiser) - Campaign and budget - Ad group / line item (if applicable) - Creative and assets - Targeting (audiences, geo, device, etc.) - User (or user identifiers) and privacy constraints - Delivery logs: impressions, clicks, conversions Explain: - Key relationships (1:N, N:M) and how you represent them. - How the schema supports the major flows: 1) **Intake/creation** flow (advertiser creates campaigns/creatives) 2) **Serving** flow (ad selection at request time) 3) **Tracking** flow (impression/click/conversion logging and attribution) - Any indexing/partitioning choices you would make for scale and reporting.

Quick Answer: This question evaluates proficiency in data modeling and database schema design for advertising systems, including entity-relationship modeling, privacy-aware user identifier handling, and delivery/tracking log representation.

Related Interview Questions

  • Design Ad Frequency and Order Tracking - Netflix
  • Design Rolling-Window Ad Frequency Capping - Netflix (medium)
  • Design ad frequency capping - Netflix (medium)
  • Design a File Backup System - Netflix (hard)
  • Design an Ad Frequency Capping System - Netflix
Netflix logo
Netflix
Jan 30, 2026, 12:00 AM
Software Engineer
Onsite
System Design
33
0

Design a data model (logical schema) for an advertising platform.

Include core entities such as:

  • Business/account (advertiser)
  • Campaign and budget
  • Ad group / line item (if applicable)
  • Creative and assets
  • Targeting (audiences, geo, device, etc.)
  • User (or user identifiers) and privacy constraints
  • Delivery logs: impressions, clicks, conversions

Explain:

  • Key relationships (1:N, N:M) and how you represent them.
  • How the schema supports the major flows:
    1. Intake/creation flow (advertiser creates campaigns/creatives)
    2. Serving flow (ad selection at request time)
    3. Tracking flow (impression/click/conversion logging and attribution)
  • Any indexing/partitioning choices you would make for scale and reporting.

Solution

Show

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More System Design•More Netflix•More Software Engineer•Netflix Software Engineer•Netflix System Design•Software Engineer System Design
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.