Blog · How-to guides · Telecommunications
Calculate subscriber value from service contribution, retention and acquisition costs. Work through a cohort example that separates device subsidies, observed results and future assumptions.
Customer lifetime value in the telecom industry is expected subscriber contribution after service costs, acquisition spending and device economics. Calculate it for an original subscriber cohort, with future contribution weighted by retention. State whether the result covers the full expected relationship or a limited period.
The useful question is how much a relationship contributes after the offer that won it. A high monthly bill can include device collections, taxes and charges that do not all belong in service contribution.
Telecom CLV per original subscriber = Sum of expected monthly cohort contribution, discounted to acquisition / Original subscribers − Acquisition and net device costs per original subscriber
Monthly cohort contribution = Net service revenue − Service delivery costs − Attributable support and collection costs
For future periods, estimate contribution using the expected number of retained subscribers and their contribution per active month. Use actual cohort contribution for observed periods. Choose a consistent treatment for shared network costs: incremental contribution and fully allocated profitability answer different management questions.
The general customer lifetime value formula covers the broader calculation. Telecom needs extra attention to the relationship unit, handset economics and the dates at which promotions expire. This example uses a finite horizon rather than presenting an unfinished cohort as a complete lifetime.
Select a cohort by first paid service activation. Keep plan transfers within the same relationship unless they represent an actual acquisition. Decide whether a returning subscriber resumes the original relationship or starts a new one, and document the rule before comparing channels.
Prepare these fields from the same closing period:
| Export | Required fields | Purpose |
|---|---|---|
| Billing detail | Subscriber ID, service month, service charges, discounts, service credits | Net service revenue |
| Subscriber history | Account ID, line ID, activation date, disconnect date, plan | Cohort membership and retention |
| Cost summary | Subscriber or segment, month, network/service allocation, support cost | Contribution after delivery |
| Acquisition detail | Original subscriber ID, channel, commission, activation spending | Acquisition cost once |
| Equipment summary | Device cost, customer recovery, trade-in recovery, promotion treatment | Net device economics |
An account with several lines needs both account and line identifiers. A disconnected tablet line is a line loss; it is not necessarily the end of the account relationship. Calculate retention using the same unit used for contribution and acquisition cost.
Keep contract dates and device payment dates separately. Verizon's device payment terms show why: device installments can continue across a specified term, promotional credits can stop on payoff, and a remaining balance can become due when a line disconnects. Those dates affect collections and offer economics without defining a universal subscriber lifetime.
Consider an illustrative US connectivity provider with 100 subscribers acquired together. Every active subscriber contributes $60 of net service revenue per complete month, incurs $20 of service delivery cost and $5 of attributable support cost. Contribution per active month is therefore $60 − $20 − $5 = $35.
The first six customer months are observed. The next three are assumptions based on comparable older cohorts. For clarity, the table assumes full months, no reactivation, no partial-month billing and no changes in contribution per retained subscriber.
| Customer month | Basis | Active subscribers | Service revenue (USD) | Delivery and support (USD) | Contribution (USD) |
|---|---|---|---|---|---|
| 1 | Observed | 100 | 6,000 | 2,500 | 3,500 |
| 2 | Observed | 98 | 5,880 | 2,450 | 3,430 |
| 3 | Observed | 95 | 5,700 | 2,375 | 3,325 |
| 4 | Observed | 93 | 5,580 | 2,325 | 3,255 |
| 5 | Observed | 90 | 5,400 | 2,250 | 3,150 |
| 6 | Observed | 88 | 5,280 | 2,200 | 3,080 |
| 7 | Assumed | 86 | 5,160 | 2,150 | 3,010 |
| 8 | Assumed | 84 | 5,040 | 2,100 | 2,940 |
| 9 | Assumed | 82 | 4,920 | 2,050 | 2,870 |
The $60 already reflects recurring discounts and credits. The equipment figure below is a separate net acquisition-date subsidy, with no further equipment costs or recoveries included in monthly contribution. This prevents counting the offer twice.
| Calculation step | Formula | Amount (USD) |
|---|---|---|
| Observed contribution | Sum of months 1–6 | 19,740 |
| Projected contribution | Sum of months 7–9 | 8,820 |
| Nine-month contribution | 19,740 + 8,820 | 28,560 |
| Acquisition spending | 100 × 60 | 6,000 |
| Net device subsidy | 100 × 120 | 12,000 |
| Net cohort value through month 9 | 28,560 − 6,000 − 12,000 | 10,560 |
| Value per original subscriber | 10,560 / 100 | 105.60 |
The result is $105.60 per original subscriber through nine months. It uses a zero discount rate for this short management comparison and assumes no value after month nine. It is an explicitly limited estimate, not a claim that every relationship ends then. A full lifetime estimate needs a supported tail and the finance team's chosen discount rate.
The observed table contains 564 active subscriber-months: 100 + 98 + 95 + 93 + 90 + 88. Multiplying 564 by $35 proves observed contribution of $19,740. Independently, observed revenue of $33,840 less delivery and support of $14,100 gives the same result.
Reconcile those revenue and cost totals to the billing and cost exports before extending the forecast. Tie the 100 original subscribers to activation records and the acquisition and equipment totals to their source summaries. Divide cohort value by the original 100, not the 88 remaining at month six.
Compare a second offer that changes only the net device subsidy from $120 to $140 per original subscriber. Acquisition equipment spending rises by 100 × $20 = $2,000. Net cohort value falls to $8,560, or $85.60 per original subscriber. Any argument that the richer offer pays for itself must show additional retained contribution; changing the subsidy alone does not create it.
For differences between this forward view and current-period profit, use customer profitability versus lifetime value. For reporting across businesses, customer lifetime value by industry explains why unlike units should remain separate.
Covirage is not affiliated with Verizon.
Bring a sample of your own billing, subscriber history and acquisition cost exports. Covirage maps the columns, and its tools compute and check cohort contribution and retention; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See Covirage for telecom teams for the supporting industry context.
Use the unit that matches the decision. Line value helps compare plans and device offers. Account value helps evaluate relationships containing several lines. Allocate shared costs consistently, and never divide account revenue by a line count while using account churn as the retention assumption.
Keep them separate in a contribution analysis. A device installment collects an equipment balance; it does not represent another month of service delivered. Include the device's economic cost and recovery under one consistent policy, without charging the same subsidy again through service costs.
Average revenue per user describes revenue for a period. It does not deduct service costs, promotional credits or acquisition spending, and it says nothing about how long subscribers remain. Use it as an input only after defining the customer unit and revenue basis.
Report observed contribution through the latest complete customer age, then show projected periods separately. Use older comparable cohorts to inform retention assumptions. Leave unobserved periods blank in historical reports instead of treating them as zero or silently filling them with a forecast.