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

Advanced Functions

taylana40363174
Level 1
Level 1

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

2 Replies
ramon_bisswanger
Employee
Employee

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

taylana40363174
Level 1
Level 1

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

ramon_bisswanger
Employee
Employee

Hi,

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

taylana40363174
Level 1
Level 1

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.

ramon_bisswanger
Employee
Employee

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))