Ballet’s Win/Loss Analysis & Safe CRM Write-Back template helps you analyze win/loss trends by competitor, identify gaps in opportunity data, and write verified updates back to HubSpot or Salesforce. Configurable approval rules and execution logs give your team control over what changes and a record of what happened.
The problem: Competitive reporting is only as reliable as your CRM data.
Understanding how your team performs against competitors helps Marketing, Product Marketing, and Sales make better decisions.
But competitive information isn’t always captured consistently. One opportunity may have a competitor recorded in a dedicated field, while another mentions the competitor only in sales notes. Some records may contain conflicting information or no competitor data at all.
This creates two challenges.
First, reporting becomes difficult. Teams spend time reviewing individual opportunities, reconciling inconsistent records, and assembling spreadsheets to understand competitive performance.
Second, the underlying data remains incomplete. Even when someone identifies missing competitor information during analysis, it may never make its way back into the CRM.
Without a consistent process, teams risk making decisions based on an incomplete view of their competitive landscape.
The play: Connect competitive analysis with CRM data quality.
Start with Ballet’s Win/Loss Analysis & Safe CRM Write-Back template and customize it with your reporting requirements and competitor data rules.
The template retrieves closed opportunities, calculates win/loss performance by documented competitor, and generates a report showing how results vary across segments.
It also checks approved CRM sources for missing competitor information and prepares evidence-backed field updates.
Changes are validated against your rules before being written back to the CRM. Records with conflicting or uncertain information can be held for human review.
The result is a repeatable process for understanding competitive performance while maintaining more complete opportunity data.
Customize the template with this prompt
Use the following instructions to tailor the template to your CRM, competitive reporting requirements, and approval rules.
Use the Win/Loss Analysis & Safe CRM Write-Back template with [HubSpot or Salesforce] to analyze win/loss performance by competitor and safely update missing competitor information.
Win/loss analysis
Retrieve closed-won and closed-lost opportunities from [CRM] for [date range].
Use [competitor field], [deal amount field], and [segment, region, product, or other relevant fields] to analyze performance.
Calculate wins, losses, win rates, and deal values by competitor. Highlight notable differences across segments and include links to supporting opportunity records.
Keep opportunities without documented competitor information in a separate, unclassified category.
Competitor data review
For opportunities with missing competitor values, examine [approved CRM fields, opportunity descriptions, or sales notes].
If an approved source clearly identifies the competitor associated with the deal outcome, prepare an update to [competitor field] and capture the supporting evidence.
Do not infer competitors from deal outcomes alone. Flag ambiguous information or conflicts with existing CRM values for review.
Safe CRM write-back
Validate proposed changes against the original opportunity records and configured field rules.
Preview each update, including the opportunity, proposed value, supporting source, and reason for the change.
Require approval for uncertain or conflicting information. Skip unchanged records and prevent repeated updates.
Write permitted changes to [CRM] using authorized integration permissions.
Final reporting
Refresh the win/loss analysis after approved updates are completed, so verified competitor information is reflected in the final results.
Generate a report with competitive performance metrics, opportunities analyzed, fields updated, unresolved data gaps, and records requiring review.
Record execution results, approvals, skipped updates, and errors in the run history.
Show me the reporting calculations, validation rules, proposed updates, and CRM write permissions before enabling write-back.
How the workflow runs
01. Select the template and configure your CRM
Open the Win/Loss Analysis & Safe CRM Write-Back template in Ballet.
Connect HubSpot or Salesforce and select the opportunity data you want to analyze.
Specify your reporting period, competitor field, deal amount, and relevant segments. Define which CRM sources can be used to verify competitor information and which fields the workflow is authorized to update.
For opportunities involving multiple competitors, establish whether your reporting should use a primary competitor or another documented classification.
02. Analyze win/loss performance by competitor
Ballet retrieves closed-won and closed-lost opportunities and calculates competitive performance using your selected fields.
The analysis can include:
- Win rate: The percentage of classified, closed opportunities won against each competitor
- Opportunity volume: The number of wins and losses associated with each competitor
- Deal value: The total value of won and lost opportunities
- Segment trends: Performance differences by industry, company size, region, or product
For example, the report might show that your team wins a higher percentage of mid-market opportunities against one competitor but performs less strongly in enterprise deals.
These patterns help identify where further competitive research may be valuable.
03. Identify gaps in competitor data
The template reviews opportunities with missing competitor values and checks the approved sources you’ve specified.
For example, a closed-lost opportunity might have an empty competitor field while its sales notes explicitly state that the customer selected Competitor X.
Ballet can use that evidence to propose an update to the opportunity’s competitor field.
If the notes mention several competitors without identifying the relevant one, the record remains unresolved rather than being assigned an unsupported value.
04. Validate and approve CRM changes
Before making updates, Ballet checks that each proposed value is supported by the source information and mapped to the correct opportunity.
Your team can review a preview of the changes, including the records affected and the evidence behind each proposed value.
Updates that meet your configured rules can proceed. Conflicting or uncertain changes are held for approval, helping protect existing CRM data.
05. Update the CRM and finalize reporting
Ballet writes permitted changes through the configured CRM integration and records the execution results.
The template can then refresh the win/loss report using the updated opportunity data.
Your team receives competitive performance findings alongside a summary of completed updates, unresolved records, and any errors that need attention.
What your team gets
For Marketing Ops
Consistent competitive reporting and a structured process for identifying and correcting CRM data gaps, reducing manual reconciliation.
For Marketing
Visibility into competitive performance across target segments to inform campaign targeting, messaging, and market priorities.
For Product Marketing
Evidence-based competitive trends to inform positioning, differentiation, battlecards, and sales enablement.
For Sales
Greater visibility into competitive outcomes and more complete opportunity records to support deal planning and competitive strategy.
For Revenue Operations
Better oversight of competitor field consistency, authorized CRM updates, and approval history.
Customize the template for your team.
Start with the opportunity fields and competitor definitions your team already uses.
Choose the segments you want to analyze, then identify which CRM sources can reliably support missing competitor values.
Run the analysis and review proposed updates before enabling CRM write-back. Once you’re confident in the results, define which changes can proceed automatically and which should require approval.
You can also configure recurring runs to refresh competitive reporting as new opportunities close.
