Model Direct-Sold DSP Orders
Company: Netflix
Role: Software Engineer
Category: Software Engineering Fundamentals
Difficulty: medium
Interview Round: Onsite
Design a data model for tracking a direct-sold demand order in a demand-side advertising platform.
Context:
- The platform manages advertiser demand and serves ads through a DSP-like system.
- The order type is direct-sold demand, not open auction demand.
- Because this is direct-sold demand, the model should not assume open auction mechanics such as exchange auctions, bid requests from open exchanges, or auction clearing prices.
Your model should cover:
- Advertisers and agencies.
- Orders and order-level configuration.
- Line items, flights, budgets, pacing, and delivery goals.
- Targeting configuration.
- Creatives and creative approval state.
- Frequency caps and other serving constraints.
- Tracking impressions, clicks, conversions, and delivery status.
- Versioning or auditability of configuration changes.
- Reporting use cases.
Overview: This Software Engineering Fundamentals question evaluates data and domain modeling skills for ad-technology order management, focusing on entities such as advertisers, agencies, orders, line items, targeting, creatives, delivery constraints, tracking events, reporting needs, and configuration versioning.