Meta·Data Scientist·Technical Phone Screen
- Write a SQL query that produces daily ad performance broken down by country for the last 7 complete UTC days. The output should include impressions, clicks, revenue, CTR, and RPM per (date, country) pair, joining impression and click data correctly and handling impressions with no clicks.
“There's a lot going on here.”