Metric Definitions: Active Users, Conversion and Why the Denominator Decides
This lesson is part of the course
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 Pro
- SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS Pro
- Metric Definitions: Active Users, Conversion and Why the Denominator Decides Pro
- Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier Pro
- Quick A/B Read: Conversion per Variant, Lift in Points and "Is It Worth Shipping?" Pro
- Cohort Retention: Months Since Signup, the Cohort Grid and Pooled vs Average Rates Pro
- Sanity Checks: Duplicated Rows, Impossible Rates and Totals That Don't Add Up Pro
- Capstone: A Timed Take-Home – Net Revenue, Refund Rate, Revenue by Channel and One Chart Pro