Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
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