Mixpanel Community Icon

Home
Groups
Members

Announcements
Community Questions
Mixpanel Bot
Product Ideas
Resources

Community Guidelines

Docs & Guides
Events & Webinars
Contact Us

Powered by Tightknit

Community Questions

Understanding Discrepancies in MAU Reporting Methods | Mixpanel Community

Community Questions

Understanding Discrepancies in MAU Reporting Methods

·

·

What is the correct way to query your MAU? I have tried 3 ways of report setup and they have different results. Why is it?

1.
When breaking down by month, selecting Unique customer and MAU are slightly different (1732 vs 1726)
2.
Average number of line graph breaking down by month is different from selecting Metrics (1726 vs 1646)

Loading attachments

1 comment

· Sorted by Oldest

Thena
APP
·
·
Hello Yanisa, The differences in user counts that you're seeing from different report setups is due to the way those metrics are calculated. 1. When you break down by month and select "Unique Users", the report counts the number of unique users who performed the event within that specific month. 2. The "MAU" metric, on the other hand, counts the number of unique users who performed the event within the last 30 days (rolling). 3. Unlike the line chart which counts users for each month separately and then takes the average of those counts (which means users can be counted multiple times), the metric chart counts unique users across the entire time period, so each user is only counted once even if they appear in multiple months. For the reasons above, you'll see slight differences in the figures - the calculations are different. If you want to get the most accurate MAU numbers, I would recommend using the MAU metric as it provides a rolling 30-day count of unique users. :)