07 Sep 2022 02:52 AM - last edited on 13 Sep 2022 12:33 AM by MaciejNeumann
I built a Funnel Dashboard that Working 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
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)
This is not what I need,
I need for each step exactly.
This request is given a different values.
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
I built the same but the numbers are not matching that why i opened this discussion.
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.
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.
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.