CX - Opportunity Revenue Line
This table describes the Opportunity Revenue Line metrics.
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 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. |