The total dollar value of orders cancelled before fulfillment.
Cancelled Amount = SUM ( Order Value ) WHERE status = cancelled
| Metric | Definition |
|---|
| Order Value | The total value of each order |
| status = cancelled | Filters to orders marked as cancelled before fulfillment |
| Metadata | |
|---|
| Type | Currency |
| Data Source | Shopify |
| Aggregation | Sum |
Example
Your store had $12,750 in cancelled orders during Q1:
| Month | Cancelled Amount | Orders Cancelled |
|---|
| January | $3,200 | 18 |
| February | $4,850 | 27 |
| March | $4,700 | 24 |
How It Works
Cancelled Amount sums the total value of all orders cancelled in Shopify before fulfillment. Unlike refunds, cancellations represent potential revenue that never converted. Spikes may indicate payment failures, inventory stockouts, or checkout friction.
When to Use
| Scenario | Action |
|---|
| Track lost revenue | Monitor potential sales that didn’t complete |
| Identify payment issues | Compare against declined transactions |
| Spot inventory problems | Correlate with stockout events |
| Segment by customer type | Compare new vs returning customer cancellations |
| Metric | Relationship |
|---|
| Cancelled Orders | Count of cancelled orders (not dollar value) |
| Refund Amount | Value refunded after fulfillment |
| Net Revenue | Revenue after all adjustments |
| Orders | All orders including cancelled |
