what is the best way to do a funnel analysis

181 views
Skip to first unread message

Silviu Caragea

unread,
Jun 8, 2017, 4:37:59 PM6/8/17
to ClickHouse
Hello,

What is the most optimal way to do a funnel analysis like in the example offered in keen.io: https://keen.io/docs/compute/intro-to-funnel-analysis/

I mean to see how many actors completed step 1 and then step 2 and then step 3 and so on. Like in the example provided above

Silviu

a...@imagespark.ru

unread,
Jun 9, 2017, 5:11:51 AM6/9/17
to ClickHouse
Hi. In docs described two aggregate functions sequenceMath and sequenceCount.

четверг, 8 июня 2017 г., 23:37:59 UTC+3 пользователь Silviu Caragea написал:

Caragea Silviu

unread,
Jun 9, 2017, 5:34:26 AM6/9/17
to a...@imagespark.ru, ClickHouse
Hello,

I already looked on that functions but I don't see how you can use them to implement something similiar with what I described as time I don't see they return how many records matched the conditions on each step

Silviu

--
You received this message because you are subscribed to a topic in the Google Groups "ClickHouse" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/clickhouse/1WPMkYfRgWk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to clickhouse+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/b31276cd-de84-45a7-9890-e9d26d2b479e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages