Creating a query

Avatar

Avatar

hannahw84397540

Avatar

hannahw84397540

hannahw84397540

03-07-2019

Hello,

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?

Lapsed.PNG

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
Employee

03-07-2019

Hi Hannah,

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)

Answers (4)

Answers (4)

Avatar

Avatar

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
Employee

03-07-2019

Question here would be on the retention of the tracking logs.

Default ACS retention is 6 months (see  Data retention )

If there was no custom retention agreed on your instance, you would not have any data older than 6 months.
Thus, the query would never match anything then

Avatar

Avatar

hannahw84397540

Avatar

hannahw84397540

hannahw84397540

03-07-2019

Thank you!

Avatar

Avatar

hannahw84397540

Avatar

hannahw84397540

hannahw84397540

03-07-2019

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

1784054_pastedImage_0.png

Avatar

Avatar

hannahw84397540

Avatar

hannahw84397540

hannahw84397540

03-07-2019

Urgh that's rubbish! Thank you.