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

Query didn't open x number of days ago

Avatar

Avatar
Level 1
nataliec3894220
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
nataliec3894220
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
nataliec3894220
Level 1

30-06-2020

I'm looking to make a query where I target profiles who haven't opened ANY emails from x number of days ago.

This is to be set up as a workflow with a recurring email to entice user's to engage with our emails.

I understand that I need to query profiles that have no tracking associated to them but where I'm getting caught up is querying to 60 days ago. 

When using the simple mode for the query, it simply says "corresponds to the last 60 days", which to me means from now until 60 days ago. But I don't want to target profiles from yesterday, ONLY 60 days ago.

 

The advanced code reads as follows, though I don't fully understand it:

@logDate >= DaysAgo(60) AND @logDate < GetDate()

 

Screen Shot 2020-06-30 at 5.30.33 PM.png

 

Thanks!

Campaign Standard

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

30-06-2020

The GetDate() returns current data + time.

So if run today at 4 p.m., it will consider anyone who did not open between NOW and NOW-60 days (i.e. 4 p.m. on the day which is 60 days ago).

So that shall satisfy your requirement

Answers (0)