Ranking The Most Used Features in Your Product Using SQL - Issue 113
How to get the most popular features, products, or user activity in SQL
Can you believe it’s October already? Bring on the last quarter of the year! Let it also serve as a gentle reminder that you have 3 more months to hit all your milestones and resolutions this year.
This week, I’d like to explore a common question in product analytics - which features in your product do users use the most?
Let’s say you are on a quest to boost your ARR aggressively and want to paywall the top 3 most popular features. How do you figure out which features are the most used across all your customers?
Or here’s another scenario: a Product Manager watches the last glimmer of hope drain from their eyes and considers sunsetting a feature. The first step in such decision-making is figuring out what the feature usage is - how many users are engaging with this product? Are they engaging at all? How can you get this data?
from Lenny’s When to sunset a feature
Below I will offer a simple solution using SQL.
This question was my favorite task to provide analysts with during technical interviews. Depending on your data health and variability of product features, it’s somewhere between an intermediate and an advanced level - analyzing user activity by applying SQL rank function.
Keep reading with a 7-day free trial
Subscribe to Data Analysis Journal to keep reading this post and get 7 days of free access to the full post archives.