A vanity metric is a kind of metric that may look good (“Wow, you have so many signups!”), but doesn’t help you to move forward with growth, product development, etc. The classic examples of vanity metrics are a number of signups, downloads, etc. If there’s no next action that could be taken based on a metric – it’s probably a vanity one.
Forewarned, forearmed. Let’s calculate how many signups in total do we have and remember – it is just a number, a vanity metric.
Do we need filters when we calculate the total amount of signups (user records)?
SELECT COUNT(*) FROM users
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 and exercises (you’re looking at one atm). They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.