Solved

How can I calculate DAU/WAU?

  • 25 January 2021
  • 2 replies
  • 619 views

Userlevel 3
Badge +1

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?

icon

Best answer by Saish Redkar 1 February 2021, 20:33

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

View original

2 replies

Userlevel 6
Badge +4

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

Badge

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

Reply