# The Win/Loss Analysis & Safe CRM Write-Back Playbook

> See how you perform against competitors. Keep your CRM data accurate.

Your CRM contains valuable information about which competitors appear in won and lost deals. But when that information is scattered across opportunity fields, sales notes, and descriptions, getting a reliable picture of competitive performance takes work.
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.

Teams: Marketing Ops, Product Marketing

## 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.

```text
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.

## FAQs

### What does the Win/Loss Analysis & Safe CRM Write-Back template do?

The template analyzes closed-won and closed-lost opportunities from HubSpot or Salesforce, calculates competitive performance metrics, identifies missing competitor information, and supports validated CRM updates with configurable approval rules.

### Can Ballet identify competitors mentioned in sales notes?

The template can be configured to examine accessible sales notes or opportunity descriptions for competitor information. You define which sources are approved and what evidence is required before a competitor can be assigned to an opportunity.

### What happens when an opportunity mentions multiple competitors?

The workflow can apply your primary-competitor rules when sufficient evidence exists. Otherwise, it can flag the opportunity for review instead of making an unsupported selection.

### Can Ballet update missing competitor fields automatically?

Yes, provided the template has the necessary CRM permissions and the proposed updates satisfy your validation rules. You can require human approval before changes are applied.

### Can I compare performance across different market segments?

Yes. You can analyze results by industry, region, product, company size, or other dimensions available in your CRM.

### Does the template explain why deals were won or lost?

The template identifies patterns in competitive outcomes. To analyze specific reasons behind those outcomes, you would need supporting information such as documented loss reasons, sales notes, or other approved sources.

### Will the report reflect newly verified competitor information?

You can configure the template to recalculate its metrics after approved CRM updates are completed.

### Can I track which records were updated?

Yes. Ballet provides run history and step-level execution details. You can configure the template to record affected opportunities, completed updates, approval decisions, and exceptions. CRM-native field history depends on your CRM settings and permissions.