Turn your Salesforce data into a causal model of how your organisation generates revenue.
Salesforce holds your pipeline, forecasts, accounts, and activity data. But Salesforce reports answer "what happened," not "why" or "who should act." KPI Tree connects to your Salesforce data through your existing warehouse or a fully managed data foundation and builds causal metric trees that trace revenue back to its drivers: pipeline generation, stage conversion, deal velocity, and rep activity. Every metric gets an owner. Every anomaly gets an action plan. Your revenue organisation stops reacting to numbers and starts understanding the system that produces them.
From Salesforce data to a revenue accountability system
Connect Salesforce data to KPI Tree in two ways: point KPI Tree at your existing warehouse where Salesforce data already lands, or let our professional services team build you turn-key AI foundations in a matter of weeks (data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer).
Connect your Salesforce data
Two ways to get started, depending on your stack.
Connect your existing warehouse where Salesforce data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Define metrics from your Salesforce data model
Build metrics from opportunities, accounts, contacts, activities, campaigns, and custom objects: pipeline created, stage conversion rates, average deal size, sales cycle length, forecast accuracy, and any custom metric your revenue operations team needs.
Build revenue trees and assign ownership
Map how pipeline generation drives stage progression drives forecast drives revenue. Assign RACI ownership to every metric - from the SDR team's meeting rate to the CRO's ARR target. KPI Tree adds statistical monitoring, correlation analysis, and automated action plans.
Revenue intelligence that goes beyond reports and dashboards
Salesforce captures the data. KPI Tree connects it into a causal model with statistical analysis and clear ownership - so your revenue team operates as a system, not a collection of dashboards.
Causal revenue trees from pipeline to ARR
Build metric trees that model how your organisation actually generates revenue. Pipeline coverage drives forecast confidence. Stage conversion drives velocity. Activity volume drives pipeline creation. Every relationship is visible, every node has an owner.
Root cause analysis for forecast misses
When the forecast slips, KPI Tree traces the cause through the metric tree in seconds. Was it fewer deals entering pipeline? Longer sales cycles? A drop in Stage 3 conversion? You get the answer before the post-mortem meeting starts.
Early warning system for revenue risk
Statistical monitoring across your entire revenue tree detects anomalies in leading indicators - pipeline creation rates, early-stage conversion, activity levels - weeks before they show up in the forecast. Act on the leading signal, not the lagging outcome.
A revenue model your whole organisation can read.
Salesforce reports are powerful but fragmented - one for pipeline, another for forecasting, another for activity. KPI Tree builds a single visual tree that models how revenue is generated in your specific organisation. The CRO sees the full system. Regional VPs see their branch. Reps see the metrics they own. Same tree, same methodology, different views.
- Visual metric tree from pipeline generation through to closed revenue
- Role-based views: CRO sees the full tree, reps see their owned metrics
- Automatic decomposition traces any revenue change to its root cause
- Consistent methodology eliminates conflicting reports across teams
Forecast accuracy backed by statistical evidence, not gut feel.
Salesforce forecasting relies on stage-weighted probabilities and manager judgement. KPI Tree adds statistical analysis - correlation between leading indicators and outcomes, regression models that quantify the revenue impact of pipeline changes, and anomaly detection that flags when historical patterns break. Your forecast becomes evidence-based.
- Correlation analysis between leading indicators and forecast accuracy
- Regression models quantify how pipeline changes translate to revenue impact
- Anomaly detection flags when conversion patterns deviate from historical norms
- Compare forecast assumptions against statistical reality each period
RACI ownership that goes deeper than opportunity assignment.
Salesforce tracks who owns each opportunity. But who owns the conversion rate from Stage 2 to Stage 3? Who's accountable when pipeline coverage drops below 3x? KPI Tree assigns RACI ownership to systemic metrics - not just individual deals - so accountability covers the health of the entire revenue engine.
- RACI ownership on systemic metrics: conversion rates, velocity, coverage
- Personalised action plans delivered when owned metrics deviate from targets
- Manager dashboards aggregate team performance with drill-down to individuals
- Clear escalation paths when leading indicators signal revenue risk
Salesforce data connected to every other revenue signal.
Revenue is influenced by marketing, product, support, and finance - not just sales. KPI Tree connects Salesforce pipeline data alongside HubSpot marketing metrics, product usage from PostHog, support health from Intercom, and billing from Stripe. One tree shows how every function contributes to the number.
- Unified metric trees spanning Salesforce, marketing, product, and finance data
- Cross-functional correlations reveal which non-sales signals predict revenue
- Single ownership model across every team and every data source
- Eliminate the "attribution wars" between marketing and sales with shared metrics
How KPI Tree uses Salesforce data differently
Salesforce is the system of record for deals. KPI Tree adds causal structure, statistical analysis, and metric ownership - transforming CRM data from a reporting tool into a revenue operating system.
From pipeline reports to causal revenue models
Salesforce reports show pipeline status. KPI Tree models the causal relationships between pipeline generation, conversion, velocity, and revenue - so you understand the system, not just the snapshot.
Systemic accountability, not deal-level tracking
Salesforce assigns deal owners. KPI Tree assigns metric owners for the systemic drivers - conversion rates, coverage ratios, cycle times - that determine whether the whole team hits target.
Off-warehouse analytics that scale with your org
KPI Tree runs one query per metric against your warehouse on a schedule, then performs all statistical analysis, correlations, regressions, and anomaly detection in its own engine. Add 500 reps without adding 500 dashboard queries.
Metrics you can track
36 Salesforce metrics ready to add to your metric trees.
Account Health Score
CRMMetric Definition
Account health score is a composite metric that evaluates the overall strength of a customer relationship using Salesforce data. It combines activity recency, opportunity pipeline status, support ticket trends, product adoption signals, and engagement frequency to produce a single score indicating whether an account is thriving, stable, or at risk.
Activity Volume per Rep
CRMMetric Definition
Activity Volume per Rep = Total Logged Activities / Number of Active Reps
Activity volume per rep measures the total number of logged activities (calls, emails, meetings, tasks) per sales representative in Salesforce over a defined period. It quantifies the effort each rep invests in customer-facing and pipeline-building activities and serves as a baseline for evaluating activity efficiency.
Marketing ROI
CRMMetric Definition
Campaign ROI = (Campaign-Attributed Revenue - Campaign Cost) / Campaign Cost x 100
Campaign ROI measures the return on investment for marketing campaigns tracked in Salesforce by comparing campaign costs against the pipeline and revenue generated by campaign members. It evaluates whether each campaign produced sufficient returns to justify its investment and informs future budget allocation.
Average Resolution Time
CRMMetric Definition
Case Resolution Time = Average(Case Close Date - Case Created Date)
Case resolution time measures the average elapsed time from case creation to case closure in Salesforce Service Cloud. It evaluates support team efficiency and customer experience by tracking how quickly issues are addressed, segmented by case priority, type, product, and support agent.
Contact Conversion Rate
CRMMetric Definition
Contact Conversion Rate = (Contacts with Opportunities / Total Qualified Contacts) x 100
Contact conversion rate measures the percentage of contacts in Salesforce that become associated with an opportunity. It evaluates the effectiveness of lead qualification, nurturing, and sales development at converting the contact database into active pipeline.
Customer Acquisition Cost
CRMMetric Definition
Customer Acquisition Cost = Total Sales & Marketing Spend / Number of New Customers Won
Customer acquisition cost (CAC) measures the total sales and marketing investment required to win a new customer. Using Salesforce opportunity data, campaign costs, and activity records, CAC quantifies acquisition efficiency and determines the breakeven point for each new customer relationship.
Customer Lifetime Value
CRMMetric Definition
Customer Lifetime Value = Average Revenue per Customer per Year x Gross Margin % x Average Customer Lifespan
Customer lifetime value (CLV) estimates the total net revenue a customer will generate over their entire relationship with your business. Using Salesforce opportunity history, renewal data, expansion revenue, and churn patterns, CLV quantifies the long-term return on each customer acquisition and retention investment.
Dashboard Adoption Rate
CRMMetric Definition
Dashboard Adoption Rate = (Users Viewing Dashboards in Period / Total Active Salesforce Users) x 100
Dashboard adoption rate measures the percentage of Salesforce users who actively view and interact with dashboards and reports on a regular basis. It evaluates whether the analytics investments made in Salesforce are actually being consumed by the intended audience and driving data-informed decision-making.
Deal Stage Progression
CRMMetric Definition
Deal stage progression measures the rate and pattern of opportunity movement through pipeline stages in Salesforce. It tracks forward progression, stage skipping, regression (deals moving backwards), and stagnation (deals stuck in a stage), providing a comprehensive view of how effectively the sales process advances deals toward close.
Forecast Accuracy
CRMMetric Definition
Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100
Forecast accuracy measures the percentage deviation between revenue forecasts derived from Salesforce pipeline data and actual closed revenue for a given period. It evaluates the reliability of opportunity stage probabilities, close date predictions, and deal value estimates across the sales organisation.
Lead Conversion Rate
CRMMetric Definition
Lead Conversion Rate = (Converted Leads / Total Leads) x 100
Lead conversion rate measures the percentage of leads in Salesforce that are successfully converted to contacts with associated accounts and opportunities. It is the primary metric for evaluating the effectiveness of lead qualification, scoring, and handoff processes between marketing and sales.
Lead Response Time
CRMMetric Definition
Lead Response Time = Timestamp of First Rep Activity - Timestamp of Lead Creation
Lead response time measures the elapsed time between a new lead being created in Salesforce and the first meaningful outreach by an assigned sales rep. It quantifies how quickly the organisation acts on new leads, which research consistently shows is one of the strongest predictors of conversion probability.
Lead Scoring Effectiveness
CRMMetric Definition
Lead scoring effectiveness evaluates the predictive accuracy of lead scores in Salesforce by comparing assigned scores to actual conversion outcomes. It measures whether higher-scored leads genuinely convert at higher rates and generate larger deals, identifying scoring criteria that add predictive value versus those that introduce noise.
Opportunity Aging
CRMMetric Definition
Opportunity aging analyses the age distribution of open opportunities in Salesforce by measuring days since creation or days in current stage. It identifies opportunities that have exceeded normal timelines, categorises pipeline into age buckets, and quantifies the proportion of pipeline at risk of being stale or unlikely to close.
Win Rate
CRMMetric Definition
Opportunity Win Rate = (Closed-Won Opportunities / Total Closed Opportunities) x 100
Opportunity win rate measures the percentage of closed opportunities in Salesforce that result in a won outcome. It is the definitive measure of sales effectiveness, capturing the combined impact of qualification, competitive positioning, pricing, negotiation, and execution across the entire pipeline.
Pipeline Coverage Ratio
CRMMetric Definition
Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target or Quota
Pipeline coverage ratio measures the total value of open pipeline in Salesforce divided by the revenue target or quota for a given period. It indicates whether sufficient pipeline exists to absorb normal loss and slippage rates while still achieving the revenue goal.
Sales Pipeline Velocity
CRMMetric Definition
Pipeline Velocity = (Number of Opportunities x Average Deal Value x Win Rate) / Sales Cycle Length
Pipeline velocity quantifies the rate at which opportunities in Salesforce convert into revenue. It combines the number of qualified opportunities, average deal value, win rate, and sales cycle length into a single metric representing the revenue-generating throughput of the sales organisation per unit of time.
Quota Attainment
CRMMetric Definition
Quota Attainment = (Closed-Won Revenue / Assigned Quota) x 100
Quota attainment measures the percentage of assigned revenue quota that a rep, team, or territory has achieved through closed-won opportunities in Salesforce. It is the ultimate accountability metric for sales, directly connecting individual and team performance to the revenue commitments that drive business planning.
Report Usage Analysis
CRMMetric Definition
Report usage analysis examines how Salesforce reports and dashboards are consumed across the organisation. It tracks which reports are viewed most frequently, which users access them, which reports are never viewed, and how report consumption correlates with sales performance and data quality.
Revenue by Product Line
CRMMetric Definition
Revenue by product line breaks down closed-won revenue in Salesforce by the products and product families included in opportunities. It tracks which products generate the most revenue, how product mix is shifting over time, and which product combinations appear most frequently in winning deals.
Sales Cycle Length
CRMMetric Definition
Sales Cycle Length = Average(Close Date - Opportunity Created Date)
Sales cycle length measures the average number of days from opportunity creation in Salesforce to a closed-won outcome. It captures the full duration of the active sales process and is a critical input for pipeline velocity, coverage calculations, and revenue forecasting.
Sales Rep Performance Analysis
CRMMetric Definition
Sales rep performance analysis compares individual reps across the full spectrum of Salesforce metrics: activity volume, pipeline generation, stage conversion rates, deal sizes, cycle lengths, win rates, and quota attainment. It identifies top performers, reveals the specific behaviours that drive success, and pinpoints coaching opportunities for each individual.
Territory Performance Analysis
CRMMetric Definition
Territory performance analysis compares pipeline generation, conversion rates, deal sizes, cycle lengths, and revenue outcomes across sales territories defined in Salesforce. It identifies high-performing and underperforming territories to inform territory design, resource allocation, and go-to-market strategy.
User Adoption Rate
CRMMetric Definition
User Adoption Rate = (Active Users in Period / Total Licensed Users) x 100
User adoption rate measures the percentage of licensed Salesforce users who actively log in and perform meaningful actions (creating records, updating opportunities, logging activities, running reports) within a defined period. It evaluates whether the Salesforce investment is being utilised by the intended user base.
Win/Loss Analysis
CRMMetric Definition
Win/loss analysis systematically examines closed opportunities in Salesforce to identify patterns that differentiate won and lost deals. It analyses loss reasons, competitive presence, deal characteristics, sales process adherence, and buyer behaviour to surface actionable insights for improving future win rates.
Contract Value Analysis
CRMMetric Definition
Contract value analysis examines the distribution and trends of contract values across Salesforce opportunities and contracts. It segments total contract value (TCV) and annual contract value (ACV) by customer segment, product mix, contract term length, and sales rep to identify pricing patterns, discount behaviours, and deal structuring trends that influence long-term revenue.
Customer Churn Prediction
CRMMetric Definition
Customer churn prediction uses Salesforce activity, support case, engagement, and renewal data to calculate a probability score indicating how likely each customer is to churn. It combines declining engagement frequency, increasing support escalations, contract approaching renewal without expansion signals, and reduced product usage into a composite risk score.
Customer Renewal Rate
CRMMetric Definition
Customer Renewal Rate = (Renewed Contracts / Contracts Up for Renewal) x 100
Customer renewal rate measures the percentage of customers whose contracts are successfully renewed at the end of their term, tracked through Salesforce renewal opportunities or contract objects. It is the primary indicator of customer retention and a critical input for revenue forecasting and customer lifetime value calculations.
Deal Stage Conversion Analysis
CRMMetric Definition
Stage Conversion Rate = (Opportunities Entering Next Stage / Opportunities Entering Current Stage) x 100
Deal stage conversion analysis measures the conversion rate between each consecutive pair of opportunity stages in Salesforce. It identifies which stage transitions have the highest drop-off rates, how conversion rates vary by deal segment, and where in the pipeline the greatest proportion of potential revenue is lost.
Deal Velocity
CRMMetric Definition
Deal Velocity = Total Days from Opportunity Creation to Close / Number of Stages Progressed
Deal velocity measures the speed at which individual opportunities in Salesforce progress through pipeline stages, expressed as the average number of days spent in each stage and the total elapsed time from creation to close. Unlike pipeline velocity which measures aggregate throughput, deal velocity focuses on the pace of individual deal progression.
Email Engagement Analysis
CRMMetric Definition
Email engagement analysis measures open rates, click-through rates, reply rates, and response times for sales emails tracked in Salesforce. It evaluates the effectiveness of outreach templates, sequences, and individual rep communication by connecting email engagement signals to downstream pipeline and revenue outcomes.
Lead Source Attribution
CRMMetric Definition
Lead source attribution traces Salesforce pipeline and closed revenue back to the original lead source, campaign, or channel that generated the initial contact. It applies first-touch, last-touch, and multi-touch attribution models to quantify each source's contribution to revenue generation across the full funnel.
Marketing Qualified Lead Rate
CRMMetric Definition
MQL Rate = (Leads Reaching MQL Status / Total New Leads) x 100
Marketing qualified lead (MQL) rate measures the percentage of leads in Salesforce that meet predefined qualification criteria based on engagement, fit, and behaviour signals. It evaluates the effectiveness of marketing programmes at generating leads that meet the threshold for sales follow-up and reflects the alignment between marketing targeting and ideal customer profile.
Pipeline Value
CRMMetric Definition
Pipeline value measures the total monetary value of all open opportunities in Salesforce at a given point in time. It provides a snapshot of the revenue potential currently in the sales pipeline, segmented by stage, expected close date, owner, territory, and product to give a comprehensive view of future revenue potential.
Sales Velocity Analysis
CRMMetric Definition
Sales Velocity = (Opportunity Count x Average Deal Value x Win Rate) / Sales Cycle Length
Sales velocity analysis breaks down the pipeline velocity formula into its four constituent components - opportunity count, average deal value, win rate, and sales cycle length - and analyses each independently to identify which lever has the greatest potential impact on revenue throughput. It goes beyond calculating a single velocity number to provide actionable decomposition.
Upsell Cross-sell Analysis
CRMMetric Definition
Upsell cross-sell analysis measures the volume, value, and conversion rate of expansion opportunities within existing Salesforce accounts. It tracks upsell opportunities (larger quantities or higher tiers of existing products) and cross-sell opportunities (new products sold to existing customers) to quantify the expansion revenue engine and its contribution to total revenue growth.
Related integrations
Other data sources that work with KPI Tree.
Common questions
- KPI Tree reads whatever tables your Fivetran, Airbyte, or Salesforce Data Cloud replication has already materialised in your warehouse. At minimum you want Account, Contact, Opportunity, OpportunityHistory, OpportunityLineItem, and Activity objects to build meaningful revenue trees. Add Lead, Campaign, CampaignMember, User, and Forecast objects if you want full pipeline-to-close attribution and rep-level performance analysis. Custom objects and custom fields are supported automatically on Enterprise and Unlimited editions through the same warehouse replication. Professional services customers get the full object graph modelled in dbt as part of the engagement. Salesforce ships a Hosted MCP Server in beta for enrolled orgs; we are tracking it and will add it as an MCP-path alternative once Salesforce moves it to GA.
- Any metric derivable from your Salesforce data: opportunities (pipeline, stage conversion, velocity, win rates), accounts (expansion, churn risk), contacts (engagement), activities (calls, emails, meetings), campaigns (influence, ROI), and any custom objects or fields your team has built.
- Yes. KPI Tree is schema-agnostic: it builds metrics from whatever tables and columns are available in your warehouse, so custom objects, custom fields, record types, and calculated fields all work as long as they are synced to your warehouse (Fivetran, Airbyte, and the Salesforce Data Cloud all preserve them by default).
- If your Salesforce data is already in a warehouse, most teams are operational in under an hour because KPI Tree auto-discovers tables and suggests metrics. The professional services route takes longer (typically a few weeks) but delivers a complete, production-ready data foundation plus the dbt models for pipeline generation, stage conversion, deal velocity, and forecast accuracy.
- No. Salesforce reports are essential for day-to-day deal management, pipeline reviews, and forecasting workflows. KPI Tree adds the causal analysis, statistical rigour, and cross-tool metric ownership layer that Salesforce's reporting isn't designed to provide.
- Yes - this is a core strength. Build metric trees that combine Salesforce pipeline data with HubSpot marketing metrics, Apollo outbound activity, Stripe billing data, or any other tool syncing to your warehouse. One unified revenue tree.
- KPI Tree connects to your warehouse, not to Salesforce directly. Warehouse access uses least-privilege read-only credentials encrypted at rest with HSM-backed KMS. No Salesforce credentials are stored or required. Your existing data governance policies remain fully enforced.
- KPI Tree syncs metric values once per schedule from your warehouse. All analytics - correlations, anomaly detection, comparisons - run off-warehouse. Whether you have 10 or 10,000 Salesforce users viewing KPI Tree, the warehouse query volume stays the same.
Related guides
Deep dives into the frameworks and metrics that work with Salesforce.
Salesforce tells you what happened. KPI Tree tells you why - and who should act.
Connect Salesforce data to KPI Tree through your warehouse. Build causal revenue trees with statistical analysis, RACI ownership, and automated action plans that turn CRM data into a system your entire organisation can act on.