mahir_data
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
dayDATE
variantTEXT
usersINT
conversionsINT

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.

See Basic plans