Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Calculate total seconds spent using data feeds

Avatar

Avatar
Level 1
abhishekj484272
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
abhishekj484272
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
abhishekj484272
Level 1

26-12-2019

How can I calculate Total Seconds Spent using Data Feeds?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct Reply

145 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct Reply

145 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

31-12-2019

Total seconds spent metric is available only in Analysis Workspace, Reports & Analytics, Report Builder (called ‘total time spent’), Data Warehouse, Ad Hoc Analysis.

 

In data feed you can do following to get time spent:

Hits must first be grouped by visit, then ordered according to the hit number within the visit.

  1. Concatenate post_visid_high , post_visid_low , visit_num , and visit_start_time_gmt .
  2. Sort by this concatenated value, then apply a secondary sort by visit_page_num .
  3. Subtract the last hit post_cust_hit_time value in a visit from the visit_start_time_gmt value calculated in first step.
  4. This number is the amount of total time spent (in seconds) for the visit.

Answers (0)