Analyze Thirty-Day Ad Performance with SQL
Company: Meta
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Onsite
Overview: Work through a multi-part advertising SQL interview covering top ads by impressions, CTR by ad type, campaign conversion value per exposed user, and peak-hour performance. The solution emphasizes correct table grain, attribution windows, user denominators, timezone handling, and statistically cautious interpretation.