Sales Funnel Drop-off Points
This dataset provides detailed, event-level tracking of user progression and abandonment within an e-commerce sales funnel. It enables identification of high-drop-off stages, analysis of abandonment reasons, and segmentation by device, country, and referrer. Ideal for conversion optimization, funnel analysis, and user experience improvement.
Sample rows
preview · 8 of 120 rows · all 14 columns| funnel_event_idstring | device_typestring | cart_valuefloat | user_idstring | session_idstring | funnel_stagestring | stage_orderinteger | event_typestring | event_timestampdatetime | browserstring | referrerstring | countrystring | abandonment_reasonstring | time_spent_secondsfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| evt_0001 | mobile | 0 | user_101 | sess_a1b2 | Landing Page | 1 | progress | 2023-10-01T09:05:12Z | Chrome | google.com | US | blank | 8.3 |
| evt_0002 | mobile | 29.99 | user_101 | sess_a1b2 | Product View | 2 | progress | 2023-10-01T09:05:22Z | Chrome | google.com | US | blank | 15.7 |
| evt_0003 | mobile | 29.99 | user_101 | sess_a1b2 | Add to Cart | 3 | progress | 2023-10-01T09:05:41Z | Chrome | google.com | US | blank | 10.2 |
| evt_0004 | mobile | 29.99 | user_101 | sess_a1b2 | Begin Checkout | 4 | exit | 2023-10-01T09:05:56Z | Chrome | google.com | US | blank | 6.4 |
| evt_0005 | tablet | 0 | user_102 | sess_c3d4 | Landing Page | 1 | progress | 2023-10-02T16:32:02Z | Safari | instagram.com | BR | blank | 13.1 |
| evt_0006 | tablet | 199.99 | user_102 | sess_c3d4 | Product View | 2 | progress | 2023-10-02T16:32:18Z | Safari | instagram.com | BR | blank | 29.8 |
| evt_0007 | tablet | 199.99 | user_102 | sess_c3d4 | Add to Cart | 3 | progress | 2023-10-02T16:32:49Z | Safari | instagram.com | BR | blank | 18.6 |
| evt_0008 | tablet | 199.99 | user_102 | sess_c3d4 | Begin Checkout | 4 | progress | 2023-10-02T16:33:09Z | Safari | instagram.com | BR | blank | 13.7 |
| evt_0009 | tablet | 199.99 | user_102 | sess_c3d4 | Shipping Information | 5 | progress | 2023-10-02T16:33:32Z | Safari | instagram.com | BR | blank | 22.4 |
| evt_0010 | tablet | 199.99 | user_102 | sess_c3d4 | Payment | 6 | abandonment | 2023-10-02T16:34:05Z | Safari | instagram.com | BR | payment failure | 41.3 |
| evt_0011 | desktop | 0 | blank | sess_ef56 | Landing Page | 1 | progress | 2023-10-03T11:13:45Z | Firefox | reddit.com | DE | blank | 3.2 |
| evt_0012 | desktop | 0 | blank | sess_ef56 | Product View | 2 | exit | 2023-10-03T11:13:53Z | Firefox | reddit.com | DE | blank | 10.6 |
| evt_0013 | mobile | 0 | user_103 | sess_g7h8 | Landing Page | 1 | progress | 2023-10-04T14:22:01Z | Samsung Internet | adnetwork.xyz | KR | blank | 2.9 |
| evt_0014 | mobile | 199.99 | user_103 | sess_g7h8 | Product View | 2 | progress | 2023-10-04T14:22:10Z | Samsung Internet | adnetwork.xyz | KR | blank | 14.4 |
| evt_0015 | mobile | 199.99 | user_103 | sess_g7h8 | Add to Cart | 3 | progress | 2023-10-04T14:22:25Z | Samsung Internet | adnetwork.xyz | KR | blank | 12.5 |
| evt_0016 | mobile | 199.99 | user_103 | sess_g7h8 | Order Confirmation | 4 | progress | 2023-10-04T14:22:38Z | Samsung Internet | adnetwork.xyz | KR | blank | 9.8 |
| evt_0017 | other | 0 | user_104 | sess_ijkl | Landing Page | 1 | progress | 2023-10-05T20:19:04Z | Brave | blank | NG | blank | 0.4 |
| evt_0018 | other | 5999.99 | user_104 | sess_ijkl | Product View | 2 | progress | 2023-10-05T20:19:05Z | Brave | blank | NG | blank | 0.2 |
| evt_0019 | other | 5999.99 | user_104 | sess_ijkl | Add to Cart | 3 | abandonment | 2023-10-05T20:19:06Z | Brave | blank | NG | complex checkout | 0.3 |
| evt_0020 | desktop | 0 | blank | sess_minimal | Landing Page | 1 | exit | 2023-10-06T07:00:00Z | Firefox | blank | blank | blank | 1.1 |
What the 120 rows show
from the 120-row sampleOther (device type) stands out: mean cart_
- 30.0median cart_
value - 3event types
- 3abandonment reasons
- 5browsers
- 5referrers
- 6countries
Median 30.0, from 0.0 to 6,000.
- string 10
- integer 1
- float 2
- datetime 1
Columns
14 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
funnel_event_id | string | Unique identifier for the funnel event recordunique | evt_0001 |
session_id | string | Unique identifier for the user's session | sess_a1b2 |
user_id | string | Unique identifier for the user (if available, else anonymous or null)optional | user_101 |
funnel_stage | string | Name of the sales funnel stage (e.g., 'Product View', 'Add to Cart', 'Checkout', 'Payment', 'Order Confirmation')8 values | Landing Page |
event_type | string | Type of event at this stage (e.g., 'progress', 'exit', 'abandonment')progress · exit · abandonment | progress |
device_type | string | Type of device used (e.g., 'desktop', 'mobile', 'tablet')desktop · mobile · tablet · other · optional | mobile |
browser | string | Browser used during the session (e.g., 'Chrome', 'Safari', 'Firefox')5 browsers · optional | Chrome |
referrer | string | Referring source or URL that led the user to the funnel5 referrers · optional | google.com |
country | string | Country from which the user accessed the site6 countries · optional | US |
abandonment_reason | string | Reason for abandonment if captured (e.g., 'high shipping cost', 'complex checkout', 'payment failure')3 reasons · optional | payment failure |
| Numbers 3 columns | |||
stage_order | integer | Numeric order of the funnel stage (lower numbers indicate earlier stages)1 or more | 1 |
time_spent_seconds | float | Time spent (in seconds) at this funnel stage before progressing or exiting0 or more · optional | 8.3 |
cart_value | float | Total value of items in the cart at the time of the event (if applicable)0 or more · optional | 0 |
| Dates and times 1 column | |||
event_timestamp | datetime | Timestamp of when the event occurred | 2023-10-01T09:05:12Z |
Use it for
An e-commerce dashboard
Cart_
value by device_ type and a breakdown of user_ id. Excel, Power BI or Tableau. Why do the 11 other rows have a mean cart_
value of 3,273? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Funnel events120evt_00010mobileevt_000229.99mobileevt_000329.99mobile
A software demo
Believable funnel events with session_
id, user_ id and funnel_ stage to fill a screen in front of a buyer.
blueprint · sales-funnel-drop-off-points
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Track each user through funnel stages
- Mark drop-off at first non-completion
- Include timestamp for each stage
- Differentiate between new and returning users
- Aggregate daily drop-off rates
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- sales-funnel-drop-off-points