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

# How to find customers by Average Order Value

**Average order value** is the total value of purchases divided by the number of orders.

***

**Use case:** find customers with an average order value between **$1,000 and $5,000** over the last year.

1. Go to **Customer Data Platform → Customers**.

<img src="https://mintcdn.com/maestraio/O0b_zyYQP7Y48mll/images/imported/How-to-find-customers-with-total-revenue-from-N.png?fit=max&auto=format&n=O0b_zyYQP7Y48mll&q=85&s=610eeadf0ac3a85b0a508fbf73bbffb4" alt="" width="5414" height="1624" data-path="images/imported/How-to-find-customers-with-total-revenue-from-N.png" />

2. Set up the filter.
   ​

<img src="https://mintcdn.com/maestraio/05-EV9YqA_RINTJ8/images/imported/Find-customers-with-an-average-order-value-from-N.png?fit=max&auto=format&n=05-EV9YqA_RINTJ8&q=85&s=4661563352856391e45eb1a92e282c3f" alt="" width="6828" height="1892" data-path="images/imported/Find-customers-with-an-average-order-value-from-N.png" />

## How average order value is calculated

* Average order value is calculated based on **placed, paid, and delivered items**.
* Even if an order was fully canceled, it still counts toward the total number of orders.

**Example:**

A customer has three orders:

* Order 1: one table \$1,500 — placed
* Order 2:
  * line 1: two chairs \$500 each — paid
  * line 2: one stool \$300 — canceled
* Order 3: one pouf \$1,000 — returned

**Total:** $1,500 + $500×2 = $2,500
​**Number of orders:** 3
​**Average order value:** $833