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

c
ceofounder
2 min read 121 views
The "Customer Frequency" Report: How to Identify VIPs and Win Back Lapsed Clients
Customer Frequency

Not All Customers Are Equal

You have customers who buy weekly, some monthly, and some who used to buy but have gone silent. If you treat them all the same, you are missing huge opportunities.

A Customer Frequency Report in your dashboard categorises customers by how often they buy, revealing your VIPs and your lapsed clients. Then you can stop guessing who deserves attention and start deciding it.

Two ways to treat the same list

Same customer list. Same products. The only difference is whether the business uses what it already knows.

Everyone equal

One message for all

  • VIPs get the same generic offer as strangers
  • Lapsing customers fade without anyone noticing
  • Lapsed customers are never contacted again
  • Discounts are given to buyers who would have paid full price
  • Retention depends on luck
Segmented

A different move for each

  • VIPs are recognised and rewarded
  • Lapsing customers are caught in time
  • Lapsed customers get a specific win back
  • Discounts go where they actually change behaviour
  • Retention becomes a process
Treating every customer identically feels fair. In practice it means the best customers subsidise the attention given to everyone else, and the ones quietly leaving are never noticed at all.

How to use the frequency report

VIP

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."
Slipping

Spot the slipping: decreasing frequency

A customer who used to buy monthly but has not bought in 45 days is slipping away. The dashboard flags this, so you can reach out with a personalised offer before the habit breaks.

"Hi Jane, we miss you. Here is 10 percent off your next order to welcome you back."
Lapsed

Win back the lapsed: no purchase in 90 or more days

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

A targeted offer to one segment outperforms a general broadcast to everyone.
The VIP list is not just a reward list. It is also your early warning system. A VIP who drops out of the top band tells you something broke before anything else does.

Reading the frequency bands

Segmentation

Four bands, four different actions

Band Last purchase Status Action
Active Within 30 days VIP Recognise and reward
Cooling 31 to 45 days Slipping Soft check in
At risk 46 to 90 days Slipping Personal offer
Lapsed 91 to 180 days Lapsed Win back campaign
Inactive Over 180 days Inactive Call or remove

The bands are a starting point. Adjust the day counts to match your actual buying cycle, since a weekly buyer and a quarterly buyer should not share the same threshold.

The automated win back play

Rules that run themselves

Set the rules once, act on the alerts

Day 45 Send a gentle check in An SMS with a small discount, framed as a friendly reminder rather than a hard sell.
Day 90 Send a stronger offer A more aggressive win back, with a short deadline attached to encourage action.
Day 180 Call or retire the record Flag for a personal conversation, or move out of the active list so the numbers stay honest.

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

Automated messages work best when they feel specific. "We miss you" lands well. "Dear valued customer" lands in the bin.

Why the list is your most valuable asset

Retaining

Existing customer

They already know you, have bought before, and trust the product. The only obstacle is a reason to come back.

Acquiring

New customer

You must earn awareness, trust and the first order from scratch. Every step costs money before a single sale arrives.

The return on retaining an existing customer is far higher than acquiring a new one. The frequency report is how you find the retention opportunities you already own.

A practical start this week

Before launching any campaign

Five steps to get the list right first

  1. Confirm that every customer record links to a phone number or account
  2. Decide the day thresholds that match your actual buying cycle
  3. Pull a list of customers with no purchase in the last 45 days
  4. Count how many VIPs are currently slipping, since those are urgent
  5. Write one message per band before automating anything
Do not start with an aggressive win back blast. Start with the slipping VIPs, where one personal message often recovers the relationship immediately.

What this actually changes

  • You know exactly who your top spenders are, by name
  • You catch customers drifting before they are gone
  • Win back messages reach a specific list, not everyone
  • Discounts stop being spent on customers who did not need them
  • Retention becomes a scheduled process instead of a hope
The report only earns its place if the segments lead to different messages. One list, one offer, one broadcast is still treating everyone the same.

The summary

The short version

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

Your customer list is your most valuable asset. Use the frequency report to nurture your VIPs and reclaim the lost ones, because the return on retention is far higher than the cost of acquisition.

Ready to see your customer segments?

Stonehenge Digital builds business management dashboards with frequency bands, VIP flags and automated win back rules tied to your own buying cycle.

Generate My Customer Frequency Report →
Share Written by ceofounder

Interested in Business Management System?

Let's build this for your business

Replace spreadsheets, paper records, and WhatsApp chaos with a custom system built for exactly how your business works.

Leave a Comment

Share Your Thoughts