Identify your at risk customers

Identify your at risk customers

Hop Designer

Shubham Kaushal


Customer, Marketing

This report lists the top 100 previous customers who have not made any purchases in the last 30 days. The top 100 customers are determined based on their purchase value, and the report is organized accordingly.


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.

  1. Customer Reactivation Strategy: E-commerce stores can use this report as a foundation for developing customer reactivation strategies. By identifying the top 100 customers based on their historical purchase value, businesses can prioritize efforts to re-engage these valuable but inactive customers. This may involve targeted email campaigns, personalized promotions, or exclusive offers to encourage them to make a return purchase.

  2. Last Order Date Analysis: Analyzing the last order date for each customer in the report allows businesses to understand the length of time since their previous purchase. This might give insight into possible reasons why some customers are now inactive. This is valuable when compared to other data points; for example, it could be that a particular product line was discontinued around that time period.

In This Report


  • Total Orders

  • Total Sales

  • Average Order Value

Additional parameters

  • Email

  • First Name

  • Last Name

  • Phone Number

  • Last Order Date

Try this report for your own store.

Connect your Shopify store and automate this report. You will never have to manually work with data again.