USQL power - follow the user session funnel more efficiently - Tip for Business App

uros_djukic1 — Tue, 18 Jul 2023 08:49:22 GMT

Hello Dynatracers,

This post will be helpfull for Managed customers. Given that nowadays with DQL we can empowered this kind of thing.
However it worth to be mentionned , particularly if you are struggling with sensitive application running below PCI DSS compliance environment.

** the tip here : How I can convert to the metric my USQL Funnel , given that it is not allowed to generate "custom metric".

You can create USQL custom metrics like this :
https://www.dynatrace.com/support/help/platform-modules/digital-experience/web-applications/additional-configuration/custom-metrics-from-user-sessions

the key is to concatanete the nb of useraction.name with adding filter for appropriate Funnel Step (i.e. Step 3 : ua.name1 + ua.name2 + ua.name3);

Afterward , you can get the more accurate result and you can do your Conversion Rate Step !

For one Tile you get this expression into Data Explorer :

Moreover , thanks to that, you can now apply arithmetic expression on USQL custom metrics 😉

Hope it helps

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App

Kenny_Gillette — Tue, 18 Jul 2023 11:46:44 GMT

Great details. Thx for sharing

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App

Romanenkov_Al3x — Tue, 18 Jul 2023 12:00:05 GMT

Can be useful. TY for sharing.

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App

radek_jasinski — Tue, 18 Jul 2023 12:10:07 GMT

Thank you:)

topic USQL power - follow the user session funnel more efficiently - Tip for Business App in Dynatrace tips

USQL power - follow the user session funnel more efficiently - Tip for Business App

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App

Re: USQL power - follow the user session funnel more efficiently - Tip for Business App