Level 2 - Question 34
Show an average number of sessions per user in the last 7 days.
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.
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.
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*