Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

Need to get the results which are not purchased in the last 18 months

Avatar

Level 2

Dear Community leaders,

 

I have recipient schema and purchase history schema which are linked.

 

I need to get the recipients which were not  do any purchases in the last 18 months. 

 

can you please tell me at the filter wizard in the filtering condition.

 

Regards

Satya

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Sathyam_Chandan ,

Hope recipient and purchase history schema is 1-N link.

In your query, have targeting and filtering dimension as recipients,

Filtering condition:

Expression > scroll down and you can see purchase history schema and select it.

purchase_history do not exist such as

creation date on or after MonthsAgo(18)

Filtering Condition will look like below,

ParthaSarathy_1-1701179105943.png

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @Sathyam_Chandan ,

Hope recipient and purchase history schema is 1-N link.

In your query, have targeting and filtering dimension as recipients,

Filtering condition:

Expression > scroll down and you can see purchase history schema and select it.

purchase_history do not exist such as

creation date on or after MonthsAgo(18)

Filtering Condition will look like below,

ParthaSarathy_1-1701179105943.png