Skip to main content
The number of orders from returning customers that were cancelled before fulfillment.

Formula

Returning Customer Cancelled Orders = COUNT ( Cancelled Orders ) WHERE customer_type = returning_customer

Formula Components

MetricDefinition
Cancelled OrdersTotal count of cancelled orders
customer_type = returning_customerFilters to orders from customers who have purchased before
Metadata
TypeNumber
Data SourceShopify
AggregationCount

Example

Your store had 22 Returning Customer Cancelled Orders this month out of 2,340 returning customer orders:
WeekRC CancellationsRC OrdersCancel %
Week 145800.7%
Week 286101.3% (inventory issue)
Week 365901.0%
Week 445600.7%
Total222,3400.9%

How It Works

This metric counts orders placed by returning customers that were cancelled before fulfillment in Shopify. A customer is classified as “returning” if they have completed at least one previous purchase. Cancellations typically occur due to inventory stockouts, payment issues, or customer requests.

When to Use

ScenarioAction
Protecting customer retentionMonitor cancellation trends among your most valuable buyers
Investigating inventory issuesSpikes may indicate stockouts affecting repeat purchasers
Measuring lost opportunityPair with RC Cancelled Amount for dollar impact
Comparing customer typesBenchmark against new customer cancellation rates

MetricRelationship
RC Cancelled AmountDollar value of these cancellations
Cancelled OrdersTotal cancellations (all customers)
NC Cancelled OrdersSame metric for first-time buyers
Returning CustomersTotal returning customers (denominator for rate)
See all Adjustments metrics →