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