USQL - Funnel by userId

[MAkimov]

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

[ChadTurner]

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?

[JamesKitson · Accepted solution]

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.

[dmitry-netrebin · Accepted solution]

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

[MAkimov]

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"