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

Michael_Manooch

20-12-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

PratheepArunRaj

Moderator

20-12-2018

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

Answers (0)