Product Analytics. Part 1 Email signups vs Social signups

151. Email signups vs Social signups

We’ve talked about data analysis as a means to find a signal in the noise. We can’t get a full picture or take any action just by looking at a metric value. We need to look at its dynamics in time and the most important – segment it, for example by country or marketing campaign.

The main trick is that one can segment by any dimension. It could be countries, campaigns, age groups, gender, device type and even version of iOS. All these parameters are some columns values. In this lesson we’ll learn how to segment metrics by type of their account...

“well worth the money”
Sign up and check out 37 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
Loading chart... ⏳