Visit Hit Number order is different from timestamp order?

Avatar

Avatar
Ignite 1
Level 1
naveens52565614
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
View profile

Avatar
Ignite 1
Level 1
naveens52565614
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
View profile
naveens52565614
Level 1

17-08-2020

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. 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Affirm 25
Employee
Khurshid_Alam
Employee

Likes

57 likes

Total Posts

198 posts

Correct reply

42 solutions
Top badges earned
Affirm 25
Boost 50
Affirm 10
Boost 25
Affirm 5
View profile

Avatar
Affirm 25
Employee
Khurshid_Alam
Employee

Likes

57 likes

Total Posts

198 posts

Correct reply

42 solutions
Top badges earned
Affirm 25
Boost 50
Affirm 10
Boost 25
Affirm 5
View profile
Khurshid_Alam
Employee

19-08-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.

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

17-08-2020

Hi @naveens52565614,

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