Showing user activity on a (30-day) monthly basis is a basic query that can often be the starting point for more in-depth data explorations. Similar to the query for daily average users, showing monthly active users is a basic query in Interana.
This article demonstrates how to measure (30-day) monthly user activity, over a three month period.
Measure user activity on a monthly basis
In the following example, we demonstrate how to measure for each day over the last 90 days the number of users who were active for at least one of the previous (30-day) months.
Since we're measuring user activity over time, we use Time view for this query. Then build the sentence for the query.
This example uses the IA_MOVIES dataset, its
useractor property, and Monthly Activity actor property. You would select the appropriate properties for your dataset.
This query uses a custom actor property for (30-day) Montlhy Activity. For information on how to create a custom actor property for this query, see Building a Monthly 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 Monthly 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 Monthly Activity that is greater than 0.
- Select Split by action to show individual groups according to action, specify a Limit of 10, Ordered by set 1 descending. This will produce a graph that is easier to read.
- 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 90 days.
- Click with time options and specify a time resolution with a trailing window. We accepted the default auto 1 day and selected Trailing 1 month, then accepted 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.