Need to get the results which are not purchased in the last 18 months | Community
Skip to main content
Sathyam_Chandan
Sathyam_Chandan
Level 2
November 28, 2023
Solved

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

  • November 28, 2023
  • 1 reply
  • 734 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

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,

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
November 28, 2023

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 S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Sathyam_Chandan
    Sathyam_ChandanAuthor
    Level 2
    November 28, 2023

    Thank you @parthasarathy 

     

    it is showing correct results.

     

     

    Regards

    Satya

     

     

      Terms & ConditionsAccessibility statement

      Loading footer...