Mineblocks is a game, and one of the core metrics to any game is the number of people who play each day. That KPI is called Daily Active Users, or DAU.
DAU is defined as the number of unique players seen in-game each day. It’s important not to double count users who played multiple times, so we’ll use distinct
in our count
function.
Likewise, Weekly Active Users (WAU) and Monthly Active Users (MAU) are in the same family.
Instructions
For Mineblocks, we’ll use the gameplays
table to calculate DAU. Each time a user plays the game, their session is recorded in gameplays
. Thus, a distinct count of users per day from gameplays will give us DAU.
Calculate Daily Active Users for Mineblocks. Complete the query’s count
function by passing in the distinct
keyword and the user_id
column name.
select date(created_at), count(/**/) as dau from gameplays group by 1 order by 1;
Here’s a hint on how to use the count function to count distinct columns in a table. Also notice that we include platform
in both the select
and group by
clauses.