Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

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

Avatar

Level 2

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

 

akma1991_0-1650036285632.png

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

3 Replies

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 2

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

Avatar

Employee Advisor

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