Monthly repurchase rate analysis

1.1 Expected effect

Repurchase rate within the month =The number of people who purchased twice or more in a month/The total number of purchases in the month.

For example, if 100 users purchase a product within a month and 20 of them purchase more than twice, then the monthly repurchase rate is 20%.

In the same way, the statistical cycle can be changed to calculate the quarterly repurchase rate and annual repurchase rate.

1.2 Problems solved

The repurchase rate can help us observe user loyalty.

Increasing the repurchase rate can increase the frequency of user purchases. In addition to the continuous input of attracting new customers, the continued growth of business is particularly important for repurchase of existing users.

This example calculates the repurchase rate of a supermarket.

Sample data: 

382.Supermarket sales data.xlsx

2.1 Data preparation

2.1.1 Select the required field

1) Upload sample data to FineBI.

2) Use the sample data to make a self-service dataset, check the fields, as shown in the following figure:

2.1.2 Calculate the number of purchases per user in a month

Drag the fields into the group bar and summary bar respectively as shown in the figure below. Change the group of "Order date" to "Year Month" and rename "Order ID" to "Monthly purchases".

2.1.3 Count the number of purchasers within a month

1) Add a new column and mark all rows with 1, as shown in the figure below:

2) Calculate all values within the group again, and add a column "Number of buyers in the month" to get the total number of purchases in each month. As shown below:

2.1.4 Count the number of people who purchase multiple times in each month

1) Mark 1 for those who buy more than once in the month, as shown in the figure below:

2) Then count how many people buy many times in a month. Add a column "Number of repeat purchases in a month", which is calculated using all values within the group, as shown in the following figure:

2.1.5 Calculate the monthly repurchase rate

Add new column "Repurchase rate". Repurchase rate=Number of repeat purchases in the month/Monthly number of buyers. As shown below:

2.2 Make components

1) Drag the "Order date" and "Repurchase rate" into the analysis area.

For "Order date", click "Dropdown>Year Month" to change the grouping to monthly grouping.

For "Repurchase rate", click "Dropdown>Summary method>Average", and change the numeric format to percentage.

In this way, the monthly repurchase rate can be obtained.

Users can also use a line chart to show the trend of the repurchase rate, as shown in the figure below:

2.3 Effect display

See section 1.1 of this article for details.

3. Conclusion analysis

The overall repurchase rate is on the rise, indicating that the supermarket user stickiness is increasing, and marketing methods have achieved certain success during this period.

According to the time trend graph of the number of purchased users and the repurchase rate, the health of user stickiness can be seen by superimposing the repurchase rate with the total number of users. The best state is that the repurchase rate does not change with the number of users. Maintaining an upward trend. Because with the development of the company, the users who create long-term value for the company must be these old users.