Telecom churn analytics: separate account and line losses

Telecom churn analytics separates customers who leave entirely from service lines disconnected by customers who stay. Compare both against a fixed opening population, then split the losses by opening plan, tenure, and region. A partial reduction can matter commercially even when the account remains active.

Define the account and the service unit

A business account may contain several locations and many service lines. Decide whether the review covers mobile lines, voice connections, or another consistently defined service. Keep unlike service units in separate schedules; adding them produces a total that is difficult to interpret.

Define an account exit as a verified end to the relationship within the covered service portfolio. Define a lost opening line as a line active at the start that no longer qualifies as active at the end under the same rule. Record effective service dates rather than the date someone exported the billing file.

Porting needs its own reason code. The FCC's number-porting guide explains that customers can keep a phone number when changing providers. An unchanged number therefore does not establish that a service stayed with your company. A recorded line departure still needs an account-level check before it becomes a full customer exit.

For the general customer-population method, use churn analytics. This review concentrates on the extra service-line denominator that telecom businesses need.

Ask for a prepared customer summary

Use one row per account active at the opening date, with opening plan, tenure group, region, opening lines, surviving opening lines, and confirmed account-exit flag. Ask billing operations to prepare those counts from the approved service records. The business review starts from that summary; it does not require a real-time scoring system.

Surviving opening lines means the original service population still active at the close. Newly activated lines stay outside this survival count. A snapshot of total closing lines is insufficient if additions have replaced disconnected lines during the period.

The illustrative US business-services provider below reviews September 1 through September 30, 2026. New and Mature are its prepared tenure labels. Plan and region assignments are fixed at the opening date. Columns A through G are source fields.

Accounts A and F left. B and D removed lines while remaining customers. C and E retained all their opening lines. The summary preserves those differences instead of reducing them to a single customer-loss count.

Calculate account and line losses separately

Opening-cohort account churn = Confirmed account exits / Opening accounts

Opening-line loss rate = Lost opening lines / Opening lines

These are management-review definitions using opening populations. Any comparison with an external report must first match its denominator, service scope, and period.

Put the customer table in Excel rows 2 through 7. Calculate lost opening lines in H2, lines lost with full account exits in I2, and partial losses in J2:

=E2-F2
=IF(G2=1,E2,0)
=IF(G2=0,H2,0)

Fill down. A confirmed account exit should have no surviving lines in this defined portfolio. A negative loss count or surviving count above opening lines indicates a preparation problem; do not repair it by forcing the result to zero.

Account churn is 2 / 6 = 33.3%. Opening-line loss is 29 / 70 = 41.4%. Rates throughout this example are rounded to one decimal place. The small illustrative population demonstrates the arithmetic; these percentages are not an industry benchmark.

The proof is physical units: 70 opening lines minus 29 lost lines equals 41 surviving opening lines. The loss components must also agree: 25 plus 4 equals 29. Both spreadsheet checks must return zero:

=SUM(E2:E7)-SUM(H2:H7)-SUM(F2:F7)
=SUM(H2:H7)-SUM(I2:I7)-SUM(J2:J7)

Compare plan, tenure, and region

Place Standard and Premium in L2 and L3. Count opening accounts and confirmed departures with these formulas. COUNTIFS counts records meeting all supplied criteria.

=COUNTIFS($B$2:$B$7,L2)
=COUNTIFS($B$2:$B$7,L2,$G$2:$G$7,1)

Sum opening and lost lines using the same grouping. SUMIFS adds values that meet the specified criteria.

=SUMIFS($E$2:$E$7,$B$2:$B$7,L2)
=SUMIFS($H$2:$H$7,$B$2:$B$7,L2)

Divide lost lines by opening lines. For tenure, replace the grouping range with $C$2:$C$7; for region, use $D$2:$D$7. Copy the corresponding labels into the criterion cells.

Each pair independently totals six opening accounts, two exits, 70 opening lines, and 29 lost lines. These are alternative views of the same population, so never sum all the views together.

Read the result before assigning a cause

Premium has more line loss than Standard, but the account-exit counts are equal. East contains both account exits, while West's loss is entirely partial. Begin the investigation with the account and service records behind those groups.

Billing operations owns the service reconciliation. Account managers verify commercial reasons, and the retention lead chooses follow-up actions. Use telecom customer churn analysis for the neighboring customer-focused investigation, and the telecom analytics dashboard when deciding which measures belong in a recurring review. A dashboard should preserve the units and denominator beside every rate.

For broader account context, the B2B telecom sales director's questions place renewal dates and customer-estate checks beside service measures. A shrinking estate and a competitive departure can require different commercial responses.

Where it goes wrong

• Dividing lines by accounts. Keep the numerator and denominator in the same unit.
• Using net closing totals as gross survival. New activations can hide disconnected opening lines.
• Counting internal migrations as exits. Verify continuity and record the approved migration treatment.
• Moving plan or region labels after departure. Freeze the opening assignments for comparison.
• Treating a group difference as a cause. Review coded reasons and account evidence before blaming price, service, or geography.

Covirage is not affiliated with Microsoft.

Review your telecom summary in Covirage

Bring a prepared account summary with opening and surviving lines, confirmed exits, and plan, tenure, and region labels. Covirage maps the columns, its tools compute and check the account and line comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for telecoms for the supporting industry context.