This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Measurement Analyst at The Trade Desk. The viewability team wants to understand how ad viewability correlates with click quality. They need each valid click enriched with the viewability and device type of its originating impression. Since impression_id in the clicks table is nullable (some clicks don't have a matched impression), you must use a LEFT JOIN to preserve all valid clicks even when no impression match exists.
You are a Measurement Analyst at The Trade Desk. The viewability team wants to understand how ad viewability correlates with click quality. They need each valid click enriched with the viewability and device type of its originating impression. Since impression_id in the clicks table is nullable (some clicks don't have a matched impression), you must use a LEFT JOIN to preserve all valid clicks even when no impression match exists.