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

tomk61257382 12-08-2016

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

Accepted Solutions (0)

Answers (0)