Hop Designer
Mayank Verma
Category
Marketing, Revenue
This report analyzes the monthly revenue generated by returning customers from the month they were acquired until the present month. It also includes sales performance metrics, such as total sales, number of customers, and average order value (AOV) for the past 12 months.
From column F, the details of each cohortβs spending details are shown. The same-month combination is the total revenue from customers who made a repeat purchase in that month. Subsequent month columns are the revenue generated from customers who made a purchase in the Column A month.
For example, F2 is the total sales from customers who made a purchase in July 2023 and also made a repeat purchase in July 2023. G2 is the total sales from customers who made a purchase in July 2023 and also purchased in August 2023. Similarly, H2 is the revenue from customers who made a purchase in July 2023 that also purchased in September 2023.
Integration(s)
![](https://framerusercontent.com/images/evrBPICfA9fXFWSUVa6HLFdwv0Q.png)
How to use this Hop.
Simply create an Airboxr account and connect your Shopify store to automatically run this export/analysis for your store. If you already have an account, click on the Add to my Collection button above.
Improve Customer Retention: By analyzing the spending patterns of returning customers, stores can identify which months have the highest repeat purchase value and compare with other cohorts. This helps in determining the value of returning customers and also determining potential reasons such as marketing campaigns or sales offers. This can then be used in planning targeted marketing campaigns or loyalty programs to improve repeat purchase value.
In This Report
Metrics
Total Sales
Customers
Orders
AOV
Grouped By
Month
Connect your Shopify store and automate this report. You will never have to manually work with data again.