Skip to main content
Interania

Measuring monthly active users (MAU)

Question 

For each day over the last 90 days, how many users were active for at least one of the previous 30 days?

Overview

Like the query on daily average users, this is a basic query in Interana: measuring user activity over a specific time range. This sort of query is often the starting point for more in-depth explorations of your data. 

Building the query

Since you're measuring use activity over time, use a Time view for this query. Then build the sentence for the query.

This example uses the Wikipedia project (and its user column), but you would select the column that represents actors in your project. 

  • SHOW
    • Count unique user actors
  • FOR 
    • All user actors
  • OVER
    • (enter a 90-day time range)
  • To measure how many users were, on any given day, active for the previous month, click Show time resolution to toggle the trailing window option and change it to: every 1 day trailing 30 days . 

Hover over any point to see the count of users who, on any day, were active for the previous month (each data point represents 1 day): 

mau_time_query.png

Tip: Samples view 

Click Samples to show some of the data used in the query.

mau_samples_view.png

  • Was this article helpful?