Cancelled Amount: Revenue Lost to Order Cancellations

The total dollar value of orders cancelled before fulfillment.

Formula

Cancelled Amount = SUM ( Order Value ) WHERE status = cancelled

Formula Components

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

See all Adjustment metrics →

Cancelled Orders NC Cancelled Orders

⌘I

​Formula

​Formula Components

​Example

​How It Works

​When to Use

​Related Metrics

Formula

Formula Components

Example

How It Works

When to Use

Related Metrics