The total dollar value of orders from returning customers that were cancelled before fulfillment.
| 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 |
