Custom chart for bounce rate

[IvanVovk]

It is possible to get bounce rate for a specific user action ( load page or xhr action).

I want to create a custom chart with bounce rate calculated for user action

[zietho · Accepted solution]

What you can do in USQL is the following query: SELECT useraction.name, COUNT(bounce) FROM usersession WHERE useraction.application='YOURAPPLICATION' GROUP BY useraction.name. You can also narrow it down with an AND seraction.name=YOURUSERACTION

And then chart and pin it to a dashboard

Notes:

• I know that's not a rate yet and only absolute but might be a start for you
• Since sessions can span over multiple apps and bounces are calculated per application this query might contain too many bounces. I still have to figure this out in detail though!

[IvanVovk]

Thanks! Thats what I'm looking for. Unfortunately, my query contains too many bounces(

[Pranjal17]

but this is not giving the exact bounce rate in percent that is what I am looking for .

[NaveenVangala]

Below is the query to get bounce in USQL -
SELECT useraction.name AS "UserAction Name", count(bounce) AS Count FROM usersession WHERE useraction.application='Test' AND bounce IN (true) GROUP BY useraction.name

we need to add bounce to True to get only useraction that were bounced.