Skip to main content
Solved

How to calculate MAU per GROUP?

  • 21 September 2023
  • 3 replies
  • 245 views

Hi, my organization has the Accounts Add-on feature, which we use to track “license” level behavior in our B2B product. So, we track individual user behavior, but also associate users with a higher-level license, which we define as a “group type”. For simplicity, we can assume most users are associated with 1 and only 1 license group. 

We want to track not only DAU/MAU, but also DAU and MAU per license. So, something like the UNIQUES(A) formula that calculates MAU in an event segmentation chart, modified to something like UNIQUES(users) / COUNT DISTINCT(license groups). 

Any ideas on how to accomplish this? Thanks!

3 replies

JennRu
Rank
Userlevel 4
Badge +9

Hi @ccanamas how often is the group property ‘license groups’ present at the time of triggered events? You could try a formula such as the following. The denominator is the distinct count of the group property “playlists” that were present at the time the Any Active Event triggered. 

 

 

Let me know if this is in the direction of what you’re looking to calculate. 

Jennifer Rudin
C
Rank
Badge

Hi @JennRu thanks so much for your response! That answers the first part of my question, but I am getting stumped now again on a second part. 

I’d like to have this metric for each group using a dynamic group property. 

For each license group, we have a group property called “max_users” which indicates the max number of users allowed under the licenses. It is represented by an integer, e.g. 10, 100, 530, etc. 

I want to come up with a property/metric for each license group that tells us: DAU/max_users. So if license group ABC has max_users = 100 and today only 20 users have fired events, then their new property would have value = 0.2. Tomorrow it would be subject to change again, but the denominator of max_users does not change. 

I have not used dynamic group properties before but from reading the Amplitude docs, it seems they’d be a good fit for this use case. The Amplitude UI warns creating these properties is irreversible so I am hesitant to jump right into testing. 

How would you suggest we set up the chart to properly display DAU/max_users such that we could turn this into a dynamic group property? Thanks in advance!

CC @Saish Redkar 

JennRu
Rank
Userlevel 4
Badge +9

Hmmm thinking out loud, one option is on the chart you could limit the query to users performing any active event for 1 group id. And then modify the query to UNIQUES(A)/PROPMAX(B) where the chart is limited to that 1 group id. 

I’ve done something similar like this in our internal data, where we tracked the dynamic # of joined users as a dynamic group property for each of our customer org id’s. So in a single chart I can view the current % of weekly active users in a specific customer org / the max # of users who have access to the org.  

 

 

Does this type of view help achieve the second part?

Jennifer Rudin

Reply


Terms & ConditionsCookie settings