Meta·Data Scientist·Technical Phone Screen
May 2026
Meta Data Scientist SQL round, focused entirely on ad analytics. Two related questions, both involving the same tables, just different levels of aggregation. Nothing too wild but the CAST thing is easy to forget under pressure.
- Write SQL to compute the overall click-through rate (clicks divided by impressions) across all ads for the last calendar week.
- Now break that CTR down by campaign type. Same time period, but join to the campaigns table and group by campaign_type.
“The mechanics are straightforward: filter by event_date, count impressions and clicks separately using conditional aggregation, then divide.” The rest of the author's notes on Data Scientist interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post