What would cause a difference in Date Feeds between visit_start_time_gmt and first_hit_time_gmt? | Community
Skip to main content
Michael_Manooch
Michael_Manooch
New Participant
December 20, 2018
Solved

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

  • December 20, 2018
  • 1 reply
  • 1550 views

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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by PratheepArunRaj

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

1 reply

PratheepArunRaj
PratheepArunRajAccepted solution
New Participant
December 21, 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

Terms & ConditionsAccessibility statement

Loading footer...