8 Prebuilt
Prebuilt Analyses
Prebuilt Analyses are the functional analysis defined using Oracle Data Visualizer on Oracle Analytics Cloud. Only analytic currency metrics are used in these analyses. These tables show the summary of predefined analyses available for each module.
Activity Management
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| New Activities | This analysis shows the number of activities created in the last 7 days, and provides a breakdown by different parameters such as creation date, activity type, and owner. | CX - Activity |
| Number of Activities | This analysis shows the number of activities performed by sales resources based on activity date, activity status, and activity type. | CX - Activity |
| Activity Duration for Completed Activities | This analysis shows how long it takes for a sales resource to complete an activity and provides a breakdown based on activity type. Summaries are included to show the metric based on activity owner, number of activities completed, activity type, date, and status. | CX - Activity |
| Team Member Activities Rate | This analysis provides useful insights into the average number of activities being performed by a team member, and includes a breakdown based on different activity types. | CX - Activity |
| Lead Activities Rate | This analysis shows the number of activities performed on leads, and provides a breakdown based on leads status and activity date. | CX - Lead Activity |
| Opportunities Activities Rate | This analysis shows the number of activities performed on opportunities and provides a breakdown by opportunity outcome and status. | CX - Opportunity Activity |
| Activity Rate - Won Opportunities | This analysis provides insights on the number of activities performed on opportunities that go on to win. This information helps businesses users understand the average number of activities needed to win an opportunity. | CX - Opportunity Activity |
| Task Rate - Won Opportunities | This analysis provides insights on the number of tasks performed on opportunities that go on to win. This information helps businesses users understand how many tasks and which types of tasks contribute to an opportunity win. | CX - Opportunity Activity |
Lead Management
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| New Leads | This analysis shows the number of leads created in the last seven days, and provides a break down by different parameters such as creation date, origin, product, and account type. | CX - Leads |
| Number of Leads | This analysis shows the number of leads by creation date, status, product, account, and other lead-related attributes. | CX - Leads |
| Average Lead Age | This project shows the average lead age by lead status and lead creation period for the current quarter. | CX - Leads |
| Lead Qualification Rate | This analysis shows qualified leads for the current quarter, and shows a break down of converted leads by different lead attributes such as status, lead creation date, age, and by lead qualification velocity. | CX - Leads |
| Lead Conversion Rate | This analysis shows lead conversions for the current quarter, and shows a break down of converted leads by different lead attributes such as lead channel and sales account. | CX - Leads |
| Won Revenue by Lead Channel | This analysis provides insights on which lead channels contribute to the highest won revenue. | CX - Leads |
| Lead to Opportunity Velocity | This analysis shows insights on how quickly leads are converting to opportunities, and allows comparison of this metric with other velocity metrics such as lead qualification to conversion velocity. | CX - Leads |
| Accounts - Leads | This analysis lists sales resources or credit recovers with the highest number of wins and deal sizes. | CX - Leads |
| Lead Conversion Overview | This analysis shows the summary of lead conversion and how it trends over time. | CX - Leads |
Marketing Campaigns
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| Campaign Attributed Leads | This analysis shows the number of leads generated from each campaign that was created in the current quarter. | CX - Campaign Members |
| Campaign Attributed Opportunities | This analysis shows the number of opportunities generated from each campaign that was created in the current quarter. This analysis uses the last touch attribution model. | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Pipeline | This analysis shows the pipeline contribution from the opportunities attributable to the campaign. | CX - Campaign Opportunity Revenue Line |
| Campaign ROI | This analysis shows the ROI from each campaign and the attributable won revenue. | CX - Campaign Opportunity Revenue Line |
| Cost Per Opportunity Revenue Line | This analysis provides insights on the average campaign cost incurred or generating a single opportunity revenue line. It also provides a comparison based on different campaigns. | CX - Campaign Opportunity Revenue Line |
| Cost Per Won Revenue | This analysis shows the average campaign cost for every earning. It also provides a comparison of this metric with different campaigns and products. | CX - Campaign Opportunity Revenue Line |
| Top Campaigns | This analysis shows the best performing campaigns based on different parameters such as ROI, number of wins, revenue generated, etc. | CX - Campaign Opportunity Revenue Line |
| Campaign Targeted Accounts | This analysis shows which accounts were targeted by different campaigns and the result based on ROI, opportunity outcome, and revenue generated. | CX - Campaign Opportunity Revenue Line |
Opportunity Management
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| Sales Pipeline - Pipeline Shape | This analysis provides a visual breakdown of open opportunity pipeline revenue by different sales stages and trend of the open opportunity pipeline revenue from last six enterprise periods. | CX - Opportunity Revenue Line Snapshot |
| Sales Pipeline - Pipeline Review | This analysis provides a visual summary of open opportunities and their revenue numbers by close date and sales stage. | CX - Opportunity Revenue Line |
| Sales Pipeline - Pipeline Trend YoY | This analysis shows historical trends of open opportunity revenue based on historical snapshots. | CX - Opportunity Revenue Line Snapshot |
| Sales Pipeline Velocity | This analysis shows the sales pipeline velocity for different quarters and the number of days spent in stage by opportunities, broken down by opportunity status and opportunity owner. | CX - Opportunity Revenue Line Snapshot, CX - Opportunity Stage Progression |
| Sales Stage Progression | This analysis shows the movement of opportunities through the sales stages in terms of total amounts and percentages. | CX - Opportunity Stage Progression |
| Sales Cycle Analysis | This analysis provides insights into bottle necks in the sales cycle, and in which stages opportunities are spending the most amount of time. | CX - Opportunity Stage Progression |
| Stalled Opportunities | This analysis provides a list of stalled opportunities in the system broken down by sales stage. Only those opportunities with a more than 50% win probability are considered in the visualization. | CX - Opportunity Stage Progression |
| Sales Stage Velocity | This analysis provides insights into how quickly opportunities are moving through the sales funnel, as well as insights relative to their outcomes (won or lost). | CX - Opportunity Stage Progression |
| Sales Funnel Leakage | This analysis shows the sales stage from which opportunities are moving to closed from lost and how they compare to those that are moving from closed to won. | CX - Opportunity Revenue Line |
| Top Deals At Risk | This analysis provides an overview of top opportunities (in terms of revenue and win probability > 50%) that are at risk of not closing. | CX - Opportunity Revenue Line |
| Weighted Pipeline - Detail | This analysis compares the open pipeline with the weighted pipeline by sales stage and closing quarter. | CX - Opportunity Revenue Line |
| Weighted Pipeline - Trend | This analysis shows trends of the weighted pipeline based on the snapshot period, and also a projection over the next 3 months. | CX - Opportunity Revenue Line |
| Won Sales | This analysis shows key metrics related to won sales such as won opportunity line revenue and number of won opportunity revenue lines, win rate, and conversion rate. It also shows how won opportunities compares to open and lost opportunities during the same time period. | CX - Opportunity Revenue Line Snapshot, CX - Opportunity Revenue Line |
| Win - Loss Analysis | This analysis shows won and lost revenue by different quarters and a historical trend over the last 6 quarters. It alsoo shows the won revenue by top 10 territories and products. | CX - Opportunity Revenue Line Snapshot, CX - Opportunity Revenue Line |
| Lost Sales | This analysis shows lost opportunity revenue lines by amount and by lost quarter. It also includes key conversion metrics such as revenue line loss rate percentage. | CX - Opportunity Revenue Line Snapshot, CX - Opportunity Revenue Line |
| Average Deal Size | This analysis provides a breakdown of average deal size by sales stage, opportunity owner, territory owner, and product/group. | CX - Opportunity Revenue Line |
| Average Deal Size - Trend Analysis | This analysis shows the trend of average deal size by territory and by product, and how the metric has evolved historically. | CX - Opportunity Revenue Line Snapshot |
| Win Rate and Conversion Rate Analysis | This analysis shows the revenue line win rate and conversion rate percentages and sales stage. | CX - Opportunity Revenue Line |
| Win Rate and Conversion Rate Trend | This analysis shows the historical trend of revenue line win rate and conversion rate by sales stage. | CX - Opportunity Revenue Line Snapshot |
| Top 20 Accounts | This analysis shows the top 20 accounts based on open and won revenue It also provides a breakdown of won revenue by account and product, as well as account and territory. | CX - Opportunity Revenue Line |
| Team All - Stars | This analysis lists sales resources or credit recovers with the highest number of wins and deal sizes. | CX - Opportunity Revenue Line |
| Converted Opportunity Pipeline | This analysis shows a summary of the converted opportunities (converted from leads) such as converted opportunity line revenue, average won line revenue, and converted revenue over time. | CX - Opportunity Revenue Line |
| Opportunity Days to Close | This analysis shows how long it takes to close opportunities, and compares them with the converted opportunities closure time and rates. | CX - Opportunity |
| Converted Opportunity Revenue | This analysis shows the pipeline contributed by converted opportunities. | CX - Opportunity |
| Opportunity Stage Progression | This analysis shows the details on the stages that Opportunities have progressed through. | CX-Opportunity Stage Progression |
| Renewal Sales Dashboard | This analysis shows the summary of opportunities created as part of the renewal selling. | CX - Opportunity Revenue Line |
Quote and Order Capture
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| Opportunity Quotes | This analysis shows the summary of the opportunity quotes raised, statuses by their owners, quotes raised over time period, etc. | CX - Opportunity Quote |
| Quote Cycle Time | This analysis provides insight into the time it takes when an opportunity moves to quote, quote to order placed, and contract start time. | CX - Opportunity Quote |
| Quote Contract Value | This analysis shows a summary of the quote contract value and details such as contract value by owner, by opportunity name, etc. | CX - Opportunity Quote |
| Quote Revenue | This analysis shows the summary of the quote revenue and how it's split into recurring, non-recurring, usage based revenue, and related details. | CX - Opportunity Quote |
| Opportunity Quote Lines | This analysis shows the summary of opportunity quote lines, the contract value, and the discount offered. | CX - Opportunity Quote Line |
| Opportunity Quotes - Trends | This analysis shows the trend of quote generation, won quote line, discount percentage, and the cycle time. | CX - Opportunity Quote |
Service Request Management
Prebuilt Analyses
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| SR Overview | This analysis shows a summary of service requests such as total SRs, critical SRs, SRs pending agent action, SRs by time, etc. | CX - Service Request |
| Critical SRs | This analysis shows the summary information for critical SRs such as critical SRs in various statuses, by assignee and customers, etc. | CX - Service Request |
| Critical SR Details | This analysis provides details of critical SRs by sales account and related details. | CX - Service Request |
| Agent Performance Details | This analysis provides insights into how the service agents performance is, such as the resolved SRs, average time to resolve, etc. | CX - Service Request |
| SR Resolution | This analysis shows a summary of resolved SRs, the time it took to resolve them by month and by severity, etc. | CX - Service Request |
| SRs by Channel | This analysis shows a summary of SRs by different channels that were used for the SRs. | CX - Service Request |
| SRs by Service Category | This analysis shows a summary of SRs by service category for which the SRs were raised. | CX - Service Request |
Subscription Management
| Analyses Detail | Analyses Description | Related Subject Areas |
|---|---|---|
| Subscription Overview | This analysis shows a summary of the subscription such as subscription MRR, subscription total contract value, average revenue per customer, MRR due for renewal, etc. | CX - Subscriptions |
| Subscription Trends | This analysis shows the trend of Active MRR, Active Customer, Active TCV, ARPU, Churn Rate, Renewal Rate, etc. over a period of time. | CX - Subscription Historical Trend |
| Subscription AR Overview | This analysis summarizes the Subscription AR transactions, and shows the overdue invoices and the credit memos raised for Subscription invoices. | Financials - AR Revenue* * This report is enabled for customers using CX+ERP sku |
Prebuilt KPIs
KPIs are measurements that define and track specific business goals and objectives that often roll up into larger organizational strategies that require monitoring, improvement, and evaluation.
KPIs can be used as an analysis in cards and decks to allow a user to view KPI performance and drill into the details to understand why a KPI value may be off the target. KPIs can also be used to automatically trigger alerts to specific users when KPI target values reach critical status levels. Only analytic currency metrics are used in the prebuilt KPIs.
Activity Management
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Number of Activities | Number of Activities | CX - Activity |
| New Activities | Activities created in the last 7 days | CX - Activity |
| Activity Rate - Won Opportunities | Average Number of Activities for Won Opportunities. | CX - Opportunity Activity |
| Task Rate - Won Opportunities | Average Number of Tasks Created for Won Opportunities. | CX - Opportunity Activity |
| Appointment Rate - Won Opportunities | Average Number of Appointments Created for Won Opportunities. | CX - Opportunity Activity |
| Meeting Rate for Won Opportunities | Average Number of Meetings for Won Opportunities | CX - Opportunity Activity |
| Demo Rate Won Opportunities | Average Number of Demos for Won Opportunities | CX - Opportunity Activity |
| Average Number of Activities Per Team Member For Won Opportunities | Average Number of Activities Per Team Member For Won Opportunities | CX - Opportunity Activity |
| Average Number of Activities Per Team Member For Lost Opportunities | Average Number of Activities Per Team Member For Lost Opportunities | CX - Opportunity Activity |
| Activity Rate for Open Opportunities | Average Number of Activities for currently open Opportunities | CX - Opportunity Activity |
| Number of Customer facing tasks for Won Opportunities | Number of tasks of type - Call, Chat, Demo, Meeting, Email for Won Opportunities | CX - Opportunity Activity |
| Number of Customer facing tasks for Lost Opportunities | Number of tasks of type - Call, Chat, Demo, Meeting, Email for Lost Opportunities | CX - Opportunity Activity |
| Activity Duration For Completed Activities | Average Activity Duration For Completed Activities | CX - Activity |
| Opportunity Activities Rate | Average Number of Activities Per Opportunity | CX - Opportunity Activity |
| Lead Activities Rate | Average Number of Activities Per Lead | CX - Lead Activity |
| Team Member Activity Rate | Average Number of Activities Per Team Member | CX - Activity |
Lead Management
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Number of Leads | Number of Leads Created in the reporting period | CX - Leads |
| Lead Qualification Rate (%) | Number of Leads qualified expressed as a percentage of the total number of Leads created | CX - Leads |
| Lead Conversion Rate (%) | Number of Leads converted expressed as a percentage of the total number of Leads created | CX - Leads |
| Lead Rejection Rate (%) | Number of Leads rejected expressed as a percentage of the total number of Leads created | CX - Leads |
| Average Lead Age | Average number of Days the lead is open before it is converted or rejected or retired | CX - Leads |
| Lead Qualification to Conversion Velocity | Average number of Days before the qualified lead is converted | CX - Leads |
| Number of Qualified Expired Leads | Number of Qualified Expired Leads | CX - Leads |
| Won Revenue By Lead Channel | Won Opportunity Revenue Generated from Leads based on their Lead Channel | CX - Leads |
| Accounts - Leads | Accounts with highest number of open Leads | CX - Leads |
| Opportunity Pipeline Split - Sales vs Marketing | Number of Open Opportunities by Sales Stage for Opportunities generated from Sales vs Marketing | CX - Leads |
| New Leads | New Leads Created (based on Lead Creation Date) | CX - Leads |
| Lead to Opportunity Velocity | Average number of days taken from the day Lead is created to the day it is converted | CX - Leads |
Marketing Campaigns
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Campaign Attributed Leads | Number of Leads generated from Marketing Campaigns | CX - Campaign Members |
| Campaign Attributed Opportunities | Number of Opportunities generated from Marketing Campaigns (Last Touch Model) | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Pipeline | Pipeline Revenue Contribution from Campaign attributable Opportunities (Last Touch Model) | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Won Revenue | The total revenue attributed to a campaign for all Opportunities with an Closed Won status | CX - Campaign Opportunity Revenue Line |
| Campaign ROI | Campaign Return on Investment based on Campaign Actual Cost and Campaign Attributable Revenue | CX - Campaign Opportunity Revenue Line |
| Campaign Responses | Number of Responses for each Campaign | CX - Campaign Member |
| Campaign Actual Vs Budgeted Cost | Ratio of Actual cost / Budgeted Cost for every campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Won Opportunity Revenue Lines | Number of Won Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Lost Opportunity Revenue Lines | Number of Lost Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Open Opportunity Revenue Lines | Number of Open Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Cost Per Opportunity Revenue Line | Ratio of Campaign Actual Cost and Number of Opportunity Revenue Lines | CX - Campaign Opportunity Revenue Line |
| Cost Per Won Opportunity Revenue Line | Ratio of Campaign Actual Cost and Number of Won Opportunity Revenue Lines | CX - Campaign Opportunity Revenue Line |
| Cost Per Won Revenue | Ratio of Campaign Actual Cost and Won Opportunity Line Revenue | CX - Campaign Opportunity Revenue Line |
| Cost Per Attributed Revenue | Ratio of Campaign Actual Cost and Total Attributable Opportunity Line Revenue | CX - Campaign Opportunity Revenue Line |
| Top Campaigns | Top Campaigns with highest Won Revenue | CX - Campaign Opportunity Revenue Line |
| Campaign Engaged Contacts | Number of Contacts Targeted By Campaigns | CX - Campaign Member |
| Campaign Targeted Accounts | Number of Accounts Targeted By Campaigns | CX - Campaign Opportunity Revenue Line |
Sales
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Won Sales | Total Sales Revenue For the Period where Opportunity Status Category= 'WON'. | CX - Opportunity Revenue Line |
| Lost Sales | Total Sales Revenue For the Period where Opportunity Status Category= 'LOST'. | CX - Opportunity Revenue Line |
| Sales Pipeline | Total Revenue of opportunity Revenue Lines with an ‘Open’ status category | CX - Opportunity Revenue Line |
| Weighted Pipeline | Weighted Pipeline measures Sales Revenue based on Opportunity Win Probability percentages assigned to the open Opportunities in the current pipeline | CX - Opportunity Revenue Line |
| Sales Pipeline Velocity | Indicates how quickly deals move through the pipeline and generating revenue. | CX - Opportunity Stage Progression |
| Sales Stage Velocity | Indicates Average time spent in stage before Opportunities move to Closed - Won or Closed - Lost | CX - Opportunity Stage Progression |
| Sales Funnel Leakage | Also known as Stage Drop Off Rates, sales funnel leakage tells you where prospects drop out of your funnel at the greatest rates. | CX - Opportunity Revenue Line |
| Sales Stage Progression | Shows how quickly Opportunities are moving through the Sales Stages | CX - Opportunity Stage Progression |
| Average Deal Size | Closed opportunity line revenue averaged over number of revenue lines. | CX - Opportunity Revenue Line |
| Win Rate % | The rate in which Opportunity revenue lines are being Closed - Won. | CX - Opportunity Revenue Line |
| Deals At Risk | Top 'N' open Opportunities (by Revenue) with Win Probability of <= 50% | CX - Opportunity Revenue Line |
| Revenue From Accounts | List of Top Accounts by Won Revenue for the reporting period | CX - Opportunity Revenue Line |
| Team All-Stars | Displays details of Primary Resources with Top 10 wins by Revenue for the time period | CX - Opportunity Revenue Line |
| Number of Leads | Number of Leads Created in the reporting period | CX - Leads |
| Lead Qualification Rate (%) | Number of Leads qualified expressed as a percentage of the total number of Leads created | CX - Leads |
| Lead Conversion Rate (%) | Number of Leads converted expressed as a percentage of the total number of Leads created | CX - Leads |
| Lead Rejection Rate (%) | Number of Leads rejected expressed as a percentage of the total number of Leads created | CX - Leads |
| Average Lead Age | Average number of Days the lead is open before it is converted or rejected or retired | CX - Leads |
| Lead Qualification to Conversion Velocity | Average number of Days before the qualified lead is converted | CX - Leads |
| Number of Qualified Expired Leads | Number of Qualified Expired Leads | CX - Leads |
| Won Revenue By Lead Channel | Won Opportunity Revenue Generated from Leads based on their Lead Channel | CX - Leads |
| Accounts - Leads | Accounts with highest number of open Leads | CX - Leads |
| Opportunity Pipeline Split - Sales vs Marketing | Number of Open Opportunities by Sales Stage for Opportunities generated from Sales vs Marketing | CX - Leads |
| New Leads | New Leads Created (based on Lead Creation Date) | CX - Leads |
| Lead to Opportunity Velocity | Average number of days taken from the day Lead is created to the day it is converted | CX - Leads |
| Number of Activities | Number of Activities | CX - Activity |
| New Activities | Activities created in the last 7 days | CX - Activity |
| Activity Rate - Won Opportunities | Average Number of Activities for Won Opportunities. | CX - Opportunity Activity |
| Task Rate - Won Opportunities | Average Number of Tasks Created for Won Opportunities. | CX - Opportunity Activity |
| Appointment Rate - Won Opportunities | Average Number of Appointments Created for Won Opportunities. | CX - Opportunity Activity |
| Meeting Rate for Won Opportunities | Average Number of Meetings for Won Opportunities | CX - Opportunity Activity |
| Demo Rate Won Opportunities | Average Number of Demos for Won Opportunities | CX - Opportunity Activity |
| Average Number of Activities Per Team Member For Won Opportunities | Average Number of Activities Per Team Member For Won Opportunities | CX - Opportunity Activity |
| Average Number of Activities Per Team Member For Lost Opportunities | Average Number of Activities Per Team Member For Lost Opportunities | CX - Opportunity Activity |
| Activity Rate for Open Opportunities | Average Number of Activities for currently open Opportunities | CX - Opportunity Activity |
| Number of Customer facing tasks for Won Opportunities | Number of tasks of type - Call, Chat, Demo, Meeting, Email for Won Opportunities | CX - Opportunity Activity |
| Number of Customer facing tasks for Lost Opportunities | Number of tasks of type - Call, Chat, Demo, Meeting, Email for Lost Opportunities | CX - Opportunity Activity |
| Activity Duration For Completed Activities | Average Activity Duration For Completed Activities | CX - Activity |
| Opportunity Activities Rate | Average Number of Activities Per Opportunity | CX - Opportunity Activity |
| Lead Activities Rate | Average Number of Activities Per Lead | CX - Lead Activity |
| Team Member Activity Rate | Average Number of Activities Per Team Member | CX - Activity |
Sales & Marketing
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Campaign Attributed Leads | Number of Leads generated from Marketing Campaigns | CX - Campaign Members |
| Campaign Attributed Opportunities | Number of Opportunities generated from Marketing Campaigns (Last Touch Model) | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Pipeline | Pipeline Revenue Contribution from Campaign attributable Opportunities (Last Touch Model) | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Won Revenue | The total revenue attributed to a campaign for all Opportunities with an Closed Won status | CX - Campaign Opportunity Revenue Line |
| Campaign ROI | Campaign Return on Investment based on Campaign Actual Cost and Campaign Attributable Revenue | CX - Campaign Opportunity Revenue Line |
| Campaign Responses | Number of Responses for each Campaign | CX - Campaign Member |
| Campaign Actual Vs Budgeted Cost | Ratio of Actual cost / Budgeted Cost for every campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Won Opportunity Revenue Lines | Number of Won Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Lost Opportunity Revenue Lines | Number of Lost Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Campaign Attributed Open Opportunity Revenue Lines | Number of Open Opportunity Revenue Lines from Opportunities attributable to a Campaign | CX - Campaign Opportunity Revenue Line |
| Cost Per Opportunity Revenue Line | Ratio of Campaign Actual Cost and Number of Opportunity Revenue Lines | CX - Campaign Opportunity Revenue Line |
| Cost Per Won Opportunity Revenue Line | Ratio of Campaign Actual Cost and Number of Won Opportunity Revenue Lines | CX - Campaign Opportunity Revenue Line |
| Cost Per Won Revenue | Ratio of Campaign Actual Cost and Won Opportunity Line Revenue | CX - Campaign Opportunity Revenue Line |
| Cost Per Attributed Revenue | Ratio of Campaign Actual Cost and Total Attributable Opportunity Line Revenue | CX - Campaign Opportunity Revenue Line |
| Top Campaigns | Top Campaigns with highest Won Revenue | CX - Campaign Opportunity Revenue Line |
| Campaign Engaged Contacts | Number of Contacts Targeted By Campaigns | CX - Campaign Member |
| Campaign Targeted Accounts | Number of Accounts Targeted By Campaigns | CX - Campaign Opportunity Revenue Line |
Opportunity Management
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Won Sales | Total Sales Revenue For the Period where Opportunity Status Category= 'WON'. | CX - Opportunity Revenue Line |
| Lost Sales | Total Sales Revenue For the Period where Opportunity Status Category= 'LOST'. | CX - Opportunity Revenue Line |
| Sales Pipeline | Total Revenue of opportunity Revenue Lines with an ‘Open’ status category | CX - Opportunity Revenue Line |
| Weighted Pipeline | Weighted Pipeline measures Sales Revenue based on Opportunity Win Probability percentages assigned to the open Opportunities in the current pipeline | CX - Opportunity Revenue Line |
| Sales Pipeline Velocity | Indicates how quickly deals move through the pipeline and generating revenue. | CX - Opportunity Stage Progression |
| Sales Stage Velocity | Indicates Average time spent in stage before Opportunities move to Closed - Won or Closed - Lost | CX - Opportunity Stage Progression |
| Sales Funnel Leakage | Also known as Stage Drop Off Rates, sales funnel leakage tells you where prospects drop out of your funnel at the greatest rates. | CX - Opportunity Revenue Line |
| Sales Stage Progression | Shows how quickly Opportunities are moving through the Sales Stages | CX - Opportunity Stage Progression |
| Average Deal Size | Closed opportunity line revenue averaged over number of revenue lines. | CX - Opportunity Revenue Line |
| Win Rate % | The rate in which Opportunity revenue lines are being Closed - Won. | CX - Opportunity Revenue Line |
| Deals At Risk | Top 'N' open Opportunities (by Revenue) with Win Probability of <= 50% | CX - Opportunity Revenue Line |
| Revenue From Accounts | List of Top Accounts by Won Revenue for the reporting period | CX - Opportunity Revenue Line |
| Team All-Stars | Displays details of Primary Resources with Top 10 wins by Revenue for the time period | CX - Opportunity Revenue Line |
| Opportunity Line Type | Shows Opportunity Revenue Lines by Type | CX - Opportunity Revenue Line |
| Revenue Type | Shows Renewal Revenue by type (Recurring, Non-Recurring, Usage) | CX - Opportunity Revenue Line |
| Renewal Pipeline | Shows all the Open Renewal Opportunities | CX - Opportunity Revenue Line |
| Renewal Revenue | Shows the Renewal Pipeline Amount | CX - Opportunity Revenue Line |
| Renewal Pipeline % | Shows the Renewal Pipeline Revenue of the total Opportunity Revenue | CX - Opportunity Revenue Line |
| Won Renewal Revenue | Shows the Won Renewal Pipeline Revenue | CX - Opportunity Revenue Line |
| Renewal Opportunities Win Rate | Shows the rate of winning Renewal Opportunities | CX - Opportunity Revenue Line |
| Lost Renewal Revenue | Shows the Renewal Pipeline Revenue that is Lost | CX - Opportunity Revenue Line |
| Lead Conversion | Won and Lost Opportunities from Converted Leads | CX - Opportunity |
| Opportunities from Leads (%) | % of Opportunities of the total, from the converted Leads | CX - Opportunity |
| Average Converted Opportunity Line Revenue | Average Opportunity Line Revenue of the Opportunities converted from Leads | CX - Opportunity Revenue Line |
| Line Revenue from Converted Leads | Open Opportunities Line revenue from converted leads | CX - Opportunity Revenue Line |
| Lead Generated Pipeline | # of Open Opportunities by Sales Stage for Opportunities generated from leads vs from non-leads | CX - Opportunity |
| Days to Close Converted Leads | Average of (Opportunity Close Date - Opportunity Creation Date) for opportunities converted from Leads | CX - Opportunity |
Quote and Order Capture
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Active Quotes | Number of Active Quotes created | CX - Opportunity Quote |
| Average Quotes for Won Opportunities | Average Number of Quotes for Won Opportunities | CX - Opportunity Quote |
| Quote Cycle Time | Total elapsed time from Quote-to-Order | CX - Opportunity Quote |
| Quote Conversion Rate | Number of Closed as a percentage of Active Quotes | CX - Opportunity Quote |
| Average Contract Value | Average Contract Value | CX - Opportunity Quote |
| Opportunity to Quote Velocity | Opportunity to Quote Cycle Time | CX - Opportunity Quote |
| Average Recurring Revenue | Average Recurring Revenue | CX - Opportunity Quote |
| Active Quote Win Rate | Number of Won Quotes as a percentage of Closed Quotes | CX - Opportunity Quote |
| Number of Quotes Lines | Number of Quote Lines created | CX - Opportunity Quote Line |
| Number of Active Quotes with Lines | Number of Active Quotes with Quote Lines | CX - Opportunity Quote Line |
| Contract Line Value | Total Contract Line Value for Active Quotes | CX - Opportunity Quote Line |
| Average Contract Line Value | Average Contract Quote Line Value | CX - Opportunity Quote Line |
| Quote Line Conversion Rate | Number of Quote Lines Converted | CX - Opportunity Quote Line |
| Average Quote Line Cycle Time | Average elapsed time from Quote Line-to-Order | CX - Opportunity Quote Line |
| Number of Quoted Opportunities | Number of Quoted Opportunities | CX - Opportunity |
Service Request Management
| KPI Name | KPI Description | Related Subject Areas |
|---|---|---|
| Service Requests by Status | CX Service Request | CX - Service Request |
| SR Backlog Rate (%) | % of Open SRs relative to the total SR's by age category | CX - Service Request |
| Escalation (Critical SR's) | Number of SRs that are marked Critical | CX - Service Request |
| SR Resolution (%) | Number of SRs in Resolved Status | CX - Service Request |
| Agent Performance | Average Time to Resolve (Days) by Service Agents | CX - Service Request |
| SRs by Service Category | Number of Open SRs by Service Category | CX - Service Request |
| SRs by Channel | Number of Open SRs by Channel | CX - Service Request |
| Top 10 Customers (With Active SRs) | Top 10 Customers with Most Active Open SRs | CX - Service Request |
Prebuilt Decks and Cards
A deck is a top-level object for executive consumption with multiple KPI cards added to a deck. Each deck contains up to 8 cards. A card is a visual presentation of a KPI with a drill-down capability to Data Visualization content.
Prebuilt Decks and Cards
| Deck Name | Deck Description |
|---|---|
| Sales Pipeline | The Sales Pipeline deck has seven KPIs for measuring the overall health of the sales pipeline. |
| Win-Loss Analysis | The Win-Loss Analysis deck includes six KPIs that provide insights and metrics on opportunity outcomes (won and lost) and the related opportunity revenue figures. |
| Sales Activity | The Sales Activity deck contains eight KPIs that provides insights on sales activities performed in the current quarter and how they relate to opportunity outcomes (won and lost). |
| Leads | The Leads deck provides eight KPIs for tracking important lead metrics including those related to lead conversions and lead qualifications. |
| Campaign Effectiveness | The Campaign Effectiveness deck includes eight KPIs that help marketing and sales users measure campaign ROI metrics, and important conversion metrics as part of the campaign to opportunity process flow. |
| Opportunity Quotes | The Opportunity Quote deck includes KPIs that help sales users gain insight into the quotes created in the system, and the contract value and cycle times associated with those quotes. |
| SR Management | The SR Management deck includes KPIs that help service managers and reps to get an overview of the SRs raised in the system, and what's the rate, escalations, and how they're being handled by the agents. |
| Lead Conversion | The Lead Conversion deck includes KPIs that provide insight into the leads that are getting converted to opportunities, the rate of conversion, their contribution to overall opportunities, and their performance in terms of revenue closure and time to close the opportunities. |
| Renewal Sales | The Renewal Sales deck includes KPIs that provide insights and metrics on the renewal opportunity pipeline, the related revenue figures, and their won rate. |