Loading...
Multi-Touch Marketing Attribution Pipeline on Snowflake
A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.
- Domain
- Pipeline Design
- Difficulty
- medium
- Seniority
- staff
Problem
Our marketing analytics platform stitches together ad spend from Google and Facebook, CRM opportunities from Salesforce, and web session data from multiple clients. The attribution model needs to give credit to every touchpoint in the customer journey before a conversion, but the data quality is inconsistent across sources and some of them don't expose an updated_at field, which makes incremental processing painful. Design a transformation pipeline that handles these sources reliably and keeps attribution fresh enough for daily campaign decisions.
Practice This Problem
Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it instantly.