Number of customers who have activated a product within 3 months of their purchase

Feb 2018
3
0
france
0
down vote
favorite


1) I have a list of customers who have bought a product and consumed it on a certain date.

I receive every month an excel sheet with the following columns:

Customer_Account / Activation_Date / Country /

2) I have another excel sheet with the volume of sales of that product by Country.

I also receive every month this second excel sheet with the following columns :

Customer_Account / Purchase_Date / Country / Store_Purchase /

3) So every month, upon reception of these two files, I need to calculate the percentage of customers who have activate their product following the 3 months after their purchase ?

I thank you very much for your great help!
 

skipjack

Forum Staff
Dec 2006
21,197
2,337
Did you mean "within three months of the date of purchase"?

Do you want a separate result for each country?
 
  • Like
Reactions: 1 person
Feb 2018
3
0
france
Did you mean "within three months of the date of purchase"? Yes exactly

Do you want a separate result for each country? Yes please


Thank you very much.
 
Last edited by a moderator:
Feb 2018
3
0
france
Hey there,

No clue ?

Thanks in advance