Customer Acquisition Cost in Telecom

Customer acquisition cost in telecom divides acquisition spending by qualifying new customers activated in the matching cohort. Choose whether a customer means an account or a subscriber line before calculating anything. Then compare acquisition spending with the contribution that the same cohort actually retains.

Fix the customer unit and activation rule

This method uses new-to-carrier accounts: each household or business account enters once, at its first qualifying paid activation. Additional lines on that account do not create additional acquired accounts. Upgrades, plan migrations, test activations, and reactivations are excluded under the stated policy.

If your operating question concerns subscriber lines, rebuild both the spending allocation and denominator on that basis, then label the result cost per new activated line. Do not compare it directly with account CAC. The general CAC article owns the common formula; the telecom work is defining activation and matching its costs.

Use the original acquired cohort even when some accounts later disconnect. Removing departed accounts from the original denominator would turn acquisition cost into a different measure. Retention belongs in the follow-up comparison.

Collect three exports

Start with the account and activation history, the acquisition cost file, and billing contribution by account. The account history needs a durable account key, earliest qualifying activation timestamp, acquisition channel, and cancellation or service-status history. The cost file needs cost date, account or campaign, channel, cost category, and amount.

Separate media and acquisition labor, incremental sales commissions, and net device support. For this example, net device support means device cost less customer device payments and trade-in recoveries for acquisition devices. It excludes upgrade support and includes no amounts already recorded in another acquisition line. If your policy also includes future promotional credits, identify that commitment separately and use the same basis across channels.

Keep this management view distinct from accounting expense. Verizon's 2025 Form 10-K, Note 2 describes capitalizing qualifying incremental commissions and amortizing them over the expected benefit period. A current-period expense total therefore need not equal commissions attributable to the current acquisition cohort.

Build the cohort in Excel

Create Accounts with one row per account: A account key, B first-ever qualifying activation date, C acquisition channel, and D cohort flag. The first activation date must come from complete available account history, rather than the earliest event in a monthly extract.

For the January 2026 cohort, enter in D2 and fill down:

=--AND(A2<>"",B2>=DATE(2026,1,1),B2<DATE(2026,2,1))

Build a Summary sheet with channel names in A. Count new activated accounts in E2:

=COUNTIFS(Accounts!$C$2:$C$10000,A2,Accounts!$D$2:$D$10000,1)

Microsoft's COUNTIFS documentation confirms that it counts rows meeting all specified criteria. The account sheet must already be unique by account key; this formula counts rows, not distinct accounts. Expand the ranges to include your export. Covirage is not affiliated with Microsoft or Verizon.

Calculate acquisition cost by channel

The following illustrative US carrier cohort uses acquisition costs matched to January's qualifying accounts. Media includes the allocated acquisition labor in this example. All amounts are USD, and total spending in F is B + C + D.

In F2 and G2, then filled down:

=SUM(B2:D2)
=IF(E2=0,NA(),F2/E2)

Total CAC is =SUM(F2:F3)/SUM(E2:E3): 138,000 / 550 = $250.91, rounded to cents. Use unrounded cell values for later calculations. Reconcile the account count to qualifying activations and the spending columns to the acquisition cost ledger, with a separate bridge to accounting expense.

Compare retained contribution on the same clock

Observe every acquired account for its first 90 days. Retained accounts have at least one active paid line at that point. Contribution below is recorded service revenue less included variable service, support, payment, and bad-debt costs, with acquisition commissions and device support excluded because they appear above. Include contribution earned before an account disconnects.

For this table in A:G, retained share is =C2/B2 and the final column is =E2-F2. Shares are rounded to one decimal place. The cohort has not covered acquisition spending within the observation window; this is not a forecast of lifetime profitability. CAC by industry explains why outside comparisons need matching definitions, while customer lifetime cost covers costs beyond acquisition.

Where it goes wrong

• Accounts and lines mix. Family accounts with several lines distort comparisons when the denominator changes.
• Net additions replace acquisitions. Departures then alter a measure intended to count new customers.
• Device support is deducted twice. Acquisition spending and contribution must have complementary cost boundaries.
• Cohort costs become P&L expense. Capitalization and amortization create timing differences that require a reconciliation.

Compare your telecom cohort in Covirage

Upload your account activation history, acquisition cost file, and billing contribution export or Google Sheet. Covirage maps the columns; its tools compute and check cohort acquisition costs and retained contribution, 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 telecom for the industry context.