Skip to main content
Full Circle Insights

Common Report Formulas: ROI based on Influenced Revenue

Create a custom ROI report

This is an example on how to create a custom ROI report formula to display the ROI for each of Campaigns based on influenced revenue. Customers who are looking to create an ROI report based on sourced revenue please see this article.

 

The basic ROI (Return on Investment) formula is:

(TotalRevenue - Cost)/Cost

In this example, we will be implementing the formula in Salesforce in order to report on ROI in reports/dashboards.

Step by Step Tutorial in SFDC

1. Navigate to the Reports tab and click New Report
clipboard_e1f5a20577a7666d0dcb193891545c432.png
2. Create a new ‘Campaign Influence Detail w/Related Objects (CRT)’ reports

clipboard_efe2455f0aa0cc01787eb4021552c1acc.png

3. Change the format to Summary Format
clipboard_e48fc2ec7eea75d3a2c9e36b62b34a979.png

4. Click Add Formula to create a custom report formula
clipboard_eae0e77512fa14371ca9970e50dc5cc79.png

5. Populate fields as follows:

General Formula:
(TotalRevenue - Cost)/Cost

 

SFDC Report Formula:
(FCRM__FCR_Influence_Detail__c.FCRM__TotalOpRevenueModel1__c:SUM - FCRM__FCR_Influence_Detail__c.FCRM__Campaign__c.ActualCost:SUM)/FCRM__FCR_Influence_Detail__c.FCRM__Campaign__c.ActualCost:SUM
 

 

*In the above example we are using the standard ActualCost field and Model 1. To report on a different model, swap in the api name for Model 2 or Model 3 (eg: FCRM__TotalOpRevenueModel2__c or FCRM__TotalOpRevenueModel3__c)

clipboard_efc341a2be806182b42f7c36189a8ab3f.png

ROI (Influenced Revenue)

The report formula is now saved and added as the last column in the report. Additional columns can be added to this report per reporting needs.

  • Was this article helpful?