How to include user think time from DEM User Sessions Query

mengsuan_koe1 — Wed, 09 Jun 2021 09:57:10 GMT

Business users had a use-case with RUM to track duration of each of their users performing a particular set of actions.

For example, track how long in between a user's Login action until Submit action. This is not about tracking individual action response time, but user's behaviour of using the app.

Would it be possible to use User Sessions Query Language to do that?

I have tried to build USQL but I'm not sure how to "minus" the action's startTime to give the exact number of minutes in between two actions.

SELECT usersession.userid, DATETIME(startTime) FROM useraction WHERE name in ("GiveConsentLogin", "SubmitClicked") GROUP BY usersession.userId

Sample result:

Has anyone gotten better results using USQL?

Re: How to include user think time from DEM User Sessions Query

mengsuan_koe1 — Wed, 09 Jun 2021 11:11:01 GMT

Alternatively, I also thought of using creating custom user action that starts from login to submit button click. This will produce an action duration of minutes, depending on how quickly the user get the end of the process.

Would this be a good alternative? I can think of inaccurate Apdex as a result of long action duration.

topic Re: How to include user think time from DEM User Sessions Query in Real User Monitoring

How to include user think time from DEM User Sessions Query

Re: How to include user think time from DEM User Sessions Query