Sales teams generate a goldmine of data within their CRM systems. Every interaction, comment, and deal status update contains valuable clues about what drives success and what causes deals to fail. However, for operations and sales managers, manually sifting through hundreds of comments in a CRM export to identify these patterns is a tedious, time-consuming task.
The Challenge
The process is often manual, prone to inconsistency, and too slow to provide timely, actionable insights. As a result, valuable lessons are missed, and strategic decisions are based on gut feelings rather than data-driven evidence.
The Solution
Elvity.ai transforms this challenge into an opportunity by automating the entire win/loss analysis process, allowing non-technical users to generate a comprehensive report in minutes with a simple, natural language prompt.
The Prompt
Analyze the CRM export data and provide a summary of customer feedback for both won and lost deals.
Your analysis should include:
- For won deals:
- Identify the 3-5 most common factors that contributed to winning the deals
- Include relevant quotes or specific examples from the comments
- Provide a brief summary paragraph of what appears to be working well in the sales process
- For lost deals:
- Identify the 3-5 most common reasons for losing deals
- Include relevant quotes or specific examples from the comments
- Provide a brief summary paragraph of potential areas for improvement
Format the output as a structured report that sales management can use to understand patterns in successful and unsuccessful deals. Use the AnalyzeContent task for this.
Input Data
- crm_export.csv: A CSV file containing customer deal information, including deal status and qualitative feedback in a comments column.
How Elvity.ai Delivers Results
With this simple prompt, Elvity.ai instantly designs and builds a sophisticated data pipeline:
- Reads and Segments Data: Elvity first reads the CRM export file and intelligently filters the data into separate streams for "Won" and "Lost" deals.
- Summarizes Qualitative Feedback: For each stream, Elvity consolidates the free-text comments and feeds them into its powerful AnalyzeContent capability.
- Generates a Structured Report: Elvity structures the analysis into a clean, easy-to-read report, separating insights for won and lost deals.
Expected Outcomes
- Clear identification of success factors from winning deals
- Specific insights into why deals are lost
- Actionable recommendations for sales process improvement
- Automated scheduling for regular analysis updates
Sample Data
Download the sample CRM export data to test this use case in your own environment:
- crm_export.csv - Sample CRM data with deal outcomes and comments
Get Started
Ready to automate your sales win-loss analysis?