Telecom customer analytics: usage, products and account value

Telecom customer analytics connects account usage, product holdings and net revenue so commercial teams can decide where to review adoption, billing or relationship coverage. Start with prepared billing and activity exports for the same period, then compare accounts using consistent definitions.

Use a closed reporting period and prepared commercial account measures.

Start with a specific account question

Choose the action first: review accounts holding several product families with little core-service usage, or explain how credits changed net billed revenue.

Use one account key across the supplied exports and agree how parent and subsidiary accounts are grouped. Count each commercial relationship once. If a business has several billing accounts, use the approved grouping supplied with the export rather than inferring relationships from similar names.

The example uses subscribed core-service seats as its activity denominator. That denominator applies only to the core service, even though the account may hold other products. Keep circuits, data volumes and seats in their own units. They cannot be added into one meaningful usage total.

For the wider commercial review, see the questions a B2B telecom sales director asks. This worksheet concentrates on the connection between activity and account value.

Prepare one row per account

Request recurring charges, credits and usage charges for a closed month. Exclude taxes, equipment and one-time charges from this example, and document those exclusions. Call the resulting measure net billed revenue; finance should supply any separate bridge to recognized revenue.

Ask for the count of distinct subscribed core-service seats and the count with qualifying activity during that same month. The activity export should already reduce repeated events to distinct active seats. Freeze the roster definition so a midmonth seat change does not silently change the denominator.

Count distinct product families held, not invoice lines or individual seats. The fictional US provider has the following prepared account rows. Put columns A through G in the worksheet; H and I contain calculated values.

The product-family total is nine account-family holdings. It does not mean nine different products exist across the provider. The same family can be held by several accounts.

Calculate revenue and activity

With the first account on row 2, enter net billed revenue in H2 and core activity rate in I2. Fill down through row 6:

=E2-F2+G2
=IF(B2=0,"",C2/B2)

Use a blank when there is no subscribed base. A missing activity export is also not a measured zero; flag it for review before calculating the rate.

The total revenue and activity formulas are:

=SUM(E2:E6)-SUM(F2:F6)+SUM(G2:G6)
=SUM(C2:C6)/SUM(B2:B6)

Revenue is $16,000 minus $700 plus $800 = $16,100. Activity is 194 / 300 = 64.7%, rounded to one decimal place. Divide the total active seats by total subscribed seats rather than averaging the account percentages.

Compare product holdings without mixing units

Separate accounts holding one family from accounts holding multiple families. This is a useful coverage comparison, not proof that another product is suitable for every account. Use the customer segmentation method to choose commercially meaningful groups.

For the multiple-family group, calculate accounts, core seats, active core seats and net billed revenue:

=COUNTIFS($D$2:$D$6,">=2")
=SUMIFS($B$2:$B$6,$D$2:$D$6,">=2")
=SUMIFS($C$2:$C$6,$D$2:$D$6,">=2")
=SUMIFS($H$2:$H$6,$D$2:$D$6,">=2")

Change the criterion to 1 for the single-family group. COUNTIFS counts matching rows, and SUMIFS sums values satisfying the specified criteria. These work here because each source row represents one account. Covirage is not affiliated with Google.

Group activity divides active seats by core seats; revenue per account divides group revenue by account count. For example, the multiple-family group returns 166 / 240 = 69.2% and $13,500 / 3 = $4,500. Keep full precision until display.

Reconcile first, then assign the account review

Group accounts must sum to five, core seats to 300 and net billed revenue to $16,100. The billing check must also reconcile recurring charges, credits and usage charges to the same included account population. Active seats must never exceed subscribed seats under the chosen roster definition.

Brookfield holds several product families but has a core activity rate of 40.0%. Its account owner should check deployment timing and the activity definition before proposing another sale. Dune's lower activity rate also deserves context; backup or seasonal use can be intentional.

Use the customer-base denominator guide when choosing peers. Add service-contact evidence through customer care analytics, and use the telecom analytics dashboard for a recurring management view.

Where it goes wrong

• Accounts mixed with seats. Revenue per account and activity per subscribed seat answer different questions.
• Activity events counted as active seats. Repeated events inflate adoption unless activity is reduced to distinct eligible seats.
• Credits applied twice. A net billing field must not be reduced again by credits already included.
• Product families counted from invoice lines. Several lines can belong to one family; use a consistent product grouping.
• Low usage treated as certain cancellation. Review contract purpose, deployment and service history before acting.

Compare your own telecom accounts in Covirage

Bring prepared billing, product-holding and activity exports with a consistent account key and reporting period. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.

See telecom analytics for the supporting commercial context.