Export time metrics to Excel

Avatar

Avatar
Boost 1
Level 1
Michaël_Zondag
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
Michaël_Zondag
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
Michaël_Zondag
Level 1

30-11-2019

Hi,

Does anyone know how to export time metrics (like time on site or time spent per visit) to excel? When I download a dashboard with time metrics form Adobe Analytics Workspace, I get completely different numbers in Excel. I have the same problem with Report Builder.

Example 1: fragment of a workspace dashboard:

1859754_pastedImage_0.png

This is what I see when I download these numbers to Excel. The numbers seem incomprehensible and unusable to me.

1859755_pastedImage_1.png

Example 2: fragment of a table I requested with Report Builder in Excel:

1860233_pastedImage_2.png

My current workaround is to download the numbers I need from the Reports section (instead of Workspace or Report Builder). Then copypaste the numbers to the Excel dashboard. This works for the Average Time on Site metric. Fragment from an export from the Reports section:

1860235_pastedImage_4.png

I would save time if I could download time on site numbers directly from Workspace to Excel. Hope somebody knows a solution.

Thanks!

Michaël

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Boost 1
Level 1
Michaël_Zondag
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
Michaël_Zondag
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
Michaël_Zondag
Level 1

02-12-2019

Thanks for the tip! I'll try that.

Avatar

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

13 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

13 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
fsakjlfdsakljfd
Level 4

02-12-2019

Have you tried requesting the seconds instead of the time formatted value?  Then you can use excel to compute the seconds back to minutes.