Retention Rate from Month 0
Hi all,
Wondering if it is possible to calculate the retention rate of monthly cohorts by calculating the number of active users in any month over the initial month of acquisition (Month 0). I have created the table below showing monthly active users by cohort. An example of what I'd ideally calculate is in the 2023-1 row taking Month 2 total of 7,402 divided by Month 0 total of 18,051. The Months from Acq is a beastmode using period_diff function.
Thank you in advance!
Best Answers
-
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
It depends on what your raw data looks like. If the card you showed us is a Pivot Table, you can do this purely with Beast Modes. I'll assume the values you have are a
COUNT
of activities for this purpose.In this case a Beast Mode like the one below might do the trick (FIXED is a powerful function once you figure it out)
COUNT(`Id`)/AVG(COUNT(CASE WHEN `Months_from_acq` = 0 THEN `Id` END) FIXED (BY `Acquisition Month`))
In this case since
Months_from_acq
is a beast mode, you might need to write your logic in there preferably in between parenthesis, unless your instance is able to reference Beast Modes inside Beast Modes already (I don't think that is GA yet and can't wait for it to be).Hope this helps :)
0
Answers
-
Hi @zfeinberg ,
So all of these numbers divided by month 0?
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
Yes, that's right. Looking to see retention from month 0 over time.
0 -
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
That's exactly what I'm trying to do. Assuming I need to get my data into a new table since the Months from Acq is a beast mode and not an actual column in the original dataset?
0 -
It depends on what your raw data looks like. If the card you showed us is a Pivot Table, you can do this purely with Beast Modes. I'll assume the values you have are a
COUNT
of activities for this purpose.In this case a Beast Mode like the one below might do the trick (FIXED is a powerful function once you figure it out)
COUNT(`Id`)/AVG(COUNT(CASE WHEN `Months_from_acq` = 0 THEN `Id` END) FIXED (BY `Acquisition Month`))
In this case since
Months_from_acq
is a beast mode, you might need to write your logic in there preferably in between parenthesis, unless your instance is able to reference Beast Modes inside Beast Modes already (I don't think that is GA yet and can't wait for it to be).Hope this helps :)
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive