KPI Tree

Salesforce Metric

Sales

Product Performance Index = (Closed Won Revenue per Product / Total Closed Won Revenue) x Product Win Rate, where Product Win Rate = Won Opportunities containing the Product / All Closed Opportunities containing the Product

Product Performance Analysis measures how individual products or product families perform across the sales motion captured in Salesforce. It draws on Opportunity Line Items, Products and Price Book entries to compare each product on revenue contribution, win rate, average deal size and pipeline coverage. It turns the product catalogue inside Salesforce into a ranked view of what is actually selling and where it stagnates.

Full guide: definition, formula, and benchmarks

Product Performance Analysis

Product Performance Analysis measures how individual products or product families perform across the sales motion captured in Salesforce. It draws on Opportunity Line Items, Products and Price Book entries to compare each product on revenue contribution, win rate, average deal size and pipeline coverage. It turns the product catalogue inside Salesforce into a ranked view of what is actually selling and where it stagnates.

How to calculate product performance analysis

Product Performance Index = (Closed Won Revenue per Product / Total Closed Won Revenue) x Product Win Rate, where Product Win Rate = Won Opportunities containing the Product / All Closed Opportunities containing the Product

Why product performance analysis matters for Salesforce users

Salesforce records every product attached to an opportunity, yet that detail usually stays trapped in line items that nobody rolls up. Without a product level view, teams keep selling the easy products and let high margin or strategic lines drift, and they cannot see which products lengthen cycles or get discounted into the ground.

Product Performance Analysis exposes the real winners and laggards in the catalogue. It tells revenue leaders where to focus enablement, which products to reprice or retire, and which lines deserve more pipeline investment, all from data the sales team already enters as part of closing deals.

Understand and act on product performance analysis with KPI Tree

Sync your Salesforce Opportunity Line Items, Products, Price Book entries and Order objects into your warehouse, then compute Product Performance Analysis in KPI Tree by aggregating revenue, win rate and deal size per product. Place it in a metric tree alongside contract value analysis and contact conversion rate so you can see how product mix feeds total revenue and where account health is strongest.

Assign RACI ownership so a product marketing or revenue operations lead is accountable for the metric, with sales leadership consulted on portfolio decisions. Set a monthly review cadence in KPI Tree to catch shifts in product win rates and discounting before they harden into a quarterly trend.

Get started with your Salesforce data

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Salesforce data already lands.

Professional Services
FivetranSnowflakedbt

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.

Related Salesforce metrics

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

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

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

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

Empower your team to understand and act on Salesforce data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

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