I am looking to create a query than investigates 'customers who have opened an email ever but have not opened in the last 9 months'
The below isn't working, does someone have a different logic to achieve the above please?
you may just switch to Advanced Mode and define a range criteria there.
e.g. following to filter on "Creation Date":
@created >= MonthsAgo(6) AND @created < MonthsAgo(3)
Question here would be on the retention of the tracking logs.
Default ACS retention is 6 months (see Data retention )
Is there a way to create a range that is also relative?
For example the customer opened between 3 & 6 months ago rather than having to set between May & July
Urgh that's rubbish! Thank you.