Conversions Goals on USQL

[ArtuD]

How can i pass a conversion goals to a USQL query and create a dashboard?

[dannemca · Accepted solution]

It depends on what kind of information you are trying to reach.

If the number of sessions that match any conversion, you can use the USQL condition "matchingConversionGoalsCount>=X", where X is the session number.

You can also use the builtin metric "builtin:apps.web.conversionRate" to get the rate (%) of sessions that matches at lease one goal.

You can also get more insights of the conversion using it on the USQL as conditions, depending on your goal set:

If action number: "userActionCount>=X"

If user action: "userAction.name=X"

If destination: "userevent.page=X"

If duration: "duration>=X"

[dannemca]

In https://dynatrace.github.io/BizOpsConfigurator/ you can also find two examples of Dashboards, including gen3, that uses conversion goals.

[ve00685603]

Thank you so much for the interactive discussion in this post. Wondering if there's a possibility to increase the funnel query count to some number as right now, I am seeing the maximum count of 10 and not allowing beyond that. Pls advise.

The maximum number of funnel-steps per query was exceeded (requested 11, but maximum is 10)