Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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