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

**URL:** <https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741>\
**Category:** Dynatrace Tips\
**Tags:** real-user-monitoring-classic, data-explorer, usql\
**Created:** [July 18, 2023, 8:49am UTC](https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741 "2023-07-18T08:49:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![uros\_djukic1](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/uros_djukic1/32/37084_2.png) [@uros\_djukic1](https://community.dynatrace.com/u/uros_djukic1)\
**Post date:** [July 18, 2023, 8:49am UTC](https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741/1 "2023-07-18T08:49:22Z")

</div>

Hello Dynatracers,

This post will be helpfull for Managed customers. Given that nowadays with DQL we can empowered this kind of thing.&nbsp;  
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”.** &nbsp;_

 ![uros_djukic1_0-1689669172856.png](https://global.discourse-cdn.com/dynatrace/original/1X/3275e3581efc761e80416c3402e40a01571d42b6.png)

You can create USQL custom metrics like this :&nbsp;

> **[Create USQL custom metrics for web applications in RUM Classic](https://docs.dynatrace.com/docs/observe/digital-experience/rum-classic/web-applications/additional-configuration/custom-metrics-from-user-sessions)**
>
> Every time a user session is closed, Dynatrace can extract metrics and store them as time series. Learn how to set up and use USQL custom metrics for web applications.

 ![uros_djukic1_1-1689669355738.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/3/e333fa36b88ab5f4ff9250919b72812cf951c8b7.png)

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 !

 ![uros_djukic1_2-1689669666321.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/6/864641aad2c5c4a1f9b0070582fab7410d1f19ba.png)

For one Tile you get this expression into Data Explorer :

 ![uros_djukic1_3-1689669748677.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/b/3b06d07aeb1a095474a294ce5e84cc4eea5a605f.png)

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

Hope it helps

---

<div class="post-metadata">

**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\
**Post date:** [July 18, 2023, 11:46am UTC](https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741/2 "2023-07-18T11:46:44Z")

</div>

Great details.&nbsp; Thx for sharing

---

<div class="post-metadata">

**Author:** ![Romanenkov\_Al3x](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/romanenkov_al3x/32/36257_2.png) [@Romanenkov\_Al3x](https://community.dynatrace.com/u/Romanenkov_Al3x)\
**Post date:** [July 18, 2023, 12:00pm UTC](https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741/3 "2023-07-18T12:00:05Z")

</div>

Can be useful. TY for sharing.

---

<div class="post-metadata">

**Author:** ![radek\_jasinski](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/radek_jasinski/32/10432_2.png) [@radek\_jasinski](https://community.dynatrace.com/u/radek_jasinski)\
**Post date:** [July 18, 2023, 12:10pm UTC](https://community.dynatrace.com/t/usql-power-follow-the-user-session-funnel-more-efficiently-tip-for-business-app/40741/4 "2023-07-18T12:10:07Z")

</div>

Thank you:)
