Find LinkedIn Ads campaigns that bring leads but no sales pipeline.
LinkedIn Ads reports cost per lead, but sales cares about opportunities. Put each campaign’s spend and lead form leads next to its Salesforce campaign members and the opportunities that name it as their primary campaign. Find the campaigns that make cheap leads and no pipeline, and the leads that never reached Salesforce.
LinkedIn Ads + Salesforce · Spend Aug 1–Oct 31, 2026, UTC · Opportunities through Nov 16
From Aug 1 to Oct 31, LinkedIn Ads spent $30,000 on five campaigns and reported 434 lead form leads. Opportunities whose primary campaign is one of the four matching Salesforce campaigns add up to $275,200 created by Nov 16, $56,400 of it won. The Startup Founders campaign had the cheapest leads, $28.87 each, but its 205 Salesforce members produced one $8,400 opportunity. The Controllers demo campaign has the opposite problem: only 21 of its 58 leads reached Salesforce, and those 21 already produced $96,000 of pipeline.
WHERE THE RESULT GOES
Google Sheets
Export each data source report to Google Sheets, then add your analysis or checklist to the review Sheet.
Example use case
Ask. Follow up. Take the next step.
✦ AI assistantSample use case
YOU
Which LinkedIn campaigns create no pipeline?
✦
From Aug 1 to Oct 31, LinkedIn Ads spent $30,000 on five campaigns and reported 434 lead form leads. Opportunities whose primary campaign is one of the four matching Salesforce campaigns add up to $275,200 created by Nov 16, $56,400 of it won. The Startup Founders campaign had the cheapest leads, $28.87 each, but its 205 Salesforce members produced one $8,400 opportunity. The Controllers demo campaign has the opposite problem: only 21 of its 58 leads reached Salesforce, and those 21 already produced $96,000 of pipeline.
01
LGF – Startup Founders – Checklist · $6,120 spent, $8,400 of pipeline212 LinkedIn leads · 205 Salesforce campaign members · 1 opportunity · $1.37 of pipeline per $1Review with sales first
This campaign has the lowest cost per lead in the account, $28.87, and almost every lead reached Salesforce: 205 members for 212 LinkedIn leads. Yet only one opportunity names its Salesforce campaign as the primary campaign: Nimbus Startup Studio, $8,400, still in Discovery. The three other campaigns with a Salesforce campaign create $11.87 to $13.22 of pipeline for every $1 spent; this one creates $1.37. Time isn’t the reason: 142 of the 205 members joined before October 1. The leads arrive, and sales isn’t turning them into opportunities.
NextTake the member list to the sales team and ask what happened to these leads: wrong company size, students and job seekers downloading the checklist, or no follow-up. If the audience is the problem, narrow the targeting or move most of this budget to the Finance Leaders guide. Don’t judge it on cost per lead again.
02
LGF – Controllers – Demo Request · 37 of 58 leads never reached Salesforce21 Salesforce campaign members · 6 opportunities · $96,000 of pipeline · $18,000 wonFix the lead sync
LinkedIn counted 58 lead form leads, but the matching Salesforce campaign has only 21 members created in the same days, 36%. The other campaigns that collect leads keep 96 to 97%. The 21 that did arrive already produced six opportunities worth $96,000, the most pipeline per dollar in the account at $13.22. The campaign looks expensive at $125.17 per lead only because most of its leads are missing from Salesforce.
NextDownload this form’s leads from Campaign Manager and ask sales operations to look for them in Salesforce by email. Check how the form’s leads get into Salesforce and whether a required field or a duplicate rule turns some of them away. Once the missing leads are found, hand them to sales right away; they asked for a demo.
The Finance Leaders guide turned $9,840 into nine opportunities worth $118,800, $12.07 per $1, with $26,400 already won. Pricing Page retargeting collects website conversions rather than form leads; its Salesforce campaign has 29 members and four opportunities worth $52,000, $11.87 per $1. Both move leads into pipeline at a similar rate.
NextKeep both running. If budget moves away from the Startup Founders campaign, the Finance Leaders guide is the place to test it first. Recheck its pipeline per dollar after the extra spend.
04
Brand – Video – Close Faster · no Salesforce campaign$2,400 spent in September · 88,000 video views · 0 leadsJudge on reach
This video campaign was built for views, not leads, and no Salesforce campaign is linked to it. Measuring it on pipeline would make it look like wasted money. Its $2,400 stays in the total spend, separate from the campaigns that collect leads.
NextReport it on reach and site visits. If it should support pipeline, create a Salesforce campaign for the people who later fill in a form after watching it.
05
Three LinkedIn opportunities with no primary campaign · $41,000Lead source LinkedIn · Primary campaign ID empty · $14,600 wonAsk sales operations
Ridgeway Partners ($16,800), Vantage Clinics ($9,600) and Larkspur Interiors ($14,600, won) were created in the same weeks with Lead source set to LinkedIn, but no primary campaign. They may come from any of the four campaigns, or from someone who saw a post and wrote in. They stay out of every campaign’s total rather than being guessed.
NextAsk sales operations to check each one’s lead history and set the primary campaign where the record shows it. Then rerun the review; the totals above can only go up.
LinkedIn Ads + Salesforce · Spend Aug 1–Oct 31, 2026, UTC · Opportunities through Nov 16
01 · CONNECT YOUR DATA
Your tools. One place to ask.
2 of 3 Free data sources No credit card · Daily refresh
DatapipeYour project
✦Your AI assistantor a report in Sheets / Data Studio
Create your free workspace
Sign up with your company email. Your first project opens on Data sources.
Add the data sources
Choose the accounts for this use case. Authorize access and select the property or site.
Bring your question
Connect your project to a supported AI assistant, or build your source reports.
Email/password signups confirm their email first. Use Google signup with a company account if you prefer.
LinkedIn Ads: Sign in with LinkedIn and choose the ad account whose campaigns you want to review. Datapipe reads campaign performance with reporting access only and changes nothing. Setup guide ↗
Salesforce: Ask your Salesforce administrator to install the Datapipe app once, then sign in with your company’s My Domain address. You see the records your Salesforce permissions allow, and nothing is changed. Setup guide ↗
Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.
02 · ASK A USEFUL QUESTION
Start with a prompt. Follow the evidence.
Copy these in order into your connected assistant. Each builds on the answer before it.
01
Read campaign spend and the Salesforce campaigns
Read the full prompt
Use only this Datapipe project’s authorized data. Discover the connected accounts, datasets and compatible fields first. Confirm dates, timezones, currencies and data coverage. Keep missing or unmatched rows visible; never substitute sample data. Compare the sources explicitly and explain every match. Do not change source records or send messages.
From the connected LinkedIn Ads account, read Daily campaign performance from Aug 1 to Oct 31, 2026 with Date (UTC), Campaign ID, Campaign name, Objective, Account currency, Spend (account currency), Clicks, Lead form leads and Website conversions. Add the days up to one line per campaign and tell me the first and last day with delivery. From Salesforce, read Selected object records (JSON) for the Campaign object with field names Name, Type, Status, StartDate, EndDate and IsActive. Show both campaign lists side by side and suggest which Salesforce campaign belongs to each LinkedIn campaign, with your reason. Do not match anything until I confirm the pairs, and list LinkedIn campaigns with no likely Salesforce campaign.
02
Count members and opportunities for each pair
Read the full prompt
Use the pairs I confirmed. Read Salesforce Selected object records (JSON) for CampaignMember with field names CampaignId, LeadId, ContactId, Status, HasResponded and CreatedDate, and count members per confirmed campaign whose CreatedDate falls between Aug 1 and Oct 31, 2026 in UTC. Then read Opportunity sales pipeline with Record ID, Created at, Opportunity name, Stage, Lead source, Won, Closed, Opportunity amount, Record or organization currency and Primary campaign ID. Keep opportunities created from Aug 1 to today whose Primary campaign ID is a confirmed campaign, and total them as all, won, open and lost, by currency. List separately any opportunity in the same dates with Lead source LinkedIn but no primary campaign, and do not credit it to any campaign.
03
Prepare the campaign review for sales
Read the full prompt
Prepare a table with one row per LinkedIn campaign: spend, lead form leads, website conversions, Salesforce members, members as a share of leads, opportunities, pipeline created, won, pipeline per $1 of spend and cost per lead. Add a total row. Give each campaign one finding: leads lost before Salesforce, leads that don’t become opportunities, creating pipeline, or not built for leads. Note how many members joined in the last 30 days, because their opportunities may not exist yet. Under the table, write three questions for the sales team about the campaigns that need a decision. Draft it in this conversation. Do not change campaigns, budgets or Salesforce records.
Match campaigns, find where leads stop and agree the change with sales.
01
Read spend and leads per campaign from LinkedIn Ads.
02
Read the Salesforce campaigns, their members and the opportunities.
03
Match campaigns, find where leads stop and agree the change with sales.
↗
Check the result at your next review.
After the sync fix and the budget change, run the same review for the next 30 complete days. Salesforce members for the Controllers demo campaign should be close to its LinkedIn lead form leads, as the other campaigns already are. If budget moved to the Finance Leaders guide, check that its pipeline per $1 stays near this period’s $12.07 once the new members have had time to become opportunities. For the Startup Founders campaign, compare opportunities per 100 members with this period’s 0.5.
Implementation tips for this use case
Nothing links a LinkedIn campaign to a Salesforce campaign automatically, so confirm each pair with whoever set them up, usually by name. For each pair, compare LinkedIn leads with Salesforce members created in the same days, then members with opportunities whose Primary campaign ID is that campaign, and pipeline with spend. Few members compared with leads means leads are lost on the way to Salesforce. Plenty of members and no opportunities means sales can’t use them. Take the table to the sales team before you move any budget.
WHEN YOU NEED MORE CONTEXT
Go a little deeper.
The method and reporting checks behind this example.
How to find LinkedIn Ads campaigns that bring leads but no sales pipeline
Read spend and leads per campaign from LinkedIn Ads.
Add the LinkedIn ad account and your Salesforce organization to one project in Data sources. Read LinkedIn Ads Daily campaign performance for the complete days you want to review: Date (UTC), Campaign ID, Campaign name, Objective, Account currency, Spend (account currency), Clicks, Lead form leads and Website conversions. LinkedIn reports UTC days and leaves out days with no delivery. Add the daily rows up to one total per campaign. Lead form leads count LinkedIn’s own forms; Website conversions count conversions with the attribution set in Campaign Manager.
Read the Salesforce campaigns, their members and the opportunities.
In Salesforce, read Selected object records (JSON) twice: Campaign with Name, Type, Status, StartDate, EndDate and IsActive, and CampaignMember with CampaignId, LeadId, ContactId, Status, HasResponded and CreatedDate. Then read Opportunity sales pipeline with Record ID, Created at, Opportunity name, Stage, Lead source, Won, Closed, Opportunity amount, Record or organization currency and Primary campaign ID. These are current records, so filter by CreatedDate yourself: members created in the spend window, opportunities created from its first day to the day you read. Salesforce returns CreatedDate in UTC, the same days LinkedIn uses.
Match campaigns, find where leads stop and agree the change with sales.
Nothing links a LinkedIn campaign to a Salesforce campaign automatically, so confirm each pair with whoever set them up, usually by name. For each pair, compare LinkedIn leads with Salesforce members created in the same days, then members with opportunities whose Primary campaign ID is that campaign, and pipeline with spend. Few members compared with leads means leads are lost on the way to Salesforce. Plenty of members and no opportunities means sales can’t use them. Take the table to the sales team before you move any budget.
See the complete example report
EXAMPLE REPORT
Which LinkedIn campaigns create no pipeline?
LinkedIn Ads + Salesforce · Spend Aug 1–Oct 31, 2026, UTC · Opportunities through Nov 16
Which LinkedIn campaigns create no pipeline?
Campaign
Spend
Pipeline
Founders checklist
$6,120
$8,400
Demo request
$7,260
$96,000
Other campaigns
$16,620
$170,800
WHAT TO LOOK ATFrom Aug 1 to Oct 31, LinkedIn Ads spent $30,000 on five campaigns and reported 434 lead form leads. Opportunities whose primary campaign is one of the four matching Salesforce campaigns add up to $275,200 created by Nov 16, $56,400 of it won. The Startup Founders campaign had the cheapest leads, $28.87 each, but its 205 Salesforce members produced one $8,400 opportunity. The Controllers demo campaign has the opposite problem: only 21 of its 58 leads reached Salesforce, and those 21 already produced $96,000 of pipeline.
Match campaigns, find where leads stop and agree the change with sales.
This campaign has the lowest cost per lead in the account, $28.87, and almost every lead reached Salesforce: 205 members for 212 LinkedIn leads. Yet only one opportunity names its Salesforce campaign as the primary campaign: Nimbus Startup Studio, $8,400, still in Discovery. The three other campaigns with a Salesforce campaign create $11.87 to $13.22 of pipeline for every $1 spent; this one creates $1.37. Time isn’t the reason: 142 of the 205 members joined before October 1. The leads arrive, and sales isn’t turning them into opportunities. LinkedIn counted 58 lead form leads, but the matching Salesforce campaign has only 21 members created in the same days, 36%. The other campaigns that collect leads keep 96 to 97%. The 21 that did arrive already produced six opportunities worth $96,000, the most pipeline per dollar in the account at $13.22. The campaign looks expensive at $125.17 per lead only because most of its leads are missing from Salesforce. The Finance Leaders guide turned $9,840 into nine opportunities worth $118,800, $12.07 per $1, with $26,400 already won. Pricing Page retargeting collects website conversions rather than form leads; its Salesforce campaign has 29 members and four opportunities worth $52,000, $11.87 per $1. Both move leads into pipeline at a similar rate. This video campaign was built for views, not leads, and no Salesforce campaign is linked to it. Measuring it on pipeline would make it look like wasted money. Its $2,400 stays in the total spend, separate from the campaigns that collect leads. Ridgeway Partners ($16,800), Vantage Clinics ($9,600) and Larkspur Interiors ($14,600, won) were created in the same weeks with Lead source set to LinkedIn, but no primary campaign. They may come from any of the four campaigns, or from someone who saw a post and wrote in. They stay out of every campaign’s total rather than being guessed.
Try the example with sample CSVs
Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.
Data method, reporting checks & sources
Add the LinkedIn ad account and your Salesforce organization to one project in Data sources. Read LinkedIn Ads Daily campaign performance for the complete days you want to review: Date (UTC), Campaign ID, Campaign name, Objective, Account currency, Spend (account currency), Clicks, Lead form leads and Website conversions. LinkedIn reports UTC days and leaves out days with no delivery. Add the daily rows up to one total per campaign. Lead form leads count LinkedIn’s own forms; Website conversions count conversions with the attribution set in Campaign Manager. In Salesforce, read Selected object records (JSON) twice: Campaign with Name, Type, Status, StartDate, EndDate and IsActive, and CampaignMember with CampaignId, LeadId, ContactId, Status, HasResponded and CreatedDate. Then read Opportunity sales pipeline with Record ID, Created at, Opportunity name, Stage, Lead source, Won, Closed, Opportunity amount, Record or organization currency and Primary campaign ID. These are current records, so filter by CreatedDate yourself: members created in the spend window, opportunities created from its first day to the day you read. Salesforce returns CreatedDate in UTC, the same days LinkedIn uses. Nothing links a LinkedIn campaign to a Salesforce campaign automatically, so confirm each pair with whoever set them up, usually by name. For each pair, compare LinkedIn leads with Salesforce members created in the same days, then members with opportunities whose Primary campaign ID is that campaign, and pipeline with spend. Few members compared with leads means leads are lost on the way to Salesforce. Plenty of members and no opportunities means sales can’t use them. Take the table to the sales team before you move any budget.
LinkedIn rows are UTC days and Salesforce CreatedDate is compared in UTC, over the same spend window. Each LinkedIn campaign is paired with a Salesforce campaign the team confirmed; nothing is matched automatically. Opportunities count only when their Primary campaign ID is the paired campaign. LinkedIn-source opportunities without one stay in a separate list. Amounts are added up only within one currency, and the video campaign’s spend stays out of pipeline per dollar.
LinkedIn rows are UTC days and Salesforce CreatedDate is compared in UTC, over the same spend window.
Each LinkedIn campaign is paired with a Salesforce campaign the team confirmed; nothing is matched automatically.
Opportunities count only when their Primary campaign ID is the paired campaign. LinkedIn-source opportunities without one stay in a separate list.
Amounts are added up only within one currency, and the video campaign’s spend stays out of pipeline per dollar.
Access to the intended LinkedIn Ads account or property.
Access to the intended Salesforce account or property.
LinkedIn rows are UTC days and Salesforce CreatedDate is compared in UTC, over the same spend window.
For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions.
LinkedIn Ads knows what each campaign cost and how many leads it collected. Salesforce knows which of those people became opportunities and what they are worth. Cost per lead from LinkedIn alone ranked the Startup Founders campaign first; Salesforce shows it created the least pipeline.
How does Datapipe know which Salesforce campaign belongs to which LinkedIn campaign?
It doesn’t on its own. LinkedIn and Salesforce share no campaign ID. The first prompt suggests pairs from the names and waits for you to confirm them. Naming Salesforce campaigns after the LinkedIn campaign, or recording the LinkedIn campaign ID in the Salesforce campaign name, makes this quick every month.
What is the primary campaign on an opportunity?
It is the single campaign recorded in the opportunity’s Primary Campaign Source field, read as Primary campaign ID. Depending on your Salesforce setup it is filled when a lead is converted or set by the rep. It credits one campaign per opportunity, so it is not multi-touch attribution.
Why are some LinkedIn leads missing from Salesforce?
Datapipe can show the gap but not the cause. Common reasons are a form whose leads aren’t sent to Salesforce, a required field or duplicate rule that turns leads away, or leads added to Salesforce without being added to the campaign. Sales operations can check the form’s settings and search for the missing people.
Can I use this with campaign members that are contacts, not leads?
Yes. A campaign member is either a lead or a contact, so existing contacts who fill in a form count as members too. Count both.
What if my Salesforce organization doesn’t have campaigns?
Salesforce campaigns and campaign members need the marketing feature and a Marketing User setting. Without them, Lead source on opportunities is the closest signal, but it can’t separate one LinkedIn campaign from another.
YOUR NEXT STEP
Try it with your own data.
Start free with up to 3 data sources. No credit card.