Visit Hit Number order is different from timestamp order? | Community
Skip to main content
N
navee1
Level 2
August 17, 2020
Solved

Visit Hit Number order is different from timestamp order?

  • August 17, 2020
  • 2 replies
  • 1880 views

The context is when we send the clickstream data to adobe analytics. The Visit Hit Number order is not matching the timestamp order.

i.e we have many examples like visit_hit_number 10, 12, 13 has the lowest timestamp for the given visitor. 

because of this, our first touch reports are mostly pointing to direct channel. We currently use timestamp optional. 

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 kainth

Hi @navee1,

If I have understood correctly you are referring to the "visit_page_num" column. As per the current design of Analytics, if the timestamp is the same for two hits then we use the combination of columns "hitid_high" & "hitid_low". Any hit whose hitid value is less will appear first followed by the one whose hitid value is higher.

So, I will suggest you to get in touch with your implementation team to identify why some of the hits have the same timestamp value. Also, one thing to note here, in case of data feeds we only look at the timestamp till seconds. If there are two hits that were received with the difference of few milliseconds then again the above-mentioned method will be followed to identify the order of the hits.

Hope this helps. Please let me know in case of any further questions.

 

Regards,

Abhinav

2 replies

K
kainthAccepted solution
Level 6
August 18, 2020

Hi @navee1,

If I have understood correctly you are referring to the "visit_page_num" column. As per the current design of Analytics, if the timestamp is the same for two hits then we use the combination of columns "hitid_high" & "hitid_low". Any hit whose hitid value is less will appear first followed by the one whose hitid value is higher.

So, I will suggest you to get in touch with your implementation team to identify why some of the hits have the same timestamp value. Also, one thing to note here, in case of data feeds we only look at the timestamp till seconds. If there are two hits that were received with the difference of few milliseconds then again the above-mentioned method will be followed to identify the order of the hits.

Hope this helps. Please let me know in case of any further questions.

 

Regards,

Abhinav

khurshid
Adobe Employee
khurshidAdobe Employee
Adobe Employee
August 19, 2020

Analytics servers do not differentiate timestamps if they are have the same second. For example, hit 1 has time stamp 01:01:01.3 and hit 2 has time stamp 01:01:01.5. Analytics will treat both the timestamps as 01:01:01. Now, the order of the hits will be decided on which hit arrives first on the servers. So, if hit B reached the servers first, the order of the hit will be Hit B > hit A.

In order to prevent this, it is advised that the hits should have at least one second's different. Therefore, hit 1 should have time stamp 01:01:01 and hit 2 as 01:01:02. You might need to work on the implementation to adjust the timestamps accordingly.

Terms & ConditionsAccessibility statement

Loading footer...