How to avoid "invalid" metric | Community
Skip to main content
December 9, 2019
Solved

How to avoid "invalid" metric

  • December 9, 2019
  • 1 reply
  • 5166 views

Hi,

In Time spent per visit (seconds) metric, sometimes I get invalid  value on result:

Source image file 20944 not available

I created a Calculated Metric to avoid this and get zero value in these cases, but I can't find the solution using Adobe functions.

Anyone know any formula type is_invalid?

Thanks!

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 nikhileshc30691

Hi Alex,

 

Invalid value is recorded when user lands on page but don't do any activity like click or something. Adobe records time by calculating time between two events like when user enters page and click on something. 

 

So

 

Time spent per visit = Last hit time - First hit time

 

if no hits/events generated after user visits the page then adobe would show "invalid" value for such cases.

 

Best way would be to filter out such value when you generate report instead of implementing any custom script.  

1 reply

nikhileshc30691
nikhileshc30691Accepted solution
Level 2
December 16, 2019

Hi Alex,

 

Invalid value is recorded when user lands on page but don't do any activity like click or something. Adobe records time by calculating time between two events like when user enters page and click on something. 

 

So

 

Time spent per visit = Last hit time - First hit time

 

if no hits/events generated after user visits the page then adobe would show "invalid" value for such cases.

 

Best way would be to filter out such value when you generate report instead of implementing any custom script.