Question

Build a Daily Active User (DAU) query using number view. Build an Explore query that returns a count of unique user actors, that is filtered to all user actors. Starting 1 day ago to now. You can also include a compare window if you would like.

Take Note:

Daily Active Users or DAU is a very commonly used metric to track how many unique users are interacting with your product, website or business on a daily basis. It is also very helpful to view this as a time view so you can observe long term trends in daily active users. Using time options will allow you to determine the time window each dot on the line is calculated over, like we did in question 7. It is also helpful to include compare groups to see how weekly trends differ based on whatever actions you and your teams may have done.

Solution

Note: The numbers and result does not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*