Advanced Functions

[taylana40363174]

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

[ramon_bisswanger]

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]

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.

[ramon_bisswanger]

Hi,

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

[taylana40363174]

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]

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