Product Analytics in SQL: Metric Definitions, Tracking Plans, Funnels, Cohort Retention and A/B Tests That Don't Fool You
From metric definitions precise down to the numerator, denominator and time window, through tracking plans and user identity, to real PostgreSQL for funnels, cohort retention, DAU/WAU/MAU, window functions, the Asia/Ho_Chi_Minh timezone and A/B tests with an SRM check.