Weekly Active Users (WAU)

Weekly Active Users (WAU): Unique users who performed a meaningful action in the product within a 7-day period.

Also known as: WAU

Formula

WAU = Count of unique users with qualifying activity in 7-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'), 7 day)

Unit: count

Notes: The 7 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 '7 day') AND event_date <= :period_end AND product_event_type = 'qualifying') AS weekly_active_users_wau

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

← Back to Product metrics