Customer Churn Watchlist

Here's your Customer Churn Watchlist with actionable insights:

🚨 HIGH PRIORITY - Immediate Outreach Needed

Long-term customers who haven't ordered in 6+ months:

  1. Kieran Mc ternan
    • 227 days since last order (€58.50 average)
  2. LOUIS LYNCH
    • 222 days since last order (€83.20 average)
  3. Nikki Wolf
    • 219 days since last order (€68.50 average)
  4. Michael O Toole
    • 217 days since last order (€64.10 average)
  5. Siobhan Hennessy
    • 217 days since last order (€68.50 average)

⚠️ MEDIUM PRIORITY - At Risk Customers

Repeat customers who haven't ordered in 3-6 months:

  1. GLE001 Glenmar Shellfish Ltd
    • 161 days (€1,600 last order!) - HIGH VALUE
  2. Farmgate Cafe
    • 144 days (2 orders, €129.50 average)
  3. GDD001 Good Day Deli
    • 141 days (3 orders, €65.30 average)
  4. Tom Ramwell
    • 139 days (2 orders, €70.30 average)
  5. Patrick O'Leary
    • 136 days (2 orders, €31.50 average)

📊 BUSINESS CUSTOMERS - Special Attention

B2B customers with concerning gaps:

  • Mac's Fish
    • 71 days (14 orders, €104 average) - Usually frequent buyer
  • The kings mill Restaurant
    • 61 days (6 orders, €72.65 average)
  • ROH001 Roundwood House
    • 26 days (5 orders, €155 average) - Still okay but monitor

💡 PROACTIVE OUTREACH STRATEGY

Immediate Actions:

  1. Email/Call the High Priority list
    • They've been gone 6+ months
  2. Special offer for GLE001 Glenmar Shellfish
    • Your €1,600 customer is at serious risk
  3. Restaurant check-ins
    • Mac's Fish and The kings mill Restaurant may have changed suppliers

Retention Tactics:

  • "We miss you" personalized emails
  • Special comeback discounts (10-15%)
  • Product recommendations based on past purchases
  • Check if they need different products/services

Monitoring Schedule:

  • Weekly check on customers 60+ days since last order
  • Monthly review of repeat customers 30+ days overdue

This watchlist shows you have several valuable customers at risk, especially in the B2B segment. The good news is that your top customers (Kish Fish Co Ltd, McNally Family Farm, Jerome Caxard) are still active with recent orders.