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

SOLVED

What would cause a difference in Date Feeds between visit_start_time_gmt and first_hit_time_gmt?

Michael_Manooch
Level 1
Level 1

Hi everyone:

Here is a sample of data from a recent data feed file - diff is simply the difference between the two columns. In many cases, there is no difference, but a large percentage of fields has a first_hit_time_gmt  that differs significantly from the visit_start_time_gmt. My question is... why?

visit_start_time_gmtfirst_hit_time_gmtdiff
15453215911422000083123321508
15452898611422388671122901190
15452898611422388671122901190
15452898611422388671122901190
15452961871429075234116220953
15452935231429075234116218289
15453143211434399052110915269
15453353331435729432109605901
15453208901438160107107160783
1545309000144604118199267819
1 Accepted Solution
PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Micheal,

Both are not same and thus the difference:

visit_start_time_gmt : Timestamp (in Unix time) of the first hit of the visit.

first_hit_time_gmt : Timestamp of the very first hit of the visitor in Unix time.

So, visit_start_time_gmt refers to the visit and first_hit_time_gmt refers to the visitor i.e. For New Visitor visit_start_time_gmt will be equal to first_hit_time_gmt but for returning visitors it is not.

Thank You

Arun

View solution in original post

1 Reply
PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Micheal,

Both are not same and thus the difference:

visit_start_time_gmt : Timestamp (in Unix time) of the first hit of the visit.

first_hit_time_gmt : Timestamp of the very first hit of the visitor in Unix time.

So, visit_start_time_gmt refers to the visit and first_hit_time_gmt refers to the visitor i.e. For New Visitor visit_start_time_gmt will be equal to first_hit_time_gmt but for returning visitors it is not.

Thank You

Arun

View solution in original post