Skip to main content
Level 2
Apr 15, 2022 3:24 PM UTC
Solved

How is it possible for Adobe Analytics Clickstream Data visit_num column to have value of '0'?

Under what circumstances would the visit_num column be 0 in clickstream data?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
isinhaAccepted solution
Employee
Apr 15, 2022 3:46 PM UTC

@akma1991 - visit_num is assigned 0 when that hit was not completely processed due to some reason, like - if it was identified as a bot, or if it was a A4T unstitched hit, or if the hit was opted-out or excluded, etc.

Thanks!

3 replies

isinhaAccepted solution
Employee
Apr 15, 2022 3:46 PM UTC

@akma1991 - visit_num is assigned 0 when that hit was not completely processed due to some reason, like - if it was identified as a bot, or if it was a A4T unstitched hit, or if the hit was opted-out or excluded, etc.

Thanks!

Translate
akma1991Author
Level 2
Apr 15, 2022 7:51 PM UTC

Thanks Ishan!  What column in clickstream will tell me if it was an u nstitched A4T hit?

Translate
Hyder_Ziaee
Employee
Apr 28, 2022 4:22 AM UTC

Check exclude_hit column value.

If 14, it indicates unstitched hit. Any value apart from 0, means it got excluded for some reason.

Data column reference | Adobe Analytics

Translate