Expand my Community achievements bar.

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

Avatar

Level 4

@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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

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_0-1712732826801.png