Number of buyers over 3 days

[cedfoning]

Hello, 

i have an issue, need your help. 

I would like to know the number of customers who bought products 3 days after the date of sending the email. 

If an email was sent on 12/05/2023, I want to know the number of customers who purchased between 12/05/2023 and 15/05/2023.

Thanks

[vikasmahajan]

Hi,

Try like this :

Dimension : Customer 

sum({<Date={"<=$(=Today()-3)"}>} Sales)

[cedfoning]

Hello @vikasmahajan 

Thanks for your reply. 
It's not working. 

i have a column email_send_date with the following data : 

i want to count the number of customers who bought products 3 days after those dates. 

[vikasmahajan]

count({$<Year=, Month=, YearMonth=,Customer={"=min({$<Sales={'>0'}, Year=, Month=, 
YearMonth=, OrderDate={'<=$(=max(OrderDate))'}>} OrderDate)>=$(=max(OrderDate)-3)"}>} 
distinct Customer)

refer this :

http://poverconsulting.com/2014/03/04/set-analysis-nested-advanced-search/

[Jaggu]

Hi ,

Create a Variable Box to pick the Email sent Date according to your format.

Count({< email_send_date={{"<=$(Email_Sentdate)"} ,email_send_date={"<=$(=Today()-3)"} >} distinct Customer)

[Chanty4u]

Try this .

Count({<PurchaseDate={">=12/05/2023 <=15/05/2023"}, EmailSentDate={12/05/2023}>} CustomerID)

[cedfoning]

hello, 

Here is the script, 

Count({<[CAMP_Email Sending Date]={'<=$(=max([CAMP_Email Sending Date]))'}>} [CAMP_Email Sending Date]) >=$(=max([CAMP_Email Sending Date])-3)"}>} distinct [CUST_LOY_Customer ID])

can you help please ? 

[Kushal_Chawda]

@cedfoning  try below. 

=count( {<CustomerID= {"= purchase_date >= email_sent_date and purchase_date<=email_sent_date+3"}>} distinct CustomerID)