Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Creating a query

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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)

View solution in original post

5 Replies

Avatar

Employee Advisor

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

Level 2

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

Correct answer by
Employee Advisor

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)