Skip Headers
Oracle® Communications Data Model Reference
11g Release 2 (11.2)

Part Number E15886-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

12 Oracle Communications Data Model Sample Reports

This chapter provides Oracle Communications Data Model sample reports.

This chapter includes the following sections:

Note:

The reports and dashboards shown in the examples in this chapter and delivered with Oracle Communications Data Model are provided only for demonstration purposes. These sample reports and dashboards are not supported by Oracle.

Cost and Contribution Sample Reports

The cost and contribution sample reports include the following areas: Operational Finance Analysis and Profitability Analysis.

This area includes the following reports:

Operational Finance Analysis

Operating Cost

This report, as shown in Figure 12-1 provides the current year month-level "Operating Cost" information based on "Organization Parent" which internally can be compared with last years metrics like LY,% Change LY, YTD, YTD LY, YTD % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-1 Operating Cost Sample Report

Description of Figure 12-1 follows
Description of "Figure 12-1 Operating Cost Sample Report"

Investment Cost

This report, as shown in Figure 12-2 provides the current year month-level "Investment Cost" information based on "Organization Parent" which internally can be compared with last years metrics like LY,% Change LY, YTD, YTD LY, YTD % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-2 Investment Cost Sample Report

Description of Figure 12-2 follows
Description of "Figure 12-2 Investment Cost Sample Report"

Advertising Cost

This report, as shown in Figure 12-3 provides the current year month-level "Advertising Cost" information based on "Organization Parent" which internally can be compared with last years metrics like LY,% Change LY, YTD, YTD LY, YTD % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-3 Advertising Cost Sample Report

Description of Figure 12-3 follows
Description of "Figure 12-3 Advertising Cost Sample Report"

Average Operating Cost per Customer

This report, as shown in Figure 12-4 provides the current year month-level "Average Operating Cost" information based on "Organization" and "Customer" which internally can be compared with last years metrics like LY,% Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-4 Average Operating Cost per Customer Sample Report

Description of Figure 12-4 follows
Description of "Figure 12-4 Average Operating Cost per Customer Sample Report"

Profitability Analysis

Total Profit

This report, as shown in Figure 12-5 provides the current year and month-level "Total Profit" information based on "Organization" which internally can be compared with last years metrics like LY,% Change LY, YTD, YTD LY, YTD % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-5 Total Profit Sample Report

Description of Figure 12-5 follows
Description of "Figure 12-5 Total Profit Sample Report"

Average Profit per Customer

This report, as shown in Figure 12-6 provides the current year and month-level "Average Profit" information based on "Customer" and "Customer by Product" which internally can be compared with metrics such as LY, % Change LY for last year.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Customer Type

Figure 12-6 Average Profit per Customer Sample Report

Description of Figure 12-6 follows
Description of "Figure 12-6 Average Profit per Customer Sample Report"

Inventory Out-of-Stock (Handset Model)

This report, as shown in Figure 12-7 provides the current month and year inventory stock information and forecast the requirements of the inventory item for future months. This report provides a good understanding of the potential out-of-stock situation and helps provider managing the inventory stock much more effectively. Here we are taking the example of Handset Mobile as inventory item.

Report dimensions are:

  • Business Time

  • Organization

  • Sales Channel

  • Handset Model

Figure 12-7 Inventory Out-of-Stock (Handset Model) Sample Report

Description of Figure 12-7 follows
Description of "Figure 12-7 Inventory Out-of-Stock (Handset Model) Sample Report"

Customer Management Sample Reports

The customer management sample reports include the following areas: Customer Churn Analysis, Customer Growth Rate, Customer Acquisition, Customer Segmentation, Customer Churn Prediction, and Customer Future Life Time Value.

Customer Churn Analysis

Customer Churn Rate

This report, as shown in Figure 12-8 provides year-level churn rate information of an organization based on Customer type.

Report dimensions are:

  • Organization

  • Business Time

  • Customer

Figure 12-8 Customer Churn Rate Sample Report

Description of Figure 12-8 follows
Description of "Figure 12-8 Customer Churn Rate Sample Report"

Customer Churn Statistics

This report, as shown in Figure 12-9 provides year-level subscription performance based on churn statistics relating to a Customer, such as high churn rate analysis for a subscription, and so on. Oracle Communications Data Model provides certain operational measures such as forecasting, prediction, and so on, to over come this problem.

Report dimensions are:

  • Organization

  • Business Time

  • Customer

Figure 12-9 Customer Churn Statistics Sample Report

Description of Figure 12-9 follows
Description of "Figure 12-9 Customer Churn Statistics Sample Report"

Churn Reason Distribution

This report, as shown in Figure 12-10 identifies the year level basic top reason that leads the customers to move out of the service providers. It also gives the flexibility to compare the same with last year predictions. Thus it gives the service providers to take the necessary steps out to overcome the so identified reasons.

Report dimensions are:

  • Business Time

  • Churn Reason

Figure 12-10 Churn Reason Distribution Sample Report

Description of Figure 12-10 follows
Description of "Figure 12-10 Churn Reason Distribution Sample Report"

Churn Outlier by Site (Building)

This report, as shown in Figure 12-11 demonstrates statistically significant anomalies in churn rate for network sites at the lowest possible level (for example building) This can help identify problem area domains and facilitates further drill down to identify the cause of the problems (network problems, and other problems) and take remedial actions to prevent churns.

Report dimensions are:

  • Business Time

  • Geography

  • Product Market Plan

Figure 12-11 Churn Outlier by Site (Building) Sample Report

Description of Figure 12-11 follows
Description of "Figure 12-11 Churn Outlier by Site (Building) Sample Report"

Churn Outlier by Sales Agent

This report, as shown in Figure 12-12 demonstrates statistically significant anomalies in churn rate by the call center or sales agents (for example which call center agents record maximum churn) This can help identify problem area domains and facilitates further drill down to identify the cause of the problems (network problems and other problems) and take remedial actions to prevent churns. Actions could be further training or education to the agents, empowering them to offer additional incentives or discounts. It helps the service providers identifying the correct sales representative agents in promoting the plans to the customers in much more efficient ways.

Report dimensions are:

  • Business Time

  • Organization

  • Product Market Plan

  • Sales Channel Representative

Figure 12-12 Churn Outlier by Sales Agent Sample Report

Description of Figure 12-12 follows
Description of "Figure 12-12 Churn Outlier by Sales Agent Sample Report"

Churn Prediction List

This report, as shown in Figure 12-13 identifies the patterns of customers churning (leaving) based on information such as customer demographic information, service quality, last tariff plan, calling usage, and other factors. Based on these patterns, the report helps to predict customers who are mostly like to churn in coming months. With these predictions, operators can initiate certain retention programs to reduce the customer churn rate.

Report dimensions are:

  • Business Time

  • Organization

  • Customer

Figure 12-13 Churn Prediction List Sample Report

Description of Figure 12-13 follows
Description of "Figure 12-13 Churn Prediction List Sample Report"

Churn Factor Rank

This report, as shown in Figure 12-14 can help operator to understand which attribute is more important in determining customer churning pattern. This chart can help marketing people to understand customer better and make better campaign strategy.

Report dimensions are:

  • Churn SVM ROC

Figure 12-14 Churn Factor Rank Sample Report

Description of Figure 12-14 follows
Description of "Figure 12-14 Churn Factor Rank Sample Report"

Customer Growth Rate

Customer Growth Rate

This report, as shown in Figure 12-15 provides the yearly and monthly customer count and revenue growth rate over products and geographical boundaries

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Geography

Figure 12-15 Customer Growth Rate Sample Report

Description of Figure 12-15 follows
Description of "Figure 12-15 Customer Growth Rate Sample Report"

Customer Growth Trend Forecast

This report, as shown in Figure 12-16 provides the yearly and monthly customer count and revenue growth trend over products and geographical boundaries.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Geography

Figure 12-16 Customer Growth Trend Forecast Sample Report

Description of Figure 12-16 follows
Description of "Figure 12-16 Customer Growth Trend Forecast Sample Report"

Customer Acquisition

Customer Acquisition

This report, as shown in Figure 12-17 provides the yearly and monthly customers count to be acquired compared with actual customers acquired by product and with respective to customers type.

Report dimensions are:

  • Business Time

  • Product

  • Customer

Figure 12-17 Customer Acquisition Sample Report

Description of Figure 12-17 follows
Description of "Figure 12-17 Customer Acquisition Sample Report"

Customer Acquisition Forecast

This report, as shown in Figure 12-18 provides the yearly and monthly level forecasting of customers count to be acquired versus the actual customers acquired by product market plan and with respective to customers type.

Report dimensions are:

  • Business Time

  • Product

  • Customer Type

  • Product Market Plan

Figure 12-18 Customer Acquisition Forecast Sample Report

Description of Figure 12-18 follows
Description of "Figure 12-18 Customer Acquisition Forecast Sample Report"

Customer Segmentation

Customer Segments

This report, as shown in Figure 12-19, shows customer segments. Customer segmentation can help understanding the current customer base. Traditionally, telecom operator can only group the customers by certain dimensions like Geography, Age, and so on. However, some customer from completely different background may show similar behaviors like High Local call users, Business Type user, Entertainment centric users, and so on.

Customer segmentation model can group customers into generally homogeneous groups based on customer demographic information, usage pattern and list of telecom products they subscribe to (customer subscriber history). Business Analysts can look into each segment to further understand the customer group discovered by the model and name each segments.

Note: This groups all the customers, not only churners.

Report dimensions are:

  • Customer

Figure 12-19 Customer Segments Sample Report

Description of Figure 12-19 follows
Description of "Figure 12-19 Customer Segments Sample Report"

Customer Segmentation Details

This report, as shown in Figure 12-20 provides the customer segmentation details on basis of certain customer statistical metrics such as contract value, month revenue, debt value and so on.

Report dimensions are:

  • Customer

Figure 12-20 Customer Segmentation Details Sample Report

Description of Figure 12-20 follows
Description of "Figure 12-20 Customer Segmentation Details Sample Report"

Customer Churn Prediction

Customer Churn Prediction by Revenue Band

This report, as shown in Figure 12-21 predicts the customer churn by revenue band. It simply means which revenue groups are more likely to churn than others. It provides details like total customer ARPU, monthly revenue, debt value and all.

Report dimensions are:

  • ARPU Band

Figure 12-21 Customer Churn Prediction by Revenue Band Sample Report

Description of Figure 12-21 follows
Description of "Figure 12-21 Customer Churn Prediction by Revenue Band Sample Report"

Retention Cumulative Gain

This report, as shown in Figure 12-22 provides how to retain the customer with the service provider. Oracle Communications Data Model will help the service providers in analyzing this kind of customers by certain threshold calculated measures. Then service provider can do certain retention programs for each customer so identified. This retention can be done through phone calls or by email.

The chart here shows the accuracy of customers so identified under retention program prediction rather than picking on random selection of customers.

Report dimensions are:

  • Churn SVM ROC

Figure 12-22 Retention Cumulative Gain Sample Report

Description of Figure 12-22 follows
Description of "Figure 12-22 Retention Cumulative Gain Sample Report"

Customer Future Life Time Value

Customer Future LTV

This report, as shown in Figure 12-23 provides the grouped predicted churners LTV (Life Time Value) by LTV Band Code.

Report dimensions are:

  • Customer

  • Customer Mining

Figure 12-23 Customer Future LTV Sample Report

Description of Figure 12-23 follows
Description of "Figure 12-23 Customer Future LTV Sample Report"

Customer by Life Time Value Band

This report, as shown in Figure 12-24 provides the value bought in by the regression model to the service provider, that is, the customers likely to be with the service provider compared with the customers already left the service provider. Thus by this the service provider can assess the LTV (Life Time Value) of an customer.

Report dimensions are:

  • Customer

  • Customer Mining

Figure 12-24 Customer by Life Time Value Band Sample Report

Description of Figure 12-24 follows
Description of "Figure 12-24 Customer by Life Time Value Band Sample Report"

Customer by Life Time Span Category

This report, as shown in Figure 12-25 provides the customer life time span with the service provider by certain statistical metrics such as average life time span months, total month revenue, contract ARPU, and so on.

Report dimensions are:

  • Customer

  • Customer Mining

Figure 12-25 Customer by Life Time Span Category Sample Report

Description of Figure 12-25 follows
Description of "Figure 12-25 Customer by Life Time Span Category Sample Report"

Customer Life Time Span Detail

This report, as shown in Figure 12-26 provides the Customer life time span with the service provider in detail.

Report dimensions are:

  • Customer

  • Customer Mining

Figure 12-26 Customer Life Time Span Detail Sample Report

Description of Figure 12-26 follows
Description of "Figure 12-26 Customer Life Time Span Detail Sample Report"

Marketing Sample Reports

The marketing area sample reports include the following areas: Targeted Promotion and Current Customer Base Analysis.

Targeted Promotion

Customer Promotion List

This report, as shown in Figure 12-27 provides list of customer promotion based on life time value of a customer and Debt value measures, for one or more customers.

Report dimensions are:

  • Customer

Figure 12-27 Customer Promotion List Sample Report

Description of Figure 12-27 follows
Description of "Figure 12-27 Customer Promotion List Sample Report"

Customer Life Time Span Detail

This report, as shown in Figure 12-28 provides month-level transaction activity information based on customer life time span measures, for one or more customers.

Report dimensions are:

  • Customer

Figure 12-28 Customer Life Time Span Detail Sample Report

Description of Figure 12-28 follows
Description of "Figure 12-28 Customer Life Time Span Detail Sample Report"

Customer by Life Time Span Category

This report, as shown in Figure 12-29 provides month-level transaction activity information based on customer life time span measures, for one or more customers.

Report dimensions are:

  • Customer

Figure 12-29 Customer by Life Time Span Category Sample Report

Description of Figure 12-29 follows
Description of "Figure 12-29 Customer by Life Time Span Category Sample Report"

Customer by Life Time Value Band

This report, as shown in Figure 12-30 predicts customer churn probability based on churn probability measures, for different customers. It buckets results according to Customer Life Time Value (LTV) band. Customer lifetime value represents exactly how much each customer is worth in monetary terms, and therefore exactly how much a marketing department should be willing to spend to acquire each customer.

Report dimensions are:

  • Customer

Figure 12-30 Customer by Life Time Value Band Sample Report

Description of Figure 12-30 follows
Description of "Figure 12-30 Customer by Life Time Value Band Sample Report"

Life Time Value (LTV)

This report, as shown in Figure 12-31 shows life time value of a customer. Customer lifetime value has intuitive appeal as a marketing concept, because in theory it represents exactly how much each customer is worth in monetary terms, and therefore exactly how much a marketing department should be willing to spend to acquire each customer. Customer relationships are often divided into two categories. In contractual or retention situations, customers who do not renew are considered "lost for good". In customer migration situations, a customer who does not buy (in a given period or from a given catalog) is still considered a customer of the firm because she may very well buy at some point in the future. In customer retention situations, the firm knows when the relationship is over. One of the challenges for firms in customer migration situations is that the firm may not know when the relationship is over (as far as the customer is concerned).

Report dimensions are:

  • Customer

Figure 12-31 Life Time Value (LTV) Sample Report

Description of Figure 12-31 follows
Description of "Figure 12-31 Life Time Value (LTV) Sample Report"

Customer Market Share

This report, as shown in Figure 12-32 shows month-level Customer Market share capture analysis.

Report dimensions are:

  • Business Time

  • Organization

  • Product

Figure 12-32 Customer Market Share Sample Report

Description of Figure 12-32 follows
Description of "Figure 12-32 Customer Market Share Sample Report"

Current Customer Base Analysis

Current Customer Base

This report, as shown in Figure 12-33 provides month-level transaction activity information based on no of customer measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Geography

Figure 12-33 Current Customer Base Sample Report

Description of Figure 12-33 follows
Description of "Figure 12-33 Current Customer Base Sample Report"

Customer Base Organization Share

This report, as shown in Figure 12-34 provides month-level transaction activity information based on no of customer measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-34 Customer Base Organization Share Sample Report

Description of Figure 12-34 follows
Description of "Figure 12-34 Customer Base Organization Share Sample Report"

Customer Base Product Share

This report, as shown in Figure 12-35 provides month-level transaction activity information based on network capacity measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Product

Figure 12-35 Customer Base Product Share Sample Report

Description of Figure 12-35 follows
Description of "Figure 12-35 Customer Base Product Share Sample Report"

Network Sample Reports

The network area sample reports include the following areas: Network Analysis, Network Health Analysis.

Network Analysis

Network Capacity

This report, as shown in Figure 12-36 provides month-level transaction activity information based on network capacity measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Geography

  • Network Element

Figure 12-36 Network Capacity Sample Report

Description of Figure 12-36 follows
Description of "Figure 12-36 Network Capacity Sample Report"

Minutes of Usage

This report, as shown in Figure 12-37 provides month-level transaction activity information based on call duration measures, for one or more time slots.

Report dimensions are:

  • Business Time

  • Network Element

Figure 12-37 Minutes of Usage Sample Report

Description of Figure 12-37 follows
Description of "Figure 12-37 Minutes of Usage Sample Report"

Airtime per Subscription

This report, as shown in Figure 12-38 provides month-level transaction activity information based on airtime per subscription connection measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Peak Off peak Time

Figure 12-38 Airtime per Subscription Sample Report

Description of Figure 12-38 follows
Description of "Figure 12-38 Airtime per Subscription Sample Report"

Load During Busy Hours

This report, as shown in Figure 12-39 provides month-level transaction activity information based on calls count during busy hours measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Peak Off peak Time

Figure 12-39 Load During Busy Hours Sample Report

Description of Figure 12-39 follows
Description of "Figure 12-39 Load During Busy Hours Sample Report"

Network Health Analysis

Traffic by Connection

This report, as shown in Figure 12-40 provides month-level transaction activity information based on traffic by connection measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Peak Off peak Time

Figure 12-40 Traffic by Connection Sample Report

Description of Figure 12-40 follows
Description of "Figure 12-40 Traffic by Connection Sample Report"

Connection per Site

This report, as shown in Figure 12-41 provides month-level transaction activity information based on subscriptions per channel measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

Figure 12-41 Connection per Site Sample Report

Description of Figure 12-41 follows
Description of "Figure 12-41 Connection per Site Sample Report"

Dropped Call Rate

This report, as shown in Figure 12-42 provides month-level transaction activity information based on dropped call rate measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

Figure 12-42 Dropped Call Rate Sample Report

Description of Figure 12-42 follows
Description of "Figure 12-42 Dropped Call Rate Sample Report"

Call Failure Rate

This report, as shown in Figure 12-43 provides month-level transaction activity information based on network congestion measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

Figure 12-43 Call Failure Rate Sample Report

Description of Figure 12-43 follows
Description of "Figure 12-43 Call Failure Rate Sample Report"

Congestion

This report, as shown in Figure 12-44 provides month-level transaction activity information based on end of period cell offered erlangs measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Time Slot

  • Peak Offpeak Time

Figure 12-44 Congestion Sample Report

Description of Figure 12-44 follows
Description of "Figure 12-44 Congestion Sample Report"

Total Traffic Versus Offered Erlangs

This report, as shown in Figure 12-45 provides month-level transaction activity information based on end of period cell offered erlangs measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Time Slot

  • Peak Offpeak Time

Figure 12-45 Total Traffic Versus Offered Erlangs Sample Report

Description of Figure 12-45 follows
Description of "Figure 12-45 Total Traffic Versus Offered Erlangs Sample Report"

Connection by Geography

This report, as shown in Figure 12-46 provides month-level transaction activity information based on connections measures, for one or more location.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Peak Offpeak Time

Figure 12-46 Connection by Geography Sample Report

Description of Figure 12-46 follows
Description of "Figure 12-46 Connection by Geography Sample Report"

Connection by Voice Channel

This report, as shown in Figure 12-47 provides month-level transaction activity information based on connections by voice channel measures, for one or more location. This report shows will be used to collect most of the cell parameters.

Report dimensions are:

  • Business Time

  • Network Element

  • Geography

  • Peak Offpeak Time

Figure 12-47 Connection by Voice Channel Sample Report

Description of Figure 12-47 follows
Description of "Figure 12-47 Connection by Voice Channel Sample Report"

Partner Management Sample Reports

The partner management sample reports include the following areas: Roaming Partner Settlement, Churn Outliner by Partner, Partner Content Sales, Track Dealer Performance, and External Debt Collection.

Roaming Partner Settlement

Roaming Partner Settlement Summary

This report, as shown in Figure 12-48 provides month-level transaction activity information based on partner settlement measures, for one or more location. This report shows summary over financial settlement activities happened to partners.

Report dimensions are:

  • Business Time

  • Geography

  • Billing Cycle

  • Event Type

  • Account

  • Party

  • Contract

Figure 12-48 Roaming Partner Settlement Summary Sample Report

Description of Figure 12-48 follows
Description of "Figure 12-48 Roaming Partner Settlement Summary Sample Report"

Churn Outliner by Partner

Churn Outliner by Partner

This report, as shown in Figure 12-49 demonstrates statistically significant anomalies in churn rate by sales channel or partners (for example which channel records maximum churn) This can help identify problem area domains and facilitates further drill down to identify the cause of the problems (network problems and other problems) and take remedial actions to prevent churns. Actions could be further training or education to the partners, empowering them to offer additional incentives or discounts

Report dimensions are:

  • Business Time

  • Sales Channel

Figure 12-49 Churn Outliner by Partner Sample Report

Description of Figure 12-49 follows
Description of "Figure 12-49 Churn Outliner by Partner Sample Report"

Partner Content Sales

Partner Content Sales

This report, as shown in Figure 12-50 provides month-level transaction activity information based on data usage measures, for one or more content.

Report dimensions are:

  • Business Time

  • Content Type

Figure 12-50 Partner Content Sales Sample Report

Description of Figure 12-50 follows
Description of "Figure 12-50 Partner Content Sales Sample Report"

Track Dealer Performance

Track Dealer Commission and Performance

This report, as shown in Figure 12-51 gives the month level Dealer performance and commission generated base on a product.

Report dimensions are:

  • Business Time

  • Commission Type

  • Product

Figure 12-51 Track Dealer Commission and Performance Sample Report

Description of Figure 12-51 follows
Description of "Figure 12-51 Track Dealer Commission and Performance Sample Report"

External Debt Collection

External Debt Collection

This report, as shown in Figure 12-52 gives month level debt collected for the services usage done by the customers through third part channels like banks and so on.

Report dimensions are:

  • Business Time

  • Collection Agency

  • Organization

Figure 12-52 External Debt Collection Sample Report

Description of Figure 12-52 follows
Description of "Figure 12-52 External Debt Collection Sample Report"

Product Management Sample Reports

The product management sample reports include the following area: Product Management.

Product Management

Product Performance

This report, as shown in Figure 12-53 provides year-level transaction activity information based on total bill amount measures, for one or more products.

Report dimensions are:

  • Business Time

  • Product

Figure 12-53 Product Performance Sample Report

Description of Figure 12-53 follows
Description of "Figure 12-53 Product Performance Sample Report"

Total Profit

This report, as shown in Figure 12-54 provides month-level transaction activity information based on total profit measures, for one or more stores.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-54 Total Profit Sample Report

Description of Figure 12-54 follows
Description of "Figure 12-54 Total Profit Sample Report"

Average Profit per Customer

This report, as shown in Figure 12-55 provides month-level transaction activity information based on average profit per customer measures, for one or more stores.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Customer

Figure 12-55 Average Profit per Customer Sample Report

Description of Figure 12-55 follows
Description of "Figure 12-55 Average Profit per Customer Sample Report"

Provisioning and Service Sample Reports

The provisioning and service sample reports show the following area: Network Usage.

Network Usage

Number of 911 Calls

This report, as shown in Figure 12-56 provides year-level transaction activity information based on no of international calls measures, for one or more stores.

Report dimensions are:

  • Organization

  • Business Time

  • Customer

  • Product

  • Call Service Type

  • Call Routing Type

Figure 12-56 Number of 911 Calls Sample Report

Description of Figure 12-56 follows
Description of "Figure 12-56 Number of 911 Calls Sample Report"

Number of Calls by Call Category

This report, as shown in Figure 12-57 provides year-level transaction activity information based on no of calls measures, for different types of call category.

Report dimensions are:

  • Business Time

  • Call Category

Figure 12-57 Number of Calls by Call Category Sample Report

Description of Figure 12-57 follows
Description of "Figure 12-57 Number of Calls by Call Category Sample Report"

Number of Calls by Call Service Type

This report, as shown in Figure 12-58 provides year-level transaction activity information based on no of calls measures, for different types of call services.

Report dimensions are:

  • Business Time

  • Call Service Type

Figure 12-58 Number of Calls by Call Service Type Sample Report

Description of Figure 12-58 follows
Description of "Figure 12-58 Number of Calls by Call Service Type Sample Report"

Number of Calls by Routing Type

This report, as shown in Figure 12-59 provides year-level transaction activity information based on no of calls measures, for different types of call routing.

Report dimensions are:

  • Business Time

  • Call Routing Type

Figure 12-59 Number of Calls by Routing Type Sample Report

Description of Figure 12-59 follows
Description of "Figure 12-59 Number of Calls by Routing Type Sample Report"

Minutes of Usage by Call Type

This report, as shown in Figure 12-60 is the combination of three reports. This report provides month-level transaction activity information based on Avg Local, National, International Minutes Usage/ Day measures, for one or more stores.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Customer

Figure 12-60 Minutes of Usage by Call Type Sample Report

Description of Figure 12-60 follows
Description of "Figure 12-60 Minutes of Usage by Call Type Sample Report"

Revenue Sample Reports

The revenue sample reports show the following areas: Revenue Analysis, Sales Analysis, Debt Collection, and Revenue Assurance.

Revenue Analysis

EBITDA

This report, as shown in Figure 12-61 provides month-level transaction activity information based on EBITDA measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Customer Type

  • Product

  • Geography

  • Organization

Figure 12-61 EBITDA Sample Report

Description of Figure 12-61 follows
Description of "Figure 12-61 EBITDA Sample Report"

ARPU

This report, as shown in Figure 12-62 provides month-level transaction activity information based on ARPU measures, for one or more stores and this is a calculation often used to determine the overall value of an application. This report used to generate revenue for a particular customer by comparing someone's account to the overall average.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-62 ARPU Sample Report

Description of Figure 12-62 follows
Description of "Figure 12-62 ARPU Sample Report"

Refund to Customer

This report, as shown in Figure 12-63 provides month-level transaction activity information based on refund amount measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Customer Type

  • Geography

  • Organization

Figure 12-63 Refund to Customer Sample Report

Description of Figure 12-63 follows
Description of "Figure 12-63 Refund to Customer Sample Report"

Monthly Revenue

This report, as shown in Figure 12-64 provides month-level transaction activity information based on revenue measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Customer Type

  • Product

  • Geography

  • Organization

Figure 12-64 Monthly Revenue Sample Report

Description of Figure 12-64 follows
Description of "Figure 12-64 Monthly Revenue Sample Report"

Revenue Forecast

This report, as shown in Figure 12-65 provides month-level transaction activity information based on revenue measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Customer Type

  • Product

  • Geography

  • Organization

Figure 12-65 Revenue Forecast Sample Report

Description of Figure 12-65 follows
Description of "Figure 12-65 Revenue Forecast Sample Report"

Product EBITDA Share

This report, as shown in Figure 12-66 provides month-level transaction activity information based on earning before income tax depreciation (EBITDA) measures, for one or more product.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-66 Product EBITDA Share Sample Report

Description of Figure 12-66 follows
Description of "Figure 12-66 Product EBITDA Share Sample Report"

Sales Analysis

Sales

This report, as shown in Figure 12-67 provides month-level transaction activity information based on sales measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Product

  • Geography

Figure 12-67 Sales Sample Report

Description of Figure 12-67 follows
Description of "Figure 12-67 Sales Sample Report"

Gross Sales

This report, as shown in Figure 12-68 provides month-level transaction activity information based on gross sales measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Product

  • Geography

Figure 12-68 Gross Sales Sample Report

Description of Figure 12-68 follows
Description of "Figure 12-68 Gross Sales Sample Report"

Net Sales

This report, as shown in Figure 12-69 provides month-level transaction activity information based on net sales measures, for one or more locations.

Report dimensions are:

  • Business Time

  • Product

  • Geography

Figure 12-69 Net Sales Sample Report

Description of Figure 12-69 follows
Description of "Figure 12-69 Net Sales Sample Report"

Debt Collection

Debt Collector Assignment

This report, as shown in Figure 12-70 generate covering letters & detailed data for assignment to external debt collectors

Report dimensions are:

  • Business Time

  • Organization

  • Geography

  • Customer Type

  • Collection Agency

Figure 12-70 Debt Collector Assignment Sample Report

Description of Figure 12-70 follows
Description of "Figure 12-70 Debt Collector Assignment Sample Report"

Month-End Aging

This report, as shown in Figure 12-71 generates month level debt collected by collection agency based on debt collection band and customer type.

Report dimensions are:

  • Business Time

  • Organization

  • Debt Aging Band

  • Customer Type

  • Collection Agency

Figure 12-71 Month-End Aging Sample Report

Description of Figure 12-71 follows
Description of "Figure 12-71 Month-End Aging Sample Report"

Revenue Assurance

Revenue Assurance

This report, as shown in Figure 12-72 try to figure out how best to assure that all of the revenue earned.

Report dimensions are:

  • Business Time

  • Organization

  • Product Market Plan

  • Geography

Figure 12-72 Revenue Assurance Sample Report

Description of Figure 12-72 follows
Description of "Figure 12-72 Revenue Assurance Sample Report"

Adjustment to Customer Account

This report, as shown in Figure 12-73 describe adjustment amount each customer type wise.

Report dimensions are:

  • Business Time

  • Organization

  • Invoice Adjustment Reason

  • Customer Type

  • Product

  • Promotion

  • Invoice Adjustment Type

  • Geography

Figure 12-73 Adjustment to Customer Account Sample Report

Description of Figure 12-73 follows
Description of "Figure 12-73 Adjustment to Customer Account Sample Report"

Refund to Customer

This report, as shown in Figure 12-74 provides refund amount to the customer.

Report dimensions are:

  • Business Time

  • Organization

  • Customer Type

  • Geography

Figure 12-74 Refund to Customer Sample Report

Description of Figure 12-74 follows
Description of "Figure 12-74 Refund to Customer Sample Report"

CDR Revenue Compared to Billed Revenue

This report, as shown in Figure 12-75 analyzes CDR Revenue and billed revenue for product.

Report dimensions are:

  • Business Time

  • Organization

  • Product

Figure 12-75 CDR Revenue Compared to Billed Revenue Sample Report

Description of Figure 12-75 follows
Description of "Figure 12-75 CDR Revenue Compared to Billed Revenue Sample Report"

Activated Lines

This report, as shown in Figure 12-76 shows number of Activation and Service orders with errors over the number of Activation and Service Orders.

Report dimensions are:

  • Business Time

  • Product

Figure 12-76 Activated Lines Sample Report

Description of Figure 12-76 follows
Description of "Figure 12-76 Activated Lines Sample Report"

Invoice Collected and Uncollected

This report, as shown in Figure 12-77 analyze Invoice Collected and Uncollected for each Month

Report dimensions are:

  • Business Time

  • Organization

  • Customer Type

  • Geography

  • Product

Figure 12-77 Invoice Collected and Uncollected Sample Report

Description of Figure 12-77 follows
Description of "Figure 12-77 Invoice Collected and Uncollected Sample Report"

Debt Aging

This report, as shown in Figure 12-78 generate overdue details for customer in relate to different aging, marketing plans, and so on.

Report dimensions are:

  • Business Time

  • Organization

  • Debt Aging Band

  • Customer Type

  • Collection Agency

Figure 12-78 Debt Aging Sample Report

Description of Figure 12-78 follows
Description of "Figure 12-78 Debt Aging Sample Report"

Identify High Usage Customers

This report, as shown in Figure 12-79 shows Identify high usage customers who have exceeded their previous bills

Report dimensions are:

  • Business Time

  • Customer Type

Figure 12-79 Identify High Usage Customers Sample Report

Description of Figure 12-79 follows
Description of "Figure 12-79 Identify High Usage Customers Sample Report"

Minutes of Usage

This report, as shown in Figure 12-80 describes minutes of usage per customer.

Report dimensions are:

  • Business Time

  • Network Element

Figure 12-80 Minutes of Usage Sample Report

Description of Figure 12-80 follows
Description of "Figure 12-80 Minutes of Usage Sample Report"

Contract Sum of Future Plans

This report, as shown in Figure 12-81 shows Customer contract amount, remaining contract amount.

Report dimensions are:

  • Business Time

  • Customer Type

  • Geography

  • Product Market Plan

  • Organization

Figure 12-81 Contract Sum of Future Plans Sample Report

Description of Figure 12-81 follows
Description of "Figure 12-81 Contract Sum of Future Plans Sample Report"

Monthly Future Plan Drop-Out

This report, as shown in Figure 12-82 describes product market plan wise dropped contract amount and contract loss amount

Report dimensions are:

  • Business Time

  • Customer Type

  • Geography

  • Product Market Plan

Figure 12-82 Monthly Future Plan Drop-Out Sample Report

Description of Figure 12-82 follows
Description of "Figure 12-82 Monthly Future Plan Drop-Out Sample Report"

External Debt Collection

This report, as shown in Figure 12-83 shows collection agency wise Debit collected amount, waiving amount.

Report dimensions are:

  • Business Time

  • Organization

  • Collection Agency

Figure 12-83 External Debt Collection Sample Report

Description of Figure 12-83 follows
Description of "Figure 12-83 External Debt Collection Sample Report"

Track Dealer Commission and Performance

This report, as shown in Figure 12-84 provides Commission type wise commission amount and average revenue for a dealer.

Report dimensions are:

  • Business Time

  • Commission Type

  • Product

Figure 12-84 Track Dealer Commission and Performance Sample Report

Description of Figure 12-84 follows
Description of "Figure 12-84 Track Dealer Commission and Performance Sample Report"