Write a query using wk_signups and wk_events to return each signup-week cohort at week_offset 0, 1 and 2. cohort_week is the signup week’s Monday at 00:00 UTC, returned as a DATE; cohort_size includes every signup in that week.
Count distinct users in two ways:
01calendar_users: Events in the calendar week starting cohort_week plus 7 × week_offset days, with shared boundaries for all cohort members.
02elapsed_users: Events from each user’s signed_up_at plus 7 × week_offset days, up to but not including that signup instant plus 7 × (week_offset + 1) days.
Both windows include their start and exclude their end. Exclude events before the user’s signup instant from both measures. Include all three offsets for every cohort, even when counts are zero.
Ordering: Sort by cohort_week, then week_offset, ascending.