cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL query on action order

Julius_Loman
Leader

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.


13 REPLIES 13

AlexanderSommer
Dynatrace Pro
Dynatrace Pro

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


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)


+ to Julius

@Alexander S. any visible timeframe for this feature?


joshua_pavlica
Dynatrace Pro
Dynatrace Pro

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.


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


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-custom...


Kind regards,
Joshua P.


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.


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.


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.


mohanasivapras1
Inactive

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

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.

alatarsa1
Participant


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 ?

alatarsa1
Participant

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 ?