Dataset research report
Ecommerce Funnel research report
A reproducible data report with schema notes, generated chart evidence, suggested follow-up questions, and export-ready Helix queries.
Executive Summary
Ecommerce conversion funnel by cohort, channel, and device for testing funnels, Sankey-style flows, cohort trends, grouped bars, and revenue analysis.
Research Context
Ecommerce Funnel: 120 rows by 11 columns. These exploratory charts are generated automatically from the data - open the dataset in Helix to ask your own questions.
Data Profile
Chart Evidence
These views are generated from the dataset profile. Each chart is paired with a Helix query so it can be opened, adjusted, and exported.
visitors over time
Trend of visitors, signups, trials_started across cohort_month.
Open and export this chartTotal revenue_usd by channel
Top channel values ranked by summed revenue_usd.
Open and export this chartCorrelation of numeric columns
Pearson correlation between numeric columns.
Open and export this chartrevenue_usd by channel
Spread of revenue_usd across channel groups.
Open and export this chartFollow-Up Queries
- funnel chart of visitors signups trials_started and purchases
- sankey chart from channel to device to purchases weighted by revenue_usd
- line chart of purchases over cohort_month by channel
- bar chart of revenue_usd by channel and device
- scatter signup_rate_pct vs trial_to_purchase_pct coloured by channel
- boxplot avg_order_value_usd by device
Preview Rows
| # | cohort_monthtext | channeltext | devicetext | visitorsinteger | signupsinteger | trials_startedinteger | purchasesinteger | revenue_usdinteger |
|---|---|---|---|---|---|---|---|---|
| 1 | 2025-01 | Paid Search | desktop | 18500 | 1110 | 510 | 171 | 13851 |
| 2 | 2025-01 | Paid Search | mobile | 19400 | 1008 | 463 | 141 | 9729 |
| 3 | 2025-01 | Organic Search | desktop | 21200 | 1399 | 608 | 193 | 17177 |
| 4 | 2025-01 | Organic Search | mobile | 22100 | 1281 | 557 | 160 | 12320 |
| 5 | 2025-01 | desktop | 23900 | 1720 | 765 | 229 | 22213 | |
| 6 | 2025-01 | mobile | 24800 | 1587 | 706 | 190 | 16150 |
Data Dictionary
- cohort_month date Monthly acquisition cohort
- channel categorical Acquisition channel
- device categorical Visitor device class
- visitors int Top-of-funnel visitors
- signups int Visitors who created an account
- trials_started int Signups who started a trial
- purchases int Trials converted to purchases
- revenue_usd float Revenue generated in USD
- signup_rate_pct float Visitor-to-signup conversion rate
- trial_to_purchase_pct float Trial-to-purchase conversion rate
- avg_order_value_usd float Average order value in USD
Method And Limits
- Load the catalog entry and preview rows from the processed dataset file.
- Infer numeric, categorical, time, and location fields from real columns.
- Generate a small set of defensive Plotly chart specifications from that profile.
- Expose each chart idea as a query link so the report can be rerun or exported in Helix.
This report is intentionally reproducible. It uses the local catalog metadata and generated chart specifications rather than claiming external conclusions beyond the dataset.