System Design Fight Club

Over 50 System Design Interview Question Solutions

Audience Segmentation (“Ad Targeting System”)

RESOURCES

  • I’ve already done multiple iterations of ad click stuff, so we’re focusing on a piece I haven’t explored as much yet

PROMPTS

ad targeting system

Company: Pinterest
Role: either mid-level or senior

REQUIREMENTS

  • the ads should be “personalized” to a given user

CHECKLIST:

  • load balancers
  • CDNs?
  • secondary indices?
  • DB schemas
  • partitioning keys, secondary indices
  • NALSD numbers (return to this at end)

LIVE DISCUSSION QUESTIONS:

what about users from different countries or regions?

Does ad-bidding happen real time? Or it is kind of precomputed in Ad-Feature Data Store? -– pre-computing winning bids might actually be “NP complete”

How Ad Feature Data Store in populated? -– it’s off of explicit entries in the webpages presented to marketing analysts

Do brand reach out to G saying this is our offering for ‘X’ day?