Onsite

SQL, Fake Accounts, and an AI Ad-Creation Case Study in the Onsite

MetaData Scientist · Onsite · Feb 2026

I just finished my virtual onsite a little while back. I ran into a few questions that other people have already posted about, but with slightly different follow-ups, so I wanted to share. SQL: active_ads. The interviewer was very organized and gave clear instructions. My second question was to find people whose total spend last year was over 1k, then look at what share of their spend this year t…

Shared by a candidate · reported Feb 2026. Interview formats change; use it as a guide, not a script.