Showing user activity over a specific time range is a basic query that can often be the starting point for more in-depth data explorations.
This article demonstrates how to determine the number of users that were active on each day, over a set period of time.
Show the number of users active each day
Since we're measuring user activity over time, we will build the sentence for this query using Time view.
This example uses the IA_MOVIES dataset, its
useractor, and a custom Daily Activity actor property. You would select the appropriate properties for your dataset.
This query uses a custom actor property for Daily Activity. For information on how to create a custom actor property for this query, see Building a Daily Activity actor property.
Building the Query
We use the IA_MOVIES dataset for our example in the following procedure. Use the dataset that is appropriate for your business. To create the custom actor property used in this query, see Building a Daily Activity actor property.
To show the daily activity of users, do the following:
- In the left menu bar, click Explore.
- In the upper left corner of the window, select the dataset. In our example, we chose IA_MOVIES.
- In the first line of the query builder, select Show count unique user actors.
- In the second line of the query builder, select: Filtered to user actors with Daily Activity that is greater than 0.
- Accept the default of Split by none.
- Specify a Starting time by selecting from the drop-down list, clicking the calendar icon and choosing a date, or clicking inside the text field and entering a value, then accept the default Ending now. We entered a value of 180 days.
- Click with time options and specify a time resolution with a trailing window. We accepted the default auto options, Pre-filtered to all events.
- Click GO.
We received the following results with our dataset. Hover over any point on the graph to view details on the count of users for that day.