How can we fetch No transations made by customer in last 6months | Community
Skip to main content
S
Shrutii
Level 4
April 10, 2024
Question

How can we fetch No transations made by customer in last 6months

  • April 10, 2024
  • 1 reply
  • 484 views

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Denis_Bozonnet 

 

Hi All,

I m really stuck in on challenging situation

where I need to  fetch customers who had made no transaction  in last 6months and target them

 

reference:

 

customer details are in Customer table

and transaction details are in transaction  table

transaction  table and Customer table  are linked

 

please help

its really imp

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

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
April 10, 2024

Hi @shrutii ,

Select targeting and filtering dimension as customer table, 

Query condition:

transaction table DO NOT EXIST SUCH AS

DateOnly(@transaction_Date) Greater than or equal to MonthsAgo(6)

 

The query condition will look similar to below image,

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

    Loading footer...