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?
Solved
How can I calculate DAU/WAU?
+1Best answer by Saish Redkar
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
Serene
+10Hi 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
Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
+10Totally 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
Timothy | Product Analytics Consultant - permutable.co
1 person likes this
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
1 person likes this
+10Hi
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 :)))
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.