Skip to content
Clientell AI

Find Out Why Deals Are Lost

Use Cases:

  • Find out why deals are being lost and how much revenue it costs.
  • Spot the most common lost reasons and their financial impact.
  • Use this data to fix issues in your sales process.
  • Focus training or resources on the top reasons deals fall through.
Build ReportsGTM/BusinessRevOps Insights

Prompt

Build a summary report of Opportunities with Stage = Closed–Lost in the last <N months>, grouped by Lost Reason, showing count and total Amount.

Try it yourself

Related use cases

See which reps convert best and where leads stall.

Try this prompt

“Break down leads created in the past 1 year into Converted vs Unconverted and show conversion rate. Also give me a conversion rate by lead owner”

Lead ConversionPast 12 months
1,240 leads32%
397 converted843 unconverted
By Owner
Sarah K.
45%
James R.
31%
Mike T.
22%
1,240 leads analyzed

Instant table of recent leads by owner, status, and date.

~1 minTry this prompt

“Create a tabular report listing Leads created in the past <N days> with columns Lead Owner, Status, Created Date, and Converted Date.”

Lead PipelineLast 30 days
OwnerStatusCreated
Sarah K.OpenMar 15
James R.WorkingMar 12
Mike T.ConvertedMar 08
Lisa M.OpenMar 05
147 leads · Last 30 days

Generate next-year renewals on every Closed Won.

Multi-stepTry this prompt

“Create a flow that generates a renewal opportunity in the same account whenever an opportunity moves to Closed Won, with close date set to 1 year from today and the same owner as the original opportunity.”

Record-Triggered FlowOpportunity
Stage = Closed Won
Trigger
+
Create Renewal Opp
Create Records
+
Close +1yr, Same Owner
Assignment
After Save · Same Account

Related How-To Guides

How to Create Salesforce Reports

Learn how to create custom Salesforce reports to analyze your data, track performance, and make data-driven decisions.

How to Create Opportunity Reports in Salesforce

Learn how to build reports on Opportunities to track pipeline, forecast revenue, and analyze sales performance.