What counts as active
The Overview counts visitors. To count a signed-in user once across devices, call
identify() and count people with SQL (Part 3).
Part 1: Read it on the Overview
- Open Overview.
- Choose the range: 7D for WAU, 30D for MAU, or one day in the calendar for DAU.
- Read Visitors: the unique visitors in the range.
- Click Visitors to show it on the trend chart. The chart shows each day, so it is your DAU curve.
- Turn on Compare to see the previous period of the same length.
Part 2: Add a DAU chart to a dashboard
- Open a dashboard and click Add chart.
- Pick the Daily visitors against a goal example. It draws daily visitors as a line, with a goal line.
- Change the goal to your target and click Save Chart.
Part 3: Count active people with SQL
This query counts DAU by user for a game or a product. It usesuser_id when there is one, else anonymous_id.
toStartOfWeek(original_timestamp, 1) or toStartOfMonth(original_timestamp). The 1 starts the week on Monday, as the reports do; with no second argument ClickHouse starts the week on Sunday. Run the query in the Explorer, or save it as a Line chart with X column day and Y column dau.
This SQL key is simpler than the report rule. It does not join anonymous activity from before
identify() to the user. So it can count a little more people than reports such as retention.Part 4: Go deeper
- Stickiness: divide DAU by MAU. A higher ratio means that people come back more often.
- Lifecycle: open Users, then Audience insights, to see New, Returning, At Risk, Churned and Resurrected people.
- Games: filter by Build or Platform in the App group to compare releases.