Capstone project · E-commerce and product analytics · about 180 minutes
Customer conversion experiment: ship the new checkout?
Run a checkout A/B test the way a senior analyst would: pre-register the metric, effect size and sample size, check the randomisation, analyse conversion with an interval for the lift, handle revenue, guardrails and segments honestly, and make a ship / no-ship call that weighs uncertainty against money.
The brief
Nakhla Market (a fictional online retailer) has redesigned its checkout into a single page (variant B). The current multi-step checkout is variant A. New visitors were randomly assigned to A or B for 14 days, and the decision meeting is next week.
Stakeholders and what they want
- The head of product built B and wants to ship it before the peak season.
- The chief financial officer wants to know what B is worth in riyals per month — and what it could cost if it is actually worse.
- The engineering lead is worried that B's heavier page loads more slowly, which could hurt customers in ways a 14-day test does not capture.
- The experimentation council (you are its analyst) insists that the metric, the effect worth detecting and the sample size are fixed before the data are read, and that every check is reported, not only the favourable ones.
Constraints. The test window was capped at 14 days by a code freeze, which gave about 16,000 users in total. For this scenario, assume the business plans with 35,000 new visitors reaching checkout per month, a gross margin of 25% on order value, and a pre-registered guardrail: B must not make the median checkout page load more than 3% slower.
The data. checkout_ab has one row per user: the day they entered the test, variant, device, location segment, whether they bought (converted, 0/1), order value (revenue_sar, 0 for non-buyers) and the checkout page-load time. The dataset is synthetic: it was generated to behave like a real e-commerce experiment, and its numbers are not evidence about any real website.
Your deliverable is a decision memo for the product review: what you planned, what you checked, what you found, how sure you are, and what Nakhla Market should do next.
Dataset
Checkout redesign A/B test
16,000 rows · one row = one user in the experiment · synthetic data
| User | Test day (day) | Signup date | Variant | Device | Country segment | Converted | Revenue (SAR) | Checkout load time (ms) |
|---|---|---|---|---|---|---|---|---|
| U00001 | 1 | 2024-05-05 | B | mobile | domestic | 0 | 0 | 1781 |
| U00002 | 1 | 2024-05-05 | B | mobile | domestic | 0 | 0 | 1842 |
| U00003 | 1 | 2024-05-05 | B | mobile | domestic | 0 | 0 | 1197 |
| U00004 | 1 | 2024-05-05 | A | desktop | gcc | 0 | 0 | 1035 |
| U00005 | 1 | 2024-05-05 | B | tablet | gcc | 0 | 0 | 1774 |
| U00006 | 1 | 2024-05-05 | A | desktop | domestic | 0 | 0 | 1609 |
Included with a Formula Quest membership
This capstone has 5 stages and 20 graded tasks, ending with a written report.
View Formula Quest memberships