How is it possible for Adobe Analytics Clickstream Data visit_num column to have value of '0'? | Community
Skip to main content
Level 2
April 15, 2022
Solved

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

  • April 15, 2022
  • 1 reply
  • 2034 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isinha

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

1 reply

isinhaAdobe EmployeeAccepted solution
Adobe Employee
April 15, 2022

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

akma1991Author
Level 2
April 15, 2022

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

Hyder_Ziaee
Adobe Employee
Adobe Employee
April 28, 2022

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