Question

Show an average number of sessions per user in the last 7 days.

Additional Context

Build a query in Explore using number view that shows an average number of sessions per user using the Flow you built in question 30 use multiple measures and divide. This query will require 3 measures to be built. Measure 1 should return a count of the number of instances of the Flow you built in question 30. Measure 2 should return a count of the number of actors that performed the Flow you built in question 30. Measure 3 should divide Measure 1 by Measure 2. The query should run from 7 days ago to now.

Take Note:

Flows are most valuable when brought into the Explore builder. In this query were using a previously created flow and using multiple measures to determine the count of users, the count of the number of sessions they've had and then dividing the two to get the average number of sessions each user had.

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*