A great way to evaluate your app’s “stickiness” is to calculate your DAU/MAU ratio. This ratio represents your average daily active user count / monthly active user count. The closer your ratio is to 1, the more often users are using your app, rather than only logging in sporadically.
By the end of this How-To, you will know how to calculate DAU/MAU for your organization.
Building the Named Expressions
Begin by building the following:
1. Metric (Num Days Active): For each user Measure: Activity – Days
2. Derived column: __28__
3. Metric (only 28): For each user Measure: Maximum - __28__
Assembling the Ratio Measure
This can be augmented to calculate DAU/WAU by using a derived column that returns 7 instead of 28.