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
| Metric | How it is computed |
|---|---|
| Cost per lead (CPL) | Marketing spend ÷ leads |
| Lead-to-customer rate | Leads converted to customers ÷ leads |
| Customer acquisition cost (CAC) | Marketing spend ÷ new customers from marketing |
| Won amount | Total 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.
| Metric | Definition | Unit |
|---|---|---|
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
| Lead-to-customer rate | Leads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / Leads | Ratio (%) |
| Customer acquisition cost (CAC) | Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketing | Currency |
| Won amount | Total value of won opportunities, by close date. | Currency |
| Win rate | Won 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
| Question | LinkedIn Ads only | Salesforce + LinkedIn Ads combined |
|---|---|---|
| Do leads become contracts? | Unknown | Lead-to-customer rate, win rate |
| What is LinkedIn's CAC? | No | Spend ÷ new customers |
| Contract value from each campaign? | No | Won amount |
Steps
- 1
Connect Salesforce
Enter the client ID, client secret and refresh token of your connected app; choose the Lead, Opportunity and Campaign objects.
- 2
Connect LinkedIn Ads
Enter your LinkedIn Marketing API credentials (OAuth client or access token) and a start date.
- 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
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