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
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
  • 1552 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
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
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

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Terms & ConditionsAccessibility statement

Loading footer...