Skip to main content
Solved

Measuring NET DAU, WAU, MAU - e.g. WAU - Users who joined in L7 days


Hi, I have a chart where I’ve plotted DAU, WAU, and MAU using the formula bar. For each metric, I want to remove users who onboarded in that timeframe (fired the onboard event), as it inflates the numbers. 

For example:

  • Net DAU = distinct users who visited in the last day - users who onboarded in the last day
  • Net WAU = distinct users who visited in L7 days - users who onboarded in L7 days
  • Net MAU = distinct users who visited in L30 days - users who onboarded in L30 days

How can I do this? Thanks!

Best answer by belinda.chiu

Hi @danah ! In addition to Saish’s recommendation above, you can also consider using the right segmentation module to remove users who onboarded in that timeframe. However, you will need behavior offset to achieve this which is only available to customers on Enterprise, Growth, or Scholarship plan: https://help.amplitude.com/hc/en-us/articles/360040965352. If you are not in one of these plan types but are interested in exploring more, I recommend reaching out to our Sales team at global-sdr@amplitude.com. 

Here’s an example of what I’m referring to: https://analytics.amplitude.com/demo/chart/new/2oog2zm

View original
Did this topic help you find an answer to your question?

2 replies

Saish Redkar
Expert
Forum|alt.badge.img+10

Hey @danah 

You can try defining 2 events - any active event and your new user event ( or onboarded event) and use them in a custom formula arithmetic like this  - https://analytics.amplitude.com/demo/chart/new/lmsyfcx

Hope this helps.


belinda.chiu
Team Member
Forum|alt.badge.img+8
  • Amplitude Support
  • 189 replies
  • Answer
  • August 5, 2022

Hi @danah ! In addition to Saish’s recommendation above, you can also consider using the right segmentation module to remove users who onboarded in that timeframe. However, you will need behavior offset to achieve this which is only available to customers on Enterprise, Growth, or Scholarship plan: https://help.amplitude.com/hc/en-us/articles/360040965352. If you are not in one of these plan types but are interested in exploring more, I recommend reaching out to our Sales team at global-sdr@amplitude.com. 

Here’s an example of what I’m referring to: https://analytics.amplitude.com/demo/chart/new/2oog2zm


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings