183. How to measure activation rate

We started Product Analytics. Part 1 chapter by introducing AARRR metrics:

  • Acquisition ✅
  • Activation
  • Retention
  • Revenue ✅
  • Referral ✅

Acquisition. We’ve learned a lot about web and mobile attribution and how to build acquisition funnels using web analytics (click and signup rates). I’d say it’s a big checkmark and you already know grouping and counting, how to calculate conversion rates, build funnels and use window functions to calculate marketing attribution. That’s a hell of a toolbox and you totally earned acquisition analytics trophy 🏆

Revenue....

“well worth the money”
Sign up and check out 36 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
LIMIT 500
Loading chart... ⏳
Previous lesson: Introduction to mobile analytics
Next exercise: Calculating soft activation rate