Complex~38min
The Phantom Subscriber
Subscriber count grew 40% in Q1. Investor deck went out. Total watch time across those new subscribers is essentially flat. Something doesn't add up.
Tables you'll query
subscriberscontent_viewssubscription_eventspromo_codes
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY