Workflow · Search and ads · Opening soon

LinkedIn Ads cost per lead

Use your LinkedIn Ads campaign export to review cost per lead by campaign week. Each row shows CPL and a status for duplicate or zero-lead rows.

Book a demo

Someone typed

“show every linkedin campaign week from the campaign export, cpl is spend divided by leads, highest first, with a Status that says "Agrees" when the row is unique and leads are over 0, else duplicate or zero-lead”

The agent read it as

show every linkedin campaign week from LinkedIn Ads campaign export, cpl is spend divided by leads, highest first, with a Status that says "Agrees" when the row is unique and leads are over 0, else duplicate or zero-lead

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

LinkedIn Ads campaign export

CSV export · 24 rows

Step

Add CPL and status

Step 1

Result

LinkedIn campaign weeks

24 rows · 3 flagged

Schedule

Runs when you say

Proposed

File
LinkedIn Ads campaign export
CSV export · 24 rows
Step
Add CPL and status
Step 1
Result
LinkedIn campaign weeks
24 rows · 3 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 24 rows came out.

Download LinkedIn Ads campaign export sample (24 rows)LinkedIn Ads: Campaigns > Export > Performance by campaign, weekly

What you get back

The result of that run, the rows to look at first.

LinkedIn campaign weeksSample data24 rows

21 agrees2 duplicate1 no leads

Campaign Name	Campaign ID	Week Start	Spend	Leads	CPL	Status
Pipeline \| Webinar \| North America	701,234,567	2026-10-26	620.40	7	88.63	Duplicate
Pipeline \| Webinar \| North America	701,234,567	2026-10-26	620.40	7	88.63	Duplicate
Lead Gen \| Hiring Guide \| APAC	701,234,572	2026-10-19	512.75	0	·	No leads
ABM \| CMO Summit \| Global	701,234,570	2026-09-28	845.20	6	140.87	Agrees
Field Marketing \| ROI Calculator \| US	701,234,571	2026-09-28	690	5	138	Agrees
ABM \| CMO Summit \| Global	701,234,570	2026-10-05	910.40	7	130.06	Agrees
ABM \| CMO Summit \| Global	701,234,570	2026-10-26	372.60	3	124.20	Agrees
Field Marketing \| ROI Calculator \| US	701,234,571	2026-10-05	724.80	6	120.80	Agrees
ABM \| CMO Summit \| Global	701,234,570	2026-10-12	965.10	8	120.64	Agrees
ABM \| CMO Summit \| Global	701,234,570	2026-10-19	1,044.80	9	116.09	Agrees
Retargeting \| Free Trial \| US	701,234,569	2026-10-19	902.10	8	112.76	Agrees
Field Marketing \| ROI Calculator \| US	701,234,571	2026-10-12	781.35	7	111.62	Agrees

24 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you track LinkedIn ads cost per lead by campaign week?

Export your LinkedIn Ads campaign data, then load the campaign export. The workflow adds CPL as spend divided by leads, shows each campaign week, and sorts the highest CPL first.

How it works

How to use the LinkedIn campaign weeks workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

LinkedIn campaign weeks: questions

What export should you use?

Use the LinkedIn Ads campaign export. It should include spend, leads, campaign, and week or a date you can group by week.

What happens to rows that do not match?

Rows with leads over 0 and no duplicate match get Status set to Agrees. Duplicate rows get Status set to duplicate, and rows with zero leads get Status set to zero-lead.

How do you change the rules in words?

You can change the steps by rewriting them in plain words, such as add CPL, set CPL to spend divided by leads, and sort highest first. You can also change the status rule to match the rows you want to keep or flag.