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

Learn More

View all

Sign in to view all badges

How can you change seconds to hours/minutes in Adobe Analytics?

Avatar

Avatar
Validate 1
Level 1
jeremyl39845142
Level 1

Likes

2 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
jeremyl39845142
Level 1

Likes

2 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
jeremyl39845142
Level 1

26-09-2017

Hi,

Is there anyway to change the Adobe Analytics so that the reports show minutes/hours instead of seconds?

Many thanks,

jeremy

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

26-01-2018

Thank you for the correction Chris, but actually now that I'm revisiting this, I don't think a static multiplier needs to be added at all.

Creating a calculated metric that simply takes the time in seconds and converts it into time format fully resolves and time interpretation issue - no raw seconds, and no decimal minutes:

The calculated metric automatically converts the raw number of seconds into hours/minutes/seconds. No multiplication or division required. The trick is to make sure you're using the 'Time' format,

Answers (3)

Answers (3)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

26-09-2017

Hi Jeremy, which report are you referring to?


If it's something like time spent reports, you can use calculated metrics to get what you're looking for. Basically create a new calculated metric that is [time in seconds] * 60.

Avatar

Avatar
Boost 1
Level 1
christine-b
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
christine-b
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
christine-b
Level 1

26-01-2018

Hello

well [time in seconds] * 60 it not accurate. it should be time in seconds / 60 and event there the decimal is not correct as the report will show time as 1mn 75 seconds and not convert the time after the decimal in minutes.

It would be nice if we could have a better view on this in HH:MM:SS

even in the calculated metrics turning the value in time rounds up or down to minute.

and there can be a huge difference when the time is rounded iup

eg

1m01s is rounded to 1mn

1m31s is rounded to 2mn

for sites with few seconds spent on site it is a huge difference.

Thanks

Chris

Avatar

Avatar
Boost 1
Level 1
christine-b
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
christine-b
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
christine-b
Level 1

28-01-2018

Hi Gigazelle

Of course now looking at it, calculation is not needed.

It's working wonders! and now my report just looks perfect.

Thanks a lot for looking into it