Time Spent on site per Unique Visitor | Community
Skip to main content
K
kelso_deluca
October 16, 2015
Solved

Time Spent on site per Unique Visitor

  • October 16, 2015
  • 1 reply
  • 822 views

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.
    Best answer by martijn_123

    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

    1 reply

    martijn_123
    martijn_123Accepted solution
    Level 3
    October 16, 2015

    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

      Terms & ConditionsAccessibility statement

      Loading footer...