SalesforceMarketingCampaign Attribution Analysis
Campaign Attribution Analysis measures how much pipeline and closed revenue each Salesforce campaign generates, using Campaign Member records and the Opportunity Contact Roles linked to them. It connects the campaigns a contact engaged with to the opportunities those contacts later touched, so credit can be assigned to the touchpoints that influenced a deal. The analysis can run on a first-touch, last-touch, or multi-touch model depending on how you weight each campaign in the buyer journey.
Salesforce metric
Campaign Attributed Revenue = Sum of (Won Opportunity Amount x Campaign Credit Weight) for opportunities linked to the campaign
Campaign Attribution Analysis measures how much pipeline and closed revenue each Salesforce campaign generates, using Campaign Member records and the Opportunity Contact Roles linked to them. It connects the campaigns a contact engaged with to the opportunities those contacts later touched, so credit can be assigned to the touchpoints that influenced a deal. The analysis can run on a first-touch, last-touch, or multi-touch model depending on how you weight each campaign in the buyer journey.
Full guide: definition, formula, and benchmarksHow to calculate Campaign Attribution Analysis
Campaign Attributed Revenue = Sum of (Won Opportunity Amount x Campaign Credit Weight) for opportunities linked to the campaign
Why Campaign Attribution Analysis matters for Salesforce users
Marketing and revenue teams running on Salesforce often see campaigns as cost centres because the link between a campaign and a closed deal is buried across Campaign Member, Contact, and Opportunity objects. Attribution analysis joins those records so you can see which campaigns actually move pipeline rather than which ones simply generate clicks or form fills.
With that visibility, budget moves towards the campaigns that influence won revenue and away from the ones that only inflate top-of-funnel counts. It also gives sales and marketing a shared, evidence based view of what is working, which reduces the friction that comes when each side measures success differently.
Driver
Conversion rate
Outcome · 58% contribution
Revenue
Understand and act on Campaign Attribution Analysis with KPI Tree
Sync your Salesforce Campaign, Campaign Member, Contact Role, and Opportunity data into your warehouse and compute Campaign Attribution Analysis in KPI Tree. Build a metric tree that links each campaign to the pipeline and closed revenue it influenced, so attributed revenue sits alongside related metrics like contact conversion rate and customer acquisition cost rather than in an isolated report.
Assign RACI ownership so a marketing operations lead is accountable for the attribution model and the chosen credit weighting, with sales leadership consulted on how opportunities are credited. In KPI Tree, set a monthly review cadence to revisit the model as campaigns and deal cycles change, and to confirm the numbers still reflect how deals are really being won.
Get started with your Salesforce data
Connect your existing warehouse where Salesforce data already lands.
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 Ready to add to your trees.
Contact Conversion Rate
CRMContact 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 metricCustomer Acquisition Cost
CRMCustomer 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 metricContract Value Analysis
CRMContract 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 metricActivity Volume per Rep
CRMActivity Volume per Rep = Total Logged Activities / Number of Active Reps
Activity volume per rep measures the total number of logged activities (calls, emails, meetings, tasks) per sales representative in Salesforce over a defined period. It quantifies the effort each rep invests in customer-facing and pipeline-building activities and serves as a baseline for evaluating activity efficiency.
View metricExplore Campaign Attribution Analysis across integrations
All Salesforce metrics
Account Health ScoreActivity Volume per RepMarketing ROIAverage Resolution TimeContact Conversion RateCustomer Acquisition CostCustomer Lifetime ValueDashboard Adoption RateDeal Stage ProgressionForecast AccuracyLead Conversion RateLead Response TimeLead Scoring EffectivenessOpportunity AgingWin RatePipeline Coverage RatioSales Pipeline VelocityQuota AttainmentReport Usage AnalysisRevenue by Product LineSales Cycle LengthSales Rep Performance AnalysisTerritory Performance AnalysisUser Adoption RateWin/Loss AnalysisContract Value AnalysisCustomer Churn PredictionCustomer Renewal RateDeal Stage Conversion AnalysisDeal VelocityEmail Engagement AnalysisLead Source AttributionMarketing Qualified Lead RatePipeline ValueSales Velocity AnalysisUpsell Cross-sell AnalysisAccount Growth RateActivity Based AnalysisAverage Deal SizeCampaign ROICase Resolution TimeChurn Risk AnalysisContact Engagement ScoreCustomer Segmentation AnalysisLead Source AnalysisMonthly Recurring RevenueOpportunity Stage AnalysisPipeline VelocityProduct Performance AnalysisQuote To Close RateSales Funnel AnalysisSales Pipeline ValueSales Rep Quota AttainmentEmpower 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.
