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

  • Thread starter Thread starter Vidalia
  • Start date Start date
  • Tags Tags
    Product
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 '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 »

Thread 'Fermat's Last Theorem'

Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
View full post »

Thread 'Useless continued fraction for 1'

I'm interested to know whether the equation $$1 = 2 - \frac{1}{2 - \frac{1}{2 - \cdots}}$$ is true or not. It can be shown easily that if the continued fraction converges, it cannot converge to anything else than 1. It seems that if the continued fraction converges, the convergence is very slow. The apparent slowness of the convergence makes it difficult to estimate the presence of true convergence numerically. At the moment I don't know whether this converges or not.
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