The same win rate and pipeline number every week, in the review and on the board slide
Your CRM has a report builder, and you still end up in a spreadsheet every Monday: the question needs two objects, a date range the builder will not express, or a definition of "won" someone changed last quarter. Quiriz connects HubSpot or Salesforce read-only, stores each definition once, and delivers win rate by rep, weighted pipeline and the quarterly deck from the same numbers.
Pipeline numbers rarely drift because the data is bad. They drift because "win rate" means three things to four people, and whichever spreadsheet is open decides which one you get this week. Quiriz fixes the definition once and uses it everywhere you report.
What you get
- One win rate, everywhere. When HubSpot or Salesforce connects, Quiriz adds the pipeline definitions to Company Context. The Excel cell, the Slides chart, the Word memo and the Slack thread all use them. An admin can edit a definition, and the daily refresh never overwrites an edit.
- The weekly review is a refresh, not a rebuild. The rep table is a formula. The quarterly deck is built once and refreshed with Refresh all next quarter.
- Read-only. Both connectors read your CRM and never write to it. Data refreshes once a day.
- Reps check their own numbers at no extra cost. Team members use the admin's keys in the add-ins and the admin's Slack binding. There is no per-seat fee for people who only ask questions.
- It says what it cannot answer. Quiriz will not call weighted pipeline a forecast. See what it will not do.
How it works for a sales team
- Connect. Connect HubSpot or Salesforce (Beta), or upload a deal export from any CRM. Connectors are included on Plus, Pro and Max.
- Quiriz sets up the datasets and definitions. Deals or opportunities, stage history, a daily pipeline snapshot and the metrics below arrive in Company Context. Your admin reviews and edits them.
- Ask where you already work. A formula in Excel or Sheets, a Figure in Word, a deck in PowerPoint or Slides, or a question in Slack.
- Deliver. A rep table for Monday, a memo with live figures, a pipeline review deck with editable charts.
- Keep it current. Data refreshes daily. Recalculate the sheet, refresh the memo, or press Refresh all in the deck.
The pipeline metrics come pre-defined
These are the names Quiriz stores when you connect. Each is a stored definition with its assumption written down, because the assumption is where these numbers go wrong. The full list per connector is on the HubSpot and Salesforce reference pages.
| Metric | HubSpot / Salesforce name | The assumption behind it |
|---|---|---|
| Win rate | Win rate / Salesforce win rate | Won deals divided by closed deals. Counts deals, not value. Still-open deals are excluded. |
| Closed-won revenue | Closed-won revenue / Salesforce closed won revenue | Sum of won deal amounts. Won comes from the CRM's own won flag, never from a stage name, because custom pipelines name stages anything. |
| Open pipeline | Pipeline value / Salesforce pipeline value | Unweighted: every open deal at full amount, whatever its stage. |
| Weighted pipeline | Weighted pipeline / Salesforce weighted pipeline | Amount times your CRM's own stage probability. It is not a commit or a plan, and it moves whenever a deal changes stage. |
| Average deal size | Average deal size / Salesforce average deal size | The average won deal. |
| Sales cycle | Sales cycle (days) / Salesforce sales cycle days | Days to close, won deals only. A deal open for a year contributes nothing until it closes. |
| Lost deals | Lost deals / Salesforce lost deals | Closed and not won. |
| Days in stage | Average days in stage / Salesforce average days in stage | From stage history. |
HubSpot also adds Closed-won ARR and Deals entering stage. Salesforce adds Salesforce stalled deals (open, more than 30 days since the last stage change), lead conversion and days to convert, and Salesforce campaign cost per won deal.
Win rate here answers "of the deals we finished, how many did we win", not "how much of our pipeline converted". Quiriz states which one it computed and computes it the same way every time. Illustrative: rep A closed 20 deals and won 12, so 60%. Rep B closed 22 and won 6, so 27.3%. The team closed 42 and won 18, so 42.9%. Averaging the two reps' rates would give 43.6%, which is why the definition is stored once.
Win rate by rep, source, stage and more
Every metric above breaks down by the columns your CRM holds, over any window you name:
- Deal owner, and owner team or region where your owners data carries them
- Stage, so open pipeline splits the way your reps see it
- Lead source: win rate by channel, computed the same way each time it is argued about
- Loss reason, with deals that have none in their own bucket rather than dropped
- Deal type: new business, renewal, expansion, as your CRM classifies them
The weekly pipeline review
The same four questions, every Monday. With HubSpot or Salesforce connected, each is a formula you recalculate instead of a pivot you rebuild.
| Ask | What comes back |
|---|---|
| Win rate by deal owner, deals closed this year | One row per rep: won deals, closed deals and the ratio. All of them, including the rep who closed least. |
| Open pipeline by stage | One row per open stage, summing to total open pipeline. |
| How much did we lose, by loss reason? | One row per reason, summing to lost value. Deals with no reason get their own bucket. |
| Win rate by lead source | One row per source. This is the one that usually starts an argument with marketing, which is the point of computing it the same way twice. |
- Excel:
=QUIRIZ.ASK("win rate, closed-won revenue and weighted pipeline by deal owner this quarter", "table")spills one row per rep. It answers against the refreshed data each time the sheet recalculates. - Google Sheets:
=QUIRIZ("open pipeline by stage", "table"). The Google spelling has no dot. - Slack: bind a channel and ask "how has open pipeline changed since last Monday?" in a thread, with the chart. Slack is included from the Plus plan. That history starts the day you connect.
Weighted pipeline, worked through. Illustrative: three open deals of $100,000 at 20%, $60,000 at 50% and $40,000 at 90% give $20,000 + $30,000 + $36,000 = $86,000 weighted, against $200,000 open. Say which of the two you are showing.
What it will not do
Two things a sales leader asks for that CRM deal data cannot answer, said here rather than discovered in the product.
- A forecast. Weighted pipeline is arithmetic on the stage probabilities your CRM already stores. A commit, a management forecast and a quota are not in a deal export, since nothing there records what anybody committed to, so Quiriz gives you the weighted figure under its own name and declines to call it a forecast.
- A person-level path from first visit to closed-won. Win rate divides deals by deals. HubSpot also adds contacts, so lead and MQL counts by source are answerable, and web traffic can come from Google Analytics 4 or PostHog beside it. Those join by date and channel in totals, not person by person, so a first-touch to closed-won rate is a channel-level estimate.
Also worth knowing: a deal with no expected close date is not counted in a close-date window, so open pipeline reads low if reps leave that field blank. The answer names what it would need rather than producing a number that looks close enough.
HubSpot or Salesforce, or an export
- HubSpot: deals, contacts, companies, deal stage history, a daily pipeline snapshot, tickets, marketing emails and campaigns, with your custom properties. Read-only, refreshed daily.
- Salesforce (Beta): leads, lead status history, opportunities, opportunity stage history, pipeline snapshots, accounts and campaigns. It needs Salesforce Enterprise edition or above, and your Salesforce admin installs the Quiriz package once. Read-only, refreshed daily.
- Any other CRM: upload a deals export. Pipedrive, Zoho, HubSpot and Salesforce exports are recognized, including their different column names for the same field. Excel, CSV, PDF and images with tables work, by upload, email or Slack.
A connected account adds what an export cannot: stage history, so average days in stage, and the daily pipeline snapshot, so "how has open pipeline changed since last Monday" works from the day you connect.
Pipeline beside ad spend, revenue and web traffic
With more than one source connected, Quiriz can answer across them, joined on a shared date or a mapping you supply. Admins can also define their own metric from metrics on different datasets, and map a Dimension, such as one lead-source column that means the same thing on both sides.
- Pipeline by source, beside ad spend. "What were win rate and closed-won revenue by lead source last quarter, and what did we spend on Google Ads and Meta Ads in the same months?" Connectors: HubSpot or Salesforce, Google Ads, Meta Ads. The join is by month and by source category. Matching a single campaign to its deals works only if campaign names match across the two systems.
- Closed-won against subscriptions. "How does HubSpot closed-won ARR compare with new MRR in Stripe each month?" Connectors: HubSpot and Stripe. The join is by month, and ARR is twelve times MRR, so the question has to state its unit.
HubSpot also joins with Google Analytics 4 for MQLs against sessions, and with QuickBooks for bookings against revenue. Cross-source figures are not on the pre-defined list above. Each answer states whether it came from a stored definition or was answered freehand, and a figure you rely on is worth defining once in Company Context. The connectors hub lists the cross-source metrics added automatically.
The quarterly board slide and the memo
The second clock is the quarterly review for the founder or the board. It starts from the same data, so it stays in step with the weekly numbers.
- The memo, in Word or Google Docs. In Word, put closed-won revenue, win rate and weighted pipeline into your sentences as live Figures and lock them so nobody types over a number. In Docs, type "open pipeline by stage" where the table belongs and press Table.
- The review deck, in PowerPoint or Google Slides. Make a deck (Beta) plans the slides first, so you edit titles and questions before it builds, and the charts are editable. Next quarter, Refresh all updates every figure and chart instead of rebuilding.
Install: Excel, Word, PowerPoint, Sheets, Docs, Slides.
Make a deck: two prompts to try
Use these in Quiriz for PowerPoint with your deals and owners datasets ticked. Each chart or table comes with takeaways written from that slide's own figures.
Pipeline review, this year against last
PowerPoint, Consulting style. Tick your deals and owners datasets.
"Pipeline review for 2026 to date against the same period of 2025. Deals won, deals lost, win rate and won revenue for both periods, win rate by deal owner for both years, lost deals by loss reason for the owner with the lowest win rate in 2026, won revenue by month, open and weighted pipeline by stage, and average deal size by deal owner. End with recommendations."
What comes back, about ten slides:
- Agenda and executive summary.
- This year against last: won, lost, win rate and won revenue, as a table.
- Win rate by deal owner, both years: a clustered bar chart.
- Why that owner lost: lost deals by loss reason, as a bar chart.
- Won revenue by month: a column chart.
- Open and weighted pipeline by stage: a table, weighted on your CRM's own stage probabilities.
- Average deal size by owner: a bar chart.
- Recommendations, written from those slides.
Rep one-to-one pack
PowerPoint, Basic style. Tick your deals and owners datasets.
"One-to-one pack for [rep name] for 2026 to date. Their deals won, lost and win rate against the team, their lost deals by reason, their open pipeline by stage, and their won revenue by month."
What comes back: a table of the rep against the team, lost deals by reason, open pipeline by stage and won revenue by month. Save it once per rep with the name changed in each question, then Refresh all before each one-to-one.
Why the number holds still
Quiriz routes the question to a stored definition that compiles to SQL, so "closed" means the same thing on the Tuesday you asked and the Thursday you presented. An admin approves a company's key questions, and their answers are cached, so the same question returns the same answer on every surface. If a definition stops compiling, for example after a renamed custom property, admins are alerted. Every answer states whether it came from those definitions or was answered freehand, so a number in a board deck traces back to the rule that produced it.
Pricing
Free is $0 for 5 files. Connectors, Slack and scheduled reports start on Plus at $12 a month ($120 a year); Pro is $30 and Max is $60 a month. You pay for the workspace and the person who builds it, not per seat asking questions. Every rep can check their own pipeline without another license. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- A weekly sales report template
- Why your win rate keeps changing: three definitions, one word, twenty points apart
- Win rate by sales rep: the breakdown, and the reps who silently vanish from it
- Weighted pipeline is not a forecast: what the figure can and cannot know
- Why is my open pipeline showing zero?: the date field, and our own four-day defect
- HubSpot to Google Sheets
- Asking an AI about your HubSpot pipeline
- Using Claude with HubSpot data
- A HubSpot attribution report, and what it can and cannot say
- A QuickBooks receivables aging report: for won deals that have not paid
- Stripe reporting: MRR and payments to set beside closed-won
- How to analyze a sales pipeline spreadsheet
- How to analyze a CRM export in Excel
- All guides →
Questions
How does Quiriz calculate win rate?
Which CRMs work?
Should I connect my CRM or upload an export?
How do I calculate win rate by rep?
=QUIRIZ.ASK("win rate by deal owner this year", "table") in Excel. You get one row per rep: won deals, closed deals and the ratio, including the rep who closed least. The rep table is a formula, so Monday's review starts from a refresh.