9 Billing Analytics Overview and Reports

This chapter contains the following sections:

Overview of Oracle Communications Data Model Billing Analytics

Billing Analytics provides the following:

  • End-to-end analytic applications developed on Oracle Communications Data Model

  • Data fed through the BRM Adapter and the NCC Adapter

  • Comprehensive and visually appealing dashboards built with Oracle Business Intelligence Enterprise Edition

  • Enables users to understand existing business customers across all their products and services and predict and analyze customer behavior to increase revenue and retention

  • Reduces time, cost, risk, and complexity of a custom solution.

Billing Analytics covers the following categories:

Category Description
Billed Revenue Revenue-related metrics: such as total revenue, Average Revenue Per User (ARPU), adjustments, collections, and so on
Prepaid Metrics Prepaid-specific metrics: such as total recharges, average recharges, disturbed recharge cycles, and so on
Usage Metrics Usage-specific metrics: such as total minutes of usage, number of calls, top users (voice, data, SMS)
Billing Efficiency Billing operations metrics: such as payments by payment method, percent of e-bills issued, percent of bills adjusted, and so on
Customer Metrics Customer acquisition and churn metrics that can be viewed across various parameters

Overview of Billing Analytics Process Flow

Figure 9-1 shows the Oracle Communications Data Model Billing Analytics process flow and major components. The process flow includes the following steps:

  1. Data from Oracle Communications Billing and Revenue Management source system or Oracle Communications Network Charging and Control source system is loaded into Oracle Communications Data Model leveraging the BRM Adapter or the NCC Adapter.

OR

  1. Data is loaded from other billing applications using a custom ETL.

  2. The Intra-ETL populates Oracle Communications Data Model analytic layer which has the same tables used by the billing analytics application.

  3. Oracle Business Intelligence Enterprise Edition dashboards display Billing Analytics metrics.

Figure 9-1 Billing Analytics Process Flow

Description of Figure 9-1 follows
Description of ''Figure 9-1 Billing Analytics Process Flow''

Billing Analytics Reports

Billing Analytics includes reports in five areas:

Billed Revenue Reports

This area includes revenue related metrics such as the following:

Billed Revenue Overview

The report in Figure 9-2 shows the total billed revenue by month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-2 Billed Revenue Overview Total Billed Revenue

Description of Figure 9-2 follows
Description of ''Figure 9-2 Billed Revenue Overview Total Billed Revenue''

The report in Figure 9-3 shows the total, prepaid, and postpaid ARPU (Average Revenue Per User) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-3 Billed Revenue Overview ARPU

Description of Figure 9-3 follows
Description of ''Figure 9-3 Billed Revenue Overview ARPU''

Figure 9-4 compares revenue targets that the company might have established to the actual revenue results. The difference is calculated and a flag is set based on positive or negative results.

Figure 9-4 Billed Revenue Overview Revenue Target

Description of Figure 9-4 follows
Description of ''Figure 9-4 Billed Revenue Overview Revenue Target''

The report in Figure 9-5 compares ARPU targets that the company might have established to the actual ARPU results. The difference is calculated and a flag is set based on positive or negative results.

Figure 9-5 Billed Revenue Overview ARPU Target

Description of Figure 9-5 follows
Description of ''Figure 9-5 Billed Revenue Overview ARPU Target''

The chart in Figure 9-6 shows the top five plans based on total revenue. This chart can be further filtered using the dashboard prompts.

Figure 9-6 Billed Revenue Overview Top Plan

Description of Figure 9-6 follows
Description of ''Figure 9-6 Billed Revenue Overview Top Plan''

The chart in Figure 9-7 shows the bottom five plans based on total revenue. This chart can be further filtered using the dashboard prompts.

Figure 9-7 Billed Revenue Overview Bottom Plan

Description of Figure 9-7 follows
Description of ''Figure 9-7 Billed Revenue Overview Bottom Plan''

The chart in Figure 9-8 shows the top five states within the United States (US) based on total revenue. This chart can be further filtered using the dashboard prompts. The chart allows for a further drill down to top cities for the given state by clicking the various bars in the chart.

Figure 9-8 Billed Revenue Overview Top State

Description of Figure 9-8 follows
Description of ''Figure 9-8 Billed Revenue Overview Top State''

The chart in Figure 9-9 shows the bottom five states in the US based on total revenue. This chart can be further filtered using the dashboard prompts. The chart also allows for a further drill down to the bottom cities for the given state by clicking the various bars in the chart.

Figure 9-9 Billed Revenue Overview Bottom State

Description of Figure 9-9 follows
Description of ''Figure 9-9 Billed Revenue Overview Bottom State''

Revenue Detail

The report in Figure 9-10 shows the total billed revenue by month. Use the slide bar and prompts to further filter the data.

Figure 9-10 Billed Revenue Detail Total Billed Revenue

Description of Figure 9-10 follows
Description of ''Figure 9-10 Billed Revenue Detail Total Billed Revenue''

The report in Figure 9-11 shows the total billed revenue per year by customer type (that is, individual or business users). Use the dashboard prompts to further filter the data.

Figure 9-11 Billed Revenue Detail Revenue by Customer Type

Description of Figure 9-11 follows
Description of ''Figure 9-11 Billed Revenue Detail Revenue by Customer Type''

The report in Figure 9-12 shows a table view of a year-over-year comparison of the total billed revenue. The difference is calculated and the percent change is displayed.

Figure 9-12 Billed Revenue Detail Revenue Comparison

Description of Figure 9-12 follows
Description of ''Figure 9-12 Billed Revenue Detail Revenue Comparison''

The report in Figure 9-13 shows a table view of the total billed revenue by customer type (individual subscribers, business users, and sum of the two).

Figure 9-13 Billed Revenue Detail Revenue by Customer Type

Description of Figure 9-13 follows
Description of ''Figure 9-13 Billed Revenue Detail Revenue by Customer Type''

The report in Figure 9-14 shows a graphical and table view of the total billed revenue per year by product type. Use the dashboard prompts to further filter the data.

Figure 9-14 Billed Revenue Detail Total Revenue by Product Type

Description of Figure 9-14 follows
Description of ''Figure 9-14 Billed Revenue Detail Total Revenue by Product Type''

The report in Figure 9-15 shows the percent of the total billed revenue by revenue type. Use the dashboard prompts to further filter the data.

Figure 9-15 Billed Revenue Detail Revenue by Revenue Type

Description of Figure 9-15 follows
Description of ''Figure 9-15 Billed Revenue Detail Revenue by Revenue Type''

The report in Figure 9-16 shows the percent of the total billed revenue by state. Use the dashboard prompts to further filter the data.

Figure 9-16 Billed Revenue Detail Revenue by State

Description of Figure 9-16 follows
Description of ''Figure 9-16 Billed Revenue Detail Revenue by State''

The report in Figure 9-17 shows a table view of the various total revenue details. Total and gross revenue are shown by each state in the US, along with comparisons to the previous year and the year-over-year percent change.

Figure 9-17 Billed Revenue Detail Revenue Detail Report

Description of Figure 9-17 follows
Description of ''Figure 9-17 Billed Revenue Detail Revenue Detail Report''

ARPU

The report in Figure 9-18 shows the total, prepaid, and postpaid ARPU (Average Revenue Per User) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-18 Billed Revenue ARPU Summary

Description of Figure 9-18 follows
Description of ''Figure 9-18 Billed Revenue ARPU Summary''

The report in Figure 9-19 shows the ARPU by customer type (that is, individual or business users). Use the dashboard prompts to further filter the data.

Figure 9-19 Billed Revenue ARPU Total by Customer Type

Description of Figure 9-19 follows
Description of ''Figure 9-19 Billed Revenue ARPU Total by Customer Type''

The report in Figure 9-20 report compares the ARPU targets that the company might have established to actual the ARPU results. The difference is calculated and a flag is set based on positive or negative results.

Figure 9-20 Billed Revenue ARPU Target

Description of Figure 9-20 follows
Description of ''Figure 9-20 Billed Revenue ARPU Target''

The report in Figure 9-21 shows the ARPU by customer type (that is, individual or business users) in a table view. Use the dashboard prompts to further filter the data.

Figure 9-21 Billed Revenue ARPU by Customer Type

Description of Figure 9-21 follows
Description of ''Figure 9-21 Billed Revenue ARPU by Customer Type''

The report in Figure 9-22 shows a graphical and table view of the ARPU per year by product type. Use the dashboard prompts to further filter the data.

Figure 9-22 Billed Revenue ARPU Total by Product Type

Description of Figure 9-22 follows
Description of ''Figure 9-22 Billed Revenue ARPU Total by Product Type''

The report in Figure 9-23 shows the percent of ARPU by each state. Use the dashboard prompts to further filter the data.

Figure 9-23 Billed Revenue ARPU by State

Description of Figure 9-23 follows
Description of ''Figure 9-23 Billed Revenue ARPU by State''

The report in Figure 9-24 shows a table view of the various ARPU details. The ARPU is shown by state and customer type. The report also displays comparisons to the previous year and the year-over-year percent change.

Figure 9-24 Billed Revenue ARPU Detail Report

Description of Figure 9-24 follows
Description of ''Figure 9-24 Billed Revenue ARPU Detail Report''

Discounts

The report in Figure 9-25 shows the total discounts granted (in dollars) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-25 Billed Revenue Discounts Total

Description of Figure 9-25 follows
Description of ''Figure 9-25 Billed Revenue Discounts Total''

The report in Figure 9-26 shows graphical and table views of the total discounts granted per year by product type. Use the dashboard prompts to further filter the data.

Figure 9-26 Billed Revenue Discounts by Product Type

Description of Figure 9-26 follows
Description of ''Figure 9-26 Billed Revenue Discounts by Product Type''

The report in Figure 9-27 shows graphical and table views of the total discounts granted per year, by customer type (that is individual versus business customers). Use the dashboard prompts to further filter the data.

Figure 9-27 Billed Revenue Discounts by Customer Type

Description of Figure 9-27 follows
Description of ''Figure 9-27 Billed Revenue Discounts by Customer Type''

The report in Figure 9-28 shows graphical and table views of the total discounts granted per year, by discount type. Use the dashboard prompts to further filter the data.

Figure 9-28 Billed Revenue Discounts by Discount Type

Description of Figure 9-28 follows
Description of ''Figure 9-28 Billed Revenue Discounts by Discount Type''

Figure 9-29 shows a table view of the discounts granted by customer type. The total discount amounts are shown by year, along with comparisons to the previous year and the year-over-year percent change.

Figure 9-29 Billed Revenue Discounts Details

Description of Figure 9-29 follows
Description of ''Figure 9-29 Billed Revenue Discounts Details''

Payments and Collections

The report in Figure 9-30 shows the total billed revenue by month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-30 Billed Revenue Payments and Collections Billed Revenue

Description of Figure 9-30 follows
Description of ''Figure 9-30 Billed Revenue Payments and Collections Billed Revenue''

The report in Figure 9-31 shows the total payments received per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-31 Billed Revenue Payments and Collections Payments Received

Description of Figure 9-31 follows
Description of ''Figure 9-31 Billed Revenue Payments and Collections Payments Received''

The report in Figure 9-32 shows the total revenue that is overdue and sent to a collections process. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-32 Billed Revenue Payments and Collections Revenue in Collections

Description of Figure 9-32 follows
Description of ''Figure 9-32 Billed Revenue Payments and Collections Revenue in Collections''

The report in Figure 9-33 shows the total revenue that has been written off per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-33 Billed Revenue Payments and Collections Total Written-Off Amount

Description of Figure 9-33 follows
Description of ''Figure 9-33 Billed Revenue Payments and Collections Total Written-Off Amount''

The report in Figure 9-34 shows both graphical and table views of the total revenue amount overdue and sent to a collections process, by customer type (that is, an individual versus the business customer). Use the dashboard prompts to further filter the data.

Figure 9-34 Billed Revenue Payments and Collection Amount by Customer Type

Description of Figure 9-34 follows
Description of ''Figure 9-34 Billed Revenue Payments and Collection Amount by Customer Type''

The report in Figure 9-35 shows both graphical and table views of the total revenue written off by customer type (that is, an individual versus business customer). Use the dashboard prompts to further filter the data.

Figure 9-35 Billed Revenue Payments and Collections Write Off Amount by Customer Type

Description of Figure 9-35 follows
Description of ''Figure 9-35 Billed Revenue Payments and Collections Write Off Amount by Customer Type''

The report in Figure 9-36 shows both graphical and table views of the total revenue amount assigned to a specific collection agency. Use the dashboard prompts to further filter the data.

Figure 9-36 Billed Revenue Payments and Collections by Collection Agency

Description of Figure 9-36 follows
Description of ''Figure 9-36 Billed Revenue Payments and Collections by Collection Agency''

The report in Figure 9-37 shows both graphical and table views of the total revenue amount that was assigned to a specific collection agency, but was written off because it could not be collected. Use the dashboard prompts to further filter the data.

Figure 9-37 Billed Revenue Payments and Collections Written-Off Amount by Collection Agency

Description of Figure 9-37 follows
Description of ''Figure 9-37 Billed Revenue Payments and Collections Written-Off Amount by Collection Agency''

The report in Figure 9-38 shows the amount of revenue in collections by each state in the US. Use the dashboard prompts to further filter the data.

Figure 9-38 Billed Revenue Payments and Collections by State

Description of Figure 9-38 follows
Description of ''Figure 9-38 Billed Revenue Payments and Collections by State''

The report in Figure 9-39 report is a table view of payment and collection details. The report shows the total billed revenue, payments received, revenue in collections, and amounts written off. The amounts are show by customer type and year-over-year changes.

Figure 9-39 Billed Revenue Payments and Collections Details

Description of Figure 9-39 follows
Description of ''Figure 9-39 Billed Revenue Payments and Collections Details''

Adjustments

The report in Figure 9-40 shows the total amount of adjustments made (in dollars) per month. The slide bar and dashboard prompts to further filter the data.

Figure 9-40 Billed Revenue Adjustments Total

Description of Figure 9-40 follows
Description of ''Figure 9-40 Billed Revenue Adjustments Total''

The report in Figure 9-41 shows the total amount of adjustments made per year by customer type (that is, an individual versus the business customers). Use the dashboard prompts to further filter the data.

Figure 9-41 Billed Revenue Adjustments by Customer Type

Description of Figure 9-41 follows
Description of ''Figure 9-41 Billed Revenue Adjustments by Customer Type''

The report in Figure 9-42 shows graphical and table views of the total adjustments made per year for each product type. Use the dashboard prompts to further filter the data.

Figure 9-42 Billed Revenue Adjustments by Product Type

Description of Figure 9-42 follows
Description of ''Figure 9-42 Billed Revenue Adjustments by Product Type''

The report in Figure 9-43 shows the total amount of adjustments made by the various adjustment reasons. Use the dashboard prompts to further filter the data.

Figure 9-43 Billed Revenue Adjustments by Adjustment Reason

Description of Figure 9-43 follows
Description of ''Figure 9-43 Billed Revenue Adjustments by Adjustment Reason''

The report in Figure 9-44 shows the total amount of adjustments made per year by the various types of adjustments. Use the dashboard prompts to further filter the data.

Figure 9-44 Billed Revenue Adjustments by Adjustment Type

Description of Figure 9-44 follows
Description of ''Figure 9-44 Billed Revenue Adjustments by Adjustment Type''

The report in Figure 9-45 report is a table view of adjustment details. The report shows adjustment amounts by product type, along with year-over-year differences and percent change.

Figure 9-45 Billed Revenue Adjustments Detail Report

Description of Figure 9-45 follows
Description of ''Figure 9-45 Billed Revenue Adjustments Detail Report''

Maps

The report in Figure 9-46 shows the total billed revenue on a graphical map view. The greater the amount of revenue the larger the circle on the map. Hover the cursor over the circle to display the revenue amount for that area.

Figure 9-46 Billed Revenue Maps of Revenue by State and City

Description of Figure 9-46 follows
Description of ''Figure 9-46 Billed Revenue Maps of Revenue by State and City''

Billing Efficiency Reports

The Billing Efficiency reports leverage standard TM Forum metrics that measure the operational efficiency of the service provider's billing process.

Billing Calculations

The report in Figure 9-47 shows the number of payment transactions per payment method/Total number of payments. Payment methods include cash, credit card, debit card, check, direct debit, bank transfer, and so on.

Figure 9-47 Percent Payment Transactions by Payment Method

Description of Figure 9-47 follows
Description of ''Figure 9-47 Percent Payment Transactions by Payment Method''

The report in Figure 9-48 shows the number of bills paid electronically/Total number of bills.

Bills paid electronically is the bills paid through home banking, automatic bank deduction, funds transfers, ATM transactions, and web or IVR based credit or debit card transactions. This calculation excludes payments by cash or check.

Figure 9-48 Percent of Electronic Payments (E-payments) Received

Description of Figure 9-48 follows
Description of ''Figure 9-48 Percent of Electronic Payments (E-payments) Received''

The report in Figure 9-49 shows the number of Bills with errors / Total number of bills.

The number of bills with errors includes all bills that were found to have an error, which includes errors found internally and errors reported by the customer.

Figure 9-49 Percent Bills Inaccurate

Description of Figure 9-49 follows
Description of ''Figure 9-49 Percent Bills Inaccurate''

The report in Figure 9-50 shows the total elapsed time from bill cycle close to bills ready for display or dispatch. The total elapsed time includes time required for bill processing up until the bills are ready for display, but excluding the time required for posting and printing.

Figure 9-50 Time to Prepare Bills for Display and Dispatch

Description of Figure 9-50 follows
Description of ''Figure 9-50 Time to Prepare Bills for Display and Dispatch''

The report in Figure 9-51 shows the aggregate time from service activation to bill dispatch / Total number of current orders. This report includes the aggregate time for all orders in hours.

Figure 9-51 Mean Time from Service Activation to Bill Dispatch

Description of Figure 9-51 follows
Description of ''Figure 9-51 Mean Time from Service Activation to Bill Dispatch''

The report in Figure 9-52 shows the aggregate time from cycle close date until bills ready for dispatch / Total number of bills. The aggregate time includes time for bill processing and printing to be completed. The calculation includes the time to process delayed calls between the close date and the actual bill run initiation.

Figure 9-52 Mean Time to Prepare and Dispatch Bills

Description of Figure 9-52 follows
Description of ''Figure 9-52 Mean Time to Prepare and Dispatch Bills''

Billing Collection and Receivables Management

The report in Figure 9-53 shows the aggregate value of unpaid invoices / aggregate value of all invoices, which is the total value of all customer invoices unpaid at 10 days after due date for the billing period. This excludes all paid invoices, and all internal or noncustomer invoices.

Figure 9-53 Percent Collections Efficiency Against Credit Terms

Description of Figure 9-53 follows
Description of ''Figure 9-53 Percent Collections Efficiency Against Credit Terms''

The report in Figure 9-54 shows collectible debt written off / total revenue collected.

Figure 9-54 Percent Collectible Debt Written Off

Description of Figure 9-54 follows
Description of ''Figure 9-54 Percent Collectible Debt Written Off''

The report in Figure 9-55 shows the number of bills issued electronically / Total number of bills issued. This report for bills issued electronically excludes any bills that have an associated paper bill.

Figure 9-55 Percent Bills Issued (Electronically Issued Bills)

Description of Figure 9-55 follows
Description of ''Figure 9-55 Percent Bills Issued (Electronically Issued Bills)''

Billing Inquiries, Disputes, and Adjustments

The report in Figure 9-56 shows the number of bills adjusted in response to customer queries or complaints / Total number of bills issued. The number of bills adjusted includes all bills requiring adjustments initiated by the customer. This calculation is for all financial adjustments or credit notes. The number does not include customer-initiated changes for items such as an address change or plan adjustments.

Figure 9-56 Percent Bills Adjusted

Description of Figure 9-56 follows
Description of ''Figure 9-56 Percent Bills Adjusted''

The report in Figure 9-57 shows the number of bills adjusted due to errors found internally before bills are issued / Total number of bills issued. The number of bills adjusted in this case includes only all bills requiring adjustments initiated by internal triggers. This includes things like plan changes, address changes, financial adjustments, credit notes, and so on, if initiated internally. This calculation excludes any customer-initiated adjustments.

Figure 9-57 Percent Bills Adjusted Internally

Description of Figure 9-57 follows
Description of ''Figure 9-57 Percent Bills Adjusted Internally''

The report in Figure 9-58 shows the number of customer-initiated billing-related contacts / Total number of bills issued. This report includes all inbound contacts such as phone, email, and web that are relating to billing and payment inquiries. It excludes any customer-initiated changes such as address changes or plan adjustments.

Figure 9-58 Percent Billing Contacts

Description of Figure 9-58 follows
Description of ''Figure 9-58 Percent Billing Contacts''

The report in Figure 9-59 shows the number of customer requests multiplied by 1000 / Total number of customers. The number of customer requests includes all inbound contacts such as phone, email, and web contacts. This includes all billing and payment inquiries, all inquiries about call plans, and so on. This calculation excludes outbound and store-front contacts.

Figure 9-59 Volume of Customer Requests by Category

Description of Figure 9-59 follows
Description of ''Figure 9-59 Volume of Customer Requests by Category''

Customer Metrics Reports

This section shows the reports for customer acquisition and churn metrics.

Acquisition

The report in Figure 9-60 shows the total number of subscribers acquired per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-60 Total Acquisition Count

Description of Figure 9-60 follows
Description of ''Figure 9-60 Total Acquisition Count''

The report in Figure 9-61 shows the total number of subscribers acquired per year by customer type (that is, an individual or business customer). Use the dashboard prompts to further filter the data.

Figure 9-61 Total Acquisition Count by Customer Type

Description of Figure 9-61 follows
Description of ''Figure 9-61 Total Acquisition Count by Customer Type''

The report in Figure 9-62 shows the total number of subscribers acquired per year by product type. Use the dashboard prompts to further filter the data.

Figure 9-62 Total Acquisition Count by Product Type

Description of Figure 9-62 follows
Description of ''Figure 9-62 Total Acquisition Count by Product Type''

The report in Figure 9-63 shows the percent of subscribers acquired by product type. Use the dashboard prompts to further filter the data.

Figure 9-63 Acquisition Count by Product Type (Pie Chart)

Description of Figure 9-63 follows
Description of ''Figure 9-63 Acquisition Count by Product Type (Pie Chart)''

The report in Figure 9-64 shows a table view of the number of subscribers acquired per year by product offer. Use the dashboard prompts to further filter the data.

Figure 9-64 Acquisition Count by Product Offer

Description of Figure 9-64 follows
Description of ''Figure 9-64 Acquisition Count by Product Offer''

The report in Figure 9-65 shows the top five states in the US with the highest number of subscribers acquired. This chart can be further filtered using the dashboard prompts. The chart allows for further drill down to top cities for the given state by clicking the various bars in the chart.

Figure 9-65 Top Five Acquisitions by State

Description of Figure 9-65 follows
Description of ''Figure 9-65 Top Five Acquisitions by State''

The report in Figure 9-66 shows the bottom five states with lowest number of subscribers acquired. This chart can be further filtered using the dashboard prompts. The chart allows for further drill down to the top cities for the given state by clicking the various bars in the chart.

Figure 9-66 Bottom Five Acquisitions by State

Description of Figure 9-66 follows
Description of ''Figure 9-66 Bottom Five Acquisitions by State''

The report in Figure 9-67 shows a table view of the total acquired subscribers by state and by customer type, along with comparisons to the previous year and the year-over-year percent change.

Figure 9-67 Customer Acquisition Details

Description of Figure 9-67 follows
Description of ''Figure 9-67 Customer Acquisition Details''

Churn

The report in Figure 9-68 shows the total number of subscribers that have churned (that is, canceled their subscription). Use the slide bar and dashboard prompts to further filter the data.

The report in Figure 9-69 shows the total number of subscribers that have churned per year by customer type (that is, an individual or a business customer). Use the dashboard prompts to further filter the data.

Figure 9-69 Churn by Customer Type

Description of Figure 9-69 follows
Description of ''Figure 9-69 Churn by Customer Type''

The report in Figure 9-70 shows the total number of subscribers that churned per year by product type. Use the dashboard prompts to further filter the data.

Figure 9-70 Churn by Product Type

Description of Figure 9-70 follows
Description of ''Figure 9-70 Churn by Product Type''

The report in Figure 9-71 shows the percent of subscribers churned by product type. Use the dashboard prompts to further filter the data.

Figure 9-71 Churn by Product Type (Pie Chart)

Description of Figure 9-71 follows
Description of ''Figure 9-71 Churn by Product Type (Pie Chart)''

The chart in Figure 9-72 shows the top five states in the US with the highest number of subscribers that have churned. This chart can be further filtered using the dashboard prompts. The chart allows for further drill down to the top cities for the given state by clicking the various sections in the chart.

Figure 9-72 Top Five Churners by State

Description of Figure 9-72 follows
Description of ''Figure 9-72 Top Five Churners by State''

The report in Figure 9-73 shows the bottom five states in the US with the lowest number of subscribers that have churned. This chart can be further filtered using the dashboard prompts. The chart allows for further drill down to the top cities for the given state by clicking the various bars in the chart.

Figure 9-73 Bottom Five Churners by State

Description of Figure 9-73 follows
Description of ''Figure 9-73 Bottom Five Churners by State''

The report in Figure 9-74 shows a table view of the total number of subscribers that have churned by state and by customer type, along with comparisons to the previous year and the year-over-year percent change.

Figure 9-74 Churn Detail Report

Description of Figure 9-74 follows
Description of ''Figure 9-74 Churn Detail Report''

Prepaid Metrics Reports

The prepaid metrics reports show details for prepaid-specific metrics such as total, average recharges, and disturbed recharge cycles.

Recharges Reports

The report in Figure 9-75 shows the total number of recharges per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-75 Prepaid Metrics Total Number of Recharges

Description of Figure 9-75 follows
Description of ''Figure 9-75 Prepaid Metrics Total Number of Recharges''

The report in Figure 9-76 shows the total monetary value of recharges per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-76 Prepaid Metrics Total Amount of Recharges

Description of Figure 9-76 follows
Description of ''Figure 9-76 Prepaid Metrics Total Amount of Recharges''

The report in Figure 9-77 shows a table view of the total number of recharges and the monetary value of the recharges per year. Users can make use dashboard prompts to further filter the data.

Figure 9-77 Prepaid Metrics Total Recharges

Description of Figure 9-77 follows
Description of ''Figure 9-77 Prepaid Metrics Total Recharges''

Prepaid Customer Base Reports

The report in Figure 9-78 shows the total number of active prepaid customers per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-78 Prepaid Customer Base Active Customers Report

Description of Figure 9-78 follows
Description of ''Figure 9-78 Prepaid Customer Base Active Customers Report''

The report in Figure 9-79 shows the total number of inactive prepaid customers per month (that is, have a positive prepaid balance, but have had no usage activity for a period). Use the slide bar and dashboard prompts to further filter the data.

Figure 9-79 Prepaid Customer Base Inactive Customers Report

Description of Figure 9-79 follows
Description of ''Figure 9-79 Prepaid Customer Base Inactive Customers Report''

The report in Figure 9-80 shows a table view of active and inactive prepaid customers with positive balances, and customers with a zero balance. The results are shown per year and per quarter. Users can make use dashboard prompts to further filter the data.

Figure 9-80 Prepaid Customer Base Total Customers Report

Description of Figure 9-80 follows
Description of ''Figure 9-80 Prepaid Customer Base Total Customers Report''

Account Recharge

The report in Figure 9-81 shows both a graph and table view of the count of subscribers recharging their prepaid accounts within a specific number of days. The graph view shows results by customer type, and the table view shows results by customer type and product type. Users can make use dashboard prompts to further filter the data.

Figure 9-81 Prepaid Metrics Account Recharge Report

Description of Figure 9-81 follows
Description of ''Figure 9-81 Prepaid Metrics Account Recharge Report''

Disturbed Recharge

The report in Figure 9-82 shows a table view of customers with disturbed recharge cycles, meaning the last time they recharged their account is greater than their typical recharge pattern. The table shows the number of days since their last recharge, the number of disturbed recharge days (that is, days over their typical pattern), and the percent disturbance. In addition to day counts, the table shows the monetary value of the customer's last recharge and amount for the last three months.

Figure 9-82 Prepaid Metrics Disturbed Recharge Report

Description of Figure 9-82 follows
Description of ''Figure 9-82 Prepaid Metrics Disturbed Recharge Report''

Usage Revenue Reports

The usage revenue reports provide usage specific metrics such as the total minutes of usage, number of calls, top and users (voice, data, SMS and MMS).

Voice Usage

The report in Figure 9-83 shows the total number of voice calls (inbound and outbound) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-83 Usage Revenue Voice Usage Total Number of Calls

Description of Figure 9-83 follows
Description of ''Figure 9-83 Usage Revenue Voice Usage Total Number of Calls''

The report in Figure 9-84 shows the total number of minutes used for voice calls (inbound and outbound) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-84 Usage Revenue Voice Usage Total Minutes of Use

Description of Figure 9-84 follows
Description of ''Figure 9-84 Usage Revenue Voice Usage Total Minutes of Use''

The report in Figure 9-85 shows the total number of voice roaming calls (inbound and outbound) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-85 Usage Revenue Voice Usage Total Number of Calls (Roaming)

Description of Figure 9-85 follows
Description of ''Figure 9-85 Usage Revenue Voice Usage Total Number of Calls (Roaming)''

The report in Figure 9-86 shows the total number of minutes used for voice roaming calls (inbound and outbound) per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-86 Usage Revenue Voice Usage Total Minutes of Use (Roaming)

Description of Figure 9-86 follows
Description of ''Figure 9-86 Usage Revenue Voice Usage Total Minutes of Use (Roaming)''

The report in Figure 9-87 shows the total number roaming and nonroaming voice calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-87 Usage Revenue Voice Usage Number of Calls (Roaming versus Nonroaming)

Description of Figure 9-87 follows
Description of ''Figure 9-87 Usage Revenue Voice Usage Number of Calls (Roaming versus Nonroaming)''

The report in Figure 9-88 shows the total number of minutes used for roaming and nonroaming voice calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-88 Usage Revenue Minutes of Use (Roaming versus Nonroaming)

Description of Figure 9-88 follows
Description of ''Figure 9-88 Usage Revenue Minutes of Use (Roaming versus Nonroaming)''

The report in Figure 9-89 shows the total number of on-net versus off-net voice calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-89 Usage Revenue Voice Usage On Net versus Off Net

Description of Figure 9-89 follows
Description of ''Figure 9-89 Usage Revenue Voice Usage On Net versus Off Net''

Voice Usage Revenue

The report in Figure 9-90 shows the total amount of usage revenue associated with voice calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-90 Voice Usage Revenue Total Usage Revenue

Description of Figure 9-90 follows
Description of ''Figure 9-90 Voice Usage Revenue Total Usage Revenue''

The report in Figure 9-91 shows the total amount of usage revenue associated with voice roaming calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-91 Voice Usage Revenue Roaming Usage Revenue

Description of Figure 9-91 follows
Description of ''Figure 9-91 Voice Usage Revenue Roaming Usage Revenue''

The report in Figure 9-92 shows the total amount of usage revenue associated with international versus local calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-92 Voice Usage Revenue by Distance

Description of Figure 9-92 follows
Description of ''Figure 9-92 Voice Usage Revenue by Distance''

The report in Figure 9-93 shows the total number of minutes associated with international versus local calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-93 Voice Usage Revenue Total Minutes by Distance

Description of Figure 9-93 follows
Description of ''Figure 9-93 Voice Usage Revenue Total Minutes by Distance''

The report in Figure 9-94 shows the average usage revenue per minute of use for voice calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-94 Voice Usage Revenue Average Revenue per Minute of Use

Description of Figure 9-94 follows
Description of ''Figure 9-94 Voice Usage Revenue Average Revenue per Minute of Use''

The report in Figure 9-95 shows the total amount of usage revenue for on-net versus off-net calls per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-95 Voice Usage Revenue On Net versus Off Net

Description of Figure 9-95 follows
Description of ''Figure 9-95 Voice Usage Revenue On Net versus Off Net''

Data Usage

The report in Figure 9-96 shows the total amount of data usage per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-96 Data Usage Total Data Usage

Description of Figure 9-96 follows
Description of ''Figure 9-96 Data Usage Total Data Usage''

The report in Figure 9-97 shows the total amount of data usage revenue per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-97 Data Usage Total Data Revenue

Description of Figure 9-97 follows
Description of ''Figure 9-97 Data Usage Total Data Revenue''

SMS Usage

The report in Figure 9-98 shows the total amount of SMS revenue per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-98 SMS Usage Total SMS Revenue

Description of Figure 9-98 follows
Description of ''Figure 9-98 SMS Usage Total SMS Revenue''

The report in Figure 9-99 shows the total number of SMS messages sent per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-99 SMS Usage Total SMS Usage

Description of Figure 9-99 follows
Description of ''Figure 9-99 SMS Usage Total SMS Usage''

MMS Usage

The report in Figure 9-100 shows the total amount of MMS usage revenue per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-100 MMS Usage Total MMS Revenue

Description of Figure 9-100 follows
Description of ''Figure 9-100 MMS Usage Total MMS Revenue''

The report in Figure 9-101 shows the total number of MMS messages sent per month. Use the slide bar and dashboard prompts to further filter the data.

Figure 9-101 MMS Usage Total MMS Usage

Description of Figure 9-101 follows
Description of ''Figure 9-101 MMS Usage Total MMS Usage''