Acquiring new customers is important to success, but retaining customers is critical to profitability and long-term growth. An earlier article explained how to track retention by calculating and tracking customer and revenue retention metrics. That used to require lots of spreadsheet work, now connecting Tally Street to your cloud-based accounting software makes it easy and automatic.
Know how to drive growth through smarter customer acquisition and retention!? Part of the answer is to focus your new sales efforts on the right subset of customers who are most similar to your best current customers AND to retain your best current customers. The key to doing this is through customer segmentation.
Most small and midsize businesses (SMBs) don’t have the time, resources and tools to do their own customer segmentation. But SMBs do have accounting systems filled with customer sales data that can be processed to automatically segment your best from your worst customers (and everything in between).
We do this using RFM, a tried-and-tested model that sophisticated marketers have used for years. We made a few tweaks to the traditional model, then applied a combination of smart software and human intelligence to automatically group customers into categories that SMBs can quickly start using to make better decisions.
One of those tweaks was to add “T” to the original RFM model. Most business-to-business (B2B) companies make some or all of their sales on credit, eg, net-30 payment terms. Extending credit to customers greases the sales process, but customers who frequently pay late are a drag on cash flow. So we added a fourth component to include timely payments as part of the overall customer value.
After compiling the sales and payment data for each customer, our software individually evaluates and scores customers on R, F, M and T. We then use the individual scores and the aggregate scores to segment every customer into one of the following categories:
Once our software does the hard work of analyzing and tagging each customer, it’s easy to start comparing performance across segments. In the following example, the 33 customers tagged as Champions have the highest average lifetime value (LTV), purchased an average 126x each, and pay in an average of 18 days. It’s definitely worth digging into what the Champions have in common (eg, bought the same products, has the same sales rep) so you can find and make more of them!
Late Payers near the bottom of the table look a lot like Champions, except they take an average of 81 days to pay, 350% longer than Champions. An effort to improve collections from those 23 Late Payers looks like a quick way to create more champions and boost cash flow!
Customer Segment | Customers | Avg LTV | # of Purchases | Total TTM Sales | Avg Days to Pay |
---|---|---|---|---|---|
Champion | 22 | $163,450 | 133 | $1,711,005 | 17 |
Good | 71 | $65,999 | 17 | $781,216 | 19 |
Promising | 44 | $11,772 | 3 | $56,976 | 1 |
Don't Lose Them | 14 | $25,148 | 8 | $44,980 | 12 |
Give Attention | 16 | $16,299 | 6 | $27,362 | 20 |
Hibernating | 29 | $14,325 | 4 | $0 | 12 |
Possible Mismatch | 45 | $1,631 | 1 | $0 | 1 |
Late Payer | 18 | $102,227 | 34 | $435,249 | 86 |
New | 1 | $3,955 | 1 | $3,955 | -- |
To see who those Late Payers (and potential champions) are, you can switch to the customer-level details in the Tally Customer Sheet. In the table below, we quickly see that Bailey Group has the 3rd highest LTV, about 8x the average for Late Payers, but takes an expensive 77 days to pay. Speeding up collections from Bailey Group should be a top priority.
Customer | Segment | LTV | Purchases | TTM Sales | Prev TTM Sales | Avg Days to Pay |
---|---|---|---|---|---|---|
Langosh and Sons | Champion | $1,638,417 | 129 | $698,175 | $451,249 | 33 |
Hintz Sauer Inc | Champion | $1,067,922 | 589 | $183,140 | $237,132 | 1 |
Bailey Group | Late Payer | $964,484 | 77 | $196,467 | $332,329 | 77 |
Lehner Hyatt Corp | Don't Lose Them | $84,938 | 4 | -- | $84,938 | 10 |
Herzog Group | Good | $82,982 | 27 | $24,206 | $28,829 | 53 |
Schulist and Barton | Good | $77,765 | 14 | $756 | $2,867 | 46 |
Harber Bros LLC | Give Attention | $67,167 | 5 | -- | $33,599 | 55 |
Customers further down the ranks present great retention opportunities. Lehner Hyatt Corp, Feeney – Zemlak, and Harber Bros LLC appear to be Promising or Good customers — except they haven’t made any recent purchases. Identifying these high churn risk customers as early as possible gives sales and support teams the opportunity to save them and grow them into better customers.
Getting results for your own business customers is easy and free! You can connect Tally Street to QuickBooks, Xero or Sage Intacct and receive results based on your customer sales data in about five minutes. The only requirement is that you keep sales invoices and receipts in the accounting software you use. Start your free trial, you can cancel any time.