Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
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