Export time metrics to Excel | Community
Skip to main content
Michaël_Zondag
New Participant
Nov 30, 2019 10:53 PM UTC
Solved

Export time metrics to Excel

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:

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

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

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:

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    fsakjlfdsakljfd
    fsakjlfdsakljfdAccepted solution
    Level 5
    Dec 2, 2019 2:49 PM UTC

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

    View reply

    3 replies

    Michaël_ZondagAuthor
    New Participant
    Dec 3, 2019 6:49 AM UTC

    Thanks for the tip! I'll try that.

    Translate
    NickingtonW
    New Participant
    Sep 26, 2023 11:31 AM UTC

    I have tried the solution but it still gives me a big number instead of the # of seconds or the time format. 

    Translate
    fsakjlfdsakljfd
    fsakjlfdsakljfdAccepted solution
    Level 5
    Dec 2, 2019 2:49 PM UTC

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

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...