Churn analysis for B2B: the average hides who left, and only they can tell you why

A B2B churn analysis is half arithmetic, half phone calls: calculate churn, GRR and NRR, cut by cohort until losses cluster, then interview those customers.

Instant Expert EditorialPublished Updated 5 min read

Churn analysis is half arithmetic and half phone calls. Billing data shows how much you lost and where; only the customers who left can tell you why. For a B2B subscription business, calculate customer churn rate, gross revenue retention and net revenue retention, cut them by cohort, segment and tenure until the losses cluster, then interview the customers inside the cluster.

Start with a made-up quarter

Here is a made-up example, used throughout. You sell scheduling software to field service companies (HVAC, plumbing, electrical). At the start of the quarter you have 200 customers paying $100,000 in monthly recurring revenue (MRR). During the quarter:

  • 12 customers cancel. Together they paid $4,800 a month.
  • Some customers downgrade, removing $1,200 of MRR.
  • Other customers add seats, adding $5,000 of MRR.
  • You sign 25 new customers. Leave them out, because churn measures the customers you started with. (They get their turn next quarter.)

1. Calculate three numbers, because one of them flatters you

These definitions follow ChurnZero's churn rate glossary and its pages on gross and net revenue retention.

Customer churn rate = customers lost in the period ÷ customers at the start of the period

12 ÷ 200 = 6% for the quarter.

Gross revenue retention (GRR) = (starting MRR − churned MRR − contraction MRR) ÷ starting MRR

($100,000 − $4,800 − $1,200) ÷ $100,000 = 94%. Gross revenue churn is the other side of the same number: 6%.

Net revenue retention (NRR) = (starting MRR + expansion MRR − contraction MRR − churned MRR) ÷ starting MRR

($100,000 + $5,000 − $1,200 − $4,800) ÷ $100,000 = 99%.

NRR of 99% looks almost flat, yet 6% of customers left. MetricHQ's comparison of NRR and GRR explains why: GRR excludes expansion and cannot exceed 100%, so it shows losses that growth elsewhere hides in NRR. ChurnZero's example also shows that losing higher-paying customers makes revenue churn higher than customer churn, and losing lower-paying ones does the opposite.

Use the same period length every time, and decide once how to treat customers who cancel and come back.

2. Cut the rate until the losses cluster

A company-wide rate rarely tells you what to do. A group where losses pile up does.

By cohort. Group customers by the quarter they started and track how many still pay after the same number of months.

Start quarterCustomers who startedStill paying after 6 monthsSix-month retention
Q1403434 ÷ 40 = 85%
Q2504040 ÷ 50 = 80%
Q3604242 ÷ 60 = 70%

If newer cohorts retain worse, something changed around the time they joined: a new acquisition channel, a pricing change, a different onboarding process or a different kind of customer.

By segment. Suppose 90 of the 200 customers have fewer than 10 technicians and 110 have 10 or more. If 10 of the 12 cancellations came from the smaller group, small accounts churned at 10 ÷ 90 = 11.1% and larger ones at 2 ÷ 110 = 1.8%. Plan, industry, region and sales channel are other useful cuts.

By tenure at cancellation. Customers who leave in the first few months often never got set up properly. Customers who leave after two years more often had something change: a new owner, a competitor's offer, a price increase.

By early behavior. If you track usage, compare churned and retained accounts on a few early actions, such as whether they finished setup or how many technicians logged in during the first month.

Watch the sample size: one or two cancellations either way would move that 11.1% noticeably. Treat small-group differences as leads for interviews, not conclusions.

3. Treat cancellation reasons as a hint, not an answer

The reason picked in your billing or CRM tool is useful for sorting, but it is short and often chosen to end the conversation. "Too expensive" can mean the customer never used the product enough to justify the price, a competitor offered a discount, or the budget owner changed. You won't know which without asking.

4. Interview the churned customers the numbers point to

In the example, start with small field service companies that cancelled within their first six months, not a random sample of everyone who left. Have a handful of conversations in that group, then decide whether you need more.

Ask each person to walk through the account's history: why they signed up, what setup looked like, the first time something didn't work, what they tried and what finally triggered the decision. Then ask what they use now. MaRS's win-loss guide points out that a churn interview for you is often a win interview for a competitor, so where they went matters as much as what they left.

How to interview churned customers covers the call itself, including how to separate the trigger from the underlying problem. How to check customer interviews against product data covers bringing the conversations back to your numbers.

5. End each round with one change and one metric

Write a short note covering the group where churn concentrates, what the interviews showed, the one change you will make and the number you expect it to move. In the example, if small companies never connected their dispatch calendar, the change might be a guided setup step, and the metric is six-month retention for the next small-account cohort. Recalculate after that cohort has passed through.

Your next step

Pull last quarter's customer list with start dates, MRR and cancellations, and calculate the three formulas. Then build the cohort and segment tables and pick the group with the worst retention.

To reach operators you don't know, including ones who chose a competitor from the start, search for people by describing their role and company type. The operations professionals in facilities management directory page is one place to start. Instant Expert finds people whose work matches your question. You review them, it sends the invitations, and you pay for each call that gets booked.

From churn numbers to churn interviews

  1. 1

    Calculate

    Customer churn, GRR and NRR for one consistent period, leaving out new customers.

  2. 2

    Cut

    Split by start cohort, segment, tenure and early behavior until losses concentrate.

  3. 3

    Interview

    Talk to a handful of churned customers from that group about the account's full history.

  4. 4

    Change

    Make one change and track retention for the next cohort in that group.

Calculate the rates, cut them until losses cluster, then talk to the customers inside the cluster.