Expand my Community achievements bar.

What are the calculation rules for total spent time?

Avatar

Level 2

Hello,

   I am currently subscribing to data from a data feed, loading it into a database via SFTP for analysis. I would like to ask about the calculation rules for the 'total spent time' metric. Which fields are used and what logic is applied to calculate it? I need to ensure that it aligns with the values in the workspace.

leozh1_0-1732157838826.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 2

My current calculation rules are:

page_name            post_cus_hit_time
page A                          11:00

page B                         11:01

page C                         11:03


page A total spent time is 11:01- 11:00 = 1 minutes

page B total spent time is 11:03-11:01= 2 minutes

However, this result is different from the one in the workspace.

Avatar

Community Advisor and Adobe Champion

Hi @leozh1, so the field you have in your screenshot is counting in seconds, not in minutes. Which means first you need to convert your measure to seconds. This time is counted against specific dimensions. In your example, you have pages. It will use the timestamps to calculate how long people spent on the page. The exception is if it's the last page of the visit, because there is no "end" time stamp, it won't be included. So, for example

Visit 1

Page A 11:00:00

Page B 11:00:30

 

Visit 2 

Page C 12:00:00

Page A 12:01:00

Page B 12:01:45

 

Visit 3

Page C 1:00:00

Page A 1:00:10

 

If we want to get the total time for each page,

Page A gets 30 seconds from the first visit and 45 seconds from the second. It doesn't count any time from the third visit because it's the last page, so there is no end time stamp for it to compute with. It would end up with 75 seconds

Page B wouldn't get any time calculated since it's the last page seen in each visit, so it would have 0.

Page C would get counted in both visits it's seen in, 1 minute from visit 2 and 10 seconds from visit 3, so a total of 70 seconds.

 

This page here explains how the different time metrics are calculated. How Time Spent is calculated in Adobe Analytics | Adobe Analytics

 

Hope this helps.

Avatar

Level 2

Hello,

      I am currently using the formula you mentioned to calculate, but the results are inconsistent with those in the workspace.

Avatar

Level 2

Hello, I found that eVars and props are also included in the total spent time. Currently, my calculation rules only use post_visid_high, post_visid_low, post_pagename, visit_num, visit_page_num, and cust_hit_time_gmt to calculate spent_time. How should I calculate the corresponding spent_time for eVars and props?

Avatar

Level 2

Persisted variables, such as eVars, count towards total seconds spent. Traffic variables, such as props, include seconds spent across subsequent link tracking calls.

 

Hello, I found that eVars and props are also included in the total spent time. Currently, my calculation rules only use post_visid_high, post_visid_low, post_pagename, visit_num, visit_page_num, and cust_hit_time_gmt to calculate spent_time. How should I calculate the corresponding spent_time for eVars and props?