Weekly active users

MediumMetaactive usersdate_trunccount distinct· 20 XP

Meta's growth dashboard shows WAU (weekly active users): the number of different people who logged in during each Monday-to-Sunday week.

For each week (starting Monday) that falls entirely within January to March 2026, show the number of distinct users who logged in.

Expected output

  • week_start as a date; sorted by week_start

Example of the shape (made-up values):

week_start wau
2026-01-05 180

Hints, the later steps and the answer come with Pro.

Write your query here. Ctrl + Enter submits.