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?
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
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
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
Hi Olivier B ! not at all a silly question, actually a very good one!
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 ))
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…
