Filtering customers who have made at least 2 purchases within the Summer period over the past two years. | Community
Skip to main content
V
vani97
Level 4
April 8, 2024
Solved

Filtering customers who have made at least 2 purchases within the Summer period over the past two years.

  • April 8, 2024
  • 3 replies
  • 774 views

Hi There is a requirement like I need to figure out the recipients who have made at least 2 purchases within the summer periods over the past 2 years .
also have a doubt do we have to keep season schema here ?

Kindly help me with necessary columns and filtering condition 

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 @vani97 ,

Solution for this is provided in another thread and modify its filtering condition to fetch from March 1 to May 31st.

Or with the same configuration, use 2 queries, Query1 to fetch 2022 records, and Query2 to fetch 2023 records. And after both the split activity (as mentioned in previous thread), use Union activity to combine the results of recipient who had made atleast 2 purchase on 2022 and atleast 2 purchase on 2023.

3 replies

isahore
Community Advisor
isahoreCommunity Advisor
Community Advisor
April 8, 2024

Hi @vani97,


The community would be able to give you guidance if you can share some details about the data model that you have (related tables only). The solution can be varied depending on that, and there can be multiple ways of doing it as well.

 

BR,

Ishan

V
vani97Author
Level 4
April 8, 2024

Hi @isahore 
I have purchase history table which is linked to recipient table 

Purchase history table having purchase date which is linked to the recipient table  by the custId 

And we have the summer period for the

1.2022 (march 1 to may 31)

2.2023(march 1 to may 31)

 





Thanks in advance!

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
April 9, 2024

Hi @vani97 ,

Solution for this is provided in another thread and modify its filtering condition to fetch from March 1 to May 31st.

Or with the same configuration, use 2 queries, Query1 to fetch 2022 records, and Query2 to fetch 2023 records. And after both the split activity (as mentioned in previous thread), use Union activity to combine the results of recipient who had made atleast 2 purchase on 2022 and atleast 2 purchase on 2023.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...