topic Re: Capturing userid with two specific consecutive user actions in Open Q&A

Capturing userid with two specific consecutive user actions

erh_inetum — Thu, 20 Oct 2022 08:38:16 GMT

Hi,

We want to extract the userid that have clicked on two useractions. These useractions must be appear consecutive.

I've read here

https://www.dynatrace.com/support/help/how-to-use-dynatrace/real-user-monitoring/how-to-use-real-user-monitoring/cross-application-user-session-analytics/custom-queries-segmentation-and-aggregation-of-session-data#limitations

that Ordering is partially supported

How can we do to get this?

Thanks in advance.

Regards,

Elena.

Re: Capturing userid with two specific consecutive user actions

ChadTurner — Fri, 20 Jan 2023 14:50:37 GMT

@erh_inetum were you able to get a solution to this? This should be able to be completed by having the USQL select the User ID where the user actions are (Action1) and (Action2). Granted you might need to do some tweaking as this is very generic.

SELECT userId FROM usersession WHERE useraction.name IS "<ACTIONNAME>" AND useraction.name IS "<ACTIONNAME>"

Re: Capturing userid with two specific consecutive user actions

erh_inetum — Mon, 23 Jan 2023 05:44:50 GMT

Hi @ChadTurner . I'll test it and I'll tell you.

Thanks!