How can I create a Contact saved search that returns Contacts associated with Sales Orders that had a status of Billed within a specific date range (e.g., August 2026)?
My current filters are:
- Transaction: Type is Sales Order
- Transaction: Date is within 8/1/2026 and 8/31/2026
- Transaction: Status is Sales Order:Billed
- Transaction: Main Line is true
- Email is not empty
- Global Subscription Status is any of Soft Opt-In, Confirmed Opt-In
But it is returning more Contacts than expected. It seems to be matching Contacts who have any transaction within this date range, not specifically ones whose Sales Order status changed to Billed within that window. Is there a correct filter I should be using instead to capture only the status-change date, when building this from a Contact-type search?