)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Traditional Salesforce reports force you to create separate views for won and lost deals, making side-by-side win/loss analysis nearly impossible. You need both deal outcomes visible simultaneously with real-time updates when deals close.
Here’s how to create a dynamic win/loss dashboard that displays both Closed Won and Closed Lost opportunities side-by-side with automatic updates the moment deals close in Salesforce.
Create side-by-side win/loss analysis with live updates using Coefficient
Coefficient enables simultaneous display of different opportunity subsets using multiple SALESFORCE_SEARCH formulas. This creates a dynamic win/loss analysis dashboard that’s impossible with traditional Salesforce exports, updating automatically when deals close without manual refresh.
How to make it work
Step 1. Set up the Closed Won opportunities column.
In column A, enter:. This pulls all won deals sorted by most recent close date first, updating automatically when new deals close.
Step 2. Create the Closed Lost opportunities column.
In column G, enter:. Include loss reason fields to analyze why deals didn’t close, with results appearing side-by-side with won deals.
Step 3. Add time-based filtering for rolling analysis.
Modify both formulas with date ranges:. This shows only deals closed in the last 30 days, creating a rolling win/loss comparison.
Step 4. Create rep-specific win/loss views.
Add owner filtering to both formulas:. Put a sales rep dropdown in cell A1 to analyze individual performance with both wins and losses visible simultaneously.
Get real-time win/loss visibility without separate reports
This approach transforms static win/loss reports into interactive, always-current analysis tools that update the moment deals close in Salesforce. Build your live win/loss dashboard and eliminate manual report creation.
