Metric Definitions: Active Users, Conversion and Why the Denominator Decides
This lesson is part of the course
In this lesson
With one small user table you calculate weekly active users under two definitions and conversion with two denominators – and see how far the answers move.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Warm-Up: Clarifying the Question, Points vs Percent and Share-of-Total Traps Locked
- SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS Locked
- Metric Definitions: Active Users, Conversion and Why the Denominator Decides Locked
- Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier Locked
- Quick A/B Read: Conversion per Variant, Lift in Points and "Is It Worth Shipping?" Locked
- Cohort Retention: Months Since Signup, the Cohort Grid and Pooled vs Average Rates Locked
- Sanity Checks: Duplicated Rows, Impossible Rates and Totals That Don't Add Up Locked
- Capstone: A Timed Take-Home – Net Revenue, Refund Rate, Revenue by Channel and One Chart Locked