| Print Open PDF Version of Online Help

##### Opportunity and Competitor Historical Analytics Subject Area ### Availability This subject area is available in all editions of Oracle CRM On Demand. ### Business Purpose This subject area allows you to analyse the many-to-many relationship between opportunities and competitor accounts. This subject area is almost identical to the opportunity subject areas. The only difference is that it includes the competitor account dimension, which has a many-to-many relationship with the opportunity record type. This subject area allows you to create reports that show all the competitors for an opportunity. Because this subject area represents the many-to-many relationship between opportunities and competitor accounts, opportunities that do not have an association with at least one competitor account cannot be reported using this subject area. The attributes that define the competitor account relationship that are available for reporting include the following: Primary Contact Role Reverse Role Start Date End Date Strengths Weaknesses Comments ### Relationship Type Many-to-many ### Dimensions This subject area has the following dimensions: Account Account Territory Campaign Date Opportunity Opportunity Competitor Owned By User Primary Contact Relationship Contact Territory ### Metrics The complete list of metrics for this subject area is as follows: Opportunity Metrics Opportunity Custom Metrics Opportunity Metrics by Open Date Number (#) of Open Opportunities Number (#) of Opportunities Number (#) of Contacts with Opportunities (Optys) Closed Revenue Expected Revenue Revenue Average Number (Avg #) of Days in Stage Number (#) of Wins Avg Deal Size (Definition: The average size of each sale for each customer, expressed as the number of units or the amount of revenue.) Avg Sales Cycle Opportunity Win Rate (Definition: The number of win opportunities divided by the number of won and lost opportunities.) Opportunity Loss Rate Revenue Expected Revenue Closed Revenue Number (#) of Opportunities Number (#) of Open Opportunities Number (#) of Contacts with Opportunities (Optys) Number (#) of Wins Average Number (Avg #) of Days in Stage Avg Deal Size (Definition: The average size of each sale for each customer, expressed as the number of units or amount of revenue.) Avg Sales Cycle Opportunity Win Rate (Definition: The total number of win opportunities divided by the total number of won and lost opportunities.) Opportunity Loss Rate Quarter Ago Opportunity Revenue Quarter Ago Closed Revenue ### Usage Notes The Account and Primary Contact dimensions include a Book hierarchy, which enables you to analyse metrics and related attributes at any level. #### Relationship Contact Dimension Opportunities can be linked to an opportunity as competitors. Any opportunities that are linked to an opportunity as competitors are listed in the Opportunity Competitors related information section of the Opportunity Detail page. The relationship between two opportunities that are linked in this way can also have a primary contact that is different from the primary contacts on the linked opportunities. To extract information about the primary contact for the relationship between the opportunity and the competitor, select the columns from the Relationship Contact dimension. To extract information about the primary contact for the opportunity, select the columns from the Primary Contact folder under the Opportunity dimension. To extract information about the primary contact for a competitor, select the columns from the Primary Contact folder under the Opportunity Competitor dimension.

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.