The acquisition funnel, all channels
Each stage is summed across the cohorts, so the width of the funnel shows where potential customers leave the journey.
How it decided
E-commerce funnel: 120 rows, 11 columns. the four ordered stage columns; channel and device are intentionally pooled.
120 rows in, 4 out across 2 columns. Each stage is summed across the cohorts, so the width of the funnel shows where potential customers leave the journey.
funnel. The question names an ordered journey, so a funnel preserves stage order instead of ranking the stages by size.
Palette, spacing, axis titles and legend placement applied. 0 issues found.
The transformation
This is the code, not a description of it — the chart above was drawn from what it returns, and the notebook download runs the same lines against the same file.
result = pd.DataFrame({"stage": ["Visitors", "Signups", "Trials", "Purchases"], "count": [df["visitors"].sum(), df["signups"].sum(), df["trials_started"].sum(), df["purchases"].sum()]})What it charted
4 rows out of 120, 2 columns. First 4 shown.
| stage | count |
|---|---|
| Visitors | 3238800 |
| Signups | 242354 |
| Trials | 98814 |
| Purchases | 27743 |