Which Promotion Is Actually Working

A hard Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

hard

Seniority

L6

Problem

We're a consumer goods company running dozens of trade promotions at once across hundreds of retail partners, and the commercial team needs promotion ROI fresh enough to cut the ones that are wasting money. Shipment events stream out of our ERP in near-real time, retailer sell-through arrives as daily files, and third-party market data lands once a week, and all of it converges in an analytics warehouse where every sale is credited to the promotion that was running when it happened. The retailer files are messy (duplicate rows and bad product codes), so the bad rows have to be set aside for review rather than dropped, and before the ROI numbers go out they have to reconcile against ERP shipment totals. Design the ingestion and warehouse architecture, keeping each source on a cadence that matches how fresh its consumer needs it.

Summary

Was the promotion worth it? The data knows.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.