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

[akma1991]

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

[Ishan_Sinha_ · Accepted solution]

@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!

[akma1991]

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

[Hyder_Ziaee]

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