How do you track win rates in Google Sheets?
Win rate tracking measures how many opportunities close as wins versus losses or open deals. In Google Sheets you store one row per deal with Stage, Outcome, and Close date columns, then use COUNTIFS or pivot tables to calculate win percentage by rep, product, or quarter. A clear tracker turns pipeline rows into leadership-ready close rate metrics without exporting to a CRM report.
When to use it
Use win rate tracking when sales, partnerships, or fundraising teams need a shared view of conversion by stage, rep, or segment. Sheets works well for early-stage teams and weekly reviews before a CRM owns the math.
When to skip it
Skip building win rates in Sheets when your CRM already calculates them accurately and your team never opens the spreadsheet. Duplicate math in two places drifts out of sync fast.
How it works
-
1
Create a Deals tab with one row per opportunity and columns for Stage, Outcome, Owner, and Close date.
-
2
Define won and lost values in a Settings tab so formulas reference stable labels, not free-text guesses.
-
3
Add a summary area with COUNTIFS for won deals divided by closed deals (won plus lost) per rep or month.
-
4
Use pivot tables or QUERY to slice win rate by product line, lead source, or deal size band.
-
5
Refresh outcomes when stages change; avoid counting open pipeline in the denominator unless you want forecast rates.
-
6
{Optional: "conditional formatting highlights reps below team average win rate for coaching conversations."}
Examples in Google Sheets
Sales pipeline win rate
Column E holds Won, Lost, or Open. A dashboard tab shows win rate as won count divided by closed count per rep with a QUERY grouped by Owner and month.
Partnership outreach tracker
Track intro calls that became signed partners. Win rate by channel shows which referral source converts best.
RFP response scorecard
Log bids as Won or No bid. Pivot table compares win rate by industry vertical to focus proposal effort.
Better Sheets resources
Common mistakes
-
Dividing wins by total pipeline including open deals, which deflates win rate every time you add leads.
-
Letting reps type "Won", "won", and "WIN" in different rows, breaking COUNTIFS until you normalize text.
-
Forgetting to backfill Close date on lost deals, so monthly win rate charts skip entire cohorts.
-
Mixing qualified and unqualified leads in one rate without a filter column for real opportunities.
-
Copying last quarter's tab without resetting outcomes, double-counting deals in annual rollups.
Frequently asked questions
- What is the win rate formula in Sheets?
- Typically =COUNTIFS(Outcome,"Won",Owner,A2)/COUNTIFS(Outcome,"Won",Owner,A2)+COUNTIFS(Outcome,"Lost",Owner,A2). Adjust ranges and criteria to match your column layout.
- Should open deals count in win rate?
- Standard win rate uses closed deals only. Some teams track forecast win rate separately with weighted pipeline.
- Can I track win rate by stage?
- Yes. Add a Stage column and calculate conversion from Stage A to Stage B with COUNTIFS on stage change dates.
- Win rate vs conversion rate?
- Teams use both terms loosely. Be explicit: win rate usually means won divided by closed opportunities.
- How do I visualize win rate?
- Use a bar chart by rep or a line chart by month from your summary QUERY or pivot table.
- Can win rates update from a CRM?
- Yes with IMPORTDATA, API pulls, or scheduled CSV imports into your Deals tab on a trigger.
- How often should we refresh win rates?
- Weekly for active sales teams, monthly for slow cycles. Document the refresh ritual on a README tab.
- Does conditional formatting help?
- Color cells below target win rate so managers spot coaching needs without opening every rep filter view.
Related terms
CRM in Google Sheets
Yes, for small teams a spreadsheet CRM tracks leads, deal stage, owner, next action, and notes in one shared file. Tabs separate Pipeline, Contacts, and Activity log. It works when volume is modest and everyone agrees the sheet is the system of record.
Read guide →KPI tracking
KPI tracking means choosing a small set of numbers that show whether you are winning, then updating them on a rhythm everyone trusts. In Sheets, each KPI usually has a definition, data source, target, and actual cell on a dashboard fed by formulas, not hand-typed guesses.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →trackers
A tracker is a living list you update over time: tasks, leads, inventory, habits, or bugs. Good trackers use one row per item, clear statuses, and columns that sort and filter without cleanup scripts. They often feed a dashboard tab when the team outgrows scanning raw rows.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →Done reading about win rate tracking?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.