Host your own
product analytics suite

1SELECT entrance_period_start,
2       reached_from_step_count,
3       reached_to_step_count,
4       if(reached_from_step_count > 0, round(reached_to_step_count / reached_from_step_count * 100, 2), 0) AS conversion_rate
5  FROM (
6        SELECT entrance_period_start,
7               countIf(steps_completed >= 1) AS reached_from_step_count,
8               countIf(steps_completed >= 2) AS reached_to_step_count
9          FROM (
10                SELECT person_id,
11                       toStartOfDay(timestamp) AS entrance_period_start,
12                       max(steps) AS steps_completed
13                  FROM (
14                        SELECT *,
15                               if(latest_0 < latest_1 AND latest_1 <= latest_0 + INTERVAL 14 DAY, 2, 1) AS steps ,
16                               if(isNotNull(latest_1) AND latest_1 <= latest_0 + INTERVAL 14 DAY, dateDiff('second', toDateTime(latest_0), toDateTime(latest_1)), NULL) step_1_conversion_time
17                          FROM (
18                                SELECT person_id,
19                                       timestamp,
20