Staff Data Engineer Enterprise Architecture
AdtWho Saw the Ad Twice
We measure advertising effectiveness across linear TV and digital platforms, but right now our TV and digital measurement pipelines are completely separate. Advertisers want to know the true unduplicated reach of a campaign that ran on both broadcast TV and connected apps. This requires joining second-level TV ad exposure logs from set-top boxes with digital impression logs, all without exposing raw PII. Design a pipeline that produces these cross-platform audience metrics.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Who Saw the Ad Twice
A hard Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- staff
Interview Prompt
We measure advertising effectiveness across linear TV and digital platforms, but right now our TV and digital measurement pipelines are completely separate. Advertisers want to know the true unduplicated reach of a campaign that ran on both broadcast TV and connected apps. This requires joining second-level TV ad exposure logs from set-top boxes with digital impression logs, all without exposing raw PII. Design a pipeline that produces these cross-platform audience metrics.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision