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

Funnel dashboard and user IDs

Malaik
DynaMight Champion
DynaMight Champion

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.

Malaik_0-1662544268039.png

 

Have a good day

Sharing Knowledge
7 REPLIES 7

mark_bley
Dynatrace Champion
Dynatrace Champion

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

 

Malaik
DynaMight Champion
DynaMight Champion

Thank @mark_bley 
This is not what I need,

 

I need for each step exactly.

This request is given a different values.

Sharing Knowledge

mark_bley
Dynatrace Champion
Dynatrace Champion

So with above query the results would look something like this

mark_bley_0-1663577209142.png

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

Malaik
DynaMight Champion
DynaMight Champion

Yes

 

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

Sharing Knowledge

mark_bley
Dynatrace Champion
Dynatrace Champion

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

Malaik
DynaMight Champion
DynaMight Champion

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.

Sharing Knowledge

mark_bley
Dynatrace Champion
Dynatrace Champion

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.

Featured Posts