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

Guide and Survey Analytics not Working
Hey there I've been playing around for a couple of hours with the guide and analytics which fires properly on the UI but wouldn't give me any analytics. I read that there is another script that should be installed for the analytics part of things. Would anyone be able to guide me towards the potential script or some…
How can I connect my Google Analytics Data with Amplitude
All my data is being collected through Firebase I want to export all this data in Amplitude and keep it synced with GA4, I tried adding data sources as BigQuery and GA4 both but for some reason it only partially imported the data and now its not working, I cant even see connected sources. Any help will be appreciated.
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…