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

Adobe Analytics Coffee Break: On Monday, January 30 at 10am PT, the NOAM User Group led by Jennifer Dungan and Jeff Bloomer will be joining us to answer your Analytics related questions. To register and for more information, follow the link to the right.
SOLVED

How to avoid "invalid" metric

Avatar

Level 1

Hi,

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

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!

1 Accepted Solution

Avatar

Correct answer by
Level 2

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.  

View solution in original post

0 Replies

Avatar

Correct answer by
Level 2

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.