Skip to content
+

Combine Salesforce with LinkedIn Ads for a B2B funnel from ad to contract

LinkedIn Ads is an expensive channel, but it reaches the actual decision makers. LinkedIn Campaign Manager reports clicks, lead gen forms and spend; Salesforce holds leads, opportunities, stages and won contract value. With both sources combined, DataxLand puts LinkedIn spend by day and campaign next to leads and opportunities in Salesforce, and computes CPL, CAC, lead-to-customer rate, win rate and won amount. You know whether LinkedIn spend turns into contracts, not just leads.

Free plan with no time limit · No card required · Sample workspace ready in minutes

Why combine

  • LinkedIn CPL is high; it only pays off if leads become opportunities and contracts.
  • Sales cycles are long; you need to follow campaigns across months of CRM data.
  • Sales and marketing look at one funnel with shared definitions.

Metrics you only get by combining

MetricHow it is computed
Cost per lead (CPL)Marketing spend ÷ leads
Lead-to-customer rateLeads converted to customers ÷ leads
Customer acquisition cost (CAC)Marketing spend ÷ new customers from marketing
Won amountTotal value of opportunities won in the periodBy the Campaign field or lead source in Salesforce.

Standard metrics from the analytics packs

Once both sources map to the same model, these metrics run on the joined data with one definition.

MetricDefinitionUnit
Marketing spendTotal cost of marketing campaigns by spend date.Currency
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
Won amountTotal value of won opportunities, by close date.Currency
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)

Questions you can answer

QuestionLinkedIn Ads onlySalesforce + LinkedIn Ads combined
Do leads become contracts?UnknownLead-to-customer rate, win rate
What is LinkedIn's CAC?NoSpend ÷ new customers
Contract value from each campaign?NoWon amount

Steps

  1. 1

    Connect Salesforce

    Enter the client ID, client secret and refresh token of your connected app; choose the Lead, Opportunity and Campaign objects.

  2. 2

    Connect LinkedIn Ads

    Enter your LinkedIn Marketing API credentials (OAuth client or access token) and a start date.

  3. 3

    Review Si's mapping

    Si proposes which Salesforce fields link leads and opportunities to LinkedIn campaigns, and which stage counts as won; you approve.

  4. 4

    Build and read the dashboards

    The Marketing funnel and Opportunities and quota dashboards show CPL, CAC and win rate by campaign; a monthly report is sent to Slack.

Frequently asked questions

What about custom objects in Salesforce?

The Salesforce connector reads the objects you choose, including custom objects. Si proposes which objects are leads, opportunities and campaigns during review.

Can I use a Salesforce sandbox?

Yes, the connector has a sandbox option so you can test the mapping before connecting your production org.

Which plan can combine two sources?

The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.

Dashboard templates that use this source

Connect Salesforce →Connect LinkedIn Ads →Ask Si about your Salesforce data →Ask Si about your LinkedIn Ads data →

Combine Salesforce and LinkedIn Ads in minutes

Free plan with no time limit · No card required · Sample workspace ready in minutes