KPI Tree

Salesforce Metric

Marketing

Campaign ROI = (Attributed Closed Won Revenue - Campaign Actual Cost) / Campaign Actual Cost x 100

Campaign ROI measures the revenue a Salesforce campaign generates against the cost recorded for it. Using the Campaign object alongside Campaign Influence and the Opportunities linked to campaign members, it compares Actual Cost against the value of Closed Won opportunities the campaign touched. It tells you which campaigns return more than they consume rather than which simply produced activity.

Full guide: definition, formula, and benchmarks
SalesforceMarketing

Campaign ROI

Campaign ROI measures the revenue a Salesforce campaign generates against the cost recorded for it. Using the Campaign object alongside Campaign Influence and the Opportunities linked to campaign members, it compares Actual Cost against the value of Closed Won opportunities the campaign touched. It tells you which campaigns return more than they consume rather than which simply produced activity.

How to calculate campaign roi

Campaign ROI = (Attributed Closed Won Revenue - Campaign Actual Cost) / Campaign Actual Cost x 100

Why campaign roi matters for Salesforce users

Salesforce records cost per campaign and links campaigns to opportunities, but the standard ROI fields often sit empty or lean on a single Primary Campaign Source, so most teams cannot say which programmes actually paid back. Without a consistent ROI view, budget tends to follow the campaigns that generated the most leads rather than the most revenue.

A reliable Campaign ROI figure lets marketing defend spend, retire programmes that drain budget without returning revenue, and reinvest in the channels that compound. It also gives sales and finance a shared, revenue-anchored read on where pipeline really comes from.

Understand and act on campaign roi with KPI Tree

Sync your Salesforce Campaign, Campaign Member, Campaign Influence and Opportunity objects into your warehouse and compute Campaign ROI in KPI Tree, deciding upfront whether you attribute on primary source or influenced revenue. Place it in a metric tree beside contact conversion rate and customer acquisition cost so you can see how campaign returns roll up into pipeline and acquisition efficiency.

Assign RACI ownership in KPI Tree so a marketing operations lead is Accountable for the figure and campaign owners are Responsible for keeping costs accurate, then set a monthly review cadence aligned to your campaign reporting cycle so underperforming programmes are caught while there is still budget to reallocate.

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

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

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

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