Growth Experiments with AARRR Pirate Metrics: North-Star Metric, Funnel Rates, Growth Accounting, Experiment Backlog & Compounding Loops
Learn growth marketing the way product-led teams run it, entirely in a spreadsheet. You start with the AARRR funnel and turn stage counts into step conversion rates, build a north-star metric from input metrics and measure its weekly and compound growth, and compare acquisition channels by cost per activated user. Then you define the aha moment for activation, read cohort retention curves, work out the referral K-factor and break revenue into paid share, ARPPU, ARPU and lifetime value, and size each funnel leak in extra paying users. Growth accounting splits monthly active users into new, resurrected and churned, with the quick ratio and user states. You score an experiment backlog with RICE, plan sample sizes and run times, read results with a z-test and a sample ratio check, track experiment cadence and compound the wins, simulate a growth loop, compare channel unit economics and build a scenario grid. A final project combines everything in one growth review. 20 hands-on labs, fictional company data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In this course you run the numbers of a growth team in a spreadsheet, one lab at a time. You turn stage counts into AARRR step rates, build a north-star metric, compare channels by cost per activated user, read cohort retention and the referral K-factor, and split monthly active users into new, resurrected and churned with the quick ratio. You then score an experiment backlog with RICE, plan sample sizes, read a test with a z-score and p-value, check a split for a sample ratio mismatch, track experiment cadence, compound the wins, simulate a growth loop, compare channel unit economics and fill a scenario grid. A final project joins everything in one growth review. All 20 labs use the fictional household budgeting app Kestrelwick, and every formula is checked as you type. All companies, people and numbers are fictional.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- 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
Learner reviews
Be the first to review this course.