I'm trying to create a segment for the visitors/customers who have visited only low valued products on my website. I have used below conditions to segment the visitor and it is not working as expected in few scenarios. Any help will be much appreciated.
(Include audience who do not have at least 1 Any event where (Value is greater than 0 AND (Price total is greater than 50)) then within 1 week)and occurs during the year of 2020
Scenarios it is working: First time visit to site > Opened a product of value less than $50 - Working as expected to tag that visitor to the segment
In the next visit > Opened a product of value greater than $50 - Working as expected in removing visitor from the segment
In the next visit > Opened a product of values less than $50 - Again tagging the visitor to segment which is not expected.
Please help me in refining the query. Any help will be much appreciated.