Loading interview...

Attributable Impression Rate

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
medium
Seniority
junior, mid

Interview Prompt

The attribution team is measuring data completeness in the ad pipeline. What percentage of all ad impressions can be tied back to a known user account? Impressions whose user cannot be found in the user records should still count toward the total but not as attributable. Return a single percentage.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision