Skip to main content

How to filter customers by total revenue

Updated over 3 weeks ago

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?