KPI Tree
Salesforce logoSalesforce Integration

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).

1

Connect your Salesforce data

Two ways to get started, depending on your stack.

SnowflakeBigQueryDatabricks
Warehouse

Connect your existing warehouse where Salesforce data already lands.

Fivetrandbt
Professional Services

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.

2

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.

3

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
0:00

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
Correlation analysis loading

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
RACI accountability matrix loading

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

CRM

Metric 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.

View metric

Activity Volume per Rep

CRM

Metric 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.

View metric

Marketing ROI

CRM

Metric 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.

View metric

Average Resolution Time

CRM

Metric 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.

View metric

Contact Conversion Rate

CRM

Metric 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.

View metric

Customer Acquisition Cost

CRM

Metric 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.

View metric

Customer Lifetime Value

CRM

Metric 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.

View metric

Dashboard Adoption Rate

CRM

Metric 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.

View metric

Deal Stage Progression

CRM

Metric 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.

View metric

Forecast Accuracy

CRM

Metric 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.

View metric

Lead Conversion Rate

CRM

Metric 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.

View metric

Lead Response Time

CRM

Metric 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.

View metric

Lead Scoring Effectiveness

CRM

Metric 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.

View metric

Opportunity Aging

CRM

Metric 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.

View metric

Win Rate

CRM

Metric 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.

View metric

Pipeline Coverage Ratio

CRM

Metric 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.

View metric

Sales Pipeline Velocity

CRM

Metric 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.

View metric

Quota Attainment

CRM

Metric 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.

View metric

Report Usage Analysis

CRM

Metric 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.

View metric

Revenue by Product Line

CRM

Metric 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.

View metric

Sales Cycle Length

CRM

Metric 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.

View metric

Sales Rep Performance Analysis

CRM

Metric 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.

View metric

Territory Performance Analysis

CRM

Metric 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.

View metric

User Adoption Rate

CRM

Metric 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.

View metric

Win/Loss Analysis

CRM

Metric 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.

View metric

Contract Value Analysis

CRM

Metric 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.

View metric

Customer Churn Prediction

CRM

Metric 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.

View metric

Customer Renewal Rate

CRM

Metric 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.

View metric

Deal Stage Conversion Analysis

CRM

Metric 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.

View metric

Deal Velocity

CRM

Metric 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.

View metric

Email Engagement Analysis

CRM

Metric 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.

View metric

Lead Source Attribution

CRM

Metric 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.

View metric

Marketing Qualified Lead Rate

CRM

Metric 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.

View metric

Pipeline Value

CRM

Metric 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.

View metric

Sales Velocity Analysis

CRM

Metric 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.

View metric

Upsell Cross-sell Analysis

CRM

Metric 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.

View metric

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.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business