Funnel Conversion rates

Thu, 03 Nov 2016 10:34:42 GMT

Hi all,

I'm working with users behaviour data in an app and I'd like to get analytic information related to the conversion of the users into the different events.

The data I have is as follow:

User ID	Event	Success / Fail	TimeStamp
1	Launch the app	-	2016-11-02 11:30:45
1	Register in the app	Fail	2016-11-02 11:31:30
1	Register in the app	Success	2016-11-02 11:32:58
1	Select something	-	2016-11-02 11:35:22
2	Launch the app	-	2016-11-02 13:21:10
2	Register in the app	Success	2016-11-02 13:21:30
2	select something	-	2016-11-02 13:22:00
2	Add something	Success	2016-11-02 13:23:45
3	Launch the app	-	2016-11-02 13:30:02
3	Register in the app	Fail	2016-11-02 13:31:02
3	Register in the app	Fail	2016-11-02 13:32:04
3	Register in the app	Fail	2016-11-02 13:32:43
3	Close the app	-	2016-11-02 13:32:45
4	Launch the app	-	2016-11-03 09:20:55
4	Register in the app	Fail	2016-11-03 09:21:59
4	Register in the app	Success	2016-11-03 09:23:01
4	Select something	-	2016-11-03 09:23:55
4	Add something	Fail	2016-11-03 09:24:08
5	Launch the app	-	2016-11-03 10:55:45
5	Register in the app	Success	2016-11-03 11:00:01
5	Select something	-	2016-11-03 11:05:09
5	Add something	Fail	2016-11-03 11:10:13
5	Add something	Success	2016-11-03 11:15:15
6	Launch the app	-	2016-11-04 20:14:05
6	Add something	Success	2016-11-04 20:14:45

And I'd like to get "Who of those users that launched the app went into successfully registered in the app, and of these users that successfully registered in the app, who went into select something, and of these users who went into successfully add something in less than 5 minutes."

In this case the answer is 2, as only user 2 completed flow in less than 5 minutes. So 16% of users who launched the app ended up the entire flow.

And the next question is "Who of those users that failed on registering in the app fo on to successfully register within 1 day" In this case the answer is user 1 and 4. So 33% of users who failed registering in the app go on to successfully register within 1 day.

What I mean is to get the typical funnel conversion with Qlik Sense expressions.

Thanks in advance!

Re: Funnel Conversion rates

Thu, 10 Nov 2016 16:45:54 GMT

Perhaps peek() or previous() functions? any idea? thanks.

topic Re: Funnel Conversion rates in App Development

Funnel Conversion rates

Re: Funnel Conversion rates