Bindle launched ads on Facebook, targeting English speaking countries: the USA, UK, Canada, and Australia (they’ll add Ireland and New Zealand to the mix later).
The question was: how many signups did they acquire from these countries?
So far we’ve learned how to count signups from a single country:
SELECT COUNT(*) FROM users WHERE country = 'us'
We even can filter signups within a time range (to make sure we can detect an uplift in signups when marketing campaigns were live):
SELECT COUNT(*) FROM users WHERE country = 'us' AND signup_date...