Compute this-year spend share of last-year whales
Company: Meta
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: easy
Interview Round: Onsite
Overview: This question evaluates proficiency in data manipulation and analytics engineering, specifically SQL and Python skills for aggregations, joins, calendar-year time filtering, cohort identification, exclusion logic, and monthly rollups of ad spend.
Read the full Meta Data Scientist interview experience this question came from