Negative Time Values in Adobe Analytics

Avatar

Avatar
Boost 25
Level 3
frederikw694537
Level 3

Likes

31 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Contributor
Shape 1
Ignite 1
Give Back
View profile

Avatar
Boost 25
Level 3
frederikw694537
Level 3

Likes

31 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Contributor
Shape 1
Ignite 1
Give Back
View profile
frederikw694537
Level 3

04-03-2020

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:

04-03-_2020_13-42-32.png

 

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

Replies

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

04-03-2020

Frederik,

 

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

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

04-03-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)

 

 

 

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

04-03-2020

What question does the 3rd metric answer?

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

04-03-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.

 

 

Avatar

Avatar
Boost 25
Level 3
frederikw694537
Level 3

Likes

31 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Contributor
Shape 1
Ignite 1
Give Back
View profile

Avatar
Boost 25
Level 3
frederikw694537
Level 3

Likes

31 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Contributor
Shape 1
Ignite 1
Give Back
View profile
frederikw694537
Level 3

04-03-2020

Hey @Andrey_Osadchuk and @pabloc82923542,

well explained, @pabloc82923542! That is one of the usecases. This is not only limited to the page dimension, but any other dimension as well. For example, we could compare the time spent per visit across device types compared to the average. That way we could easily see, that our mobile users are spending 3 minutes less on our page than the average over all devices. This is also interesting for marketing campaigns or entry page reports.

For a media company like us, there is even one more case: We have a lot of videos and need to compare the watchtime per video start across videos to the average as well. Things like "video a is watched 2 minutes less than average" are very important to us!

Does this clear things up a bit? 🙂

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

05-03-2020

I like the metric just be careful as time on page can be influenced if your users do alot of idling.(leave page open for the 30 mins)

 

Videos you should also ensure you capture video tracking metrics if not done so. That will be a much more accurate way to see video engagement. Esp if you have your own player. Embedded is tricker.

 

Glad it made sense! GLTU