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

How to interpret t_time_info and post_t_time_info from raw data?

Avatar

Avatar
Validate 1
Level 1
cleverc13493803
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cleverc13493803
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
cleverc13493803
Level 1

05-03-2018

Hi Everyone!

I am trying to derive some useful information from analytics clickstream raw data and noticed there are two fields t_time_info and post_t_time_info.

From Analytics Help and Reference, these two fields are "Raw time information from JavaScript. Used to determine the visitor's timezone." This information could be definitely help in plotting users' activity across the day. My question is how to interpret these fields properly?

Here are some examples get from the two and related fields:

date_timet_time_info
post_t_time_info
2018-02-16 12:08:1716/1/2018 9:8:16 5 48016/1/2018 9:8:16 5 480
2018-02-16 12:29:2316/1/2018 12:29:23 5 30016/1/2018 12:28:36 5 300

I try to understand date_time as the server time, the t_time_info (post_t_time_info) as the client time. The gaps between the two are resulted from time zone differences. Any thoughts how I should interpret them properly in SQL when I read these fields?

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

05-03-2018

I'm glad you asked this, because quite frankly it's one of the most confusing and arbitrary fields out there. Here's what our internal tool says about t_time_info:

And post_t_time_info is the same, after processing rules and VISTA rules are applied. As a rule of thumb you'll almost always want to use post_ fields when reporting data.

Answers (2)

Answers (2)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

06-03-2018

The date_time field is when a hit was recorded based on the report suite's time zone.

Avatar

Avatar
Validate 1
Level 1
cleverc13493803
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cleverc13493803
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
cleverc13493803
Level 1

06-03-2018

Thank you very much, Gigazelle, for your clear explanation! Very professional!

A following-up question and to confirm with you about the date_time field: does it record the server time of the hit with respect to how the timezone of the server is set?

Thanks again for your explanation!