Expand my Community achievements bar.

Adobe Analytics Champions applications are now OPEN! Applications are open through June 2nd. Click the link to learn more and apply.
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!

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

page footer