busy-secretary-78039
11/03/2022, 7:09 PMfuture-teacher-7046
select user_id, timestamp from step1
2. select user_id, timestamp from step2
Step 1 doesn't need anything special to work. For Step 2, you'll need to set the denominator to Step 1 to turn it into a funnel metric. That will make the metric (step 2 conversions) / (step 1 conversions)
, in other words the percent of people on step 1 who completed step 2.SUM(value)
. So if they made 3 purchases, we would sum the values together and it would be treated as 1 big purchase instead.busy-secretary-78039
11/03/2022, 7:19 PMfuture-teacher-7046
busy-secretary-78039
11/03/2022, 7:21 PMfuture-teacher-7046
busy-secretary-78039
11/03/2022, 7:22 PMfuture-teacher-7046
Binomial
then it will treat it as a percentagebusy-secretary-78039
11/03/2022, 7:27 PMfuture-teacher-7046
value
.