> ## Documentation Index
> Fetch the complete documentation index at: https://docs.upstackdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Returning Customer Cancelled Amount: Lost Revenue from Repeat Buyers

> Track cancelled order value from returning customers. Monitor repeat buyer cancellations to identify fulfillment issues and protect customer lifetime value.

<Tip>
  The total dollar value of orders from returning customers that were cancelled before fulfillment.
</Tip>

## Formula

<Info>
  **Returning Customer Cancelled Amount** = **SUM** ( Cancelled Order Value ) **WHERE** [customer\_type = returning\_customer](/data-dictionary/measures-and-dimensions#visitor-dimensions)
</Info>

### Formula Components

| Metric                                                                                                  | Definition                                                 |
| ------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------- |
| [**Cancelled Amount**](/reference/metrics/orders/adjustments/cancelled-amount)                          | Total dollar value of cancelled orders                     |
| [**customer\_type = returning\_customer**](/data-dictionary/measures-and-dimensions#visitor-dimensions) | Filters to orders from customers who have purchased before |

| Metadata        |                             |
| --------------- | --------------------------- |
| **Type**        | Currency                    |
| **Data Source** | [Shopify](/sources/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   |

***

## Related Metrics

| Metric                                                                                           | Relationship                                 |
| ------------------------------------------------------------------------------------------------ | -------------------------------------------- |
| [RC Cancelled Orders](/reference/metrics/orders/adjustments/returning-customer-cancelled-orders) | Count of cancelled returning customer orders |
| [Cancelled Amount](/reference/metrics/orders/adjustments/cancelled-amount)                       | Total cancelled amount across all customers  |
| [NC Cancelled Amount](/reference/metrics/orders/adjustments/new-customer-cancelled-amount)       | Cancelled amount from first-time buyers      |

[See all Adjustments metrics →](/reference/metrics/orders/adjustments)