Skip to main content

Hey guys!

I was working with a customer on setting up some charts and they were looking to set up a chart to calculate DAU/WAU. i.e. daily active users divided by weekly active users. Would this be something we can set up using custom formulas?

Hi Serene,
I believe we can do this using custom formulas in event segmentation charts 

UNIQUES(A)/ROLLWIN(UNIQUES, A, 7)

The interpretation of this ratio depends on how we are aggregating the event segmentation chart. ie. daily vs weekly vs monthly. 

We can also use this to calculate DAU/MAU ( stickiness)  : UNIQUES(A)/ROLLWIN(UNIQUES, A, 30)

Hope this helps!

 

-- Saish


Totally agree with the answer above, but for a bit of an extended look at DAU/MAU and some common mistakes I’ve written an article:

https://medium.com/permutable-analytics/how-to-calculate-dau-mau-ratio-in-amplitude-db2cc1e0cdf0


Hi,

Maybe silly question but if i want to calculate a DAU/MAU should i calculate it on a daily basis or a monthly basis ? I mean i would to know my DAU/MAU for let say the month of december : but in than case, for the DAU, sould i use the everage of DAU of december and then divide it by the MAU of december ? Or i can only have the DAU/MAU for each day of december.

I used the formula that was given here but when i click on amplitude on the Monthly button, i got an 400 error message, so i’m a bit lost. Many thanks in advance if you can explain this to me. Best Olivier


Hi @Olivier B ! not at all a silly question, actually a very good one!

 

Yes unfortunately the formula won’t work when switched to monthly, because the units in the formula assume daily time intervals.

 

I believe the standard approach for calculating “December” DAU/MAU is exactly as you say - calculate DAU/MAU for each day, then take the average. I don’t think it’s possible to do that automatically with a formula though.


Hi Timothy ! Many thanks for your reply ! so i don’t have to start again all what i’ve done :)))


Reply