Blog · Finance metrics and formulas · Sales teams
Calculate LinkedIn Ads cost per lead from campaign and lead exports. Match the leads to qualified contacts, opportunities and won customers to see whether a lower CPL produces better sales outcomes.
LinkedIn Ads cost per lead is campaign spending divided by counted leads for the same period. To judge the spending, reconcile submissions to usable CRM contacts and follow those contacts through qualification and customer conversion. A lead-form submission alone does not establish sales pipeline.
LinkedIn says its Lead Gen Forms use profile information to populate fields and that advertisers can download leads from Campaign Manager in its Lead Gen Forms overview. Use that lead download alongside the matching campaign-spending export. Treat the submission as a response event, then apply your company's qualification standard separately.
Retain campaign ID, offer, reporting dates, currency and spend. For each response, keep lead ID, submission date, campaign ID and the matched CRM contact or account ID. Add qualification date, opportunity ID, won date and won amount from the CRM export.
Choose whether the business decision concerns contacts or accounts. Several people at one company may all be legitimate contacts, but they do not represent several independent account opportunities. The broader B2B cost per lead method covers that account comparison.
Covirage is not affiliated with LinkedIn. Covirage is not affiliated with Microsoft.
This illustrative US business-software company compares two offers acquired in the same period. It reviews both cohorts after the same elapsed follow-up interval. Spending is media only, and won amounts are contract values on a consistent basis, not cash collected or recognized revenue.
The first review table removes repeated submissions before identifying unusable remaining records. Those exclusion groups do not overlap.
| Offer | Ad spend (USD) | Submissions | Repeats removed | Unusable removed | Usable leads |
|---|---|---|---|---|---|
| Operations checklist | 7,200 | 120 | 12 | 8 | 100 |
| Sales consultation | 4,800 | 40 | 2 | 2 | 36 |
| Total | 12,000 | 160 | 14 | 10 | 136 |
Put those headers in A1:F1. In F2 enter the reconciliation formula, then fill down:
=C2-D2-E2
The bridge is 160 − 14 − 10 = 136 usable leads. Preserve every excluded event with its reason. Keep unmatched records outside the qualified count until someone resolves them; absence of a match is not evidence of qualification or disqualification.
For this example, a qualified lead meets the agreed account-fit and purchase-need criteria and is accepted by sales. Each opportunity and won customer is assigned once to a campaign. Where several contacts share an opportunity, count that opportunity once rather than once per contact.
Add these outcome columns as G:J in the same workbook:
| Offer | Qualified leads | Opportunities | Won customers | Won contract value (USD) |
|---|---|---|---|---|
| Operations checklist | 20 | 8 | 2 | 24,000 |
| Sales consultation | 18 | 9 | 3 | 45,000 |
| Total | 38 | 17 | 5 | 69,000 |
The underlying cost per lead calculation is:
CPL = Campaign spending / Leads counted under the stated definition
Use these Excel formulas for row 2, with the outcomes in G:J:
Submission CPL: =B2/C2
Usable-lead CPL: =B2/F2
Qualified-lead cost: =B2/G2
Cost per opportunity: =B2/H2
Ad spend per won customer: =B2/I2
Lead-to-customer conversion: =I2/F2
| Offer | Submission CPL (USD) | Usable-lead CPL (USD) | Qualified-lead cost (USD) | Cost/opportunity (USD) | Ad spend/customer (USD) |
|---|---|---|---|---|---|
| Operations checklist | 60.00 | 72.00 | 360.00 | 900.00 | 3,600.00 |
| Sales consultation | 120.00 | 133.33 | 266.67 | 533.33 | 1,600.00 |
| Total | 75.00 | 88.24 | 315.79 | 705.88 | 2,400.00 |
Totals divide summed spending by summed counts. For qualified-lead cost, use:
=SUM(B2:B3)/SUM(G2:G3)
Microsoft documents adding ranges with the SUM function. Do not average the row ratios. Round displayed money to cents and percentages to two decimals while retaining full precision in calculations. Flag zero denominators as undefined rather than reporting a zero cost.
The checklist generates cheaper submissions. The consultation produces lower cost per qualified lead and won customer. Its usable-lead customer conversion is 3 / 36 = 8.33%, versus 2 / 100 = 2.00% for the checklist. Across the cohorts, 5 / 136 = 3.68%.
Won contract value divided by spend is 69,000 / 12,000 = 5.75 times. That ratio is not a profit measure: it excludes fulfillment costs and wider acquisition costs. Use customer acquisition cost for the latter, and cost per qualified lead for consistent stage definitions.
LinkedIn's conversion-tracking guidance distinguishes website conversions from imported outcomes that can occur online or offline. In your management report, explicitly state which outcome the export represents. Do not add different conversion events together and label their sum unique leads.
Tie spending back to the campaign export, submissions back to the lead download and won amounts back to distinct CRM opportunities. Compare acquisition cohorts at the same age. A mature cohort and a recent cohort can show different customer rates because of time alone; an external CPL benchmark cannot resolve that difference.
Upload a file containing campaign spending and matched CRM outcomes; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for sales teams for the supporting business context.
A useful CPL depends on the offer, audience, qualification standard and eventual customer economics. Compare campaigns against your own matched sales outcomes first. An external average needs a stated date, geography, format and lead definition before it can help set a target.
A submission records a person's response to an offer. Qualification requires a separate business rule, such as account fit, purchase need and sales acceptance. Apply that rule in the CRM, retain its effective date, and compare submissions and qualified leads as separate stages.
Repeated submissions, missing matches, unusable details and different date rules can change the counts. Preserve the original events and prepare a reconciliation to accepted contacts. Investigate unmatched records before treating every advertising response as a new prospect or applying a qualification rate.
You can calculate that ratio when the revenue belongs to customers traced to the acquisition cohort. Label the revenue basis and cutoff. The result does not measure profit or fully loaded acquisition cost, because delivery costs and other sales and marketing spending remain outside it.