Skip to main content
frederikw694537
frederikw694537
New Participant
March 4, 2020

Negative Time Values in Adobe Analytics

  • March 4, 2020
  • 2 replies
  • 12663 views

Hey Guys,

 

I cam across a strange behavior in Analytics. It seems like it is not able to render negative values in time format correctly, at least in Analysis Workspace.

 

To reproduce, I created two calculated metrics, one with a static value of "30" and one with "-30". Then I formatted them both as time. In Workspace, they look like this:

 

Clearly, the negative value is broken. We need this to compare time spent on specific pages with the average, but it does not work right now. The expected result would be "-00:00:30".

 

Best regards,

Frederik

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

2 replies

Pablo_Childe
Pablo_Childe
New Participant
March 4, 2020

I think its a case of creating 3 calculated metrics.

 

1 avg time spent on page per visit

2 overall avg time spent on all pages per visit

3 the difference of 1-2(or vice versa)

 

All are positives except the last one which (could be negative)

 

 

 

Andrey_Osadchuk
Andrey_Osadchuk
New Participant
March 4, 2020

What question does the 3rd metric answer?

Pablo_Childe
Pablo_Childe
New Participant
March 4, 2020

The 3rd will answer.

 

If articles avg time spent on the specific page is X, then how does it compare to over all average? A positive number means its better than avg, a negative means its lower.

 

I am assuming he is trying to understand relative content engagement. vs site content engagement average.

 

(this is a very simplified way to measure content engagement as it really only looks at 1 metric as the determiner(avg time spent on page))

 

There are more complete methods to create calculated metrics to indicate page level (thereby content level) engagement but as a first pass will be a good lesson.

 

 

Andrey_Osadchuk
Andrey_Osadchuk
New Participant
March 4, 2020

Frederik,

 

I wonder what a negative value in the time format means? Could you share a use case?

    Terms & ConditionsAccessibility statement

    Loading footer...