Home / CRM
For sales ops and sales leaders on HubSpot and Salesforce

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.

Try it on a sample pipeline → No signup, no CRM admin access, nothing to install.

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

How it works for a sales team

  1. Connect. Connect HubSpot or Salesforce (Beta), or upload a deal export from any CRM. Connectors are included on Plus, Pro and Max.
  2. 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.
  3. 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.
  4. Deliver. A rep table for Monday, a memo with live figures, a pipeline review deck with editable charts.
  5. 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.

MetricHubSpot / Salesforce nameThe assumption behind it
Win rateWin rate / Salesforce win rateWon deals divided by closed deals. Counts deals, not value. Still-open deals are excluded.
Closed-won revenueClosed-won revenue / Salesforce closed won revenueSum 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 pipelinePipeline value / Salesforce pipeline valueUnweighted: every open deal at full amount, whatever its stage.
Weighted pipelineWeighted pipeline / Salesforce weighted pipelineAmount 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 sizeAverage deal size / Salesforce average deal sizeThe average won deal.
Sales cycleSales cycle (days) / Salesforce sales cycle daysDays to close, won deals only. A deal open for a year contributes nothing until it closes.
Lost dealsLost deals / Salesforce lost dealsClosed and not won.
Days in stageAverage days in stage / Salesforce average days in stageFrom 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:

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.

AskWhat comes back
Win rate by deal owner, deals closed this yearOne row per rep: won deals, closed deals and the ratio. All of them, including the rep who closed least.
Open pipeline by stageOne 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 sourceOne 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.

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.

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

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.

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.

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:

  1. Agenda and executive summary.
  2. This year against last: won, lost, win rate and won revenue, as a table.
  3. Win rate by deal owner, both years: a clustered bar chart.
  4. Why that owner lost: lost deals by loss reason, as a bar chart.
  5. Won revenue by month: a column chart.
  6. Open and weighted pipeline by stage: a table, weighted on your CRM's own stage probabilities.
  7. Average deal size by owner: a bar chart.
  8. 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.

Ask the sample pipeline → Then connect your CRM, or try your own export and check the win rate against the one you reported.

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

Questions

How does Quiriz calculate win rate?
Won deals divided by closed deals: counts, not value, with still-open deals excluded from both sides. It answers "of the deals we finished, how many did we win", not "how much of the pipeline converted". Those are different questions, and conflating them is the most common way a win rate ends up wrong.
Which CRMs work?
HubSpot and Salesforce connect directly. Both are read-only and refresh daily, and connectors are included on paid plans. Salesforce is in Beta and needs Enterprise edition or above, with your Salesforce admin installing the Quiriz package once. Any other CRM that exports deals, including Pipedrive and Zoho, works by upload.
Should I connect my CRM or upload an export?
Connect when you want numbers refreshed daily, stage history and a pipeline snapshot, or a join with ad, web or finance data. The connection is read-only. Upload when you use another CRM, or when you would rather not sign in. Both routes use the same win rate and pipeline definitions.
How do I calculate win rate by rep?
Ask for win rate by deal owner for the period you want, for example =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.
What is weighted pipeline, and is it a forecast?
Weighted pipeline is each open deal's amount times its stage probability, summed. Quiriz uses the stage probabilities your CRM already stores. It is not a forecast: a commit, a management forecast and a quota are not in deal data, so Quiriz gives you the weighted figure under its own name.
Which period does a deal count in?
Its close date. A deal created in January and closed in March counts in March. Open pipeline is as-of by nature, but the close-date window still applies, so a deal with no expected close date is not counted at all. If reps leave that field blank on open deals, open pipeline will read low.
Can Quiriz build the quarterly pipeline review or board deck?
Yes. In Quiriz for PowerPoint or Google Slides, describe the deck, such as win rate by rep this year against last and open pipeline by stage. Quiriz shows a plan of slide titles and questions to edit before it builds, with editable charts. Next quarter you press Refresh all instead of rebuilding it. Make a deck is in Beta.
Does it replace our CRM reports?
No. It answers the questions the report builder makes awkward, such as the ones needing two objects, an unusual window or a definition your CRM does not hold, without exporting to a spreadsheet and rebuilding the same pivot every month.
Do my reps need a license to see the numbers?
No. Team members use the admin's keys in the add-ins and the admin's Slack binding, so there is no per-seat fee for people who only ask questions. Plus allows 5 add-in keys, Pro 10 and Max unlimited.