> ## 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.

# Order Cancelled Value: Track Revenue Lost to Cancellations

> Track the total monetary value of cancelled Shopify orders. Identify revenue leakage, measure cancellation impact, and optimize retention.

<Tip>
  The total monetary value of all cancelled orders in the selected period.
</Tip>

## Formula

<Info>
  **Order Cancelled Value** = **SUM** ( Cancelled Order Values )
</Info>

### Formula Components

| Metric                     | Definition                                                         |
| -------------------------- | ------------------------------------------------------------------ |
| **SUM**                    | Aggregation function that totals all cancelled order values        |
| **Cancelled Order Values** | Monetary value of each order that was cancelled before fulfillment |

| Metadata        |                                                              |
| --------------- | ------------------------------------------------------------ |
| **Type**        | Currency                                                     |
| **Data Source** | [Upstack Pixel](/pixel), [Shopify](/sources/catalog/shopify) |
| **Aggregation** | Sum                                                          |

***

## Example

Your Shopify store had **\$12,450** in cancelled orders this month:

| Cancellation Reason | Value   | Share |
| ------------------- | ------- | ----- |
| Customer Request    | \$7,470 | 60%   |
| Payment Failed      | \$2,490 | 20%   |
| Inventory Issue     | \$1,867 | 15%   |
| Fraud Suspected     | \$623   | 5%    |

***

## How It Works

Order Cancelled Value sums the monetary value of each cancelled order from your Shopify store. When an order status changes to cancelled, its value is captured and attributed to the original conversion touchpoint. This helps you understand how much potential revenue was lost to cancellations.

***

## When to Use

| Scenario                          | Action                                                            |
| --------------------------------- | ----------------------------------------------------------------- |
| Measuring revenue leakage         | Track total value lost to cancellations over time                 |
| Identifying cancellation patterns | Compare cancelled value across products or channels               |
| Calculating net revenue           | Subtract from Conversion Value to find actual realized revenue    |
| Improving retention               | Investigate high-value cancellations for prevention opportunities |

***

## Related Metrics

| Metric                                                                     | Relationship                                                   |
| -------------------------------------------------------------------------- | -------------------------------------------------------------- |
| [Conversion Value](/reference/metrics/funnel/conversions/conversion-value) | Total revenue before cancellations (this metric measures loss) |
| [Conversions](/reference/metrics/funnel/conversions/conversions)           | Count of conversion events (compare with cancellation rate)    |
| [Purchases](/reference/metrics/funnel/conversions/purchases)               | Completed purchase events (excludes cancelled orders)          |

[See all Attributed Conversions metrics →](/reference/metrics/funnel/conversions)