Create a new version of Time Spent - Bucketed with different buckets? | Community
Skip to main content
June 3, 2024
Question

Create a new version of Time Spent - Bucketed with different buckets?

  • June 3, 2024
  • 1 reply
  • 524 views

Hello-

Is there a way to create a new version of Time Spent on Page - Bucketed that has different buckets?  Possibly with Classification Rule Builder?  

Thanks. 

Colleen

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 3, 2024

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