Say the grain before you write the query.

Prompt

Build a query for week-one activation by signup channel. You have users, events, teams, and purchases. Talk through the query before writing it.

Answer shape

• State the output grain: one row per signup channel and signup week.
• Define activation as a specific event within seven days of signup.
• Pre-aggregate events before joining to users so one user cannot inflate the count.
• Name trust checks: null channel, bot accounts, timezone, duplicate users, and late events.