topic Re: USQL query on action order in Real User Monitoring

USQL query on action order

Julius_Loman — Thu, 14 Mar 2019 12:46:00 GMT

Is there any option to query user sessions that have actions in some consecutive order?

For example - an application has 3 actions - "action1", "action2", "action3". These may appear in any order in a user session and they can also repeat. I need to have a list of sessions in which actions are in exact order - such as "action1" is followed by "action2" which is followed by "action3".

It seems this cannot be achieved using USQL - can anyone confirm that? We can only filter sessions having particular actions, but regardless of their order.

Re: USQL query on action order

AlexanderSommer — Mon, 18 Mar 2019 08:43:40 GMT

Not at this point in time. This is on the roadmap.

Re: USQL query on action order

Julius_Loman — Mon, 18 Mar 2019 08:49:30 GMT

Good to know... Any ideas when this might be available?

Are also conversion goals based to action order on the roadmap? (see my idea here)

Re: USQL query on action order

vladislav_samoy — Fri, 06 Dec 2019 15:21:12 GMT

+ to Julius

@Alexander S. any visible timeframe for this feature?

Re: USQL query on action order

joshua_dtrace — Fri, 06 Dec 2019 16:06:16 GMT

Are you by chance asking about a Funnel for User Sessions? If so, in v1.182 of Dynatrace we're launching USQL Funnels!

Here's an example USQL query that provided the examples below:

SELECT FUNNEL(useraction.name="AppStart (easyTravel)" AS 'Open easytravel', useraction.name = "searchJourney" AS 'Search journey', useraction.name = "bookJourney" AS 'Book journey') FROM usersession

Kind regards,
Joshua P.

Re: USQL query on action order

Julius_Loman — Mon, 09 Dec 2019 20:02:19 GMT

Exactly! I'm looking forward to see this feature.
If we could get USQL running on live sessions, then it would be awesome.

Re: USQL query on action order

joshua_dtrace — Mon, 09 Dec 2019 20:07:09 GMT

Awesome to hear! 🙂

I'm not sure about USQL on live sessions, but we did just release a blog about new USQL functionality that should be live on v1.180 and later!

https://www.dynatrace.com/news/blog/find-the-user-session-data-you-need-and-better-understand-customer-experience-with-new-usql-functions/

Kind regards,
Joshua P.

Re: USQL query on action order

Julius_Loman — Mon, 09 Dec 2019 20:11:40 GMT

Well, until we get USQL working on live sessions, the usage will still be mostly for business analytics. It's not very useful for realtime or near-real-time monitoring of user experience - live session may take up to several hours to finalize and included in USQL results.

Re: USQL query on action order

rastislav_danis — Fri, 17 Jan 2020 09:36:44 GMT

Hi Joshua, why your mentioned blog doesn't contain info about FUNNEL functionality ? I have already tried it and it looks nice. Even dynatrace documentation is extended with info about this functionality so i wonder why it's so "hidden" in news.

Re: USQL query on action order

joshua_dtrace — Fri, 17 Jan 2020 18:58:09 GMT

Hi Rastislav D.!

That didn't make it into the blog as it released later, but here's some documentation below if you search for "FUNNEL": https://www.dynatrace.com/support/help/shortlink/usql-info#frequently-used-keywords

Kind regards,
Joshua P.

Re: USQL query on action order

mohanasivapras1 — Thu, 13 Feb 2020 21:39:02 GMT

Hi,

Once we write the USQL query using Funnel, it is not showing in Dashboard as "Y" shape of Funnel details like user action name details with count and % of completion?

Showing above Funnel look is not good to see in dashboards.

Let us know your thoughts?

Regards,

M.Mohana

Re: USQL query on action order

joshua_dtrace — Thu, 13 Feb 2020 22:11:57 GMT

Hello, M.Mohana!

Can you please reach out over Dynatrace Live Chat so that our Product Specialists can help you troubleshoot your issue? Thank you!
https://www.dynatrace.com/support/live-chat/

Kind regards,
Joshua P.

Re: USQL query on action order

Malaik — Mon, 09 Nov 2020 15:59:05 GMT

Hi all,

I have a question about funnel Dashboards,

I have a user journey but 2 diffrent ways to access :

1 - actionA actionB actionC actionD

for many reasons, some users cannot perform ActionC and I want that user to appear in the same FUNNEL.

Is it possible ?

Re: USQL query on action order

Malaik — Mon, 09 Nov 2020 15:59:25 GMT

Hi all,

I have a question about funnel Dashboards,

I have a user journey but 2 diffrent ways to access :

1 - actionA actionB actionC actionD

for many reasons, some users cannot perform ActionC and I want that user to appear in the same FUNNEL.

Is it possible ?