KPI Tree

Salesforce Metric

CRM

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.

Revenue by Product Line

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.

Why revenue by product line matters for Salesforce users

Aggregate revenue numbers hide critical product-level dynamics. Overall revenue might be growing while a key product line declines, masked by growth in another product. Salesforce opportunity products capture this granularity, but most teams only analyse total deal values. Product-level revenue analysis reveals which products are driving growth, which are stagnating, and which product combinations produce the highest total deal values.

Product mix trends also inform strategic decisions about investment, packaging, and pricing. If a new product is appearing in an increasing proportion of winning deals, that validates the product strategy. If a legacy product's revenue contribution is declining despite stable pricing, it may indicate competitive pressure or market shift that requires strategic response.

Understand and act on revenue by product line with KPI Tree

Sync Salesforce opportunity product data with deal outcomes in your warehouse. KPI Tree calculates revenue, deal count, and win rates per product and product family with full historical trending.

Build a product revenue branch in your metric tree showing each product line's contribution to total revenue. Assign ownership to product managers for their lines, set alerts for product revenue shifts, and track product mix trends period-over-period to validate product strategy and identify cross-sell opportunities.

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

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

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

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

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

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