topic Re: USQL - Funnel by userId in Real User Monitoring

USQL - Funnel by userId

MAkimov — Thu, 25 Jun 2020 11:46:58 GMT

as I understand correctly, the funnel function is based on a user session

is it possible to build a funnel based on unique users?

for example, when a user starts a process, but within one session does not end it. And then, for example, tomorrow he will start filling out the process again.

We need Funnul based uniq user not usersession

Re: USQL - Funnel by userId

ChadTurner — Thu, 25 Jun 2020 12:00:36 GMT

While I have not tried this, its worth a shot. Did you try and were you unable to make a funnel chart based off of a single user?

Re: USQL - Funnel by userId

JamesKitson — Thu, 25 Jun 2020 14:17:35 GMT

You can filter down to a specific user tag in a funnel/usql but all of the funnel queries work at the session level so you can't span multiple sessions (over several days for example) when populating a funnel.

Re: USQL - Funnel by userId

dmitry-netrebin — Mon, 24 Aug 2020 14:03:15 GMT

Hi Mikhail.

Yes, you right, funnel based on sessions. but you can use Single value in USQL to see that values on your dashboard.

it will looks like this

where three tiles at the bottom will contain something like this:

1. SELECT COUNT(userid) as users FROM usersession WHERE useraction.name = "AppStart (easyTravel)"

2. SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney"

3. SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney" AND useraction.name = "bookJourney"

Probably you got to use COUNT(DISTINCT userid) instead of COUNT(userid) to exclude dublicates

Re: USQL - Funnel by userId

MAkimov — Mon, 24 Aug 2020 16:32:32 GMT

have a question

will this select show users who had the first action in one session and the second in another, or will it show users who had two actions in one session

SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney"