How to make cohort retention analysis in metabase?
Hey, a few questions:
- What do your tables look like? Or do you want to use the Sample Database?
- Do you want to use the query builder or are you writing SQL?
We don't have a tutorial on cohort analysis yet, but I can point you in the right direction depending on how you want to do it.
I want it using query builder.. U can just provide me with sample
Currently I have bookings table.. And I want cohort for retention of users monthly
Rows & Columns
From Jan 2022
Till Dec 2022
Users registered in Jan then retention from feb till dec
Then
Users registered in Feb then retention from Mar till dec
.
.
.
Etc
U got it?
What does your bookings table look like? Can you take a screenshot or make a simple table with the rows and columns you have?
And you want an output like this right:
0 | 1 | 2 | |
---|---|---|---|
Jan | 100% | % retained in Feb | % retained in March |
Feb | 100% | ... | ... |
Mar | 100% | ... | ... |
Where the left column is the Registered Month, and the other columns (0, 1, 2...) are the cohort age in months?
Yes exactly as your example!
So, how to do it ?
This is what I want how to do it please?
Can you please share a screenshot of your Bookings table?
The steps will depend on what your Bookings data looks like
My booking table has 68 columns how can I take screen shot ?!
You can just provide me step with the sample u provided
Here we go, this is exactly what I want
in the period 1 Oct - 7 Oct : 3331 users registered in my app
for those 3331 ,in the same period 14% of them made confirmed order
for those 3331 , in 8 Oct - 14 Oct , 8% of them made confirmed order
for those 3331 , in 15 Oct - 21 Oct , 2% of them made confirmed order
etc
clear ?
Hi, I understand the result you want. But I cannot show you how to get from A to B if I don't know what A looks like.
You'll have to describe what rows and columns are in your data if you can't take a screenshot of it.
Do you have something like this?
Customer ID | Subscription Date | Cancel Date |
---|---|---|
A | 2022-01-01 | 2023-01-01 |
B | 2022-01-01 | 2023-01-01 |
I will show you the relavent columns from the two tables I use to get cohort manually in excel.
Table (bookings)
Booking ID (PK), User ID (FK), booking_date
Table (users)
User ID (PK), user_registration_date
I think now by looking at my last previous message and the screenshot of excel I sent before things are clear.
I'm waiting for your response