25 Jun 2020 11:25 AM
Hello
can I calculate the time between two steps in a User session through USQL?
For example, the time from the start of the purchase to payment for the goods?
Solved! Go to Solution.
25 Jun 2020 01:06 PM
You could put in the duration time of action x and make another USQL for action Y. You could also mark the requests as Key request and formulate a chart off of that or even conversion goals
25 Jun 2020 01:55 PM
I need a metric not the sum of two steps, but the duration of the period in the session between two steps.
we have a metric for the duration of the session. So I need only part of this metric regarding the two steps of the user in the funnel
25 Jun 2020 03:34 PM
No the only place this is available to any extent is if you're looking at a single user's session where you can see all of the user actions in order but there's no way to get this as a metric or even as number from usql.
With usql you can get start times and end times by querying the user action table but you'd be querying both relevant user actions you can't have data from both of them in the same row. And if you queried from the usersession table you can pull from the useractions but you can't get the starttime from two actions separately, there's just no way to express that.
You'd need to be able to do something like select action1.startTime - action2.startTime as difference from usersession which you cannot do.
25 Jun 2020 08:15 PM
pity that there is no such. This is a very useful indicator for business.
maybe I create an RFE. maybe developers will create when not
02 Jul 2021 02:31 PM
Yes. This is very useful information for business, we have useraction.startTime information in the useraction but we are not able to use it wisely for our analysis. Extracting data via USQL API and query the time difference from another tool would not be an ideal way for a single use case(this involves exporting data and requires elasticsearch or an ideal tool in Prod enV).