The week’s call list: trade customers about to reorder
Reorder calls for a growing wholesaler, tested on 47 weeks of real invoices against the CRM due-date rule.
Executive summary
A weekly reorder score puts 63% of 100 calls on trade customers who order within a fortnight, against 19% for the CRM due-date rule.
Situation
Account managers call customers past their usual gap, and most calls land at the wrong time.
Approach
A reorder score each Monday from invoice history, tested on 47 weeks of real wholesale invoices.
Result
63% of calls on customers about to order, against 19%.
The problem
A wholesaler’s inside sales team calls trade customers from a list of accounts, usually alphabetical or by last year’s spend. A customer who usually reorders every three weeks and has gone five is the call that matters. Distributors that give reps a daily list of customers due to reorder report more orders per rep and revenue they can trace to the calls.
I measured how well a weekly ranking by each customer’s chance of ordering in the next fortnight puts the coming orders at the top of the list, against calling the biggest accounts first.
- Team
- Owner, account managers, the person who runs the CRM
- Scale
- A few thousand trade customers; a few hundred calls a week
- Systems
- HubSpot or Pipedrive tasks, Shopify B2B or Xero invoices, a phone and email sequence
- Measure
- Calls that reach a customer within 14 days of their order; order value reached per call
What I built
A reorder score refreshed every Monday from the invoice history. For each customer with two or more orders it reads the days since the last order against their own usual gap, how regular their gaps are, their order count over three and twelve months, order value and what they did in the same weeks last year, then ranks the chance of an order in the next fortnight. The top of the list becomes HubSpot call tasks for the week, with the customer’s usual gap and last order on the task.
Results
I tested on the UCI Online Retail II data: real invoices from a UK online giftware wholesaler, many of whose customers are wholesalers and shops, 33,107 order-days from 5,878 customers between December 2009 and December 2011. The score was fitted on weekly lists for 2010 and tested on the 47 Mondays of 2011, each covering about 3,166 active customers.
| Weekly call list | Customers called | Order within 14 days | Share of reorders reached | Share of reorder value |
|---|---|---|---|---|
| Due-date rule | 710 | 18% | 28% | 31% |
| Reorder score, same number | 710 | 32% | 51% | 68% |
| Reorder score, top 100 | 100 | 63% | 14% | 31% |
At the due-date rule’s own list size of about 710 customers a week, the score reaches 51% of the customers who reorder against 28%, and 68% of the order value against 31%, because it favours regular, larger accounts.
Data and method
- Data
- UCI Online Retail II (CC BY 4.0): every invoice line from a UK online giftware wholesaler, December 2009 to December 2011. Cancellations and lines without a customer removed; orders collapsed to one per customer per day. Customers appear only as numbers in the release.
- Population
- Each Monday, customers with at least two earlier orders and an order in the last twelve months
- Target
- Customer places an order in the 14 days from the Monday
- Methods
- Gradient-boosted classifier on recency, the customer’s own gap statistics, order counts over three and twelve months, order value, the same fortnight last year and the month; fitted on 2010 and tested on 2011
- Comparison
- Due-date rule: days since the last order between one and two times the customer’s median gap
Limitations
- The test measures who ordered, not who ordered because of a call. A month with half the list called and half left measures the lift in orders and basket size.
- One wholesaler’s customers from 2010 and 2011; the score is refitted on the business’s own invoices.
- In the live set-up, due customers who are not on the call list still get the usual email reminder.
- New customers with one order are left to the onboarding sequence until they have a gap to compare.
How I would take it live
- Export two years of invoices from Xero, Shopify or the order system
- Fit the score and set the weekly call count with the account managers
- Push the list to HubSpot as tasks each Monday for four weeks, with half the list held back
- Adopt with orders and value per call compared with the held-back half