Skip to main content
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.