mediumTraveloka · experimentationBasicNew
Cumulative conversion rate by day
Traveloka's experiment dashboard shows a running conversion rate so the team can watch a test unfold. Watching it is also how teams talk themselves into stopping early on a day that happens to look good — the false-positive rate climbs every time you peek and act.
From daily_ab, return day, variant, and cumulative_rate — total conversions through that day divided by total users through that day, rounded to 4 decimal places. Order by day, then variant.
Schema
▸daily_ab
| day | DATE |
| variant | TEXT |
| users | INT |
| conversions | INT |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.