topic Re: FUnnel Dashboard and UserIds in Dashboarding

Funnel dashboard and user IDs

Malaik — Wed, 24 May 2023 09:45:31 GMT

Hi Community

I built a Funnel Dashboard that works fine, but now I want to retrieve in a second tile the user IDs for each step,

If any one build this before, his help is appreciated.

Have a good day

Re: FUnnel Dashboard and UserIds

mark_bley — Mon, 12 Sep 2022 11:15:35 GMT

Hi @Malaik

in order to get specific userIds for a useraction you can use a query like this one:

SELECT DISTINCT userId as 'Current Unique UserID' FROM usersession Where (useraction.name = "Submit PE Products" and userId IS NOT NULL)

Best,

Mark

Re: FUnnel Dashboard and UserIds

Malaik — Mon, 19 Sep 2022 07:02:39 GMT

Thank @mark_bley
This is not what I need,

I need for each step exactly.

This request is given a different values.

Re: FUnnel Dashboard and UserIds

mark_bley — Mon, 19 Sep 2022 08:48:06 GMT

So with above query the results would look something like this

which show you in a second tile the user Ids (count or list) for each step

Re: FUnnel Dashboard and UserIds

Malaik — Mon, 19 Sep 2022 10:29:27 GMT

Yes

I built the same but the numbers are not matching that why i opened this discussion.

Re: FUnnel Dashboard and UserIds

mark_bley — Mon, 17 Oct 2022 14:12:50 GMT

Hi @Malaik,

the numbers do not need to match necessarily from one step to the other.

What numbers are you seeing that would not expect ?

I would like to understand this issue better to help you out.

Best,

Mark

Re: FUnnel Dashboard and UserIds

Malaik — Thu, 15 Dec 2022 06:37:34 GMT

Hi and sorry for the delay,

The issue is that the numbers between the funnel steps and the the table bellow are not matching and this is normal I thing.

Because the second step in the funnel should come from the frist step.

And the table, we dont have any control on the actions.

Re: FUnnel Dashboard and UserIds

mark_bley — Thu, 15 Dec 2022 08:22:59 GMT

Funnel show the specific order that a user has gone through those actions, if none have (gone through the actions in that order), then the amount/count of user IDs (of that action) and the number from the funnel will vary. In this blog post the funnel usage is explained pretty well.