Skip to main content

Weekly active users (WAUs)

info

View this example in Motif here.

This example calculates weekly active users (WAU).

Video​

SOL query​

// Divide user activity into weeks
match split ActiveWeek()+
if time_bucket(1w, SUFFIX[0]) > time_bucket(1w, ActiveWeek[-1])

// Create a dimension for each sequence with the week label
set week = time_bucket(1w, ActiveWeek[0])

Key steps​

  1. Split sequences by week using the time_bucket function.
match split ActiveWeek()+
if time_bucket(1w, SUFFIX[0]) > time_bucket(1w, ActiveWeek[-1])
  1. Define a sequence dimension indexing each week.
set week = time_bucket(1w, ActiveWeek[0])
  1. We plot the counts by week to see user growth.

wau