Monthly Active Users (MAU)

Monthly Active Users (MAU): Unique users who performed a meaningful action in the product within a 30-day period.

Also known as: MAU

Formula

MAU = Count of unique users with qualifying activity in 30-day period

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

window(count_distinct(field.user_id where field.product_event_type = 'qualifying'), 30 day)

Unit: count

Notes: The 30 days ending at period_end.

Data requirements

Grain: Distinct users in a trailing window (1, 7 or 30 days) ending at period end · Frequency: Daily · Aggregation: window (day) · Staged: no · Main source: Product Analytics.

Field	Dataset	Type
`event_date`	product_event	date
`product_event_type`	product_event	string
`user_id`	product_event	string

Example SQL (Postgres)

SELECT (SELECT COUNT(DISTINCT user_id) FROM product_event WHERE event_date > (:period_end - INTERVAL '30 day') AND event_date <= :period_end AND product_event_type = 'qualifying') AS monthly_active_users_mau

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Monthly Active Users (MAU)" }) or generate_query({ "metric": "Monthly Active Users (MAU)", "adapter": "<your adapter JSON>" }).

What It Tells You

Monthly engagement breadth.

← Back to Product metrics