Campaign ROI (Return On Investment)
Campaign ROI (Return on Investment) in Salesforce is the formula-driven percentage that compares the closed-won revenue attributed to a Campaign against the cost the marketing team spent to run it.
Definition
Campaign ROI (Return on Investment) in Salesforce is the formula-driven percentage that compares the closed-won revenue attributed to a Campaign against the cost the marketing team spent to run it. The standard Campaign object ships with the ROI field computed as (Total Value of Won Opportunities minus Actual Cost in Campaign) divided by Actual Cost in Campaign, multiplied by 100. A 200 percent ROI means the campaign returned twice its cost in won revenue. Salesforce uses Campaign Influence and Campaign Members to attribute Opportunities to the Campaign; ROI is just the rolled-up math on that attribution.
Campaign ROI matters because every marketing team needs to prove which campaigns work. Without it, marketing budgets get cut indiscriminately or expanded without evidence. With it, leadership can see the campaigns that produce real pipeline and the ones that consume budget without return. The accuracy of Campaign ROI depends entirely on two inputs: how rigorously cost is tracked in the Actual Cost field, and how completely Opportunities are attributed to the right Campaigns through Campaign Influence. Sloppy on either side and the ROI number reads like fiction; rigorous on both and ROI becomes the single most-watched marketing performance metric.
How Campaign ROI is calculated and where it goes wrong
The formula and its inputs
Campaign ROI = ((Total Value of Won Opportunities - Actual Cost in Campaign) / Actual Cost in Campaign) * 100. The numerator captures revenue closed and attributed to the Campaign. The denominator is the Actual Cost manually entered by marketing operations. Both fields are queryable; ROI is a standard formula field on Campaign.
Campaign Influence and attribution
Opportunities attribute to Campaigns through Campaign Influence records (and the simpler Primary Campaign Source on Opportunity). The Campaign Influence model can be 1.0 (single attribution per Opportunity to its Primary Campaign Source) or Customizable Campaign Influence (multi-touch with weighting). Multi-touch attribution divides credit across multiple Campaigns; single attribution gives full credit to one.
Actual Cost versus Budgeted Cost
The Campaign object has both Budgeted Cost and Actual Cost. ROI uses Actual Cost. Most marketing teams update Actual Cost throughout the Campaign as invoices land; some forget, leaving the field blank or stale. Without an accurate Actual Cost, the ROI calculation has no denominator and the field returns either zero or an error depending on the formula handling.
Won Opportunities and revenue rollup
Salesforce rolls up Total Value of Won Opportunities from every Opportunity attributed to the Campaign as won. The rollup field is part of the standard Campaign object. Opportunities not yet closed do not count; the field reflects realised revenue, not pipeline.
Multi-touch attribution and Customizable Campaign Influence
Customizable Campaign Influence (CCI) lets multiple Campaigns share credit for one Opportunity. The model uses weighted Campaign Influence records to distribute attribution. CCI dramatically changes ROI reporting; the same revenue can credit several Campaigns at different weights. Marketing operations teams use it to reflect the multi-touch reality of modern demand generation.
Reporting and dashboards
Standard Campaign report types include Campaign with Won Opportunities, Campaign ROI Analysis, and Campaign Pipeline. Most marketing dashboards combine these to show ROI by Campaign, ROI by Campaign Type (Email, Webinar, Event), and ROI Trend by quarter. Custom report types extend the standard set when CCI is enabled.
Common attribution mistakes
Three patterns recur. Opportunities not added to Campaigns at all (no Campaign Member, no Primary Campaign Source, no Campaign Influence) get zero ROI credit despite the marketing source. Cost fields left blank produce divide-by-zero or zero-cost ROI that reads as infinite. And single-touch attribution credits late-stage email blasts at the expense of the early-funnel campaigns that did the real work.
How marketing teams operationalise ROI
Mature marketing teams attach every Opportunity to one or more Campaigns at lead capture, maintain Actual Cost throughout the Campaign lifecycle, and review ROI monthly. The discipline pays off in budget defence and in the credibility of the marketing function. Programs that skip the discipline find ROI numbers nobody believes.
How to make Campaign ROI reliable
Campaign ROI is a formula on existing fields; the work is making those fields accurate. Discipline in attribution and cost tracking is what makes ROI trustworthy.
- Enable Customizable Campaign Influence
Setup, Campaign Influence Settings. Enable CCI if multi-touch attribution matches the marketing model. Single-touch via Primary Campaign Source is fine for simple programs but underestimates early-funnel work.
- Build Campaign attribution into Lead and Opportunity creation
Every Lead from a marketing source should add a Campaign Member. Every Opportunity should attribute to the right Campaign(s) at creation, not after the fact.
- Track Actual Cost rigorously
Update Actual Cost as invoices land. A Flow that prompts Campaign owners monthly to update cost prevents the field from going stale.
- Audit ROI per Campaign quarterly
Build a report on Campaign ROI by Campaign Type. Investigate any Campaign with infinite or zero ROI; usually it indicates a data quality issue, not a real return.
- Use ROI in budget conversations
Bring the data to budget reviews. Campaign programs with strong ROI get more budget; weak ROI programs get redesigned or retired.
- Actual Cost blank produces nonsense ROI (zero, infinite, or null). Update the field rigorously throughout the Campaign lifecycle.
- Opportunities not attributed to any Campaign get zero ROI credit. The marketing source goes invisible.
- Single-touch attribution credits late-stage Campaigns at the expense of early-funnel ones. CCI fixes this if the marketing model is multi-touch.
- ROI uses only won revenue. Open pipeline does not count; programs that just kicked off may show artificially low ROI for a quarter or two.
Trust & references
Cross-checked against the following references.
- Campaigns OverviewSalesforce Help
- Campaign InfluenceSalesforce Help
Straight from the source - Salesforce's reference material on Campaign ROI (Return On Investment).
- Campaign ROI ReportsSalesforce Help
About the Author
Dipojjal Chakrabarti is a B2C Solution Architect with 29 Salesforce certifications and over 13 years in the Salesforce ecosystem. He runs salesforcedictionary.com to help admins, developers, architects, and cert/interview candidates sharpen their fundamentals. More about Dipojjal.
Test your knowledge
Q1. What is the formula for Campaign ROI?
Q2. What must be populated for Campaign ROI to be calculated?
Q3. What is a limitation of Campaign ROI as a metric?
Discussion
Loading discussion…