Finance

Key Performance Indicators

KPI

Description

Overall ARPU

The overall Average Revenue Per User (based on subscriber invoices) is shown prominently in the KPI section. The figure displayed is the ARPU for the last 6 months and excludes VAT from any figures shown.

Value of Open Queries

Any open query is a disruption to cash flow and potential indication of customer dissatisfaction. This KPI summarises the value of open queries.

Profitable Subscribers

The Profitable Subscriber KPI is based on subscriber invoicing over time showing the percentage of subscribers where billed revenue exceeded the wholesale cost of the usage consumed by the subscribers in that month. Hovering over the columns within the charts allows data points to be viewed that provide more detail.

Sales Ledger Adjustments

The value and volume of Sales Ledger Adjustments can be an indication of potential lost revenue and customer dissatisfaction. The Sales Ledger Adjustments KPI chart allows tracking and trending of the value of adjustments applied over time.

Finance Analysis

Wherever profitability is analysed, it is assumed that the wholesale cost of usageClosed The consumption of services, for example a subscriber using call minutes. is included in the usage records and that the cost accurately represents the cost of usage.

 

Analytic

Description

Customer Revenue Analysis

This analytic contains the similar attributes as Tariff Analysis but in addition, provides for revenue and profitability to be analysed in more detail by:

  • Network
  • Invoice Day
  • Tariff Description
  • Customer Type
  • Group Name
  • Corporate Name
  • Customer Name

The dashboard contains the following charts:

  • Customer Spend
  • Spend Per Usage Types
  • Usage Record bundling
  • Revenue and Margin Per Subscriber
  • ARPU Per Network
  • Revenue and Margin Per Tariff (Customer Specific)

These charts allow a variety of analytics to be performed, for example:

  • ARPU split between Services or Usage
  • Total Revenues
  • Wholesale Costs
  • Usage and Service Revenue
  • Usage Bundling
  • Spend per usage type
  • ARPU per Network
  • For any selected Group. Corporate or Customer by tariff:
    • ARPU
    • AMPU
    • Revenue
    • Number of subs invoiced

Device Revenue Analysis

Device Revenue Analysis derives a TAC from the International Mobile Equipment Identity (IMEI) serial number field in CMP (where stored). Subscriber invoicing is used to match subscriber invoices to subscriber IMEIs, allowing the number of subscribers by TAC and their associated revenue to be presented.

Analysis is available by:

  • TAC Number
  • Network
  • Invoice Month

Amounts in Query

Amounts in Query can be investigated from a number of angles in order to analyse agent performance in resolving queries, the ageing of open queries, the average value, and the average time taken to resolve queries.

This analytic displays:

  • Highest Open Query Amounts with amounts > £10,000 highlighted
  • Customer Name and Group showing the Oldest Open Query Amounts

Profitable Subscribers

Further information is made available about the value of volume of non-profitable subscribers with a filter of customer type.

Sales Ledger Adjustments & Sales Ledger Adjustment Analysis

Reducing the volume and value of SLAs can often lead to increased profitability and, by identifying root cause, increased customer satisfaction.

Two dashboards provide SLA details in chart and table form that cover Sales Ledger Adjustments (SLAs) from the previous 12 months. The data covers:

  • The reason for the SLA
  • The Agent raising the SLA
  • Whether the SLA is debit or credit amount
  • Top 10 credit adjustments by reason per month
  • Top 10 agents raising the most credit adjustments
  • Highest value credit adjustments
  • Total value / volume of SLAs in both for Net SLAs and splits between credit and debit adjustments
  • All customers who have had an SLA applied in the previous 12 months