Accounted For

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The attribution team is auditing the ad log campaign by campaign, where an impression counts as traceable only when it maps to a known user account. For each campaign, find the percentage of its impressions that are traceable, most traceable first.

Summary

Every impression is a face in the crowd; some we can name, the rest are strangers. Measure the gap, campaign by campaign.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.