Skip to main content
Interania

Measuring daily active users (DAU)

Question

During the past seven days, how many users were active on each day?

Overview

This is a basic query in Interana: measuring user activity over a specific time range. This sort of query is often the starting point for more in-depth explorations of your data. 

Building the query

Because we're measuring use activity over time, use a Time view for this query. Then build the sentence for the query.

This example is using the music project (and its user ID column), but you would select the column that represents actors in your project. 

  • SHOW
    • count unique user ID actors
  • FOR 
    • all user ID actors
  • SPLIT BY
    • none
  • OVER
    • (enter a 1-week time range)
  • Click Show time resolution to toggle the trailing window option, and use the default value: every auto (1 day) trailing auto (1 day) 
    • This is the default value, but it's useful to know what it is and how to change it. 

You can hover over any point to see the count of users for that day: 

dau_time_query.png

Tip: Samples view

Click Samples to show some of the data used in the query.

dau_samples_view.png

  • Was this article helpful?