KPI Tree

Salesforce Metric

CRM

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.

Full guide: definition, formula, and benchmarks

Marketing ROI

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.

How to calculate marketing roi

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

Why marketing roi matters for Salesforce users

Salesforce campaigns capture both cost inputs and member-level outcome tracking, providing the data needed for genuine ROI calculation. But most organisations only report on campaign response rates or member counts, not downstream revenue. Connecting campaign membership to opportunity outcomes reveals which campaigns actually drive revenue versus those that generate engagement without commercial impact.

ROI analysis also prevents the common trap of judging campaigns by early indicators. A webinar might generate 500 registrants but zero qualified pipeline, while a targeted executive dinner for 20 guests produces five enterprise opportunities. Without attributing pipeline and revenue to campaigns, the webinar looks like a success and the dinner looks like a failure. ROI reverses this perception and drives smarter investment.

Understand and act on marketing roi with KPI Tree

Sync Salesforce campaign, campaign member, opportunity, and cost data into your warehouse. KPI Tree traces campaign members through to closed-won deals, calculating true ROI with both first-touch and multi-touch attribution models.

Build a campaign ROI branch in your metric tree showing return per campaign and campaign type. Assign ownership to the marketing team for campaign execution and to finance for ROI validation, set alerts for campaigns trending below break-even, and compare ROI across campaign types to inform future investment allocation.

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

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

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

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

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

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