Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Calculated Metric for Average Page View Time in Time (hh:mm:ss) Format

Avatar

Level 2

I am interested in configuring a calculated metric for use in the pages report to provide end users with an easy to read and understand metric titled Average Page View Time in hh:mm:ss format rather than the out of box Time Spent or Average Time Spent on Page metric which includes custom logic and displays the result in minutes (ie. 1.88).

Here is my current approach:

Format: Time

Summary: Total Seconds Spent / (Visits - Single Page Visits)

OR

Format: Time

Summary: Total Seconds Spent / (Visits - (Bounces+Exits))

To Calculate Minutes

Format: Decimal  (Decimal Places = 2)

((Total Seconds Spent / (Visits - Single Page Visits)) / 86400) * 1440

0 Replies