Skip to main content
kelso_deluca
Oct 16, 2015 2:26 AM UTC
Solved

Time Spent on site per Unique Visitor

I am looking to find time spent on site for every single unique visitor grouped by individual minutes. At the moment all I can pull is a general breakdown ie. 1-5 mins, 10-30 mins etc.  I need this to be 1 min, 2 min, 3 min .  The business scenario is the calculation of headroom , so I need to see how long a group of users engages with the site.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    martijn_123
    martijn_123Accepted solution
    Level 3
    Oct 16, 2015 2:26 AM UTC

    Hi Kelso,

    If you have access to Datawarehouse you could extract "Visitor ID" and "total seconds spent" for the required period. Then you can add the segments (1 minute, 2 minutes, etc..) that you are looking for and group the visitors by your segment. You could do this in Excel for example.

    It might get problematic if you have a lot of unique visitors (+/- 1 million)  because of the file size. But I don't see an option with the other tools, maybe others do.

    Martijn

    View in thread

    1 reply

    martijn_123
    martijn_123Accepted solution
    Level 3
    Oct 16, 2015 2:26 AM UTC

    Hi Kelso,

    If you have access to Datawarehouse you could extract "Visitor ID" and "total seconds spent" for the required period. Then you can add the segments (1 minute, 2 minutes, etc..) that you are looking for and group the visitors by your segment. You could do this in Excel for example.

    It might get problematic if you have a lot of unique visitors (+/- 1 million)  because of the file size. But I don't see an option with the other tools, maybe others do.

    Martijn

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...