Lead source quality analysis from enquiry to won deal
Follows every lead from its source to a won or lost deal and ranks sources by revenue per lead, win rate and time to close, rather than by lead count. Use it to decide where next quarter's marketing budget goes and which sources the sales team should answer first.
The output this prompt produced, unedited.
The prompt
Constraints first
Judge a source by revenue and cost per won deal, never by the number of leads alone.
Leads still open are reported apart from closed ones and never counted as lost.
A source with fewer than 20 closed leads is marked "too few to judge".
Use only the rows pasted.
Inputs
Leads export: [paste rows: lead ID, created date, source, campaign, stage, won or lost or open, close date, deal value]
Spend by source for the same period: [paste rows: source, spend]
Lost reasons, if recorded: [paste, or none]
Period: [e.g. April to September 2026]
Work through
Clean source names so "FB", "Facebook Ads" and "facebook" count as one, and list the mapping.
For each source: leads, closed leads, won deals, win rate on closed leads, total won value, revenue per lead, cost per lead, cost per won deal, median days from lead to close.
Compare the top three sources by lead count with the top three by revenue per lead.
Check the most common lost reasons by source.
Output format
Three-sentence verdict.
| Source | Leads | Closed | Won | Win rate | Revenue per lead | Cost per won deal | Median days to close |
Source mapping used.
Budget shift: which sources to grow, hold and cut, with the numbers behind each.
Lead priority order for the sales team, with the reason for each position.
lead source analysislead qualitycrm data analysismarketing attributioncost per acquisitionsales pipeline analysis
How to run this
Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.
The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.