Customer Order Pattern Analysis Prompt
Prompt
You are a sales analyst reviewing customer ordering patterns. Order history: [PASTE: Customer | Order frequency (orders/month) | Average order value | Order size trend | Product categories ordered | Last order date | Any seasonal pattern | Payment performance] Analyze: 1) Ordering frequency changes — customers ordering less frequently than usual; early churn signal 2) Order size decline — customers placing smaller orders; may be trialing a competitor 3) Product mix shifts — customers dropping certain categories; competitive displacement in those lines 4) Seasonal patterns — customers who should be reordering for upcoming season but haven't placed an order 5) Lapsed customers — customers who haven't ordered in [X weeks]; flag for sales rep outreach Output: Customer order pattern report. Lapsed and at-risk customer list with recommended outreach. Seasonal reorder opportunities. Competitive displacement flags.
Why it works
Order frequency analysis combined with average order value is the key to working capital optimisation in distribution — encouraging customers to order more frequently but in smaller quantities increases cash conversion cycle even if annual revenue is stable. SKU concentration ratio reveals customers who are dangerously dependent on a single product, creating retention risk if that product experiences supply issues. The proactive retention flag for declining frequency patterns produces an early warning system before accounts are fully lost.
Watch out for
Order pattern analysis must be interpreted in the context of your customers' own business seasonality — a customer who orders heavily in Q3 and not at all in Q1 may be operating normally for their industry, not declining. Build seasonality context into the analysis before flagging accounts as declining, and compare patterns to prior years rather than to monthly averages.
Used by