Bookshelf: Metadata Requirements for Siebel CME Analytics Applications

This section covers data setup that needs to be done properly in the Siebel transactional database for it to be displayed accurately in Siebel Analytics.

Communications, Media and Energy (CME) industry-specific analytics dashboards and pages are shown in Table 32.

Table 32. Communications, Media and Energy Dashboards and Page Tabs
Dashboard	Page	Function
Loyalty Management	Customer Lifetime Value	Segments customers based upon defined ranges of scores predicting customer lifetime value.
	Churn Propensity	Segments customers based on defined ranges of scores estimating churn propensity.
	Selling Propensity	Segments customers based on defined ranges of scores valuing the potential of up-sell and cross-sell opportunities.
	Financial Risk	Segments customers based on defined ranges of scores predicting financial risk.
	Actual Churn	Shows trending of actual customer churn, and actual customer acquisition, over time.
Revenue Management	Revenue Trends	Charts trends of order revenue and order volume over time, and identifies top products based on order revenue and volume.
	Service Activations	Charts trends of service activations over time, and indicates top service activations based on order revenue and volume.
	Service Modifications	Charts trends of service modifications over time, and indicates top service modifications based on order revenue and volume.
	Service Disconnections	Charts trends of service disconnections over time, and identifies services with the highest disconnection volume.
Account Management	Sales Portal	Identifies top accounts, and related top products, based upon order revenue and order volume.
	Service Activations	Charts trends of account service activations, and indicates top accounts based on service activation performance metrics.
	Service Modifications	Charts trends of account service modifications, and indicates top accounts based on service modification performance metrics.
	Service Disconnections	Charts trends of account service disconnections, and identifies accounts with the highest volume of disconnections.
	Trouble Tickets	Provides trouble ticket trending charts, and performance indicators, for particular accounts, and for accounts with selected common characteristics.
	Customer Satisfaction	Provides customer satisfaction trending charts, and performance indicators, for particular accounts, and for accounts with selected common characteristics.

To support these industry-specific dashboards, Communications, Media and Energy (CME) Analytics contains corresponding industry-specific metadata. In the Siebel Analytics Server Administration Tool, industry-specific metadata is flagged with an icon picturing a telephone. Although this icon is visible in the Server Administration Tool, it is neither visible nor included within Siebel Answers. End users employ Siebel Answers to access metadata for building queries and reports. For users of Siebel Answers to view and access CME metadata columns, they must log in to Siebel using one of the CME responsibilities listed in Table 27. These responsibilities also determine what subject areas the user may access.

The data requirements for each of the Communications, Media and Energy dashboards are detailed in Table 33.

Table 33. Data Requirements for Communications, Media and Energy Dashboards
Dashboard	Function
Loyalty Management	This dashboard uses customer scores generated from any third-party predictive modeling application offering the following predictive models: Customer Lifetime Value, Churn Propensity, Up-Sell Propensity, Cross-Sell Propensity, and Financial Risk Propensity. Scores must be generated for each Siebel Account, integrated into the Siebel Transaction Database, and then written to the Siebel Data Warehouse. This dashboard uses the Siebel Analytics Customers subject area. See About Predictive Analytics Metadata for more information.
Revenue Management	This dashboard uses data generated by Siebel Communications, Media and Energy order management and interactive selling functionality. No specific data requirements are required beyond the data generated from these Siebel modules. This dashboard uses the Siebel Analytics Orders and Products subject areas.
Account Management	This dashboard uses data generated by Siebel Communications, Media and Energy order management, interactive selling, and service functionality. No specific data requirements are required beyond the data generated from these Siebel modules. This dashboard uses the Siebel Analytics Orders, Products, Service Request and Customer Satisfaction subject areas.