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

Advanced Functions

Avatar

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
taylana40363174
Level 1

12-06-2019

Hi,

I am trying to target customers that purchased a product x days ago using advanced expression function but it is not working. This was fairly simple on Neolane but can't get it to work on ACS.

Thank you!

Taylan

expression.JPG

Replies

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

12-06-2019

What type of link do you have?

You can also try adding the condition via Drag & Drop.

Just go to the Explorer tab in the Query Dialog.

This will automatically create an EXISTS join on the purchases and then you can define the filter on that Join

Avatar

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
taylana40363174
Level 1

13-06-2019

Thanks for the reply!

I tried that too but none of the filters allows me to choose x days/months ago. It is either before or after.order.JPG

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

13-06-2019

Hi,

You have to change the filter type to "relative" then you should be able to choose last X days as an option.

Avatar

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
taylana40363174
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
taylana40363174
Level 1

13-06-2019

That isn't actually what I'm looking for. For example, last 7 days would bring an open window that looks back to everyone who did an activity in the last 7 days.

I want to build a drip campaign series that target people exactly 30 days after they made a purchase. Hope that clarifies.

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

13-06-2019

If you drag the exists and choose the date, you can always switch to Advanced mode.

For your example, you could use following query in advanced mode:

    @transactionDate = DateOnly(DaysAgo(5))