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!
 

Thread 'Non-orthogonal bases'

Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
View full post »

Thread 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Similar threads

MHB Population formula part 1: Birth
Replies
2
Views
2K
MHB with Simple Interest Problems
Replies
2
Views
7K
Have You Shopped with Your Credit Card in Foreign Country?
Replies
19
Views
2K
Analyzing Customer Product Purchases Using Venn Diagrams and Basic Probability
Replies
4
Views
3K
Buy and Hold Beats Active Investing
Replies
46
Views
5K
MHB Find Constant % of Annual Salary to Reach Retirement Goal
Replies
9
Views
3K
MHB Statistics and customer ratings
Replies
1
Views
1K
How Can We Estimate Sampling Probability from Sales Data?
Replies
1
Views
2K
I Optimization problem with multiple outputs: impossible?
Replies
6
Views
2K
Challenge Math Challenge - December 2018
2
Replies
67
Views
14K

Hot Threads

Recent Insights

Back
Top