MHB Calculating Activation Rate of Customers within 3 Months Post-Purchase

  • Thread starter Thread starter Vidalia
  • Start date Start date
  • Tags Tags
    Product
AI Thread Summary
To calculate the activation rate of customers within three months post-purchase, first, merge the two Excel sheets based on the Customer_Account. Next, filter the data to identify customers whose Activation_Date falls within three months of their Purchase_Date. Then, calculate the percentage of these activated customers relative to the total number of customers who made a purchase in each country. This method provides a clear view of activation rates by country. Implementing this process in spreadsheet software will yield the desired results efficiently.
Vidalia
Messages
2
Reaction score
0
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 (rate) of customers by Country who have activate their product following within the 3 months after their purchase ?

I thank you very much for your great help!
 
Mathematics news on Phys.org
Hi Vidalia and welcome to MHB. :D

Any thoughts on how to begin? Are you looking for spreadsheet code or just a general answer?
 
greg1313 said:
Hi Vidalia and welcome to MHB. :D

Any thoughts on how to begin? Are you looking for spreadsheet code or just a general answer?

Hi Greg,

Thank you for your answer. I think If I can have a general answer that can be applied to spreadsheet code, that will be great! But would take any answer.

Thank you very much!
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.

Similar threads

Replies
2
Views
2K
Replies
2
Views
7K
Replies
46
Views
5K
Replies
1
Views
1K
2
Replies
67
Views
14K
Back
Top