How could I display a slope showing an average page visit count per session per day?
Let’s say there was 1000 sessions yesterday, and each of those users visited somewhere between 1 and 50 pages. How do I aggregate those visit counts and display an average for each day?
Another way to look at it is:
I can select a “Page Visit” event in the Insights Report, and do a Breakdown by “Session ID” (we already have a super property called “Session ID”), but how do I combine those individual session slopes into a single “average count” slope?
Best answer by tyler
thank you for the question! fortunately you may don’t need to implement anything special. we can get the average “Page Visit” count per session per day by following this:
- Select “Page Visit” event with “Total” as A
- Select “Page Visit” event with “Count sessions” as B
- Add a formula “A/B”
- Select desired date rage with the interval “Day”
Now you are dividing total number of “Page Visit” with the number of sessions that contains “Page Visit” event within a day, which is the average “Page Visit” per session per day!
you can also see an average “Page Visit” per User per day instead of sessions count, by changing “Count sessions” to “Unique” from the above instruction.