Sizing the Leak: Multiplying Step Rates, Activation Targets with XLOOKUP and Extra Paying Users
Lessons in this course
- The AARRR Funnel: Stage Counts, Step Conversion Rates and the Visit-to-Paid Rate by ChannelFree
- The North-Star Metric: Input Metrics, Week-over-Week Growth, the Compound Rate and Weeks to a Goal Locked
- Acquisition Quality: Cost per Sign-Up, Cost per Activated User, Channel Shares and Ranking Locked
- Activation: Defining the Aha Moment with IF and AND, the Activation Rate and the Retention Gap Locked
- Retention: Cohort Tables, Mixed References, Weighted Retention per Month and Retention Curves Locked
- Referral: Share of Inviters, Invite Conversion, the K-Factor and the Amplification Factor Locked
- Revenue: Paid Share, ARPPU, ARPU, Subscriber Churn and a Simple Lifetime Value Locked
- Sizing the Leak: Multiplying Step Rates, Activation Targets with XLOOKUP and Extra Paying Users Locked
- Growth Accounting: New, Resurrected and Churned Users, the MAU Identity, Quick Ratio and Churn Rate Locked
- User States: Classifying New, Retained, Resurrected, Churned and Dormant Users with IFS and COUNTIFS Locked
- The Experiment Backlog: RICE Scores, Ranking, Balance across AARRR Stages and a Top-3 Rule Locked
- Planning a Test: Absolute Effect, Sample Size per Variant, Weeks to Run and a Run-or-Rethink Verdict Locked
- Reading a Test: Relative Lift, z-Score, Two-Sided p-Value and a Ship, Revert or Inconclusive Decision Locked
- Experiment Cadence: Win Rate to Date, Velocity Trend with SLOPE, FORECAST.LINEAR and Expected Wins Locked
- Compounding Wins: Growth Factors, PRODUCT, the Compounded Lift and Small Weekly Improvements Locked
- Growth Loops: Simulating Loop Sign-Ups, Churn and Active Households Month by Month Locked
- Channel Unit Economics: CAC, Lifetime Value, the LTV to CAC Ratio and Payback Months Locked
- Scenario Grids: Mixed References, COUNTIF Targets, INDEX-MATCH Lookups and a Heat Map Locked
- Trusting a Test: Expected Split, Chi-Square, the SRM p-Value and a Status Rule Locked
- Final Project: A Growth Review of the Year with Growth Accounting, Activation, Win Rate, a Forecast and a Trend Chart Locked