Chart for WAU/MAU

Hi everyone, do you know how I can create a chart to see WAU/MAU? Only been able to find DAU/MAU on the community. Thank you!

Find more posts tagged with

Custom Formulas

Accepted answers

Saish Redkar

Hey my88finds

I haven’t personally dived into this metric yet, but can loosely translate the DAU/MAU formula to a WAU/MAU. This

Since our numerator is WAU, we will have to start with a weekly chart interval and do a rolling over the last one month defined in weeks. So a custom formula like : UNIQUES(A)/ROLLWIN(UNIQUES, A, 4) with a chart interval of Weekly . Here’s a demo chart using this formula - https://analytics.amplitude.com/demo/chart/new/duv4m8x

This approach could be slightly inaccurate since there could be caveats in here - 4 full weeks need not translate to one full month always and 5 weeks overshoot the 30 day time period. Not quite sure if Amplitude allows to use of a 30 day window in the denominator, but still sticking with a weekly aggregation.

Would love to hear thoughts and alternate / better approaches from others one this one. Hope this helps to some extent.

All comments

Saish Redkar

Hey my88finds

I haven’t personally dived into this metric yet, but can loosely translate the DAU/MAU formula to a WAU/MAU. This

Would love to hear thoughts and alternate / better approaches from others one this one. Hope this helps to some extent.

my88finds

Thank you, Saish! I will leave this open for others to chime in on how to produce this chart.

Thao Nguyen

Hi Saish Redkar, thank you so much for your contribution to Amplitude Community!

Hi my88finds, thank you for writing in and welcome to Amplitude Community!

Saish Redkar’s answer is correct. I just wanted to add two workarounds for your consideration.

If your chart looks at a daily interval, you can use the custom formula: ROLLWIN(UNIQUES, A, 7)/ROLLWIN(UNIQUES, A, 30) to view the ratio of the number of users in the last 7 days and 30 days. I’ve made an example chart in our Demo to illustrate.
For a date range based on calendar dates, a workaround would be to create two charts (one with DAU, the other with MAU), and use our Dashboard REST API or CSV export to export chart data for calculation outside of Amplitude.

Hope this helps! Let me know if you have any further concerns!

Best,

Thao

timothy-permutable

If you should be totally precise, I believe it’s possible something like below. But to be honest I would go with Saish’s approach!

create derived event properties for yearweek and yearmonth (assuming you can access derived properties)
create an event segmentation with two “any active event”, and group them by yearweek and yearmonth
set the chart to bar chart and set the time picker to last 12 months
use a custom formula to get the ratio

Quick Links

Unanswered Questions

Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
400 Status Code Error When Loading "Page Viewed: Cart" Data
Hi, I’m trying to create a chart in Amplitude using the Page Viewed: Cart event, measured as Uniques, over the past 7 days. However, I keep getting this error on the graph: "An error occurred while loading your data. (400 status code)" Other events seem to load fine, so it looks specific to this event or configuration. Has…