SF - Campaign Influence

This table describes Salesforce Campaign Influence metrics.

These metrics are used in the Document Currency (DC) and Corporate Currency (CC) fact folders in the subject area. Document Currency is the currency used while entering the data in the application. Corporate Currency is the currency defined in Salesforce CRM. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
# of Campaigns with Influence The total number of Campaigns that Influenced the Opportunities
# of Influenced Opportunities  The total number of Opportunities influenced by Campaigns
# of Influenced Won Opportunities  The total number of Won Opportunities influenced by Campaigns
Average Campaign Cost per Influenced Revenue  The total Campaign Cost per Influenced Revenue. This metric is calculated as follows: SF Campaign Actual Cost / Influenced Opportunity Revenue 
Average Campaign Cost per Opportunity  The total Campaign Cost per Opportunity. This metric is calculated as follows: SF Campaign Actual Cost / # of Influenced Opportunities 
Average Campaign Cost per Won Opportunity  The total Campaign Cost per Won Opportunity. This metric is calculated as follows: SF Campaign Actual Cost / # of Influenced Won Opportunities
Average Campaign Influenced Won Revenue  The average Won Opportunity Revenue. This metric is calculated as follows: Influenced Won Opportunity Revenue / # of Influenced Won Opportunities 
Average Influenced Opportunity Percentage Share  The percentage of the associated Opportunity’s Amount field attributed to the associated Campaign
Campaign Actual Cost  The total Campaign Cost
Campaign Expected Revenue  The total Campaign Opportunity Expected Revenue
Campaign ROI  The Campaign ROI is based on the Campaign Influence Model. This metric is calculated as follows: (Influenced Opportunity Revenue  - SF Campaign Actual Cost) / SF Campaign Actual Cost
Influenced Opportunity Revenue  The total Campaign Influenced Opportunity Revenue
Influenced Won Opportunity Revenue  The total Campaign Influenced Won Opportunity Revenue
Opportunity Amount The total Opportunity Amount