Cohort Retention

Get Help
1

How to make cohort retention analysis in metabase?

2

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.

3

I want it using query builder.. U can just provide me with sample

4

Currently I have bookings table.. And I want cohort for retention of users monthly

5

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?

6

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?

7

Yes exactly as your example!

8

So, how to do it ?

9

This is what I want how to do it please?

10

Can you please share a screenshot of your Bookings table?

The steps will depend on what your Bookings data looks like :slight_smile:

11

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

You can just provide me step with the sample u provided

12

ex
ex1113×174 8.47 KB

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 ?

13

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
14

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

15

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: