My dashboard was inspired by 0xDataWolf, adriaparcerisas and Ali3N from whom I forked some queries to use as a basis for my analysis!
Orig. dashboards:
We want to determine the number of Stablejack users returning to transact within the platform.
The table we're using for this analysis is the standard retention table, a familiar and useful tool. We typically segment it by time, often in months, to track user retention and assess whether users are staying engaged. This kind of retention table is widely used and valuable.
When we examine the table horizontally, we can identify special behavior within a cohort. For example, we observe particularly robust and consistent retention in the most recent cohort, possibly indicating early adopters who are highly loyal.
Looking vertically allows us to spot trends in retention, helping us pinpoint when customers might lose interest in the product and churn. Additionally, the 'new users' column allows us to track the influx of new users over time.
Examining the table diagonally gives us insight into the current state of affairs across all cohorts. This method is particularly useful for understanding if the product is performing well overall. Essentially, it helps us determine if a rising tide is indeed lifting all boats, providing a comprehensive analysis across all cohorts.