Creating marketing funnels or how to calculate complex metrics in ClickHouse

In this talk I will discuss implementation of "Fun with Funnels", a standalone web application based on AppMetrica’s data, which uses the ClickHouse database and is distributed as a docker container. You will learn about arrays and higher-order functions in ClickHouse and how to use them to calculate complex metrics such as marketing funnels.