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.
Solved! Go to Solution.
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
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