Daily signups by acquisition channel

Question

Growth marketing wants a simple daily pulse of new accounts split by acquisition channel.

Using `signup_events`, return `signup_date`, `channel` and the number of signups as `signup_count`, one row per date-and-channel combination.

Accepted Answer

Step 1: The grain of the answer is one row per (date, channel) pair, so both columns go into the `GROUP BY`. Step 2: `COUNT(*)` counts the rows collapsed into each group — every row in this table is exactly one signup. Step 3: Any non-aggregated column in the `SELECT` list must also appear in the `GROUP BY`; `signup_date` and `channel` satisfy that rule. Step 4: Alias the aggregate as `signup_count` so downstream dashboards get a readable column name.

Daily signups by acquisition channel

More GROUP BY questions

Asked at ZoomInfo