Skip to main content

How to filter customers by total revenue

Updated today

The nested conditions in the revenue filter work the same way as in order filters.

The key difference is that the top-level condition here is total revenue value, not order.

Next, set the range from … to (upper bound is not inclusive) and define which orders should be used to calculate revenue.

Revenue is calculated based on the order total after discount excluding refunds.

Use case: let's find customers whose total revenue is $3,000* or more over the last month.

*The currency depends on your project settings.

  1. Go to Customer Data Platform→ Customers.

  2. Set up the filter.

Revenue is calculated using placed, paid, and delivered items. Canceled and returned items are not included in the total.

Did this answer your question?