Create a new version of Time Spent - Bucketed with different buckets?
Hi,
I think you can do this with calculated metrics.
I just did a test for between 45 and 120 seconds and it appears to work...
But it's a but complex... it requires nested if statements.
So for the first bucket, 0-X; this would be the easiest:
IF [
Time Spent on Page - Granular is less than X [
Total Seconds Spent
]
Value if True [
Total Seconds Spent
]
Value if False [
Static Number 0
]
]
Basically, I check if the granular time on the page is less than X, if it is, I return the Time Spent, otherwise I return 0.
Now, for the bounding box values, such as X-Y:
IF [
Time Spent on Page - Granular is greater than or equal to X [
Total Seconds Spent
]
Value if True [
IF [
Time Spent on Page - Granular is less than Y [
Total Seconds Spent
]
Value if True [
Total Seconds Spent
]
Value if False [
Static Number 0
]
]
Value if False [
Static Number 0
]
]
So in this case, I first have to check if the granular time spent is greater than X, then I have to do a second check if the value is less than Y. If both pass, then I pass back the Time Spent... if not, I return 0.
It's not the easiest, but I think it should work.. but test it out with a few samples and test to make sure it works....
The last one (the catch all for high values), would be built like the first one, but instead of Less Than, it would be Greater Than.
Good Luck
Related Conversations
