Calculating Activation Rate of Customers within 3 Months Post-Purchase

  • Context: MHB 
  • Thread starter Thread starter Vidalia
  • Start date Start date
  • Tags Tags
    Product
Click For Summary
SUMMARY

The discussion focuses on calculating the activation rate of customers within three months post-purchase using two Excel sheets. The first sheet contains customer accounts and activation dates, while the second includes purchase dates and sales volume by country. The objective is to determine the percentage of customers who activated their product within three months of their purchase, segmented by country. Participants suggest a general approach that can be translated into spreadsheet formulas for this calculation.

PREREQUISITES
  • Excel data manipulation skills
  • Understanding of date functions in Excel
  • Basic knowledge of percentage calculations
  • Familiarity with data filtering techniques
NEXT STEPS
  • Learn Excel's VLOOKUP function for data matching
  • Explore Excel's DATE and DATEDIF functions for date calculations
  • Research how to create pivot tables for data analysis by country
  • Study conditional formatting in Excel to visualize activation rates
USEFUL FOR

This discussion is beneficial for data analysts, marketing professionals, and anyone involved in customer retention analysis who needs to evaluate product activation rates effectively.

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!
 
Physics 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!
 

Similar threads

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