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 are a consumer goods company running dozens of trade promotions simultaneously across hundreds of retail partners, and our commercial analytics team needs to measure promotion ROI in near-real time to see which promotions are working and which are wasting money. Right now the data is fragmented across retailer portals, our own ERP, and third-party syndicated data providers. Design the ingestion pipeline and the BigQuery analytics architecture.

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.