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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Creating a query

hannahw84397540
Level 2
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
ramon_bisswanger
Correct answer by
Employee
Employee

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
ramon_bisswanger
Employee
Employee

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
hannahw84397540
Level 2
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

ramon_bisswanger
Correct answer by
Employee
Employee

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