Subject Areas

8 Subject Areas

Subject Areas

This chapter provides information on the subject areas with data you maintain in Oracle Analytics for Advertising and Customer Experience (CX). These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:

This section provides information on the subject areas with data you maintain in Oracle Fusion CX Analytics. These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:

Description of the subject area.
Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.
Job-specific groups and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.
Primary navigation to the work area that is represented by the subject area.
Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.
The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.
Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.

Overview

This section details subject area information for Customer Experience data using Oracle Fusion CX Analytics.

Download this ZIP file that contains available subject areas that apply to the current version of Oracle Fusion CX Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 24R2_Fusion_CX_Analytics_SubjectAreas.html.

Offerings and Functional Areas

This table shows the offerings in Oracle Fusion CX Analytics and their source.

Offering	Functional Area	Activation Dependency *	Subject Areas Covered	Source	Initial Release
Customer Experience Sales Analytics	Sales Pipeline	None	CX - Opportunity CX - Opportunity Revenue Line CX - Activity CX - Opportunity Activity CX - Lead Activity CX - Leads	Oracle CX Cloud (Fusion Sales)	22R2
Customer Experience Sales Analytics	Sales Pipeline Snapshot	Sales Pipeline	CX - Opportunity Snapshot CX - Opportunity Revenue Line Snapshot CX - Opportunity Stage Progression	Oracle CX Cloud (Fusion Sales)	22R2
Customer Experience Sales Analytics	Sales CPQ Integrated Analytics	Sales Pipeline	CX - Opportunity Quote CX - Opportunity Quote Line	Oracle CX Cloud (Fusion Sales)⁺	22R2
Customer Experience Marketing Analytics	Marketing Campaign Closed Loop Analytics	Sales Pipeline	CX - Campaign Members CX - Campaign Opportunity Revenue	Oracle CX Cloud (Fusion Sales)^#	22R2
Customer Experience Service Analytics	B2B Service Analytics	None	CX - Service Request CX - Service Request Milestone CX - Service Request Lifecycle	Oracle CX Cloud (Fusion B2B Service)	22R2
Subscription Analytics	Subscription Management Analytics	None	CX - Subscriptions CX - Subscription Bill Line	Oracle Subscription Management	22R3
Subscription Analytics	Subscription Management Snapshot	Subscription Management Analytics	CX - Susbcription Historical Trend	Oracle Subscription Management	22R3
Customer Experience Marketing Analytics	Marketing Campaign Analytics	None	CX - Campaign Activity Analysis	Oracle Eloqua**	22R3
Customer Experience Marketing Analytics	Marketing Campaign Activity Detail Analytics	Marketing Campaign Analytics	CX - Campaign Activity Detail Analysis	Oracle Eloqua**	23R3
Customer Experience Security Configuration	CX Security Data	None	NA	Oracle CX Cloud (Fusion Sales)	23R3
Customer Experience Sales Analytics	CX Resource HCM Worker Analytics	Sales Pipeline	NA	Oracle CX Cloud (Fusion Sales)	23R3

* The functional area listed must be activated.

+ The pipeline or functional area is applicable when there's integration between Oracle Fusion Cloud Sales Automation and Oracle Configure, Price, Quote, otherwise the subject area won't have data.

# The pipeline or functional area is applicable when there's integration between Oracle Fusion Cloud Sales Automation and Oracle Eloqua Marketing Automation, otherwise the subject area won't have data.

** Enable the Odata flag for the Eloqua instance.

Security Assignment

Description

Using the Security Assignment subject area, you can create reports about the current security assignments. These reports enable you to track the security contexts and the users who have access to the security contexts.

Business Questions

This subject area can answer the following business questions:

What is the total number of security contexts?
What is the number of users by security context?
Which user is assigned to which security context and when was the assignment done?

Duty Roles

The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Security Assignment

Workbook: Security Audit

Special Considerations

None.

Security Audit History

This section is applicable for CX Subscription Management Analytics only.

Description

Using the data in the Security Audit History subject area, you can create reports to track assignment of users to groups, groups to roles, and security context members to users.

Business Questions

This subject area can answer the following business questions:

When was a group created?
When was a role created?
When was a user assigned to or removed from a group?
When was a user assigned to or removed from a role?
When was a user assigned to or removed from a security context?

Duty Roles

The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Security Audit History

Workbook: Security Audit

Special Considerations

None.

Usage Tracking

Description

Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In Oracle Fusion Data Intelligence you can track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that you can use in a variety of ways such as reports optimization, user session strategies, or plan usage by users, and departments based on the resources that they consume. When reviewing the business metrics, it is important to keep the usability considerations in mind including trends, slice-and-dice, and drilldowns. Where applicable, benchmark information showcasing performance with the peer group is available. Companies typically set strategic quarterly goals in terms of key metrics; where applicable, the business metrics show progress towards such goals.

This subject area includes details of logical queries that provide insights on the types of queries generated and their performance. Along with it, the Common - Usage Tracking - Physical Query subject area provides details of physical queries sent to the database. These details can help you understand query execution plans in Autonomous Data Warehouse to identify areas of improvement in report creation. Both subject areas have the Logical query folder with a common set of attributes, that you can use to join a logical or semantic query to its physical database queries. Together, they provide valuable insights to track performance of the Oracle Analytics platform and help you design reports and visualizations that can perform optimally.

Business Questions

This subject area can answer the following business questions:

What are the average queries ran by the user by month?
How many number of user sessions were created per month?
How many distinct queries were run per month?
How many distinct users used the system?
How many distinct users used the system in a week?
What are the average queries ran by the user in a week?
How many logical queries ran by the top users?
What are the top 10 logical and physical queries by execution time?
Which dashboards and visualizations are the slowest performing?

Duty Roles

The Usage Tracking Analysis Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Usage Tracking

Workbook: Usage Tracking

Special Considerations

None.

Warehouse Refresh Statistics

Description

The Warehouse Refresh Statistics subject area provides valuable information on pipeline activity and performance. You can use this subject area to create analytics on data refreshes, pipeline jobs, job failures, and details on rejected records. Together with data validation, this subject area helps reconcile data between the Oracle Fusion Cloud Applications source module and Oracle Fusion Data Intelligence, and improve data quality over time.

Business Questions

This subject area can answer the following business questions:

When was the warehouse last refreshed, by each module?
Which modules have high percentage of rejected records?
What are the specific records that have been rejected for a certain module?
What errors did the pipeline encounter, by specific jobs?
Which jobs fail most frequently?
What are the cascading effects, for example what other related records also fail due to a certain failure of a job?

Duty Roles

The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Warehouse Refresh Statistics

Workbook: Warehouse Refresh Statistics

Special Considerations

None.

Business Questions

For each business question in this section, links are provided for more detailed information about the subject areas, job-specific groups, and duty roles associated with the business question.

Overview

For each business question in this section, links are provided for more detailed information about the subject areas, job-specific groups, and duty roles associated with the business question.

Download this ZIP file that contains available business questions that apply to the current version of Oracle Fusion CX Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 24R2_Fusion_CX_Analytics_BQs.html.

Note:

Job roles are the same as job-specific groups.

Job-Specific Groups

Overview

This section provides job-specific groups that can be used to secure access to the subject area.

Note:

Job roles are the same as job-specific groups.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Functional Area
ORA_ZBS_SALES_ADMINISTRATOR_JOB	Sales Administrator	Sales Administrator Job Group	OA4F_CX_CAMPAIGN_MEMBERS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVN_DUTY OA4F_CONTENT_REPORTING_CONFIG OA4F_CX_SALES_LEAD_ACTIVITY_DUTY OA4F_CX_LEADS_DUTY OA4F_CX_SALES_LEAD_CUSTOM_DATA OA4F_CX_SALES_LEADS_DATA OA4F_CX_OPTY_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_CUSTOM_DATA OA4F_CX_SALES_OPTY_DATA OA4F_CX_REVN_LINE_ANALYSIS_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_DUTY OA4F_CX_SALES_ACCNT_DATA OA4F_CX_SALES_ACTIVITY_DUTY OA4F_CX_SALES_ACTIVITY_ASSIGNEE_DATA OA4F_CX_SALES_ACTIVITY_DELEGATOR_DATA OA4F_CX_SALES_ACTIVITY_RES_HIER_DATA OA4F_CX_SALES_ACTIVITY_CUSTOM_DATA OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_QUOTE_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ALL_DATA OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_MEMBERS_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_CONTENT_DUTY OA4F_CX_LEADS_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_PIPELINE_OAC_CONTENT_DUTY OA4F_CX_WIN_LOSS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_EFFECTIVENESS_OAC_CONTENT_DUTY OA4F_CX_OPPORTUNITY_QUOTES_OAC_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_RENEWAL_SALES_OAC_CONTENT_DUTY OA4F_CX_LEAD_CONVERSION_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_MEMBERS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_OAC_CONTENT_DUTY	CX Sales
ORA_ZBS_SALES_VP_JOB	Sales VP	Sales VP Job Group	OA4F_CX_CAMPAIGN_MEMBERS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVN_DUTY OA4F_CONTENT_REPORTING_CONFIG OA4F_CX_SALES_LEAD_ACTIVITY_DUTY OA4F_CX_LEADS_DUTY OA4F_CX_SALES_LEAD_CUSTOM_DATA OA4F_CX_SALES_LEADS_DATA OA4F_CX_OPTY_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_CUSTOM_DATA OA4F_CX_SALES_OPTY_DATA OA4F_CX_REVN_LINE_ANALYSIS_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_DUTY OA4F_CX_SALES_ACCNT_DATA OA4F_CX_SALES_ACTIVITY_DUTY OA4F_CX_SALES_ACTIVITY_ASSIGNEE_DATA OA4F_CX_SALES_ACTIVITY_DELEGATOR_DATA OA4F_CX_SALES_ACTIVITY_RES_HIER_DATA OA4F_CX_SALES_ACTIVITY_CUSTOM_DATA OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_QUOTE_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ALL_DATA OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_MEMBERS_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_CONTENT_DUTY OA4F_CX_LEADS_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_PIPELINE_OAC_CONTENT_DUTY OA4F_CX_WIN_LOSS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_EFFECTIVENESS_OAC_CONTENT_DUTY OA4F_CX_OPPORTUNITY_QUOTES_OAC_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_RENEWAL_SALES_OAC_CONTENT_DUTY OA4F_CX_LEAD_CONVERSION_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_MEMBERS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_OAC_CONTENT_DUTY	CX Sales
ORA_ZBS_SALES_MANAGER_JOB	Sales Manager	Sales Manager Job Group	OA4F_CX_CAMPAIGN_MEMBERS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVN_DUTY OA4F_CONTENT_REPORTING_CONFIG OA4F_CX_SALES_LEAD_ACTIVITY_DUTY OA4F_CX_LEADS_DUTY OA4F_CX_SALES_LEAD_CUSTOM_DATA OA4F_CX_SALES_LEADS_DATA OA4F_CX_OPTY_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_CUSTOM_DATA OA4F_CX_SALES_OPTY_DATA OA4F_CX_REVN_LINE_ANALYSIS_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_DUTY OA4F_CX_SALES_ACCNT_DATA OA4F_CX_SALES_ACTIVITY_DUTY OA4F_CX_SALES_ACTIVITY_ASSIGNEE_DATA OA4F_CX_SALES_ACTIVITY_DELEGATOR_DATA OA4F_CX_SALES_ACTIVITY_RES_HIER_DATA OA4F_CX_SALES_ACTIVITY_CUSTOM_DATA OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_QUOTE_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ALL_DATA OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_MEMBERS_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_CONTENT_DUTY OA4F_CX_LEADS_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_PIPELINE_OAC_CONTENT_DUTY OA4F_CX_WIN_LOSS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_EFFECTIVENESS_OAC_CONTENT_DUTY OA4F_CX_OPPORTUNITY_QUOTES_OAC_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_RENEWAL_SALES_OAC_CONTENT_DUTY OA4F_CX_LEAD_CONVERSION_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_MEMBERS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_OAC_CONTENT_DUTY	CX Sales
ORA_ZBS_SALES_REPRESENTATIVE_JOB	Sales Representative	Sales Representative Job Group	OA4F_CX_CAMPAIGN_MEMBERS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVN_DUTY OA4F_CONTENT_REPORTING_CONFIG OA4F_CX_SALES_LEAD_ACTIVITY_DUTY OA4F_CX_LEADS_DUTY OA4F_CX_SALES_LEAD_CUSTOM_DATA OA4F_CX_SALES_LEADS_DATA OA4F_CX_OPTY_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_CUSTOM_DATA OA4F_CX_SALES_OPTY_DATA OA4F_CX_REVN_LINE_ANALYSIS_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_DUTY OA4F_CX_SALES_ACCNT_DATA OA4F_CX_SALES_ACTIVITY_DUTY OA4F_CX_SALES_ACTIVITY_ASSIGNEE_DATA OA4F_CX_SALES_ACTIVITY_DELEGATOR_DATA OA4F_CX_SALES_ACTIVITY_RES_HIER_DATA OA4F_CX_SALES_ACTIVITY_CUSTOM_DATA OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_DUTY OA4F_CX_SALES_OPTY_QUOTE_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_CUSTOM_DATA OA4F_CX_SERVICE_REQUEST_ALL_DATA OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_MEMBERS_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_CONTENT_DUTY OA4F_CX_LEADS_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SALES_PIPELINE_OAC_CONTENT_DUTY OA4F_CX_WIN_LOSS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_EFFECTIVENESS_OAC_CONTENT_DUTY OA4F_CX_OPPORTUNITY_QUOTES_OAC_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_RENEWAL_SALES_OAC_CONTENT_DUTY OA4F_CX_LEAD_CONVERSION_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_MEMBERS_OAC_CONTENT_DUTY OA4F_CX_SALES_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_LEAD_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_OAC_CONTENT_DUTY OA4F_CX_LEADS_OAC_CONTENT_DUTY OA4F_CX_OPTY_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_REVN_LINE_SNP_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_OPTY_PROG_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_OAC_CONTENT_DUTY	CX Sales
ORA_SVC_CUSTOMER_SERVICE_REPRESENTATIVE_JOB	Customer Service Representative	Customer Service Representative Job Group	OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY	CX Service
ORA_SVC_CUSTOMER_SERVICE_MANAGER_JOB	Customer Service Manager	Customer Service Manager Job Group	OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY OA4F_CX_SR_MANAGEMENT_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_OAC_CONTENT_DUTY	CX Service
ORA_OSS_SUBSCRIPTION_SPECIALIST_JOB	Subscription Specialist	Subscription Specialist Job Groups	OA4F_CX_SUBCRIPTIONS_ANALYSIS_DUTY OA4F_CX_SUBSCRIPTION_CUSTOM_DATA OA4F_CX_SUBCRIPTION_BILL_LINE_ANALYSIS_DUTY OA4F_CX_SUBCRIPTION_HISTORICAL_TREND_ANALYSIS_DUTY OA4F_CX_SUBCRIPTIONS_ANALYSIS_CONTENT_DUTY OA4F_CX_SUBCRIPTION_BILL_LINE_ANALYSIS_CONTENT_DUTY OA4F_CX_SUBCRIPTION_HISTORICAL_TREND_ANALYSIS_CONTENT_DUTY OA4F_CX_SUBCRIPTIONS_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SUBCRIPTION_HISTORICAL_TREND_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SUBCRIPTION_BILL_LINE_ANALYSIS_OAC_CONTENT_DUTY OA4F_CX_SUBSCRIPTION_CUSTOM_DATA OA4F_CX_SUBSCRIPTION_BUSINESS_UNIT_DATA	CX Subscription

Common Job-Specific Groups

The common job-specific groups are applicable across the analytics applications that are part of Oracle Fusion Data Intelligence such as Oracle Fusion HCM Analytics and Oracle Fusion ERP Analytics.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Associated Application Role Names	Functional Area
ORA_FND_INTEGRATION_SPECIALIST_JOB	Integration Specialist	Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.	Author OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Not applicable	Common

Job-Specific Group Code

Job-Specific Group Name

Description

Associated Application Roles

Associated Application Role Names

Functional Area

ORA_FND_INTEGRATION_SPECIALIST_JOB

Integration Specialist

Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.

Author

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Not applicable

Common

Data Roles

Overview

This section provides data roles that can be used to secure access to the subject area.

Data Role Code	Data Role Name	Description	Functional Area
OA4F_CX_SALES_ACTIVITY_ASSIGNEE_DATA	Sales Activity By Assignee Data Security	Data security role to access activity data by Assignee.	CX Sales
OA4F_CX_SALES_ACTIVITY_DELEGATOR_DATA	Sales Activity By Delegator Data Security	Data security role to access Sales activity data by Delegator.	CX Sales
OA4F_CX_SALES_ACTIVITY_RES_HIER_DATA	Sales Activity By Resource Hierarchy Data Security	Data security role to access activity data by Resource Hierarchy.	CX Sales
OA4F_CX_SALES_ACTIVITY_CUSTOM_DATA	Sales Activity Custom and System Access Group Data Security	Data security role to access Activity data by Activity Access Group data.	CX Sales
OA4F_CX_SALES_LEAD_CUSTOM_DATA	Lead Custom and System Access Group Data Security	Data security role to access Lead data by Access Group data	CX Sales
OA4F_CX_SALES_LEADS_DATA	Lead Data Security	Data security role to access Lead data.	CX Sales
OA4F_CX_SALES_OPTY_CUSTOM_DATA	Opportunity Custom and System Access Group Data Security	Data security role to access Opportunity data by Access Group data.	CX Sales
OA4F_CX_SALES_OPTY_DATA	Opportunity Data Security	Data security role to opportunity data.	CX Sales
OA4F_CX_SALES_ACCNT_DATA	Sales Account Data Security	Data security role to access sales account data.	CX Sales
OA4F_CX_SERVICE_REQUEST_CUSTOM_DATA	Service Request Custom and System Access Group Data Security	Data security role to access B2B Service Request data by Activity Access Group data.	CX Service
OA4F_CX_SERVICE_REQUEST_ALL_DATA	Service Request All Data Security	Data security role to allow acess to all Service Request data.	CX Service
OA4F_CX_SALES_OPTY_QUOTE_CUSTOM_DATA	Opportunity Quote Custom and System Access Group Data Security	Data security role to access Opportunity Quote data by Access group data.	CX Sales
OA4F_CX_SUBSCRIPTION_BUSINESS_UNIT_DATA	Subscription Business Unit Data Security	Data Security role to access Subscription Business Unit based data	CX Subscription
OA4F_CX_SUBSCRIPTION_CUSTOM_DATA	Subscription Custom and System Access Group Data Security	Data Security role to access Subscription data by Access group data	CX Subscription

Duty Roles

Overview

This section provides subject area and content-related duty roles that you can use to secure access to the subject areas and specific content. For each duty role in this section, links are provided for detailed information about the job-specific groups, subject areas, and business questions associated with the duty role.

Duty Role Code	Duty Role Name	Duty Role Description	Functional Area	Gets access to Subject Area Display Name OR Associated Role
OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_CONTENT_DUTY	Campaign Activity Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Campaign Activity Analysis subject area.	CX - Marketing	NA
OA4F_CX_CAMPAIGN_ACTIVITY_ANALYSIS_DUTY	Campaign Activity Analysis Duty	Controls presentation catalog access to CX - Campaign Activity Analysis subject area.	CX - Marketing	CX - Campaign Activity Analysis
OA4F_CX_CAMPAIGN_ACTIVITY_DETAIL_ANALYSIS_DUTY	Campaign Activity Detail Analysis Duty	Object security role to control presentation catalog access to "CX - Campaign Activity Detail Analysis" subject area.	CX - Marketing	CX - Campaign Activity Detail Analysis
OA4F_CX_CAMPAIGN_MEMBERS_CONTENT_DUTY	Campaign Member Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Campaign Members subject area.	CX-Sales	NA
OA4F_CX_CAMPAIGN_MEMBERS_DUTY	Campaign Members Analysis Duty	Controls presentation catalog access to CX - Campaign Members subject area.	CX - Sales	CX - Campaign Members
OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_CONTENT_DUTY	Campaign Opportunity Revenue Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Campaign Opportunity Revenue subject area.	CX-Sales	NA
OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_DUTY	Campaign Opportunity Revenue Analysis Duty	Controls presentation catalog access to CX - Campaign Opportunity Revenue subject area.	CX-Sales	CX - Campaign Opportunity Revenue
OA4F_CX_CAMPAIGN_OPTY_REVENUE_ANALYSIS_OAC_CONTENT_DUTY	Campaign Opportunity Revenue Analysis OAC Content Duty	Controls presentation catalog access to business metric Overview Dashboards built against the CX - Campaign Opportunity Revenue Analysis subject area	CX-Sales	NA
OA4F_CX_CAMPAIGN_OPTY_REVN_CONTENT_DUTY	Campaign Opportunity Revenue Line Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Campaign Opportunity Revenue Line subject area.	CX-Sales	NA
OA4F_CX_LEADS_CONTENT_DUTY	Lead Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Leads subject area.	CX-Sales	NA
OA4F_CX_LEADS_DUTY	Lead Analysis Duty	Controls presentation catalog access to CX - Leads subject area.	CX - Sales	CX - Leads
OA4F_CX_OPTY_ANALYSIS_CONTENT_DUTY	Opportunity Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity subject area.	CX-Sales	NA
OA4F_CX_OPTY_ANALYSIS_DUTY	Opportunity Analysis Duty	Controls presentation catalog access to CX - Opportunity subject area.	CX - Sales	CX - Opportunity
OA4F_CX_OPTY_PROG_ANALYSIS_CONTENT_DUTY	Opportunity Stage Progression Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Stage Progression subject area.	CX-Sales	NA
OA4F_CX_OPTY_PROG_ANALYSIS_DUTY	Opportunity Stage Progression Duty	Controls presentation catalog access to CX - Opportunity Stage Progression subject area.	CX - Sales	CX - Opportunity Stage Progression
OA4F_CX_OPTY_SNP_ANALYSIS_CONTENT_DUTY	Opportunity Snapshot Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Snapshot subject area.	CX-Sales	NA
OA4F_CX_OPTY_SNP_ANALYSIS_DUTY	Opportunity Snapshot Duty	Controls presentation catalog access to CX - Opportunity Revenue Line subject area.	CX - Sales	CX - Opportunity Snapshot
OA4F_CX_REVN_LINE_ANALYSIS_CONTENT_DUTY	Opportunity Revenue Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Revenue Line subject area.	CX-Sales	NA
OA4F_CX_REVN_LINE_ANALYSIS_DUTY	Opportunity Revenue Analysis Duty	Controls presentation catalog access to CX - Opportunity Revenue Line subject area.	CX - Sales	CX - Opportunity Revenue Line
OA4F_CX_REVN_LINE_SNP_ANALYSIS_CONTENT_DUTY	Opportunity Revenue Line Snapshot Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Revenue Line Snapshot subject area.	CX-Sales	NA
OA4F_CX_REVN_LINE_SNP_ANALYSIS_DUTY	Opportunity Revenue Line Snapshot Duty	Controls presentation catalog access to CX - Opportunity Revenue Line Snapshot subject area.	CX - Sales	CX - Opportunity Revenue Line Snapshot
OA4F_CX_SALES_ACTIVITY_CONTENT_DUTY	Sales Activity Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Activity subject area.	CX-Sales	NA
OA4F_CX_SALES_ACTIVITY_DUTY	Sales Activity Analysis Duty	Controls presentation catalog access to CX - Activity subject area.	CX - Sales	CX - Activity
OA4F_CX_SALES_LEAD_ACTIVITY_CONTENT_DUTY	Lead Activity Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Lead Activity subject area.	CX-Sales	NA
OA4F_CX_SALES_LEAD_ACTIVITY_DUTY	Lead Activity Analysis Duty	Controls presentation catalog access to CX - Lead Activity subject area.	CX - Sales	CX - Lead Activity
OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_CONTENT_DUTY	Sales Opportunity Activity Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Activity subject area.	CX-Sales	NA
OA4F_CX_SALES_OPPORTUNITY_ACTIVITY_DUTY	Sales Opportunity Activity Analysis Duty	Controls presentation catalog access to CX - Opportunity Activity subject area.	CX - Sales	CX - Opportunity Activity
OA4F_CX_SALES_OPPTY_QUOTE_LINE_ANALYSIS_CONTENT_DUTY	Opportunity Quote Line Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Quote Line subject area.	CX-Sales	NA
OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_CONTENT_DUTY	Opportunity Quote Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Opportunity Quote subject area.	CX-Sales	NA
OA4F_CX_SALES_OPTY_QUOTE_ANALYSIS_DUTY	Opportunity Quote Analysis Duty	Controls presentation catalog access to CX - Opportunity Quote subject area.	CX-Sales	CX - Opportunity Quote
OA4F_CX_SALES_OPTY_QUOTE_LINE_ANALYSIS_DUTY	Opportunity Quote Line Analysis Duty	Controls presentation catalog access to CX - Opportunity Quote Line subject area.	CX-Sales	CX - Opportunity Quote Line
OA4F_CX_SERVICE_REQUEST_ANALYSIS_CONTENT_DUTY	Service Request Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Service Request subject area.	CX-Sales	NA
OA4F_CX_SERVICE_REQUEST_ANALYSIS_DUTY	Service requests Analysis Duty	Controls presentation catalog access to CX - B2B Service Requests subject area.	CX - Service	CX - Service Request
OA4F_CX_SERVICE_REQUEST_LIFECYCLE_ANALYSIS_CONTENT_DUTY	Service Request Lifecycle Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Service Request Lifecycle subject area.	CX - Service	NA
OA4F_CX_SERVICE_REQUEST_MILESTONE_ANALYSIS_CONTENT_DUTY	Service Request Milestone Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Service Request Milestone subject area.	CX - Service	NA
OA4F_CX_SUBCRIPTION_BILL_LINE_ANALYSIS_CONTENT_DUTY	Subscription Bill Line Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Subscription Bill Line subject area.	CX - Subscription	NA
OA4F_CX_SUBCRIPTION_BILL_LINE_ANALYSIS_DUTY	Subscription Bill Line Analysis Duty	Controls presentation catalog access to CX - Subscription Bill Line subject area.	CX - Subscription	CX - Subscription Bill Line
OA4F_CX_SUBCRIPTION_HISTORICAL_TREND_ANALYSIS_CONTENT_DUTY	Subscription Historical Trend Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Subscription Historical Trend subject area.	CX - Subscription	NA
OA4F_CX_SUBCRIPTION_HISTORICAL_TREND_ANALYSIS_DUTY	Subscription Historical Trend Analysis Duty	Controls presentation catalog access to CX - Subscription Historical Trend subject area.	CX - Subscription	CX - Subscription Historical Trend
OA4F_CX_SUBCRIPTIONS_ANALYSIS_CONTENT_DUTY	Subscription Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the CX - Subscriptions subject area.	CX - Subscription	NA
OA4F_CX_SUBCRIPTIONS_ANALYSIS_DUTY	Subscription Analysis Duty	Controls presentation catalog access to CX - Subscriptions subject area.	CX - Subscription	CX - Subscription

Common Duty Roles

The common duty roles are applicable across the analytics applications that are part of the application such as Oracle Fusion CX Analytics, Oracle Fusion HCM Analytics, and Oracle Fusion ERP Analytics.

Duty Role Code	Duty Role Name	Details	Functional Area	Gets access to Subject Area Display Name OR Associated Role
OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Data Warehouse Refresh Analysis Duty	Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.	Common	Common - Warehouse Refresh Statistics
OA4F_COMMON_USAGE_TRACKING_DUTY	Usage Tracking Analysis Duty	Object security role to control presentation catalog access to Common - Usage Tracking subject area.	Common	Common - Usage Tracking
OA4F_SECURITY_REPORTING_DUTY	Security Reporting Duty	Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.	Common	Common - Security Assignment Common - Security Audit History

Duty Role Code

Duty Role Name

Details

Functional Area

Gets access to Subject Area Display Name OR Associated Role

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Data Warehouse Refresh Analysis Duty

Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.

Common

Common - Warehouse Refresh Statistics

OA4F_COMMON_USAGE_TRACKING_DUTY

Usage Tracking Analysis Duty

Object security role to control presentation catalog access to Common - Usage Tracking subject area.

Common

Common - Usage Tracking

OA4F_SECURITY_REPORTING_DUTY

Security Reporting Duty

Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.

Common

Common - Security Assignment

Common - Security Audit History

Subject Area Metric Details

CX - Activity

This table describes the Activity Metrics.

Metric	Metric Definition
# of Activities	The total Activities
# of Appointments	The total Appointments (Activity function = Appointments)
# of Call Reports	The total Call Reports (Activity function = Call Reports)
# of Completed Activities	The total Completed Activities (Status = Complete)
# of Expired Activities	The total Expired Activities (Status not equal to Complete/Cancelled & Current Date > Activity Due Date)
# of Open Activities	The total Open Activities (Status not equal to Complete/Cancelled)
# of Tasks	The total Tasks (Activity function = Task)
Average Activity Duration For Completed Activities	Average time to Complete the Activity
Average Number of Activities Per Team Member	Average number of Activity per Team Member. This metric is compurted as follows: # of Activities/# of Resources

CX - Campaign Activity Analysis

This table describes the Marketing (Eloqua) Campaign Activity Analysis metrics.

Metric	Metric Definition
# of Bouncebacks	The total Emails that returned a Bounceback (hard or soft)
# of Email Clickthroughs	The total Email Clickthroughs. This includes multiple clicks by the same recipient
# of Email Opens	The total opens by email recipients (original recipients or email forwards). An open is counted every time the email is opened.
# of Emails Delivered	The total Emails Delivered. This metric is computed as follow: (# of Email Sent - # of Email Bounceback)
# of Emails Sent	The total Emails Sent
# of Existing Visitor Clickthroughs	Total Email Clickthroughs by returning visitors. A returning visitor has an existing Oracle Eloqua cookie. The cookie is unique to the browser and device.
# of Form Submissions	The total Form submissions. This includes multiple submissions by the same contact
# of Hard Bouncebacks	The total Emails that returned a Hard Bounceback. A hard bounce back is an Email that permanently couldn't be delivered.
# of Landing Page Views	The number of times the landing page was viewed. If a visitor visits the page multiple times, all those views are counted.
# of New Contacts	The total new Contacts. A contact is considered new if the contact record was created as a result of a campaign response. Your organization defines what a response is and the priority of the response using response rules.
# of New Leads	The total new leads generated by the campaign. A lead is generated if a contact is newly acquired and responds to the campaign. Contacts are considered leads only once, so contacts are considered new leads only the first time they respond to a campaign. For subsequent responses, the contact is considered an existing lead. Your organization defines what a response is and the priority of the response using response rules.
# of New Visitor Clickthroughs	Total email clickthroughs by new visitors. An new visitor does not have an Oracle Eloqua cookie. The cookie is unique to the browser and device.
# of Page Views	The number of times that a page was viewed. A visitor might view the page multiple times during a visit and this metric counts each of those views. One page view is counted every time the page is loaded.
# of Possible Forwarders	The total original recipients that forwarded the email atleast once
# of Responses	The total response activity for the campaign. Your organization defines what a response is and the priority of the response using response rules. Although a campaign member might respond in many ways to a campaign (for example, clicking through an email or submitting a form), Oracle Eloqua records only the response deemed by your organization as the highest priority response. For example, a form submit at your organization might be considered a higher priority response than an email click-through. So, even if a contact performed both of these responses, Oracle Eloqua records the form submit as a response to the campaign. Responses are captured for a campaign only after the campaign's reporting start date.
# of Soft Bouncebacks	The total Emails that returned a Soft Bounceback. A soft bounce back is an Email that temporarily couldn't be delivered.
# of Spam Unsubscribers by Email	The total Email recipients that marked the email as Spam
# of Unsubscribes by Email	The total Email recipients that Unsubscribed. (Globally or Spam Unsubscribed)
# of Visitors	The unique visitors to a web page. A visitor is identified by the unique visitor identifier that is part of the Oracle Eloqua cookie. The cookie is unique to the browser and device.
Average Landing Page Time	The average amount of time spent on a Landing page. This metric is computed as follows: (Landing Page Time / Landing Page Views)
Average Responses	The average number of campaign responses (Total Response / Campaign Count)
Bounceback Rates	The Email Bounceback rate. This metric is computed as follows: (Total Soft and Hard bouncebacks / Total Emails sent) * 100
Clickthrough Rate (CTR)	The Clickthrough Rate. This metric is computed as follows: (Total Clickthroughs / Total Emails Delivered) * 100
Delivered Rate	The email Delivered Rate. This metric is computed as follows: (Total Emails delivered / Total Emails sent) * 100
Hard Bounceback Rate	The Hard Bounceback rate. This metric is computed as follows: (Total Hard bouncebacks / Total Emails sent) * 100
Landing Page Time	The total amount of time visitors spent on a Landing Page in seconds
Open Rate	The Email Open Rate. This metric is computed as follows: (Total Emails Opened / Total Emails Delivered) * 100
Possible Forward Rate	The Possible Forward Rate. This metric is computed as follows: (Total Possible Forwarders / Total Emails Delivered) * 100
Soft Bounceback Rate	The Soft Bounceback rate. This metric is computed as follows: (Total Soft bouncebacks/Total Emails sent) * 100
Unsubscribed Rate	The Unsubscribe Rate. This metric is computed as follows: (Total Unsubscribes / Total Emails Delivered) * 100
# of Outbound Activities	The amount of Outbound Activity. Outbound activities include emails sent, emails delivered, and surveys sent. This counts all of the activity including multiple activities by the same campaign member. An outbound activity can be generated by a contact that was initially targeted by the campaign or by a contact that performed an outbound activity (for example, via a forwarded email).
# of Inbound Activities	The amount of Inbound Activity. Inbound activities include email opens, clickthroughs, form submissions, and so on. This counts all of the activity including multiple activities by the same campaign member. An inbound activity can be generated by a contact that was initially targeted by the campaign or by a contact that performed an inbound activity (for example, via a forwarded email).
# of Marketing Activities	Total number of activities (total outbound+inbound)
# of Campaign Members	The total contacts that entered campaigns included in the analysis. Campaign members could be contacts that were initially targeted by the campaign, or contacts that performed an inbound activity (for example, a contact that clicked through an email that was forwarded to them).
# of Campaigns	The total Campaigns included in the Analysis
# of External Activities	The activity that occurred outside of Oracle Eloqua. For example, attending a trade show, or interacting with an app such as WeChat. Your organization defines external activities.
Inbound Activity Rate	The total inbound activities divided by the total Campaign member (Total Inbound Activities/Campaign Members)*100
Response Rate	The total campaign responses divided by the total campaign member (Total Responses/Campaign Members)*100
Cost/Inbound Activity	The total Campaign Cost per Inbound Activity. This metric is calculated as follows: Campaign Actual Cost/'# of Inbound Activities
Cost/New Lead	The total Campaign Cost per New Lead. This metric is calculated as follows: Campaign Actual Cost/'# of New Leads
Cost/Response	The total Campaign Cost per Response. This metric is calculated as follows: Campaign Actual Cost/'# of Response
Average Responses	The average number of campaign responses (Total Response/Campaign Count)
Click to Open Rate	The Click to Open Rate. It is the unique clickthroughs by the original recipient divided by the unique opens by the original recipient. This metric ignores possible forwards. This metric is computed as follows: (Unique Clickthroughs/Unique Opens) * 100
Form Conversion Rate from Email	The total Form Submissions that can be attributed back to the Email Sent is divided by the total Email Delivered. This metric is computed as follows: (Total Form Submissions from Emails Sent/Total Emails Delivered)

CX - Campaign Activity Detail Analysis

This table describes the Marketing (Eloqua) Campaign Activity Detail Analysis metrics for the associated Contacts, Accounts, and Assets.

Metric	Metric Definition
# of Email Sent	The total Emails Sent
# of Emails Delivered	The total Emails Delivered. This metric is computed as follows: (# of Email Sent - # of Email Bounceback)
# of Email Opens	The total opens by email recipients (original recipients or email forwards). An open is counted every time the email is opened.
# of Unique Opens	The Unique Email Opens. One open is counted against each recipient that opens the email.
# of Email Clickthroughs	The total Email Clickthroughs. This includes multiple clicks by the same recipient.
# of Unique Email Clickthroughs	The total Unique Email Clickthroughs. This includes one click per recipient.
# of Email Bounceback	The total Emails that returned a Bounceback (hard or soft)
# of Hard Email Bounceback	The total Emails that returned a Hard Bounceback. A hard bounce back is an Email that permanently couldn't be delivered.
# of Soft Email Bounceback	The total Emails that returned a Soft Bounceback. A soft bounce back is an Email that temporarily couldn't be delivered.
# of Email Unsubscribes	The total Email recipients that Unsubscribed. (Globally or Spam Unsubscribed)
# of Form Submissions	The total Form submissions. This includes multiple submissions by the same contact.
# of External Activities	The activity that occurred outside of Oracle Eloqua. For example, attending a trade show, or interacting with an app such as WeChat. Your organization defines external activities.
Bounceback Rates	The Email Bounceback rate. This metric is computed as follows: (Total Soft and Hard bouncebacks/Total Emails sent)*100
Hard Bounceback Rate	The Hard Bounceback rate. This metric is computed as follows: (Total Hard bouncebacks/Total Emails sent)*100
Soft Bounceback Rate	The Soft Bounceback rate. This metric is computed as follows: (Total Soft bouncebacks/Total Emails sent)*100
Delivered Rate	The email Delivered Rate. This metric is computed as follows: (Total Emails delivered/Total Emails sent)*100
Open Rate	The Email Open Rate. This metric is computed as follows: (Total Emails Opened/Total Emails Delivered)*100
Unique Open Rate	The Unique Email Open Rate. This metric is computed as follows: (Total Unique Email Opened/Total Emails Delivered)*100
# of Spam Unsubscribes by Email	The total Email recipients that marked the email as Spam.
# of Email Auto Open	The total Email opens are detected as being auto-generated by scanning or privacy tools. These opens aren't included in Total Opens or any associated open rates.
# of Email Auto Click	The total Email clickthrough detected as being auto-generated by scanning or privacy tools. These clickthroughs aren't included in Total clickthroughs or any associated click rates.
Unsubscribed Rate	The Email Unsubscribed Rate. This metric is computed as follows: (Total Unsubscribes / Total Delivered) * 100.
Clickthrough Rate	The Email clickthrough Rate. This metric is computed as follows: (Total Clickthroughs / Total Delivered) * 100.
Unique Clickthrough Rate	The Email unique clickthrough Rate. This metric is computed as follows: (Unique Clickthroughs / Total Delivered) * 100 Note: This metric calculation ignores possible forwards.
Campaign Actual Cost	The Actual Cost of the Campaign
Campaign Budgeted Cost	The Budgeted Cost of the Campaign

CX - Campaign Members

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in Subject Area.

Document Currency is the currency used while entering the data. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Campaign Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
# of Active CX Campaigns	The total Active CX Campaigns
# of Contacts	The total Contacts associated to CX Campaigns
# of CX Campaign Members	The total CX Campaign Members
# of CX Campaign Owners	The total CX Campaign Owners
# of CX Campaigns	The total CX Campaigns
# of Leads	The total Leads associated to CX Campaigns
# of Responses	The total CX Campaign Responses
Actual Cost	The Actual Cost of the CX Campaign
Budgeted Cost	The Budgeted Cost of the CX Campaign

CX - Campaign Opportunity Revenue

These metrics are used in the Document Currency (DC), CX Currency (CC), and Analytics Currency (AC) fact folders in the subject area.

Document Currency is the currency used while entering the data in the application. CX Currency is the currency defined in Oracle CRM. Analytics Currency is the currency defined in Fusion CX Anaytics. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses the Opportunity Expected Close Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
# of CX Campaigns	The total CX Campaigns
# of CX Campaign Owners	The total CX Campaign Owners
# CX Campaign Targeted Accounts	The total Accounts associated to CX Campaigns (targeted by CX Campaigns)
CX Campaign Budgeted Cost	The Budgeted Cost of the CX Campaign
CX Campaign Actual Cost	The Actual Cost of the CX Campaign
# of Opportunity Revenue Lines	The total Opportunity Revenue Lines associated to CX Campaigns
# of Open Opportunity Revenue Lines	The total Open Opportunity Revenue Lines associated to CX Campaigns
# of Won Opportunity Revenue Lines	The total Won Opportunity Revenue Lines associated to CX Campaigns
# of Lost Opportunity Revenue Lines	The total lost Opportunity Revenue Lines associated to CX Campaigns
# of No Sale Opportunity Revenue Lines	The total No Sale Opportunity Revenue Lines associated to CX Campaigns
# of Opportunities with Revenue Lines	The total Opportunities with Revenue Lines
Revenue Line Loss Rate	The CX Campaign Opportunity Revenue Line Won Rate. This metric is computed as follows: 100 * # of Won Revenue Lines/# of Won+Lost Revenue Lines
Revenue Line Won Rate	The CX Campaign Opportunity Revenue Line Loss Rate. This metric is computed as follows: 100 * # of Lost Revenue Lines/# of Won+Lost Revenue Lines
CX Campaign Actual Vs Budgeted Cost (%)	The ratio of CX Campaign Actual and Budgeted cost. This metric is computed as follows: CX Campaign Actual Cost/CX Campaign Budgeted Cost
Average Won Opportunity Line Revenue	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue/# of Won Opportunity Revenue Lines
CX Campaign Cost Per Opportunity Revenue Line	The total CX Campaign Cost Per Opportunity Revenue Line. This metric is calculated as follows: Total CX Campaign Cost/# of Opportunity Revenue Lines.
CX Campaign Cost Per Won Opportunity Revenue Line	The total CX Campaign Cost Per Won Opportunity Revenue Line. This metric is calculated as follows: Total CX Campaign Cost/# of Won Opportunity Revenue Lines.
Raw Opportunity Line Revenue	The total Opportunity Line Revenue (for Opportunities associated to CX Campaigns). Note that for Opportunities having multiple CX Campaigns, this value would be repeated.
Open Opportunity Line Revenue (Linear Attribution)	The total Open Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Linear attribution model.
Won Opportunity Line Revenue (Linear Attribution)	The total Won Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Linear attribution model.
Lost Opportunity Line Revenue (Linear Attribution)	The total Lost Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Linear attribution model.
No Sales Opportunity Line Revenue (Linear Attribution)	The total No Sale Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Linear attribution model.
Average Won Opportunity Line Revenue (Linear Attribution)	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue (Linear Attribution)/# of Won Opportunity Revenue Lines
CX Campaign Attributed Pipeline Revenue (Linear Attribution)	The total Pipeline revenue attributable to the CX Campaign based on the Linear attribution model (Revenue divided equally amongst all the CX Campaigns associated to the Opportunity)
CX Campaign ROI (Linear Attribution)	The ROI of the CX Campaign based on the Linear attribution model. This metric is calculated as follows: (CX Campaign Attributed Pipeline Revenue (Linear Attribution)- Actual Cost ) / Actual Cost
CX Campaign Cost Per Attributed Revenue (Linear Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the Linear attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue (Linear Attribution)
CX Campaign Cost Per Won Line Revenue (Linear Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the Linear attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue for Won Revenue Line (Linear Attribution)
Open Opportunity Line Revenue (First Touch Attribution)	The total Open Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the First Touch attribution model.
Won Opportunity Line Revenue (First Touch Attribution)	The total Won Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the First Touch attribution model.
Lost Opportunity Line Revenue (First Touch Attribution)	The total Lost Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the First Touch attribution model.
No Sales Opportunity Line Revenue (First Touch Attribution)	The total No Sale Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the First Touch attribution model.
Average Won Opportunity Line Revenue (First Touch Attribution)	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue (First Touch Attribution)/# of Won Opportunity Revenue Lines
CX Campaign Attributed Pipeline Revenue (First Touch Attribution)	The total Pipeline revenue attributable to the CX Campaign based on the First touch attribution model (Revenue divided equally amongst all the CX Campaigns associated to the Opportunity)
CX Campaign ROI (First Touch Attribution)	The ROI of the CX Campaign based on the First touch attribution model. This metric is calculated as follows: (CX Campaign Attributed Pipeline Revenue (First touch Attribution)- Actual Cost ) / Actual Cost
CX Campaign Cost Per Attributed Revenue (First Touch Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the First touch attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue (First touch Attribution)
CX Campaign Cost Per Won Line Revenue (First Touch Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the First touch attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue for Won Revenue Line (First touch Attribution)
Open Opportunity Line Revenue (Last Touch Attribution)	The total Open Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Last Touch attribution model.
Won Opportunity Line Revenue (Last Touch Attribution)	The total Won Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Last Touch attribution model.
Lost Opportunity Line Revenue (Last Touch Attribution)	The total Lost Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Last Touch attribution model.
No Sales Opportunity Line Revenue (Last Touch Attribution)	The total No Sale Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the Last Touch attribution model.
Average Won Opportunity Line Revenue (Last Touch Attribution)	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue (Last Touch Attribution)/# of Won Opportunity Revenue Lines
CX Campaign Attributed Pipeline Revenue (Last Touch Attribution)	The total Pipeline revenue attributable to the CX Campaign based on the Last touch attribution model (Revenue divided equally amongst all the CX Campaigns associated to the Opportunity)
CX Campaign ROI (Last Touch Attribution)	The ROI of the CX Campaign based on the Last touch attribution model. This metric is calculated as follows: (CX Campaign Attributed Pipeline Revenue (Last touch Attribution)- Actual Cost ) / Actual Cost
CX Campaign Cost Per Attributed Revenue (Last Touch Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the Last touch attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue (Last touch Attribution)
CX Campaign Cost Per Won Line Revenue (Last Touch Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the Last touch attribution model. This metric is calculated as follows: Total CX Campaign Cost/Campaign Attributed Pipeline Revenue for Won Revenue Line (Last touch Attribution)
Open Opportunity Line Revenue (U-Shaped Attribution)	The total Open Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the U-Shaped attribution model.
Won Opportunity Line Revenue (U-Shaped Attribution)	The total Won Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the U-Shaped attribution model.
Lost Opportunity Line Revenue (U-Shaped Attribution)	The total Lost Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the U-Shaped attribution model.
No Sales Opportunity Line Revenue (U-Shaped Attribution)	The total No Sale Opportunity Line Revenue (for Opportunities associated to CX Campaigns) based on the U-Shaped attribution model.
Average Won Opportunity Line Revenue (U-Shaped Attribution)	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue (U-Shaped Attribution)/# of Won Opportunity Revenue Lines
CX Campaign Attributed Pipeline Revenue (U-Shaped Attribution)	The total Pipeline revenue attributable to the campaign based on the U-Shaped attribution model (Revenue divided equally amongst all the CX Campaigns associated to the Opportunity)
CX Campaign ROI (U-Shaped Attribution)	The ROI of the CX Campaign based on the U-Shaped attribution model. This metric is calculated as follows: (CX Campaign Attributed Pipeline Revenue (U-Shaped attribution)- Actual Cost ) / Actual Cost
CX Campaign Cost Per Attributed Revenue (U-Shaped Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the U-Shaped attribution. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue (U-Shaped attribution)
CX Campaign Cost Per Won Line Revenue (U-Shaped Attribution)	The total CX Campaign Cost Per Opportunity Attributed Revenue based on the U-Shaped attribution model. This metric is calculated as follows: Total CX Campaign Cost/CX Campaign Attributed Pipeline Revenue for Won Revenue Line (U-Shaped attribution)

CX - Lead Activity

This table describes the Lead Activity Metrics.

Metric	Metric Definition
# of Completed Lead Activities	The total Completed Activities associated to Leads (Activity Status = Complete)
# of Expired Lead Activities	The total Expired Activities associated to Leads (Activity Status not equal to Complete/Cancelled & Current Date > Activity Due Date)
# of Lead Activities	The total Activities associated to Leads
# of Lead Activities for Highly Ranked Leads	The total Activities for highly ranked Leads (Lead Rank = Hot)
# of Lead Appointments	The total Appointments associated to Leads (Activity function = Appointments)
# of Lead Call Reports	The total Call Reports associated to Leads (Activity function = Call Reports)
# of Lead Tasks	The total Tasks associated to Leads (Activity function = Task)
# of Open Lead Activities	The total Open Activities associated to Leads (Activity Status not equal to Complete/Cancelled)
Activity Rate - Converted Leads	The rate of Activities for Converted Leads. This metric is computed as follows: 100 * # of Activities for Converted Leads/# of Converted Leads
Activity Rate - Qualified Leads	The rate of Activities for Qualified Leads. This metric is computed as follows: 100 * # of Activities for Qualified Leads/# of Qualified Leads
Activity Rate - Rejected Leads	The rate of Activities for Rejected Leads. This metric is computed as follows:100 * # of Activities for Rejected Leads/# of Rejected Leads
Activity Rate - Retired Leads	The rate of Activities for Retired Leads. This metric is computed as follows: 100 * # of Activities for Retired Leads/# of Retired Leads
Activity Rate - Unaccepted Leads	The rate of Activities for Unaccepted Leads. This metric is computed as follows: 100 * # of Activities for Unaccepted Leads/# of Unaccepted Leads
Activity Rate - Unassigned Leads	The rate of Activities for Unassigned Leads. This metric is computed as follows: 100 * # of Activities for Unassigned Leads/# of Unassigned Leads
Activity Rate - Unconverted Leads	The rate of Activities for Unconverted Leads. This metric is computed as follows: 100 * # of Activities for Unconverted Leads/# of Unconverted Leads
Average Activity Duration For Completed Activities	The average time taken to complete an activity. This metric is computed as follows: Activity duration for completed activity/# of Completed Activities
Average Number of Lead Activities Per Team Member	The average number of Lead Activities per Team member.
Lead Activity Rate	The rate of Activities for Leads. This metric is computed as follows: 100 * # of Lead Activities/# of Leads
Lead First Response Time	The time to respond to an assigned Lead. This metric is computed as follows: Date of first Lead Activity - Lead assigned date
Lead Idle Days	The days since the last Lead Activity. This metric is computed as follows: Current Date - Last Lead Activity Date

CX - Leads

These metrics are used in the Document Currency (DC), CX Currency (CC), and Analytics Currency (AC) fact folders in this subject area.

Document Currency is the currency used while entering the data in the application. CX Currency is the currency defined in Oracle CRM. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Lead Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
# of Accepted Leads	The total Accepted Leads (Accepted Flag = Y)
# of Accounts Leads Converted	The total Converted Leads from Account(Lead Status = Converted, Sales Account Type = Customer)
# of Assigned Leads	The total assigned leads (Assignment status = Assigned)
# of Contacts with Leads	The total Contacts with Leads
# of highly Ranked Qualified Leads	The total Qualified Hot Leads (Lead Status = Qualified, Rank Name = Hot)
# of Leads	The total number of Leads
# of Leads Converted	The total Converted Leads (Lead Status = Converted)
# of Leads from Account	The total leads from Account (Sales Account Type = Customer)
# of Leads from Prospect Account	The total leads from Prospect (Sales Account Type = Prospect)
# of Leads Generated from Marketing Source	The total Leads generated from Marketing Source (Lead Source = Marketing)
# of Leads Generated from Non Marketing Source	The total Leads generated from Non- marketing Source (Lead Source not equal to Marketing)
# of Low Ranked Qualified Leads	The total Qualified Cool Leads (Lead Status = Qualified, Rank Name = Cool)
# of Medium Ranked Qualified Leads	The total Qualified Warm Leads (Lead Status = Qualified, Rank Name = Warm)
# of Partner Assigned Leads	The total leads assigned to a Partner
# of Prospect Leads Converted	The total Converted Leads from Prospect(Lead Status = Converted, Sales Account Type = Prospect)
# of Qualified Expired Leads	The total Qualified Expired Leads (Lead Status = Qualified, Current Date > Lead Expiry Date)
# of Qualified Leads	The total Qualified Leads (Lead Status = Qualified)
# of Rejected Leads	The total Rejected Leads (Assignment Status = Rejected)
# of Retired Leads	The total Retired Leads (Lead Status = Retired)
# of Sales Accounts with Leads	The total Accounts with Leads
# of Unaccepted Leads	The total Unaccepted Leads (Accepted Flag = N)
# of Unassigned Leads	The total Unassigned Leads. This metric is computed as follows: # of Leads - # of Assigned Leads
# of Uncovered Leads	The total Unconverted Leads. This metric is computed as follows: # of Leads - # of Converted Leads
# of Unqualified Leads	The total Unqualified leads (Lead Status = Unqualified)
Average Lead Age (Days)	The average age of the Leads. This metric is computed as follows: For Converted or Retired Leads, the day when it was converted/Retired - Lead Created date. For others it is the Current Date - the Lead created date
Average Number of Days Open for Unqualified Leads	The Average number of days to Qualify a lead. This metric is computed as follows: Total Lead Age of Unqualified leads/ # of Unqualified Leads
Average Number of Days to Convert Leads	The Average number of days to Convert a lead. This metric is computed as follows: Total Lead Age of Converted leads/ # of Converted Leads
Budget Amount	The total Budget Amount
Lead Idle Days	The total days the Active Lead is idle (Lead Status not equal to Retired/Rejected). This metric is computed as follows: Current Date - Last Activity Date
Lead Qualification Rate (%)	Rate of Qualified Leads to the total Leads. This metric is computed as follows: 100 * # of Qualified Leads/# of Leads
Lead Qualification to Conversion Velocity	Rate of Converting the Qualified Leads. This metric is computed as follows: Lead Converted Date - Lead Qualified Date / # of Converted Leads
Lead Qualification Velocity	Rate of Qualifying the Leads. This metric is computed as follows: Lead Qualified Date - Lead Created Date/# of Qualified Leads
Leads Conversion % (Across Levels in Lead Owner Resource Hierarchy)	Lead to Opportunity Conversion % calculated at the total level of lead owner hierarchy
Leads Conversion % (Across Levels in Primary Partner Hierarchy)	Lead to Opportunity Conversion % calculated at the total level of primary partner hierarchy
Leads Conversion %(Across Levels in Sales Account Hierarchy)	Lead to Opportunity Conversion % calculated at the total level of sales account hierarchy
Leads to Opportunity Conversion (%)	Rate of Converted Leads to the total Leads. This metric is computed as follows: # of Converted Leads/# of Leads
Potential Revenue	The total Lead Revenue
Ratio of Converted Leads to Qualified Leads	Ratio of Converted Leads to Qualified Leads
Ratio of Highly Ranked Qualified Leads to Qualified Leads	Ratio of Highly Ranked Qualified Leads to Qualified Leads
Ratio of Low Ranked Qualified Leads to Qualified Leads	Ratio of Low Ranked Qualified Leads to Qualified Leads
Ratio of Medium Ranked Qualified Leads to Qualified Leads	Ratio of Medium Ranked Qualified Leads to Qualified Leads
Ratio of Qualified Leads to Unqualified Leads	Ratio of Qualified Leads to Unqualified Leads
Ratio of Retired Leads to Ratio of Unqualified Leads	Ratio of Retired Leads to Unqualified Leads
Raw Lead Amount	The total Raw Lead Amount
Rejected Leads (%)	Rate of Rejected Leads to the total Leads. This metric is computed as follows: # of Rejected Leads/# of Leads
Retired Leads (%)	Rate of Retired Leads to the total Leads. This metric is computed as follows: # of Retired Leads/# of Leads
Total Market Potential	The total Lead Revenue for Qualified or Unqualified Leads

CX - Opportunity

This table describes the Opportunity Metrics.

Metric	Metric Definition
# of Accounts with Won Opportunities	The total Accounts with Won Opportunities
# of Competitive Lost Opportunities	The total Lost Opportunities with atleast one Competitor
# of Competitive No Sale Opportunities	The total No Sale Opportunities with atleast one Competitor
# of Competitive Open Opportunities	The total Open Opportunities with atleast one Competitor
# of Competitive Opportunities	The total Opportunities with atleast one Competitor
# of Competitive Won Opportunities	The total Won Opportunities with atleast one Competitor
# of Converted Lost Opportunities	The total Lost Opportunities which were created by converting the Leads.
# of Converted Open Opportunities	The total Open Opportunities which were created by converting the Leads.
# of Converted Opportunities	The total Opportunities which were created by converting the Leads.
# of Converted Won Opportunities	The total Won Opportunities which were created by converting the Leads.
# of Expansion Opportunities	The total Expansion Opportunities (Opportunity Type Code = Expansion)
# of Expired Opportunities	The total Expired Opportunities. This metric is computed as follows: Opportunity Status = Open, Current Date > Opportunity Expected Close Date
# of Lost Expansion Opportunities	The total Lost Expansion Opportunities (Opportunity Status = Lost and Opportunity Type Code = Expansion)
# of Lost New Opportunities	The total Lost New Opportunities (Opportunity Status = Lost and Opportunity Type Code = New)
# of Lost Opportunities	The total Lost Opportunities (Opportunity Status = Lost)
# of Lost Renewal Opportunities	The total Lost Renewal Opportunities (Opportunity Status = Lost and Opportunity Type Code = Renewal)
# of New Opportunities	The total New Opportunities (Opportunity Type Code = New)
# of No Sale Expansion Opportunities	The total No Sale Expansion Opportunities (Opportunity Status = No Sale and Opportunity Type Code = Expansion)
# of No Sale Opportunities	The total No Sale Opportunities (Opportunity Status = No Sale)
# of No Sale Renewal Opportunities	The total No Sale Renewal Opportunities (Opportunity Status = No Sale and Opportunity Type Code = Renewal)
# of Open Expansion Opportunities	The total Open Expansion Opportunities (Opportunity Status = Open and Opportunity Type Code = Expansion)
# of Open New Opportunities	The total Open New Opportunities (Opportunity Status = Open and Opportunity Type Code = New)
# of Open Opportunities	The total Open Opportunities (Opportunity Status = Open)
# of Open Renewal Opportunities	The total Open Renewal Opportunities (Opportunity Status = Open and Opportunity Type Code = Renewal)
# of Opportunities	The total number of Opportunities
# of Renewal Opportunities	The total Renewal Opportunities (Opportunity Type Code = Renewal)
# of Unconverted Closed Opportunities	The total Closed Opportunities which were not created by converting the Leads.
# of Unconverted Opportunities	The total Opportunities which were not created by converting the Leads.
# of Unconverted Won Opportunities	The total Won Opportunities which were not created by converting the Leads.
# of Won Expansion Opportunities	The total Won Expansion Opportunities (Opportunity Status = Won and Opportunity Type Code = Expansion)
# of Won New Opportunities	The total Won New Opportunities (Opportunity Status = Won and Opportunity Type Code = New)
# of Won Opportunities	The total Won Opportunities (Opportunity Status = Won)
# of Won Renewal Opportunities	The total Won Renewal Opportunities (Opportunity Status = Won and Opportunity Type Code = Renewal)
# of No Sale New Opportunities	The total No Sale New Opportunities (Opportunity Status = No Sale and Opportunity Type Code = New)
Average # of Days to Close	Average number of days to Close an Opportunity. This metric is computed as follows: Total days needed to close Opportunities/# of Open Opportunities
Average # of Days to Open	Average number of days the Opportunity is Open. This metric is computed as follows: Total days the Opportunity is Open/# of Open Opportunities
Average Age of Closed Opportunities	Average Age of Closed Opportunities. This metric is computed as follows: Total Closed Opportunities Age/# of Closed Opportunities
Average Age of Converted Opportunity	Average Age of Converted Opportunities. This metric is computed as follows: sum(Opportunity Close Date - Opportunity Creation Date)/# of Converted Closed Opportunities
Average Age of Converted Won Opportunity	Average Age of Converted Won Opportunities. This metric is computed as follows: sum(Opportunity Close Date - Opportunity Creation Date)/# of Converted Won Opportunities
Average Age of Lost Opportunities	Average Age of Lost Opportunities. This metric is computed as follows: Total Lost Opportunities Age/# of Lost Opportunities
Average Age of No Sale Opportunities	Average Age of No Sale Opportunities. This metric is computed as follows: Total No Sale Opportunities Age/number of No Sale Opportunities
Average Age of Unconverted Opportunity	Average Age of Uncoverted Opportunities. This metric is computed as follows: sum(Opportunity Close Date - Opportunity Creation Date)/# of Unconverted Closed Opportunities
Average Age of Unconverted Won Opportunity	Average Age of Uncoverted Won Opportunities. This metric is computed as follows: sum(Opportunity Close Date - Opportunity Creation Date)/# of Unconverted Won Opportunities
Average Age of Won Opportunities	Average Age of Won Opportunities. This metric is computed as follows: Total Won Opportunities Age/# of Won Opportunities
Average Opportunity Win Probability	Average probability to Win the Opportunity. This metric is computed as follows: Total win probabilities/# of Opportunities
Competitive Loss Rate	Rate of Losing Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Lost Opportunities/Total Competitive Closed Opportunities
Competitor Conversion Rate	Rate of Converting Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Won Opportunities/Total Competitive Opportunities
Competitor Win Rate	Rate of Winning Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Won Opportunities/Total Competitive Won and Lost Opportunities
Conversion Rate	Rate of Converting Opportunities. This metric is computed as follows: 100 * Total Won Opportunities/Total Opportunities
Converted Lead Contribution to Closed Opportunities %	The ratio of Converted Closed Opportunities (created from Leads) in all the Closed Opportunities. This metric is computed as follows: (#of Converted Closed Opportunities/# of Closed Opportunities)*100
Converted Lead Contribution to Opportunities %	The ratio of Converted Opportunities (created from Leads) in all the Opportunities. This metric is computed as follows: (#of Converted Opportunities/# of Opportunities)*100
Converted Lead Contribution to Won Opportunities %	The ratio of Converted Won Opportunities (created from Leads) in all the Won Opportunities. This metric is computed as follows: (#of Converted Won Opportunities/# of Won Opportunities)*100
Converted Lead Contribution to Lost Opportunities %	The ratio of Converted Lost Opportunities (created from Leads) in all the Lost Opportunities. This metric is computed as follows: (#of Converted Lost Opportunities/# of Lost Opportunities)*100
Expansion Opportunities Conversion Rate	The Conversion rate of the Expansion Opportunities. This metric is computed as follows: (# of Won Expansion Opportunities/# of Expansion Opportunities)
Expansion Opportunities Loss Rate	The Loss rate of the Expansion Opportunities. This metric is computed as follows: (# of Lost Expansion Opportunities/# of Won+Lost Expansion Opportunities)
Expansion Opportunities Win Rate	The Win Rate of the Expansion Opportunities. This metric is computed as follows: (# of Won Expansion Opportunities/# of Won+Lost Expansion Opportunities)
Loss Rate	Rate of Losing Opportunities. This metric is computed as follows: 100 * Total Lost Opportunities/Total Won and Lost Opportunities
New Opportunities Conversion Rate	The Conversion rate of the New Opportunities. This metric is computed as follows: (# of Won New Opportunities/# of New Opportunities)
New Opportunities Loss Rate	The Loss rate of the New Opportunities. This metric is computed as follows: (# of Lost New Opportunities/# of Won+Lost New Opportunities)
New Opportunities Win Rate	The Win Rate of the New Opportunities. This metric is computed as follows: (# of Won New Opportunities/# of Won+Lost New Opportunities)
Ratio of # of lost Opportunities (unconverted) to Converted Lost Opportunities	The ratio of Uncoverted Lost Opportunities to Converted Lost Opportunities. This metric is computed as follows: (# of Lost Opportunities - # of Converted Lost Opportunities) /# of Converted Lost Opportunities
Renewal Opportunities Conversion Rate	The Conversion rate of the Renewal Opportunities. This metric is computed as follows: (# of Won Renewal Opportunities/# of renewal Opportunities)
Renewal Opportunities Loss Rate	The Loss rate of the Renewal Opportunities. This metric is computed as follows: (# of Lost Renewal Opportunities/# of Won+Lost renewal Opportunities)
Renewal Opportunities Win Rate	The Win Rate of the Renewal Opportunities. This metric is computed as follows: (# of Won Renewal Opportunities/# of Won+Lost renewal Opportunities)
Win Rate	Rate of Winning Opportunities. This metric is computed as follows: 100 * Total Won Opportunities/Total Won and Lost Opportunities

CX - Opportunity Activity

This table describes the Opportunity Activity Metrics.

Metric	Metric Definition
# of Completed Opportunity Activities	The total Completed Activities associated Opportunities (Activity Status = Complete)
# of Expired Opportunity Activities	The total Expired Activities associated to Opportunities (Activity Status not equal to Complete/Cancelled & Current Date > Activity Due Date)
# of Open Opportunity Activities	The total Open Activities associated to Opportunities (Activity Status not equal to Complete/Cancelled)
# of Opportunity Activities	The total Activities associated to Opportunities
# of Opportunity Appointments	The total Tasks associated to Appointments (Activity function = Appointments)
# of Opportunity Call Reports	The total Tasks associated to Call Reports (Activity function = Call Reports)
# of Opportunity Tasks	The total Tasks associated to Opportunities (Activity function = Task)
Activity Rate - Lost Opportunities	The rate of Activities for Lost Opportunities. This metric is computed as follows: 100 * # of Activities for Lost Opportunities/# of Lost Opportunities
Activity Rate - No Sale Opportunities	The rate of Activities for No Sale Opportunities. This metric is computed as follows: 100 * # of Activities for No Sale Opportunities/# of No Sale Opportunities
Activity Rate - Open Opportunities	The rate of Activities for Open Opportunities. This metric is computed as follows: 100 * # of Activities for Open Opportunities/# of Open Opportunities
Activity Rate - Opportunities	The rate of Activities for Opportunities. This metric is computed as follows: 100 * # of Opportunity Activities/# of Opportunities
Activity Rate - Won Opportunities	The rate of Activities for Won Opportunities. This metric is computed as follows: 100 * # of Activities for Won Opportunities/# of Won Opportunities
Appointment Rate - Lost Opportunities	The rate of Appointments for Lost Opportunities. This metric is computed as follows: 100 * # of Appointments for Lost Opportunities/# of Lost Opportunities
Appointment Rate - No Sale Opportunities	The rate of Appointments for No Sale Opportunities. This metric is computed as follows: 100 * # of Appointments for No Sale Opportunities/# of No Sale Opportunities
Appointment Rate - Open Opportunities	The rate of Appointments for Open Opportunities. This metric is computed as follows: 100 * # of Appointments for Open Opportunities/# of Open Opportunities
Appointment Rate - Won Opportunities	The rate of Appointments for Won Opportunities. This metric is computed as follows: 100 * # of Appointments for Won Opportunities/# of Won Opportunities
Average Activity Duration for Completed Activities	The average time taken to complete an activity. This metric is computed as follows: Activity duration for completed activity/# of Completed Activities
Average Activity Duration For Open Activities	The average time of an activity. This metric is computed as follows: Activity duration for Activities not in Cancelled or Complete status/# of Activities not in Cancelled or Complete status
Average Number of Calls for Lost Opportunities	The average number of Calls for Lost Opportunities. This metric is computed as follows: # of Activities of type code = Calls for Lost Opportunities/# of Lost Opportunities
Average Number of Calls for Won Opportunities	The average number of Calls for Won Opportunities. This metric is computed as follows: # of Activities of type code = Calls for Won Opportunities/# of Won Opportunities
Average Number of Demos for Lost Opportunities	The average number of Demos for Lost Opportunities. This metric is computed as follows: # of Activities of type code = Demos for Lost Opportunities/# of Lost Opportunities
Average Number of Demos for Won Opportunities	The average number of Demos for Won Opportunities. This metric is computed as follows: # of Activities of type code = Demos for Won Opportunities/# of Won Opportunities
Average Number of Emails Sent for Lost Opportunities	The average number of Emails sent for Lost Opportunities. This metric is computed as follows: # of Activities of type code = Email for Lost Opportunities/# of Lost Opportunities
Average Number of Emails Sent for Won Opportunities	The average number of Emails sent for Won Opportunities. This metric is computed as follows: # of Activities of type code = Email for Won Opportunities/# of Won Opportunities
Average Number of Meetings for Lost Opportunities	The average number of Meetings for Lost Opportunities. This metric is computed as follows: # of Activities of type code = Meetings for Lost Opportunities/# of Lost Opportunities
Average Number of Meetings for Won Opportunities	The average number of Meetings for Won Opportunities. This metric is computed as follows: # of Activities of type code = Meetings for Won Opportunities/# of Won Opportunities
Average Number of Opportunity Activities Per Team Member	The average number of Opportunity Activities per Team member
Call Report Rate - Lost Opportunities	The rate of Call Reports for Lost Opportunities. This metric is computed as follows: 100 * # of Call Reports for Lost Opportunities/# of Lost Opportunities
Call Report Rate - No Sale Opportunities	The rate of Call Reports for No Sale Opportunities. This metric is computed as follows: 100 * # of Call Reports for No Sale Opportunities/# of No Sale Opportunities
Call Report Rate - Open Opportunities	The rate of Call Reports for Open Opportunities. This metric is computed as follows: 100 * # of Call Reports for Open Opportunities/# of Open Opportunities
Call Report Rate - Won Opportunities	The rate of Call Reports for Won Opportunities. This metric is computed as follows: 100 * # of Call Reports for Won Opportunities/# of Won Opportunities
Task Rate - Lost Opportunities	The rate of Tasks for Lost Opportunities. This metric is computed as follows: 100 * # of Tasks for Lost Opportunities/# of Lost Opportunities
Task Rate - No Sale Opportunities	The rate of Tasks for No Sale Opportunities. This metric is computed as follows: 100 * # of Tasks for No Sale Opportunities/# of No Sale Opportunities
Task Rate - Open Opportunities	The rate of Tasks for Open Opportunities. This metric is computed as follows: 100 * # of Tasks for Open Opportunities/# of Open Opportunities
Task Rate - Won Opportunities	The rate of Tasks for Won Opportunities. This metric is computed as follows: 100 * # of Tasks for Won Opportunities/# of Won Opportunities

CX - Opportunity Quote

This table describes the Opportunity Quotes Metrics.

Metric	Metric Definition
# of Active Quotes	The total number of Active Quotes
# of Active Quotes with Proposal	The total number of Active Quotes with Proposal
# of Closed Active Quotes	The total number of Active Quotes Closed (Won+Lost)
# of Expired Quotes	The total number of Expired Quotes
# of In-Progress Active Quotes	The total number of Active In-Progress Quotes
# of Lost Active Quotes	The total number of Active Quotes Lost
# of Quotes	The total number of Quotes
# of Unique Quotes	The total number of Unique Quotes (based on External Quote number, ignores Quotes versions and treats Quotes with same Quote id as one)
# of Won Active Quotes	The total number of Active Quotes Won
Active Quote Conversion Rate	The rate of converting the Active Quotes. This metric is computed as follows: 100 * # of Closed Quotes/# of Active Quotes
Active Quote Loss Rate	The rate of losing Active Quotes. This metric is computed as follows: 100 * # of Lost Quotes/# of Closed Quotes
Active Quote to Contract Start Time	The time to start the Contract after the Quote is created. This metric is computed as follows: (Contract Start Date - Quote Creation Date)/# of Active Quotes
Active Quote To Lost Opportunity Time	The average time between Lost Opportunity Close Date and Quote creation date. This metric is computed as follows: (Opportunity Close Date - Quote Creation Date)/# of Active Quotes for Lost Opportunities
Active Quote To Won Opportunity Time	The average time between Won Opportunity Close Date and Quote creation date. This metric is computed as follows: (Opportunity Close Date - Quote Creation Date)/# of Active Quotes for Won Opportunities
Active Quote Win Rate	The rate of winning Active Quotes. This metric is computed as follows: 100 * # of Won Quotes/# of Closed Quotes
Average # of Quotes for Lost Opportunities	The average number of Quotes for Lost Opportunities. This metric is computed as follows: # of Quotes/# of Lost Opportunities
Average # of Quotes for No-Sale Opportunities	The average number of Quotes for No Sale Opportunities. This metric is computed as follows: # of Quotes/# of No-Sale Opportunities
Average # of Quotes for Open Opportunities	The average number of Quotes for Open Opportunities. This metric is computed as follows: # of Quotes/# of Open Opportunities
Average # of Quotes for Won Opportunities	The average number of Quotes for Won Opportunities.This metric is computed as follows: # of Quotes/# of Won Opportunities
Average Active Quote Cycle Time	The average Quote Cycle Time. This metric is computed as follows: (Quote Order Placed on Date - Quote Creation Date)/# of Active Quotes
Average Contract Value (Active Quotes)	The average Contract value per Active Quote. This metric is computed as follows: Total Contract Value/# of Active Quotes
Average Length of Contract (Active Quote)	The average Length of the Contract. This metric is computed as follows: (Contract End Date - Contract Start Date)/# of Active Quotes
Average Non Recurring Revenue (Active Quotes)	The average Non-Recurring Revenue Amount from Active Quotes. This metric is computed as follows: Total Non-Recurring Revenue Amount/# of Active Quotes
Average Number of Active Quote Iterations	The average number of Quotes created per Active Quote. This metric is computed as follows: # of Quotes/# of Active Quotes
Average Opportunity to Current Active Quote Time	The average time between Opportunity and Quote creation date. This metric is computed as follows: (Quote Creation Date - Opportunity Creation Date)/# of Active Quotes
Average Recurring Revenue (Active Quotes)	The average Recurring Revenue Amount from Active Quotes. This metric is computed as follows: Total Recurring Revenue Amount/# of Active Quotes
Average Usage Revenue (Active Quotes)	The average Usage Revenue Amount from Active Quotes. This metric is computed as follows: Total Usage Revenue Amount/# of Active Quotes
Contract Value (Active Quotes)	The total Quote Contract value in Active Quotes
Non Recurring Revenue Amount (Active Quotes)	The total Non-Recurring Revenue Amount from Active Quotes
Raw Contract Value	The total Quote Contract value in all Quotes
Raw Non Recurring Revenue Amount	The total Non-Recurring Revenue Amount from all Quotes
Raw Recurring Revenue Amount	The total Recurring Revenue Amount from all Quotes
Raw Usage Revenue Amount	The total Usage Revenue Amount from all Quotes
Recurring Revenue Amount (Active Quotes)	The total Recurring Revenue Amount from Active Quotes
Usage Revenue Amount (Active Quotes)	The total Usage Revenue Amount from Active Quotes

CX - Opportunity Quote Lines

This table describes the Opportunity Quote Line Metrics.

Metric	Metric Definition
# of Active Quotes with Lines	The total Active Quotes with atleast one Quote Line
# of Closed Lines for Active Quotes	The total Closed (Won+Lost) Quote Lines from Active Quotes
# of In-Progress Lines for Active Quotes	The total In-Progress Quote Lines from Active Quotes
# of Lines for Active Quotes	The total Quote Lines from Active Quotes
# of Lost Lines for Active Quotes	The total Lost Quote Lines from Active Quotes
# of Quotes with Lines	The total Quotes with atleast one Quote Line
# of Unique Quotes with Lines	The Unique Quotes with atleast one Quote Line
# of Won Lines for Active Quotes	The total Won Quote Lines from Active Quotes
Average Contract Line Value for Active Quotes	The Average Contract Value (Total Contract Value / # of Quote Lines)
Average Length of the Contract for Active Quote Lines	The average Length of the Contract. This metric is computed as follows: (Quote Line Contract Start Date - Quote Line Contract End Date) / (# of Lines for Active Quotes)
Average Line Cycle Time for Active Quotes	The average Quote Line Cycle Time. This metric is computed as follows: (Quote Order Placed on Date - Quote Creation Date)/(# of Lines for Active Quotes)
Average Non-Recurring Line Revenue for Active Quotes	The Average Non-Recurring Revenue (Total Non-Recurring Revenue Amount / # of Quote Lines)
Average Recurring Line Revenue for Active Quotes	The Average Recurring Revenue (Total Recurring Revenue Amount / # of Quote Lines)
Average Usage Line Revenue for Active Quotes	The Average Usage Revenue Amount (Total Usage REvenue/ # of Quote Lines)
Contract Line Value for Active Quotes	The total Contract value (Sum of Recurring Revenue, Non-Recurring Revenue and Usage Revenue) of Qutoe Lines from Active Quotes
Line Conversion Rate for Active Quotes	The Quote Line Conversion Rate (# of Won Lines for Active Quotes / # of Lines for Active Quotes *100)
Line Loss Rate for Active Quotes	The Quote Line Loss Rate (# of Lost Lines for Active Quotes) / ( # of Closed Lines for Active Quotes) *100
Line Win Rate for Active Quotes	The Quote Line Win Rate (# of Won Lines for Active Quotes) /( # of Closed Lines for Active Quotes) *100
Non-Recurring Line Revenue for Active Quotes	The total Non-Recurring Revenue of a Quote Line from Active Quotes
Raw Quote Line Non-Recurring Revenue	Total Non Recurring Revenue amount of Quote Lines
Raw Quote Line Recurring Revenue	Total Recurring Revenue amount of Quote Lines
Raw Quote Line Usage Revenue	Total Usage Revenue amount of Quote Lines
Raw Quote Line Contract Value	Total Contract Value of Quote Lines
Recurring Line Revenue for Active Quotes	The total Recurring Revenue of a Quote Line from Active Quotes
Usage Line Revenue for Active Quotes	The total Usage Revenue of a Quote Line from Active Quotes
Average Quote Line Discount %	The Average Quote Line Discount Percentage.

CX - Opportunity Revenue Line

These metrics are used in the Document Currency (DC), CX Currency (CC), and Analytics Currency (AC) fact folder in this subject area.

Document Currency is the currency used while entering the data in the application. CX Currency is the currency defined in Oracle CRM. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Opportunity Expected Close Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
# of Competitive Opportunity Revenue Lines	The total Opportunity Revenue Lines with atleast one Competitor
# of Expansion Opportunity Revenue Lines	The total Expansion Opportunity Revenue Lines
# of Expired Opportunity Revenue Lines	The total Expired Opportunity Revenue Lines with atleast one Competitor
# of Lost Competitive Opportunity Revenue Lines	The total Lost Opportunity Revenue Lines with atleast one Competitor
# of Lost Opportunity Revenue Lines	The total Lost Opportunity Revenue Lines (Revenue Status = Lost)
# of New Opportunity Revenue Lines	The total New Opportunity Revenue Lines
# of No Sale Competitive Opportunity Revenue Lines	The total No Sale Opportunity Revenue Lines with atleast one Competitor
# of No Sale Opportunity Revenue Lines	The total No Sale Opportunity Revenue Lines (Revenue Status = No Sale)
# of Open Competitive Opportunity Revenue Lines	The total Open Opportunity Revenue Lines with atleast one Competitor
# of Open Opportunity Revenue Lines	The total Open Opportunity Revenue Lines (Revenue Status = Open)
# of Opportunity Revenue Lines	The total Opportunity Revenue Lines
# of Raw Opportunity Revenue Lines	The total Raw Opportunity Revenue Lines
# of Won Competitive Opportunity Revenue Lines	The total Won Opportunity Revenue Lines with atleast one Competitor
# of Won Opportunity Revenue Lines	The total Won Opportunity Revenue Lines (Revenue Status = Won)
# of Renewal Opportunity Revenue Lines	The total Renewal Opportunity Revenue Lines
% Change Average Won Opportunity Line Revenue Same Time Last Period	The % change in Average Won Opportunity Line Revenue compared to the Last Period, at this time
% Change Average Won Opportunity Line Revenue Same Time Last Quarter	The % change in Average Won Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Average Won Opportunity Line Revenue Same Time Last Year	The % change in Average Won Opportunity Line Revenue compared to the Last Year, at this time
% Change Lost Opportunity Line Revenue Same Time Last Period	The % change in Lost Opportunity Line Revenue compared to the Last Period, at this time
% Change Lost Opportunity Line Revenue Same Time Last Quarter	The % change in Lost Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Lost Opportunity Line Revenue Same Time Last Year	The % change in Lost Opportunity Line Revenue compared to the Last Year, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Period	The % change in No Sale Opportunity Line Revenue compared to the Last Period, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Quarter	The % change in No Sale Opportunity Line Revenue compared to the Last Quarter, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Year	The % change in No Sale Opportunity Line Revenue compared to the Last Year, at this time
% Change Open Opportunity Line Revenue Same Time Last Period	The % change in Open Opportunity Line Revenue compared to the Last Period, at this time
% Change Open Opportunity Line Revenue Same Time Last Quarter	The % change in Open Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Open Opportunity Line Revenue Same Time Last Year	The % change in Open Opportunity Line Revenue compared to the Last Year, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Period	The % change in Weighted Open Opportunity Line Revenue compared to the Last Period, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Quarter	The % change in Weighted Open Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Year	The % change in Weighted Open Opportunity Line Revenue compared to the Last Year, at this time
% Change Won Opportunity Line Revenue Same Time Last Period	The % change in Won Opportunity Line Revenue compared to the Last Period, at this time
% Change Won Opportunity Line Revenue Same Time Last Quarter	The % change in Won Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Won Opportunity Line Revenue Same Time Last Year	The % change in Won Opportunity Line Revenue compared to the Last Year, at this time
% Renewal Lost Opportunity Line Revenue	The % of Renewal Lost Opportunity Line Revenue of the total Lost Opportunity Line Revenue. This metric is computed as follows: (Renewal Lost Opportunity Line Revenue / Lost Opportunity Line Revenue)
% Renewal Open Opportunity Line Revenue	The % of Renewal Open Opportunity Line Revenue of the total Open Opportunity Line Revenue. This metric is computed as follows: (Renewal Open Opportunity Line Revenue / Open Opportunity Line Revenue)
% Renewal Opportunity Line Revenue	The % of Renewal Opportunity Line Revenue of the total Opportunity Line Revenue. This metric is computed as follows: (Renewal Opportunity Line Revenue / Opportunity Line Revenue)
% Renewal Won Opportunity Line Revenue	The % of Renewal Won Opportunity Line Revenue of the total Won Opportunity Line Revenue. This metric is computed as follows: (Renewal Won Opportunity Line Revenue / Won Opportunity Line Revenue)
Average # of Days Open	The average number of days an Opportunity Revenue Line is Open. This metric is computed as follows: (Current Date - Open Opportunity Revenue Line Creation Date)/# of Open Opportunity Revenue Lines
Average Age of Lost Opportunity Revenue Lines	The average age of the Lost Opportunity Revenue Lines. This metric is computed as follows: sum(Lost Revenue Line Close Date - Lost Revenue Line Created Date))/# of Lost Opportunity Revenue Lines
Average Age of No Sale Opportunity Revenue Lines	The average age of the No Sale Opportunity Revenue Lines. This metric is computed as follows: sum(No Sale Revenue Line Close Date - No Sale Revenue Line Created Date))/# of No Sale Opportunity Revenue Lines
Average Age of Opportunity Revenue Lines	The average age of the Opportunity Revenue Lines. This metric is computed as follows: sum(Won/Lost/No Sale Revenue Line Close Date - Won/Lost/No Sale Revenue Line Created Date))/# of Won+Lost+No Sale Opportunity Revenue Lines
Average Age of Won Opportunity Revenue Lines	The average age of the Won Opportunity Revenue Lines. This metric is computed as follows: sum(Won Revenue Line Close Date - Won Revenue Line Created Date))/# of Won Opportunity Revenue Lines
Average Won Opportunity Line Revenue	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue/# of Won Opportunity Revenue Lines
Competitive Opportunity Line Revenue	The total Opportunity Line Revenue with atleast one competitor
Expansion Lost Opportunity Line Revenue	The total Lost Expansion Opportunity Line Revenue (Revenue Type = Expansion and Revenue Status = Lost)
Expansion No Sale Opportunity Line Revenue	The total No Sale Expansion Opportunity Line Revenue (Revenue Type = Expansion and Revenue Status = No Sale)
Expansion Open Opportunity Line Revenue	The total Open Expansion Opportunity Line Revenue (Revenue Type = Expansion and Revenue Status = Open)
Expansion Opportunity Line Revenue	The total Expansion Opportunity Line Revenue (Revenue Type = Expansion)
Expansion Won Opportunity Line Revenue	The total Won Expansion Opportunity Line Revenue (Revenue Type = Expansion and Revenue Status = Won)
Expected Opportunity Line Revenue	The total Expected Opportunity Line Revenue
Expired Opportunity Line Revenue	The total Expired Opportunity Line Revenue (status = Open and Current Date > Expected Close date for Revenue Line)
Lost Competitive Opportunity Line Revenue	The total Lost Opportunity Line Revenue with atleast one competitor
Lost Opportunity Line Non-Recurring Revenue	The total Lost Opportunity Line Non-Recurring Revenue (Revenue Status = Lost)
Lost Opportunity Line Recurring Revenue	The total Lost Opportunity Line Recurring Revenue (Revenue Status = Lost)
Lost Opportunity Line Revenue	The total Lost Opportunity Line Revenue (Revenue Status = Lost)
Lost Opportunity Line Usage Revenue	The total Lost Opportunity Line Usage Revenue (Revenue Status = Lost)
New Lost Opportunity Line Revenue	The total Lost New Opportunity Line Revenue (Revenue Type = New and Revenue Status = Lost)
New No Sale Opportunity Line Revenue	The total No Sale New Opportunity Line Revenue (Revenue Type = New and Revenue Status = No Sale)
New Open Opportunity Line Revenue	The total Open New Opportunity Line Revenue (Revenue Type = New and Revenue Status = Open)
New Opportunity Line Revenue	The total New Opportunity Line Revenue (Revenue Type = New)
New Won Opportunity Line Revenue	The total Won New Opportunity Line Revenue (Revenue Type = New and Revenue Status = Won)
No Sale Competitive Opportunity Line Revenue	The total No Sale Opportunity Line Revenue with atleast one competitor
No Sale Opportunity Line Non-Recurring Revenue	The total No Sale Opportunity Line Non-Recurring Revenue (Revenue Status = No Sale)
No Sale Opportunity Line Recurring Revenue	The total No Sale Opportunity Line Recurring Revenue (Revenue Status = No Sale)
No Sale Opportunity Line Revenue	The total No Sale Opportunity Line Revenue (Revenue Status = No Sale)
No Sale Opportunity Line Usage Revenue	The total No Sale Opportunity Line Usage Revenue (Revenue Status = No Sale)
Non-Renewal Lost Opportunity Line Revenue	The total Lost Non-Renewal Opportunity Line Revenue (Revenue Type = Do not Renew and Revenue Status = Lost)
Non-Renewal No Sale Opportunity Line Revenue	The total No Sale Non-Renewal Opportunity Line Revenue (Revenue Type = Do not Renew and Revenue Status = No Sale)
Non-Renewal Open Opportunity Line Revenue	The total Open Non-Renewal Opportunity Line Revenue (Revenue Type = Do not Renew and Revenue Status = Open)
Non-Renewal Opportunity Line Revenue	The total Non-Renewal Opportunity Line Revenue (Revenue Type = Do not Renew)
Non-Renewal Won Opportunity Line Revenue	The total Won Non-Renewal Opportunity Line Revenue (Revenue Type = Do not Renew and Revenue Status = Won)
Open Competitive Opportunity Line Revenue	The total Open Opportunity Line Revenue with atleast one competitor
Open Opportunity Line Non-Recurring Revenue	The total Open Opportunity Line Non-Recurring Revenue (Revenue Status = Open)
Open Opportunity Line Recurring Revenue	The total Open Opportunity Line Recurring Revenue (Revenue Status = Open)
Open Opportunity Line Revenue	The total Open Opportunity Line Revenue (Revenue Status = Open)
Open Opportunity Line Usage Revenue	The total Open Opportunity Line Usage Revenue (Revenue Status = Open)
Opportunity Line Non-Recurring Revenue	The total Opportunity Line Non-Recurring Revenue
Opportunity Line Recurring Revenue	The total Opportunity Line Recurring Revenue
Opportunity Line Revenue	The total Opportunity Line Revenue
Opportunity Line Split Revenue	The total Opportunity Line Split Revenue
Opportunity Line Usage Revenue	The total Opportunity Line Usage Revenue
Raw Opportunity Line Revenue	The total Raw Opportunity Line Revenue
Renewal Lost Opportunity Line Revenue	The total Lost Renewal Opportunity Line Revenue (Revenue Type = Renew and Revenue Status = Lost)
Renewal No Sale Opportunity Line Revenue	The total No Sale Renewal Opportunity Line Revenue (Revenue Type = Renew and Revenue Status = No Sale)
Renewal Open Opportunity Line Revenue	The total Open Renewal Opportunity Line Revenue (Revenue Type = Renew and Revenue Status = Open)
Renewal Opportunity Line Revenue	The total Renewal Opportunity Line Revenue (Revenue Type = Renew)
Renewal Won Opportunity Line Revenue	The total Won Renewal Opportunity Line Revenue (Revenue Type = Renew and Revenue Status = Won)
Revenue Line Competitive Conversion Rate	The Competitive Revenue Line conversion rate. This metric is computed as follows: 100 * # of Won Competitive Revenue Lines/# of Competitive Opportunity Revenue Lines
Revenue Line Competitive Loss Rate	The Competitive Revenue Line Loss rate. This metric is computed as follows: 100 * # of Lost competitive Revenue Lines/# of Won+Lost Competitive Revenue Lines
Revenue Line Competitive Won Rate	The Competitive Revenue Line Win rate. This metric is computed as follows: 100 * # of Won Competitive Revenue Lines/# of Won+Lost Competitive Revenue Lines
Revenue Line Conversion Rate	The Revenue Line conversion rate. This metric is computed as follows: 100 * # of Won Opportunity Revenue Lines/# of Opportunity Revenue Lines
Revenue Line Loss Rate	The Revenue Line Loss rate. This metric is computed as follows: 100 * # of Lost Opportunity Revenue Lines/# of Won+Lost Opportunity Revenue Lines
Revenue Line Won Rate	The Revenue Line Win rate. This metric is computed as follows: 100 * # of Won Opportunity Revenue Lines/# of Won+Lost Opportunity Revenue Lines
Weighted Open Opportunity Line Revenue	The total Weighted Opportunity Line Revenue. This metric is computed as follows: Open Opportunity Revenue * Win Probability
Won Competitive Opportunity Line Revenue	The total Won Opportunity Line Revenue with atleast one competitor
Won Opportunity Line Non-Recurring Revenue	The total Won Opportunity Line Non-Recurring Revenue (Revenue Status = Won)
Won Opportunity Line Recurring Revenue	The total Won Opportunity Line Recurring Revenue (Revenue Status = Won)
Won Opportunity Line Revenue	The total Won Opportunity Line Revenue (Revenue Status = Won)
Won Opportunity Line Usage Revenue	The total Won Opportunity Line Usage Revenue (Revenue Status = Won)
Average Revenue Line Discount %	The Average Revenue Line Discount Percentage.

CX - Opportunity Revenue Line Snapshot

These metrics are used in the Document Currency (DC), CX Currency (CC), and Analytics Currency (AC) fact folders in this subject area.

Document Currency is the currency used while entering the data in the application. CX Currency is the currency defined in Oracle CRM. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Opportunity Expected Close Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
# of Competitive Opportunity Revenue Lines	The total Opportunity Revenue Lines with atleast one Competitor
# of Expired Opportunity Revenue Lines	The total Expired Opportunity Revenue Lines with atleast one Competitor
# of Lost Competitive Opportunity Revenue Lines	The total Lost Opportunity Revenue Lines with atleast one Competitor
# of Lost Opportunity Revenue Lines	The total Lost Opportunity Revenue Lines (Revenue Status = Lost)
# of No Sale Competitive Opportunity Revenue Lines	The total No Sale Opportunity Revenue Lines with atleast one Competitor
# of No Sale Opportunity Revenue Lines	The total No Sale Opportunity Revenue Lines (Revenue Status = No Sale)
# of Open Competitive Opportunity Revenue Lines	The total Open Opportunity Revenue Lines with atleast one Competitor
# of Open Opportunity Revenue Lines	The total Open Opportunity Revenue Lines (Revenue Status = Open)
# of Opportunity Revenue Lines	The total Opportunity Revenue Lines
# of Raw Opportunity Revenue Lines	The total Raw Opportunity Revenue Lines
# of Won Competitive Opportunity Revenue Lines	The total Won Opportunity Revenue Lines with atleast one Competitor
# of Won Opportunity Revenue Lines	The total Won Opportunity Revenue Lines (Revenue Status = Won)
% Change Average Won Opportunity Line Revenue Same Time Last Period	The % change in Average Won Opportunity Line Revenue compared to the Last Period, at this time
% Change Average Won Opportunity Line Revenue Same Time Last Quarter	The % change in Average Won Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Average Won Opportunity Line Revenue Same Time Last Year	The % change in Average Won Opportunity Line Revenue compared to the Last Year, at this time
% Change Lost Opportunity Line Revenue Same Time Last Period	The % change in Lost Opportunity Line Revenue compared to the Last Period, at this time
% Change Lost Opportunity Line Revenue Same Time Last Quarter	The % change in Lost Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Lost Opportunity Line Revenue Same Time Last Year	The % change in Lost Opportunity Line Revenue compared to the Last Year, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Period	The % change in No Sale Opportunity Line Revenue compared to the Last Period, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Quarter	The % change in No Sale Opportunity Line Revenue compared to the Last Quarter, at this time
% Change No Sale Opportunity Line Revenue Same Time Last Year	The % change in No Sale Opportunity Line Revenue compared to the Last Year, at this time
% Change Open Opportunity Line Revenue Same Time Last Period	The % change in Open Opportunity Line Revenue compared to the Last Period, at this time
% Change Open Opportunity Line Revenue Same Time Last Quarter	The % change in Open Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Open Opportunity Line Revenue Same Time Last Year	The % change in Open Opportunity Line Revenue compared to the Last Year, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Period	The % change in Weighted Open Opportunity Line Revenue compared to the Last Period, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Quarter	The % change in Weighted Open Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Weighted Open Opportunity Line Revenue Same Time Last Year	The % change in Weighted Open Opportunity Line Revenue compared to the Last Year, at this time
% Change Won Opportunity Line Revenue Same Time Last Period	The % change in Won Opportunity Line Revenue compared to the Last Period, at this time
% Change Won Opportunity Line Revenue Same Time Last Quarter	The % change in Won Opportunity Line Revenue compared to the Last Quarter, at this time
% Change Won Opportunity Line Revenue Same Time Last Year	The % change in Won Opportunity Line Revenue compared to the Last Year, at this time
Average # of Days Open	The average number of days an Opportunity Revenue Line is Open. This metric is computed as follows: (Current Date - Open Opportunity Revenue Line Creation Date)/# of Open Opportunity Revenue Lines)
Average Age of Lost Opportunity Revenue Lines	The average age of the Lost Opportunity Revenue Lines. This metric is computed as follows: sum(Lost Revenue Line Close Date - Lost Revenue Line Created Date))/# of Lost Opportunity Revenue Lines
Average Age of No Sale Opportunity Revenue Lines	The average age of the No Sale Opportunity Revenue Lines (sum(No Sale Revenue Line Close Date - No Sale Revenue Line Created Date))/# of No Sale Opportunity Revenue Lines
Average Age of Opportunity Revenue Lines	The average age of the Opportunity Revenue Lines. This metric is computed as follows: sum(Won/Lost/No Sale Revenue Line Close Date - Won/Lost/No Sale Revenue Line Created Date))/# of Won+Lost+No Sale Opportunity Revenue Lines
Average Age of Won Opportunity Revenue Lines	The average age of the Won Opportunity Revenue Lines. This metric is computed as follows: sum(Won Revenue Line Close Date - Won Revenue Line Created Date))/# of Won Opportunity Revenue Lines
Average Won Opportunity Line Revenue	The average Won Opportunity Line Revenue. This metric is computed as follows: Won Opportunity Line Revenue/# of Won Opportunity Revenue Lines
Competitive Opportunity Line Revenue	The total Opportunity Line Revenue with atleast one competitor
Expected Opportunity Line Revenue	The total Expected Opportunity Line Revenue
Expired Opportunity Line Revenue	The total Expired Opportunity Line Revenue (status = Open and Current Date > Expected Close date for Revenue Line)
Lost Competitive Opportunity Line Revenue	The total Lost Opportunity Line Revenue with atleast one competitor
Lost Opportunity Line Revenue	The total Lost Opportunity Line Revenue (Revenue Status = Lost)
No Sale Competitive Opportunity Line Revenue	The total No Sale Opportunity Line Revenue with atleast one competitor
No Sale Opportunity Line Revenue	The total No Sale Opportunity Line Revenue (Revenue Status = No Sale)
Open Competitive Opportunity Line Revenue	The total Open Opportunity Line Revenue with atleast one competitor
Open Opportunity Line Revenue	The total Open Opportunity Line Revenue (Revenue Status = Open)
Opportunity Line Revenue	The total Opportunity Line Revenue
Opportunity Line Split Revenue	The total Opportunity Line Split Revenue
Raw Opportunity Line Revenue	The total Raw Opportunity Line Revenue
Revenue Line Competitive Conversion Rate	The Competitive Revenue Line conversion rate. This metric is computed as follows: 100 * # of Won Competitive Revenue Lines/# of Competitive Opportunity Revenue Lines
Revenue Line Competitive Loss Rate	The Competitive Revenue Line Loss rate. This metric is computed as follows: 100 * # of Lost competitive Revenue Lines/# of Won+Lost Competitive Revenue Lines
Revenue Line Competitive Won Rate	The Competitive Revenue Line Win rate. This metric is computed as follows: 100 * # of Won Competitive Revenue Lines/# of Competitive Won+Lost Opportunity Revenue Lines
Revenue Line Conversion Rate	The Revenue Line conversion rate. This metric is computed as follows: 100 * # of Won Opportunity Revenue Lines/# of Opportunity Revenue Lines
Revenue Line Loss Rate	The Revenue Line Loss rate. This metric is computed as follows: 100 * # of Lost Opportunity Revenue Lines/# of Won+Lost Opportunity Revenue Lines
Revenue Line Won Rate	The Revenue Line Win rate. This metric is computed as follows: 100 * # of Won Opportunity Revenue Lines/# of Won+Lost Opportunity Revenue Lines
Weighted Open Opportunity Line Revenue	The total Weighted Opportunity Line Revenue. This metric is computed as follows: Open Opportunity Revenue * Win Probability
Won Competitive Opportunity Line Revenue	The total Won Opportunity Line Revenue with atleast one competitor
Won Opportunity Line Revenue	The total Won Opportunity Line Revenue (Revenue Status = Won)
# of Changes to Expected Enterprise Line Close Date	The total number of times the Revenue Line Expected Close Date has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the date has been changed 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of date changes in the chosen snapshot period. (Note - This metric depends on the snapshot frequency e.g. if the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured).
# of Changes to Expected Enterprise Line Close Period	The total number of times the Revenue Line Expected Close Period has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the period has been changed 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of period changes in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured).
# of Changes to Expected Enterprise Line Close Quarter	The total number of times the Revenue Line Expected Close Quarter has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the quarter has been changed 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of quarter changes in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured).
# of Changes to Expected Enterprise Line Close Year	The total number of times the Revenue Line Expected Close Year has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the year has been changed 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of year changes in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured).
# of Revenue Lines moved out in the selected snapshot period	The total Revenue Lines moved out of the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 will be shown.
# of Revenue Lines moved out by 1 period in the selected snapshot period	The total Revenue Lines moved out by 1 period from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q2 will be shown.
# of Revenue Lines moved out by 2 periods in the selected snapshot period	The total Revenue Lines moved out by 2 periods from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q3 will be shown.
# of Revenue Lines moved out by 3 periods in the selected snapshot period	The total Revenue Lines moved out by 3 periods from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q4 will be shown.
# of New Revenue Lines added in the selected snapshot period	The total New Revenue Lines added to selected time period when the snapshot was taken. Note: This data is for the selected snapshot period. e.g. If Q2 is the snapshot quarter chosen, the revenue lines newly added in Q2 will be shown. (Note: When a snapshot is scheduled newly, all the Opportunities would show up as New Opportunities for the first snapshot)
# of Existing Revenue Lines added in the selected snapshot period	The total Existing Revenue Lines added to the selected time period when the snapshot was taken. Note: This data is for the selected snapshot period. e.g. If Q2 is the snapshot quarter chosen, the existing revenue lines added in Q2 will be shown.
# of Revenue Lines added in the selected snapshot period	The total Revenue Lines added to the selected time period when the snapshot was taken. Note: This data is for the selected snapshot period. e.g. If Q2 is the snapshot quarter chosen, the total revenue lines added in Q2 will be shown.
# of times Revenue Line Amount Changed	The total number of times the Revenue Line Expected Amount has been changed till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the revenue amount has been changed 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of date changes in the chosen snapshot period.
# of times Revenue Line Amount Increased	The total number of times the Revenue Line Expected Amount has been increased till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the revenue amount has been increased 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of amount increases in the chosen snapshot period.
# of times Revenue Line Amount Decreased	The total number of times the Revenue Line Expected Amount has been decreased till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the revenue amount has been decreased 10 times in total during the lifetime of the Revenue Line, and 2 times in Q2, then this will show 10 and not the count of amount decreases in the chosen snapshot period.

CX - Opportunity Snapshot

This table describes the Opportunity Snapshot Metrics.

Metric	Metric Definition
# of Accounts with Won Opportunities	The total Accounts with Won Opportunities
# of Competitive Lost Opportunities	The total Lost Opportunities with atleast one Competitor
# of Competitive No Sale Opportunities	The total No Sale Opportunities with atleast one Competitor
# of Competitive Open Opportunities	The total Open Opportunities with atleast one Competitor
# of Competitive Opportunities	The total Opportunities with atleast one Competitor
# of Competitive Won Opportunities	The total Won Opportunities with atleast one Competitor
# of Expired Opportunities	The total Expired Opportunities (Opportunity Status = Open, Current Date > Opportunity Expected Close Date)
# of Lost Opportunities	The total Lost Opportunities in the system (Opportunity Status = Lost)
# of No Sale Opportunities	The total No Sale Opportunities in the system (Opportunity Status = No Sale)
# of Open Opportunities	The total Open Opportunities in the system (Opportunity Status = Open)
# of Opportunities	The total Opportunities
# of Won Opportunities	The total Won Opportunities in the system (Opportunity Status = Won)
Average # of Days Open	Average number of days the Opportunity is Open. This metric is computed as follows: Total days the Opportunity is Open/# of Open Opportunities
Average # of Days to Close	Average number of days to Close an Opportunity. This metric is computed as follows: Total days needed to close Opportunities/# of closed Opportunities
Average Age of Closed Opportunities	Average Age of Closed Opportunities. This metric is computed as follows: Total Closed Opportunities Age/# of Closed Opportunities
Average Age of Lost Opportunities	Average Age of Lost Opportunities. This metric is computed as follows: Total Lost Opportunities Age/# of Lost Opportunities
Average Age of No Sale Opportunities	Average Age of No Sale Opportunities. This metric is computed as follows: Total No Sale Opportunities Age/number of No Sale Opportunities
Average Age of Won Opportunities	Average Age of Won Opportunities. This metric is computed as follows: Total Won Opportunities Age/# of Won Opportunities
Average Opportunity Win Probability	Average probability to Win the Opportunity. This metric is computed as follows: Total win probabilities/# of Opportunities
Competitive Loss Rate	Rate of Losing Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Lost Opportunities/Total Competitive Closed Opportunities
Competitor Conversion Rate	Rate of Converting Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Won Opportunities/Total Competitive Opportunities
Competitor Win Rate	Rate of Winning Competitive Opportunities. This metric is computed as follows: 100 * Total Competitive Won Opportunities/Total Competitive Won and Lost Opportunities
Conversion Rate	Rate of Converting Opportunities. This metric is computed as follows: 100 * Total Won Opportunities/Total Opportunities
Loss Rate	Rate of Losing Opportunities. This metric is computed as follows: 100 * Total Lost Opportunities/Total Won and Lost Opportunities
Win Rate	Rate of Winning Opportunities. This metric is computed as follows: 100 * Total Won Opportunities/Total Won and Lost Opportunities
# of Changes to Expected Enterprise Close Date	The total number of times the Opportunity Expected Close Date has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the Date has been changed 10 times in total during the lifetime of the Opportunity, and 2 times in Q2, then this will show 10 and not the count of Date changes only in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured)
# of Changes to Expected Enterprise Close Period	The total number of times the Opportunity Expected Close Period has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the Period has been changed 10 times in total during the lifetime of the Opportunity, and 2 times in Q2, then this will show 10 and not the count of Period changes only in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured)
# of Changes to Expected Enterprise Close Quarter	The total number of times the Opportunity Expected Close Quarter has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the Quarter has been changed 10 times in total during the lifetime of the Opportunity, and 2 times in Q2, then this will show 10 and not the count of Quarter changes only in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured)
# of Changes to Expected Enterprise Close Year	The total number of times the Opportunity Expected Close Year has been changed in its lifecycle till the end of the selected snapshot period. e.g. If Q2 is the snapshot quarter selected, and if the Year has been changed 10 times in total during the lifetime of the Opportunity, and 2 times in Q2, then this will show 10 and not the count of Year changes only in the chosen snapshot period. (Note - this depends on the snapshot frequency e.g. If the snapshot frequency is weekly, and there are multiple changes done before the weekly snapshot is taken, those cannot be captured)
# of Opportunities moved out in the selected snapshot period	The total Opportunities moved out of the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 will be shown.
# of Opportunities moved out by 1 period in the selected snapshot period	The total Opportunities moved out by 1 period from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q2 will be shown.
# of Opportunities moved out by 2 periods in the selected snapshot period	The total Opportunities moved out by 2 periods from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q3 will be shown.
# of Opportunities moved out by 3 periods in the selected snapshot period	The total Opportunities moved out by 3 periods from the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those revenue lines that were moved out in Q1 to Q4 will be shown.
# of Opportunities added in the selected snapshot period	The total Opportunities added in the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those Opportunities that were added in Q1 will be shown.
# of New Opportunities added in the selected snapshot period	The total New Opportunities added in the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those New Opportunities that were added in Q1 will be shown. (When a snapshot is scheduled newly, all the Opportunities would show up as New Opportunities for the first snapshot)
# of Existing Opportunities added in the selected snapshot period	The total Existing Opportunities added in the selected snapshot period. Note: This data is for the selected snapshot period. e.g. If Q1 is the snapshot quarter chosen, only those Existing Opportunities from other quarters and added in Q1 will be shown. Any new Opportunities created during Q1 period will not be included here.

CX - Opportunity Stage Progression

This table describes the Opportunity Stage Progression Metrics.

Metric	Metric Definition
# of Opportunities	The total Opportunities
# of Opportunities Across Stages	The total Opportunities across Stages
# of Progressed Opportunities	The total Progressed Opportunities
% Opportunities by Stage	The % of Opportunities in a stage of the total Opportunities
% Progressed	The Progressed Opportunity Percentage. This metric is computed as follows: # of Progressed Opportunities/# of Opportunities Across Stages
Average # of Days in Stage	The average number of days in a Sales stage. This metric is computed as follows: sum of days in stage/# of Opportunities
Average # of Days Stalled in Stage	The average number of stalled days in a Sales stage. This metric is computed as follows: sum of stalled days/# of Opportunities
Conversion Rate	The rate of converting Opportunities.This metric is computed as follows: 100 * # of Won Opportunities/# of Opportunities
Loss Rate	The rate of losing Opportunities.This metric is computed as follows: 100 * # of Lost opportunities/# of Won+Lost Opportunities
Win Rate	The rate of winning Opportunities. This metric is computed as follows: 100 * # of Won opportunities/# of Won+Lost Opportunities

CX - Service Request

This table describes the Service Request Metrics.

Metric	Metric Definition
# of Closed Critical SRs	The total number of Critical SRs that are in Closed status (status = Closed)
# of Closed SRs	The total number of Closed SRs (status = Closed)
# of Critical SRs	The total number of Critical SRs
# of High Severity SRs	The total number of High severity SRs (severity = High)
# of In Progress Critical SRs	The total number of Critical SRs that are In Progress status
# of In Progress SRs	The total number of in progress SRs (status = In Progress)
# of Initial Resource Assigned SRs	The total number of assigned SRs
# of Internal Resolved Closed SRs	The total number of SRs with Resolved or Closed status
# of Low Severity SRs	The total number of Low severity SRs (severity = Low)
# of Medium Severity SRs	The total number of Medium severity SRs (severity = Medium)
# of New Critical SRs	The total number of Critical SRs that are in New status
# of New SRs	The total number of new SRs (status = New)
# of Open Critical SRs	The total number of Critical SRs that are Open (status = In Progress, New and Waiting)
# of Open High Severity Critical SRs	The total number of Critical SRs that are High severity and Open (status = In Progress, New and Waiting)
# of Open SRs	The total number of Open SRs (status = In Progress, New and Waiting)
# of Raw SRs	The total SRs in the sytem including the deleted ones (delete flag = Y)
# of Reopened SRs	The total number of SRs that are Reopened
# of Resolved Critical SRs	The total number of Critical SRs that are Resolved (status = Resolved)
# of Resolved SRs	The total number of SRs that are Resolved (status = Resolved)
# of SRs	The total number of SRs
# of SRs Pending Agent Action	The total number of SRs assigned to an Agent having status as In Progress or New
# of SRs Resolved in 24-48 hrs	The total number of SRs that were resolved in between 24-48 hours after they were opened
# of SRs Resolved in under 24 hrs	The total number of SRs that were resolved in under 24 hours after they were opened
# of SRs Transferred	Number of SR's that were transferred
# of Transfers	Number of times the SR's were transferred
# of Unassigned SRs	The total number of SRs that have not been assigned
# of Waiting Critical SRs	The total number of Critical SRs that are in Queue and waiting to be assigned (status = Waiting)
# of Waiting SRs	The total number of SRs that are in Queue and waiting to be assigned (status = Waiting)
% Reopened SRs	The % of now Closed SRs that were Reopened in SR lifecycle. This metric is computed as follows: (# of Reopened SRs that are in Closed state/# of Closed SRs)*100
% SRs Transferred	The total percentage of SR's that were transferred. This metric is computed as follows: 100*(# of SRs Transferred/# of SRs)
Average # of Transfers	The average number of times SR's were transferred. This metric is computed as follows: (# of Transfers/# of SRs Transferred)
Average Open SR Age (Days)	The average number of days a SRs is Open
Average Time to Assign to Resource(Days)	The average number of days to assign a resource to the SRs
Average Time to Assign to Resource(Hours)	The average number of hours to assign a resource to the SRs
Average Time to Assign to Resource(Mins)	The average number of minutes to assign a resource to the SRs
Average Time to Close (Days)	The average days to close the SRs
Average Time to Close (Hours)	The average hours to close the SRs
Average Time to Close (Mins)	The average minutes to close the SRs
Average Time to Resolve (Days)	The average days to resolve the SRs
Average Time to Resolve (Hours)	The average hours to resolve the SRs
Average Time to Resolve (Mins)	The average minutes to resolve the SRs
Open SR Age (Days)	# of days since the SR was reported (doesn't apply for Closed/Resolved SRs)
SR Resolution Rate	The SRs Resolution rate. This metric is computed as follows: 100 * # of Resolved + Closed SRs/# of SRs
Total Time to Assign to Queue (Days)	The total number of days to assign a SRs to a Queue
Total Time to Assign to Queue (Hours)	The total number of hours to assign a SRs to a Queue
Total Time to Assign to Queue (Mins)	The total number of minutes to assign a SRs to a Queue
Total Time to Assign to Resource(Days)	The total number of days to assign a resource to SRs
Total Time to Assign to Resource(Hours)	The total number of hours to assign a resource to SRs
Total Time to Assign to Resource(Mins)	The total number of minutes to assign a resource to SRs
Total Time to Close (Days)	The total number of days to close the SRs
Total Time to Close (Hours)	The total number of hours to close the SRs
Total Time to Close (Mins)	The total number of minutes to close the SRs
Total Time to Resolve (Days)	The total number of days to resolve a SRs
Total Time to Resolve (Hours)	The total number of hours to resolve a SRs
Total Time to Resolve (Mins)	The total number of minutes to resolve a SRs

CX - Service Request Lifecycle

This table describes the B2B Service Request Lifecycle metrics.

Metric	Metric Definition
# of Distinct SR Assignees	The number of distinct resources an SR has been assigned to.
# of Distinct SR Queues Assigned	The number of distinct Queues the SR has been assigned to. (The initial Queue assignment is also counted).
# of Raw SRs (Lifecycle)	The total number of SRs tracked for Lifecycle changes, including the deleted SRs..
# of SR Lifecycle Changes	The total updates made to the SR (changes to Status, Severity, Queue assignment, and Resource Assignment).
# of SR Queue Assignments	The number of Queues the SR has been assigned to. (The initial Queue assignment and multiple assignments to the same queue is counted ).
# of SR Reopen Events	The number of times an SR has been reopened (after being resolved).
# of SR Resource Assignments	The number of resources an SR has been assigned to (multiple assignations to the same resource are counted).
# of SR Status Change Events	The number of times (occurrences) the SR status changes..
# of SRs (Lifecycle)	The total number of SRs tracked for Lifecycle changes.
Average # of Distinct SR Assignees	The average number of distinct SR Assignees. This metric is calculated as follows: # of Distinct SR Assignees / # of SRs with at least one assignee.
Average # of Distinct SR Queues Assigned	The average number of distinct SR Queues. This metric is calculated as follows: # of Distinct SR Queues Assigned / # of SRs with Queue.
Average # of SR Queue Assignments	The average number of SR Queues. This metric is calculated as follows: # of SR Queues Assigned / # of SRs with Queue.
Average # of SR Resource Assignments	The average number of SR Resource Assignments. This metric is calculated as follows: # of SR Resource Assignments / # of SRs with at least one assignee.
Average Duration as High Severity SR (Days)	The total Duration as High Severity SR (Days) averaged over # of High Severity SRs. This metric is calculated as follows: Total Duration as High Severity SR (Days) / # of High Severity SRs.
Average Duration as High Severity SR (Hours)	The total Duration as High Severity SR (Hours) averaged over # of High Severity SRs. This metric is calculated as follows: Total Duration as High Severity SR (Hours) / # of High Severity SRs.
Average Duration as High Severity SR (Minutes)	The total Duration as High Severity SR (Minutes) averaged over # of High Severity SRs. This metric is calculated as follows: Total Duration as High Severity SR (Minutes) / # of High Severity SRs.
Average Duration as In Progress SR (Days)	The total Duration as In Progress SR (Days) averaged over # of In Progress SRs. This metric is calculated as follows: Total Duration as In Progress SR (Days) / # of In Progress SRs.
Average Duration as In Progress SR (Hours)	The total Duration as In Progress SR (Hours) averaged over # of In Progress SRs. This metric is calculated as follows: Total Duration as In Progress SR (Hours) / # of In Progress SRs.
Average Duration as In Progress SR (Minutes)	The total Duration as In Progress SR (Minutes) averaged over # of In Progress SRs. This metric is calculated as follows: Total Duration as In Progress SR (Minutes) / # of In Progress SRs.
Average Duration as Low Severity SR (Days)	The total Duration as Low Severity SR (Days) averaged over # of Low Severity SRs. This metric is calculated as follows: Total Duration as Low Severity SR (Days) / # of Low Severity SRs.
Average Duration as Low Severity SR (Hours)	The total Duration as Low Severity SR (Hours) averaged over # of Low Severity SRs. This metric is calculated as follows: Total Duration as Low Severity SR (Hours) / # of Low Severity SRs.
Average Duration as Low Severity SR (Minutes)	The total Duration as Low Severity SR (Minutes) averaged over # of Low Severity SRs. This metric is calculated as follows: Total Duration as Low Severity SR (Minutes) / # of Low Severity SRs.
Average Duration as Medium Severity SR (Days)	The total Duration as Medium Severity SR (Days) averaged over # of Medium Severity SRs. This metric is calculated as follows: Total Duration as Medium Severity SR (Days) / # of Medium Severity SRs.
Average Duration as Medium Severity SR (Hours)	The total Duration as Medium Severity SR (Hours) averaged over # of Medium Severity SRs. This metric is calculated as follows: Total Duration as Medium Severity SR (Hours) / # of Medium Severity SRs.
Average Duration as Medium Severity SR (Minutes)	The total Duration as Medium Severity SR (Minutes) averaged over # of Medium Severity SRs. This metric is calculated as follows: Total Duration as Medium Severity SR (Minutes) / # of Medium Severity SRs.
Average Duration as New SR (Days)	The total Duration as New SR (Days) averaged over # of New SRs. This metric is calculated as follows: Total Duration as New SR (Days) / # of New SRs.
Average Duration as New SR (Hours)	The total Duration as New SR (Hours) averaged over # of New SRs. This metric is calculated as follows: Total Duration as New SR (Hours) / # of New SRs.
Average Duration as New SR (Minutes)	The total Duration as New SR (Minutes) averaged over # of New SRs. This metric is calculated as follows: Total Duration as New SR (Minutes) / # of New SRs.
Average Duration as Resolved SR until Reopen (Days)	The total Duration as Resolved SR until Reopen (Days) averaged over # of re - opened SRs. This metric is calculated as follows: Total Duration as Resolved SR until Reopen (Days) / # of Resolved SR until Reopen.
Average Duration as Resolved SR until Reopen (Hours)	The total Duration as Resolved SR until Reopen (Hours) averaged over # of re - opened SRs. This metric is calculated as follows: Total Duration as Resolved SR until Reopen (Hours) / # of Resolved SR until Reopen.
Average Duration as Resolved SR until Reopen (Minutes)	The total Duration as Resolved SR until Reopen (Minutes) averaged over # of re - opened SRs. This metric is calculated as follows: Total Duration as Resolved SR until Reopen (Minutes) / # of Resolved SR until Reopen.
Average Duration as Waiting SR (Days)	The total Duration as Waiting SR (Days) averaged over # of Waiting SRs. This metric is calculated as follows: Total Duration as Waiting SR (Days) / # of Waiting SRs.
Average Duration as Waiting SR (Hours)	The total Duration as Waiting SR (Hours) averaged over # of Waiting SRs.. This metric is calculated as follows: Total Duration as Waiting SR (Hours) / # of Waiting SRs.
Average Duration as Waiting SR (Minutes)	The total Duration as Waiting SR (Minutes) averaged over # of Waiting SRs. This metric is calculated as follows: Total Duration as Waiting SR (Minutes) / # of Waiting SRs.
Average Duration in SR Queue (Days)	The total Duration in SR Queue (Days) averaged over # of SRs that have traversed that queue. This metric is calculated as follows: Total Duration in SR Queue (Days) / # of SRs in Queue .
Average Duration in SR Queue (Hours)	The total Duration in SR Queue (Hours) averaged over # of SRs that have traversed that queue. This metric is calculated as follows: Total Duration in SR Queue (Hours) / # of SRs in Queue .
Average Duration in SR Queue (Minutes)	The total Duration in SR Queue (Days) averaged over # of SRs that have traversed that queue. This metric is calculated as follows: Total Duration in SR Queue (Minutes) / # of SRs in Queue .
Average Duration of SR Lifecycle Change (Days)	The average duration in days that an SR is with a particular status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource. This metric is calculated as follows: Total Duration of SR Lifecycle Change (Days) / # of SRs tracked for Lifecycle changes.
Average Duration of SR Lifecycle Change (Hours)	The average duration in hours that an SR is with a particular status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource. This metric is calculated as follows: Total Duration of SR Lifecycle Change (Hours) / # of SRs tracked for Lifecycle changes.
Average Duration of SR Lifecycle Change (Minutes)	The average duration in minutes that an SR is with a particular status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource. This metric is calculated as follows: Total Duration of SR Lifecycle Change (Minutes) / # of SRs tracked for Lifecycle changes.
Average Duration SR Unassigned to Assignee (Days)	The total duration an SR is Unassigned to any Assignee (Days). This metric is calculated as follows: Total Duration SR Unassigned to Assignee (Days) / # of SRs not assigned to an Assignee (SRs where the Assignee field is blank).
Average Duration SR Unassigned to Assignee (Hours)	The total duration an SR is Unassigned to any Assignee (Hours). This metric is calculated as follows: Total Duration SR Unassigned to Assignee (Hours) / # of SRs not assigned to an Assignee (SRs where the Assignee field is blank).
Average Duration SR Unassigned to Assignee (Minutes)	The total duration an SR is Unassigned to any Assignee (Minutes). This metric is calculated as follows: Total Duration SR Unassigned to Assignee (Minutes) / # of SRs not assigned to an Assignee (SRs where the Assignee field is blank).
Average Duration SR Unassigned to Queue (Days)	The total duration an SR is Unassigned to any Queue (Days). This metric is calculated as follows: Total Duration SR Unassigned to Queue (Days) / # of SRs not assigned to a Queue (SRs where the Queue field is blank).
Average Duration SR Unassigned to Queue (Hours)	The total duration an SR is Unassigned to any Queue (Hours). This metric is calculated as follows: Total Duration SR Unassigned to Queue (Hours) / # of SRs not assigned to a Queue (SRs where the Queue field is blank).
Average Duration SR Unassigned to Queue (Minutes)	The total duration an SR is Unassigned to any Queue (Minutes). This metric is calculated as follows: Total Duration SR Unassigned to Queue (Minutes) / # of SRs not assigned to a Queue (SRs where the Queue field is blank).
Average Duration with SR Assignee (Days)	The total Duration with SR Assignee (Days) averaged over # of SRs assigned to the resource at least once. This metric is calculated as follows: Total Duration with SR Assignee (Days) / # of SRs with Assignees.
Average Duration with SR Assignee (Hours)	The total Duration with SR Assignee (Hours) averaged over # of SRs assigned to the resource at least once. This metric is calculated as follows: Total Duration with SR Assignee (Hours) / # of SRs with Assignees.
Average Duration with SR Assignee (Minutes)	The total Duration with SR Assignee (Minutes) averaged over # of SRs assigned to the resource at least once. This metric is calculated as follows: Total Duration with SR Assignee (Minutes) / # of SRs with Assignees.
Maximum Change End Date	The End time of association of an SR with a tracked attribute such as Assignee, Queue, Severity, Status or Status Type..
Minimum Change Start Date	The Start time of association of an SR with a tracked attribute such as Assignee, Queue, Severity, Status or Status Type..
Total Duration as High Severity SR (Days)	The total duration in days that SR Severity is High (Sev Code = ORA_SVC_SEV1).
Total Duration as High Severity SR (Hours)	The total duration in hours that SR Severity is High (Sev Code = ORA_SVC_SEV1).
Total Duration as High Severity SR (Minutes)	The total duration in minutes that SR Severity is High (Sev Code = ORA_SVC_SEV1).
Total Duration as In Progress SR (Days)	The total duration in days that an SR is in any status that belongs to 'In Progress' Status Type..
Total Duration as In Progress SR (Hours)	The total duration in hours that an SR is in any status that belongs to 'In Progress' Status Type..
Total Duration as In Progress SR (Minutes)	The total duration in minutes that an SR is in any status that belongs to 'In Progress' Status Type..
Total Duration as Low Severity SR (Days)	The total duration in days that SR Severity is Low (Sev Code = ORA_SVC_SEV3).
Total Duration as Low Severity SR (Hours)	The total duration in hours that SR Severity is Low (Sev Code = ORA_SVC_SEV3).
Total Duration as Low Severity SR (Minutes)	The total duration in minutes that SR Severity is Low (Sev Code = ORA_SVC_SEV3).
Total Duration as Medium Severity SR (Days)	The total duration in days that SR Severity is Medium (Sev Code = ORA_SVC_SEV2).
Total Duration as Medium Severity SR (Hours)	The total duration in hours that SR Severity is Medium (Sev Code = ORA_SVC_SEV2).
Total Duration as Medium Severity SR (Minutes)	The total duration in minutes that SR Severity is Medium (Sev Code = ORA_SVC_SEV2).
Total Duration as New SR (Days)	The total duration in days that an SR is in any status that belongs to 'New' Status Type..
Total Duration as New SR (Hours)	The total duration in hours that an SR is in any status that belongs to 'New' Status Type..
Total Duration as New SR (Minutes)	The total duration in minutes that an SR is in any status that belongs to 'New' Status Type..
Total Duration as Resolved SR until Reopen (Days)	The total duration in days that an SR is in any status that belongs to 'Resolved' Status type until it was reopened. (applicable only for a reopened SR).
Total Duration as Resolved SR until Reopen (Hours)	The total duration in hours that an SR is in any status that belongs to 'Resolved' Status type until it was reopened. (applicable only for a reopened SR).
Total Duration as Resolved SR until Reopen (Minutes)	The total duration in minutes that an SR is in any status that belongs to 'Resolved' Status type until it was reopened. (applicable only for a reopened SR).
Total Duration as Waiting SR (Days)	The total duration in days that an SR is in any status that belongs to 'Waiting' Status Type..
Total Duration as Waiting SR (Hours)	The total duration in hours that an SR is in any status that belongs to 'Waiting' Status Type..
Total Duration as Waiting SR (Minutes)	The total duration in minutes that an SR is in any status that belongs to 'Waiting' Status Type..
Total Duration in SR Queue (Days)	The total duration in days that an SR stays in any specific queue.
Total Duration in SR Queue (Hours)	The total duration in hours that an SR stays in any specific queue.
Total Duration in SR Queue (Minutes)	The total duration in minutes that an SR stays in any specific queue.
Total Duration of SR Lifecycle Change (Days)	The total duration in days that an SR is resident in a specific status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource..
Total Duration of SR Lifecycle Change (Hours)	The total duration in hours that an SR is resident in a specific status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource..
Total Duration of SR Lifecycle Change (Minutes)	The total duration in minutes that an SR is resident in a specific status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource..
Total Duration SR Unassigned to Assignee (Days)	The total duration in days that an SR is not assigned to any resource. (Assignee field is blank).
Total Duration SR Unassigned to Assignee (Hours)	The total duration in hours that an SR is not assigned to any resource. (Assignee field is blank).
Total Duration SR Unassigned to Assignee (Minutes)	The total duration in hours that an SR is not assigned to any resource. (Assignee field is blank).
Total Duration SR Unassigned to Queue (Days)	The total duration in days that an SR is not assigned to any Queue. (Queue field is blank).
Total Duration SR Unassigned to Queue (Hours)	The total duration in hours that an SR is not assigned to any Queue. (Queue field is blank).
Total Duration SR Unassigned to Queue (Minutes)	The total duration in minutes that an SR is not assigned to any Queue. (Queue field is blank).
Total Duration with SR Assignee (Days)	The total duration in days that an SR stays with any specific resource / assignee.
Total Duration with SR Assignee (Hours)	The total duration in hours that an SR stays with any specific resource / assignee.
Total Duration with SR Assignee (Minutes)	The total duration in minutes that an SR stays with any specific resource / assignee.
Average Duration of SR Lifecycle Change (Minutes)	The average duration in minutes that an SR is with a particular status / severity / queue / resource. The metric assumes meaning seen in context of one of status, severity, queue or resource. This metric is calculated as follows: Total Duration of SR Lifecycle Change (Minutes) / # of SRs tracked for Lifecycle changes.
Minimum Change Start Date	The Start time of association of an SR with a tracked attribute such as Assignee, Queue, Severity, Status or Status Type.
Maximum Change End Date	The End time of association of an SR with a tracked attribute such as Assignee, Queue, Severity, Status or Status Type.
# of Raw SRs (Lifecycle)	The total number of SRs tracked for Lifecycle changes, including the deleted SRs.

CX - Service Request Milestone

This table describes the B2B Service Request Milestone metrics.

Metric	Metric Definition
# of Active Milestones	The total SR Active Milestones (does not include the Milestones in Cancelled status)
# of Cancelled Milestones	The total SR Milestones that are in Cancelled status. (Milestone status = Cancelled)
# of Completed Compliant Milestones	The total Milestones that have been Completed and are Compliant (Milestone status = Complete and Compliance Flag = Y)
# of Completed Expired Milestones	The total Milestones that have been completed and Expired (Milestone status = Complete and Compliance Flag = N)
# of Completed Milestones	The total Milestones that have been completed (Milestone status = Complete)
# of Compliant Milestones	The total Compliant Milestones (Milestone Status not equal to Cancelled and Compliance Flag not equal to N)
# of Expired Milestones	The total Expired Milestones (Milestone Status not equal to Cancelled and Compliance Flag = N)
# of Milestones	The total SR Milestones including the Milestones in Cancelled status
# of Overdue Time Milestones	The total non-compliant/Overdue Milestones. (Compliance Flag = N). Canceled Milestones are also included in this metric.
# of Raw SRs (Milestone)	The total number of SRs with Milestones including the deleted SRs.
# of SRs	The total number of SRs with Milestones
% Completed Compliant Milestones	The percentage of Completed Compliant milestones. This metric is calculated as follows: 100*(# of Completed Compliant Milestones/# of Completed Milestones)
% Completed Expired Milestones	The percentage of Completed Expired Milestones. This metric is calculated as follows: 100*(# of Completed Expired Milestones/# of Completed Milestones)
% Completed Milestones	The percentage of Completed Milestones. This metric is calculated as follows: 100*(# of Completed Milestones/# of Active Milestones)
% Compliant Milestones	The percentage of Compliant Milestones. This metric is calculated as follows: 100*(# of Compliant Milestones/# of Active Milestones)
% Expired Milestones	The percentage of Expired Milestones. This metric is calculated as follows: 100*(# of Expired Milestones/# of Active Milestones)
Average of Overdue Time (Minutes)	The total time elapsed in minutes since the SR Milestone was due averaged over a number of overdue time Milestones. Applies for non-compliant milestones.
Overdue Time (Minutes)	The total time elapsed in minutes since the SR Milestone was due. Applies for non-compliant milestones.
# of First Response Compliant SRs	The total SRs that have the compliant first response milestone i.e. whose First Response milestone has been met.
# of Resolution Compliant SRs	The total Resolved Compliant SRs i.e. whose Resolution milestone has been met.
# of SRs with First response Violations	The total SRs with first-response violations i.e. whose First Response milestone has not been met.
# of SRs with Resolution Violations	The total SRs with Resolution violations i.e. whose Resolution milestone has not been met.
% First Response Compliant SRs	The percentage of the first response SRs that are compliant. This metric is calculated as follows: 100*(# of First Response Compliant SRs/(# of First Response Compliant SRs + # of SRs with First Response Violations)
% Resolution Compliant SRs	The percentage of the Resolution SRs that are compliant. This metric is calculated as follows: 100*(# of Resolution Compliant SRs/(# of Resolution Compliant SRs + # of SRs with Resolution Violations )
% SRs with First Response Violations	The percentage of the SRs with first-response violations. This metric is calculated as follows: 100*(# of SRs with First response Violations / (# of First Response Compliant SRs + # of SRs with First Response Violations)
% SRs with Resolution Violations	The percentage of the SRs with Resolution violations. This metric is calculated as follows: 100*(# of SRs with Resolution Violations/(# of Resolution Compliant SRs + # of SRs with Resolution Violations)

CX - Subscription Bill Line

This table describes the Subscription Bill Line metrics. These metrics are used in the Document Currency (DC) and Analytics Currency (AC) fact folders in this subject area.

Document Currency is the currency used while entering the data in the application. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Subscription Start Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Subscription Bill Amount	The total Subscription Bill Amount
Subscription Invoiced Amount with Tax	The total Subscription Invoiced Amount with Tax
Subscription Invoiced Bill Amount	The total Subscription Invoiced Bill Amount
Subscription Invoiced Onetime Charges	The total Subscription Invoiced Onetime Charges
Subscription Invoiced Recurring Charges	The total Subscription Invoiced Recurring Charges
Subscription Invoiced Usage Amount	The total Subscription Invoiced Usage Amount
Subscription Invoiced Usage Quantity	The total Subscription Invoiced Usage Quantity
Subscription Onetime Charges	The total Subscription Onetime Charges
Subscription Recurring Charges	The total Subscription Recurring Charges
Subscription Usage Amount	The total Subscription Usage Amount
Subscription Usage Quantity	The total Subscription Usage Quantity

CX - Subscription Historical Trend

This table describes the Subscription Historical Trend metrics. These metrics are used in the Document Currency (DC) and Analytics Currency (AC) fact folders in this subject area.

Metric	Metric Definition
# of Active Customers - Period Start	The total Active customers at the start of a period (Customers with an active subscription in a given period)
# of Active Subscriptions - Period Start	The total number of Active Subscriptions at the start of a period
Active MRR - Period Start	The total monthly recurring revenue of all Active Subscriptions at the start of a period
Average Revenue per Customer - Period Start	The total Average Revenue per Customer (ARPU) at the start of a period. This metric is computed as follows: Total Active MRR/Total number of Active Customers
Product Net Price (TCV) - Period Start	The total Product Net Price of Active Subscriptions at the start of a period
# of Active Customers - Period End	The total Active customers at the end of a period (Customers with an active subscription in a given period)
# of Active Subscriptions - Period End	The total number of Active Subscriptions at the end of a period
Active MRR - Period End	The total Monthly Recurring Revenue of all Active Subscriptions at the end of a period
Average Revenue per Customer - Period End	The total Average Revenue per Customer (ARPU) at the end of a period. This metric is computed as follows: Total Active MRR/Total number of Active Customers
Product Net Price (TCV) - Period End	The total Product Net Price of Active Subscriptions at the end of a period
# of New Active Subscriptions	The number of New Subscriptions started in a period. (Started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions)
# of Renewed Active Subscriptions	The number of Subscriptions Renewed in a period. (Number of active subscriptions that are renewed from existing subscriptions)
# of Terminated Subscriptions	The number of Subscriptions Terminated in a period. (Number of active subscriptions that are terminated in a period. This metric doesn't include closed subscriptions due to the amendment or suspension of existing subscriptions)
# of Due for Renewal Subscriptions	The number of Subscriptions that are due for Renewal in a period.
# of Expansion Subscriptions	The total Expansion Subscriptions (Target subscription MRR greater than Source Subscription MRR).
# of Contraction Subscriptions	The total number of Expansion Subscriptions (Target subscription MRR less than Source Subscription MRR).
# of Churned Renewal Subscription	The total Churned Renewal Subscriptions in a period. (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period)
# of Lapsed Renewal Subscriptions	The total Lapsed Renewal Subscriptions in a period. (Active subscriptions that expired in a period without being renewed).
New Active MRR	The total new MRR of Active subscriptions added in a period. (Started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions)
Activated Renewal MRR	The total Activated Renewal MRR in a period. (Active Subscriptions that were renewed from existing subscriptions)
Termination MRR	The total Termination MRR in a period. (Active subscriptions that are closed in a period, not due to the amendment or suspension of existing subscriptions)
MRR Due for Renewal	The total MRR of Subscriptions that are due for Renewal in a period
Expansion MRR	The total Expansion MRR in a period. (The difference in MRR between a target and source of an amendment relationship where the target MRR > Source MRR and the target start date falls within this period and not in Draft)
Contraction MRR	The total Contraction MRR in a period. (The difference in MRR between a target and source of an amendment relationship where the target MRR < Source MRR and the target start date falls within this period and not in Draft)
Churned Renewal MRR	The total Churned Renewal MRR in a period. (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period)
Lapsed Renewal MRR	The total Lapsed Renewal MRR in a period. (Active subscriptions that expired in a period without being renewed)
Product Net Price (TCV) - Contraction Subscriptions	The Product Net Price (TCV) due to Contraction in a period (The difference in Product Net Price (TCV) between a target and source of an amendment relationship where the target TCV less than Source TCV and the target start date falls within this period and not in Draft).
Product Net Price (TCV) - Expansion Subscriptions	The Product Net Price (TCV) due to Expansion in a period (The difference in Product Net Price (TCV) between a target and source of an amendment relationship where the target TCV greater than Source TCV and the target start date falls within this period and not in Draft).
Product Net Price (TCV) - New Active Subscriptions	The total Product Net Price of the New Subscriptions started in a period (started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions).
Product Net Price (TCV) - Renewed Active Subscriptions	The total Product Net Price of the Renewed Subscriptions in a period (number of active subscriptions that are renewed from existing subscriptions).
Product Net Price (TCV) - Terminated Subscriptions	The total Product Net Price of the Subscriptions Terminated in a period (number of active subscriptions that are terminated in a period). This metric does not include TCV of the closed subscriptions due to the amendment or suspension of existing subscriptions.
Product Net Price (TCV) - Due for Renewal	The total Product Net Price of Subscriptions that are due for Renewal in a period.
Product Net Price (TCV) - Churned Renewal Subscriptions	The total Product Net Price of the Churned Renewal Subscriptions in a period (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period).
Product Net Price (TCV) - Lapsed Renewal Subscriptions	The total Product Net Price of the Lapsed Renewal Subscriptions in a period(Active subscriptions that expired in a period without being renewed).
Absolute MRR Churn	The Absolute MRR Churn. This metric is calculated as follows: (Lapsed Renewal MRR + Termination MRR + Churned Renewal MRR)
# of New Customers	The number of New Customers added in a period. (Customers who started an active subscription in a given period)
# of Churned Customers	The number of Customers Churned in a period (Customers whose active subscriptions were all terminated or expired without renewal in a given period)
New Customer MRR	The total MRR of a new Customer added in a period (started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions).
Product Net Price (TCV) - New Customers	The total Product Net Price of the New Customers added in a period (Customers who started an active subscription in a given period)
Change in # of Active Customers	The change in the number of Active Customers in a given period. This metric is calculated as follows: # of Active Customers (Period End) - # of Active Customers (Period start)
Change in # of Active Subscriptions	The change in the Number of Subscriptions in a given period. This metric is calculated as follows: Number of active subscriptions (Period End) - Number of active subscriptions (Period Start)
Change in Active MRR	The change in Active MRR in a given period. This metric is calculated as follows: Active MRR (Period End) - Active MRR (Period Start)
Change in Average Revenue per Customer	The change in Average Revenue per Customer in a given Period. This metric is calculated as follows: Average Revenue per customer (Period End) - Average Revenue per customer (Period Start)
Change in Product Net Price	The change in the Product Net Price in a given period. This metric is calculated as follows: Product Net Price (Period End) - Product Net Price (Period Start)
Customers Churn Rate %	The Customer Churn Rate. This metric is calculated as follows: # of Churned Customers /# of Active Customers (period start)
MRR Churn Rate %	The MRR Churn Rate. This metric is calculated as follows: 100 * (Lapsed Renewal MRR + Termination MRR + Churned Renewal MRR) / Active MRR (Period Start)
MRR Lapsed Renewal %	The MRR Lapsed Renewal Rate. This metric is calculated as follows: 100*Lapsed Renewal MRR/MRR Due for Renewal
MRR Renewal Rate %	The MRR Renewal Rate. This metric is calculated as follows: 100 * Activated Renewal MRR / MRR due for Renewal (Period End)
Net Revenue Retention Rate %	The Net Revenue Retention Rate. This metric is calculated as follows: 100 * Active MRR (Period End) / Active MRR (Period Start)
# of Expired Subscriptions	The total number of Subscriptions Expired in a period (Started as Active while entering in the Period, and Expired without being Renewed by the end of the Period, and also includes the Subscriptions marked as 'Do Not Renew')

CX - Subscriptions

This table describes the Subscription Metrics.

Metric	Metric Definition
# of Active Subscription Downgrades	The total Downgraded Subscriptions (amend reason = ORA_DOWNGRADE) that are Active
# of Active Subscription Upgrades	The total Upgraded Subscriptions (amend reason = ORA_UPGRADE) that are Active
# of Active Subscriptions	The total Active Subscriptions
# of Active Subscriptions Added - Last 30 days	The total Subscriptions Added in the last 30 days that are Active
# of Active Subscriptions Expiring - Next 30 days	The total Active Subscriptions Expiring in the next 30 days
# of Customers	The total Customers
# of Customers with Active Subscriptions	The total customers with at least one Active Subscription
# of Evergreen Subscriptions	The total Evergreen Subscriptions (no end date)
# of Expansion Active Subscriptions	The total Expansion Subscriptions (Target subscription MRR > Source Subscription MRR) that are Active
# of Expansion Subscriptions	The total Expansion Subscriptions (Target subscription MRR > Source Subscription MRR)
# of Expired Subscriptions	The total Expired Subscriptions
# of New Active Subscriptions	The total new Subscriptions that are Active (started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions)
# of Products	The total Products
# of Products with Active Subscriptions	The total Products that have Active Subscriptions
# of Subscription Downgrades	The total Downgraded Subscriptions (amend reason = ORA_DOWNGRADE)
# of Subscription Upgrades	The total Upgraded Subscriptions (amend reason = ORA_UPGRADE)
# of Subscriptions	The total Subscriptions
# of Subscriptions Expired - Last 30 days	The total Subscriptions Expired in the last 30 days
# of Terminated Subscriptions	The total terminated subscriptions
# Renewed Active Subscriptions	The total Renewed Subscriptions that are Active
# Renewed Subscriptions	The total Renewed Subscriptions
Activated Renewal MRR	The total Activated Renewal MRR (Active Subscriptions that were renewed from existing subscriptions)
Active Subscription MRR	The total Monthly Recurring Revenue for Active Subscription
Average Revenue per Customer (ARPU)	The Total Average Revenue per Customer (ARPU). This metric is computed as follows: Total Active MRR/Total number of Active Customers
Contraction Active MRR	The total Contraction MRR for Active Subscription(The difference in MRR between a target and source of an amendment relationship where the target MRR < Source MRR and the target start date falls within this period and not in Draft/Cancelled)
Early Termination Fee	Early Termination Fee
Expansion Active MRR	The total Expansion MRR for Active Subscriptions (The difference in MRR between a target and source of an amendment relationship where the target MRR > Source MRR and the target start date falls within this period and not in Draft/Cancelled)
First Active MRR	The total new MRR of Active subscriptions (which aren't a result of an amendment, suspension, or renewal of existing subscriptions)
Subscription Cancelled Amount	The total Subscription Cancelled Amount
Subscription Closed Amount	The total Subscription Closed Amount
Subscription Credited Amount	The total Subscription Credited Amount
Subscription Invoiced Amount	The total Subscription Invoiced Amount
Subscription MRR	The total Monthly Recurring Revenue
Subscription Total Contract Value (TCV)	The total Subscription Contract Value