The "Customer Frequency" Report: How to Identify VIPs and Win Back Lapsed Clients

Not All Customers Are Equal

You have customers who buy from you weekly, some monthly, and some who used to buy but have gone silent. If you treat them all the same, you're missing huge opportunities. A Customer Frequency Report in your dashboard categorises customers by how often they buy, revealing your VIPs and your lapsed clients.

How to Use the Frequency Report

1. Identify Your VIPs (High Frequency, High Value)

These are the customers who buy often and spend a lot. They deserve special treatment: a loyalty discount, a personal phone call, a birthday gift. The dashboard can flag them for you. "VIP: Jane M. – 12 purchases in the last 3 months, total KSh 85,000."

2. Spot the "Slipping" (Decreasing Frequency)

A customer who used to buy monthly but hasn't bought in 45 days is slipping away. The dashboard flags this. Reach out with a personalised offer: "Hi [Name], we miss you! Here's 10% off your next order to welcome you back."

3. Win Back the Lapsed (No Purchase in 90+ Days)

These customers may have found a competitor or simply forgotten you. A specific win-back campaign can recover a significant portion. The dashboard provides the list; you provide the message.

The Automated Win-Back Play

Set up automated rules in your dashboard:

• 45 days no purchase: Send a "We miss you" SMS with a 5% discount.
• 90 days no purchase: Send a more aggressive offer: "20% off your next order if you return within 7 days."
• 180 days no purchase: Flag for a personal phone call or remove from the active list.

The beauty of this is that it runs in the background. You don't have to manually track who's lapsing. The dashboard does it for you, and you just act on the alerts.

Your Most Valuable Asset

Your customer list is your most valuable asset. Use the frequency report to nurture your VIPs and reclaim the lost ones. The ROI on retaining an existing customer is far higher than acquiring a new one.

Stop treating all customers the same. Segment, target, and win.

Generate My Customer Frequency Report →