Cohort Retention

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 :slight_smile:

My booking table has 68 columns how can I take screen shot :joy:?!

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 :rose: