E-commerce / product analytics
Orion Shop Experiments
Two months of web sessions for a fictional online shop running an A/B test of a new one-page checkout (variant B). Supports funnel analysis, conversion rates, A/B testing and confidence intervals.
Log in to query this database in your browser.
Data dictionary
sessions · 31,553 rows
One row per website session, with funnel flags.
| Column | Type | Description |
|---|---|---|
| session_id | INTEGER | |
| user_id | INTEGER | |
| session_date | TEXT (ISO date) | |
| device | TEXT | |
| traffic_source | TEXT | |
| checkout_variant | TEXT | A = existing checkout, B = new one-page checkout |
| viewed_product | INTEGER | |
| added_to_cart | INTEGER | |
| started_checkout | INTEGER | |
| purchased | INTEGER | 1 if the session ended in a purchase |
| revenue | REAL | Order value (USD) if purchased |
| duration_sec | INTEGER |
ab_assignments · 14,830 rows
Experiment assignment per user (first-seen date).
| Column | Type | Description |
|---|---|---|
| user_id | INTEGER | |
| variant | TEXT | A (control) or B (treatment) |
| assigned_date | TEXT (ISO date) |