Returning Customer Cancelled Amount: Lost Revenue from Repeat Buyers

The total dollar value of orders from returning customers that were cancelled before fulfillment.

Formula

Returning Customer Cancelled Amount = SUM ( Cancelled Order Value ) WHERE customer_type = returning_customer

Formula Components

Metric	Definition
Cancelled Amount	Total dollar value of cancelled orders
customer_type = returning_customer	Filters to orders from customers who have purchased before

Metadata
Type	Currency
Data Source	Shopify
Aggregation	Sum

Example

Your store had $4,250 in returning customer cancellations during March:

Week	RC Cancelled Amount	RC Cancelled Orders	Avg Order Value
Week 1	$890	4	$222.50
Week 2	$1,340	6	$223.33
Week 3	$1,120	5	$224.00
Week 4	$900	4	$225.00

How It Works

This metric sums the total value of cancelled orders specifically from returning customers—buyers who have completed at least one previous purchase. When a returning customer’s order is cancelled before fulfillment in Shopify, the order value is added to this total.

When to Use

Scenario	Action
Rising cancellation value	Investigate inventory issues or shipping delays affecting loyal customers
Compare to new customer cancellations	Determine if repeat buyers have different cancellation patterns
High-value order cancellations	Prioritize outreach to retain valuable repeat customers
Seasonal analysis	Identify if promotions drive cancellation spikes among returning buyers

Metric	Relationship
RC Cancelled Orders	Count of cancelled returning customer orders
Cancelled Amount	Total cancelled amount across all customers
NC Cancelled Amount	Cancelled amount from first-time buyers

See all Adjustments metrics →

RC Cancelled Orders Cost of Goods Sold

⌘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