FoundationsBeginner
Summarize daily product activity
Which milestones are users completing on each day?
Group product milestones from one event table by UTC day. Count successes and total attempts separately.
The dataset and query remain in this browser.
Expected result
Daily successful product milestones
2
2026-07-01
4
2026-07-02
2
2026-07-03
4
2026-07-04
3
2026-07-05
2
2026-07-06
1
2026-07-08
1
2026-07-09
1
2026-07-12
| activity_day | events | successful_events | active_accounts |
|---|---|---|---|
| 2026-07-01 | 2 | 2 | 1 |
| 2026-07-02 | 4 | 4 | 2 |
| 2026-07-03 | 3 | 2 | 2 |
| 2026-07-04 | 4 | 4 | 1 |
| 2026-07-05 | 3 | 3 | 2 |
| 2026-07-06 | 2 | 2 | 1 |
| 2026-07-08 | 1 | 1 | 1 |
| 2026-07-09 | 1 | 1 | 1 |
| 2026-07-12 | 1 | 1 | 1 |
How to read the query
- The UTC day is derived from the event timestamp instead of a client-supplied date label.
- Event volume and distinct active accounts answer different questions, so both remain visible.
- The status condition prevents a failed integration attempt from being counted as a completed milestone.
How to interpret the results
- 1Decide whether retries and repeated milestones should remain visible.
- 2Exclude internal, test, or bot accounts before treating this as adoption.
- 3Use complete time buckets when comparing recent days.
Related lessons
Keep the result
Run this query on your own events
Create a free workspace only when you are ready to save the query, connect real events, and monitor the result. No credit card is required.