Hi! The general thought process is correct in my understanding, but I think the containers may be introducing some issues. For example, since the top container (Jan 1, 2025 - Jul 30, 2026 AND Cart Add Exists) is at the person level, it will include all people who both have any hits in the time period and have any orders, but these orders may be placed outside of the date range in the segment. The other containers will have similar issues as well.
To alleviate this issue, I would recommend making the overall segment at the Visitor level, but making the other containers within the segment at the hit level. This will lead to a visitor who
- Has at least one hit between Jan 1, 2025 - Jul 30, 2026 with a Cart Add
- Excludes those with a hit between Jan 1, 2025 - Jul 30, 2026 which is an Order
- Has at least one hit between Jul 31, 2026 - Aug 31, 2026 which is an Order
To double check this logic, if you were to build a table with Orders as the metric using a data range of hit between Jan 1, 2025 - Jul 30, 2026 there should be no Orders in that table since all orders should be excluded.
Let me know if anything is unclear or if this segment does not satisfy the desired results!
