WAU/MAU Ratio

WAU/MAU Ratio: Weekly to monthly active user ratio.

Formula

WAU/MAU = WAU / MAU × 100

Computable definition

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

metric.weekly_active_users_wau / metric.monthly_active_users_mau

Unit: percent (the formula yields an unscaled ratio)

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 (CAST(((SELECT COUNT(DISTINCT user_id) FROM product_event WHERE event_date > (:period_end - INTERVAL '7 day') AND event_date <= :period_end AND product_event_type = 'qualifying')) AS DOUBLE PRECISION) / NULLIF(((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')), 0)) AS waumau_ratio

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

Benchmarks

Below 40%: Infrequent use
40-60%: Moderate use
Above 60%: Regular weekly use

← Back to Product metrics