Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. The AARRR Funnel: Stage Counts, Step Conversion Rates and the Visit-to-Paid Rate by ChannelLabFree
  2. The North-Star Metric: Input Metrics, Week-over-Week Growth, the Compound Rate and Weeks to a GoalLab Locked
  3. Acquisition Quality: Cost per Sign-Up, Cost per Activated User, Channel Shares and RankingLab Locked
  4. Activation: Defining the Aha Moment with IF and AND, the Activation Rate and the Retention GapLab Locked
  5. Retention: Cohort Tables, Mixed References, Weighted Retention per Month and Retention CurvesLab Locked
  6. Referral: Share of Inviters, Invite Conversion, the K-Factor and the Amplification FactorLab Locked
  7. Revenue: Paid Share, ARPPU, ARPU, Subscriber Churn and a Simple Lifetime ValueLab Locked
  8. Sizing the Leak: Multiplying Step Rates, Activation Targets with XLOOKUP and Extra Paying UsersLab Locked
  9. Growth Accounting: New, Resurrected and Churned Users, the MAU Identity, Quick Ratio and Churn RateLab Locked
  10. User States: Classifying New, Retained, Resurrected, Churned and Dormant Users with IFS and COUNTIFSLab Locked
  11. The Experiment Backlog: RICE Scores, Ranking, Balance across AARRR Stages and a Top-3 RuleLab Locked
  12. Planning a Test: Absolute Effect, Sample Size per Variant, Weeks to Run and a Run-or-Rethink VerdictLab Locked
  13. Reading a Test: Relative Lift, z-Score, Two-Sided p-Value and a Ship, Revert or Inconclusive DecisionLab Locked
  14. Experiment Cadence: Win Rate to Date, Velocity Trend with SLOPE, FORECAST.LINEAR and Expected WinsLab Locked
  15. Compounding Wins: Growth Factors, PRODUCT, the Compounded Lift and Small Weekly ImprovementsLab Locked
  16. Growth Loops: Simulating Loop Sign-Ups, Churn and Active Households Month by MonthLab Locked
  17. Channel Unit Economics: CAC, Lifetime Value, the LTV to CAC Ratio and Payback MonthsLab Locked
  18. Scenario Grids: Mixed References, COUNTIF Targets, INDEX-MATCH Lookups and a Heat MapLab Locked
  19. Trusting a Test: Expected Split, Chi-Square, the SRM p-Value and a Status RuleLab Locked
  20. Final Project: A Growth Review of the Year with Growth Accounting, Activation, Win Rate, a Forecast and a Trend ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy