Skip to content

Pipeline created vs closed report

The Pipeline created vs closed report answers one question: are we adding pipeline faster than we close or lose it? It counts the deals created in each week, month or quarter against the deals won and lost in it, and shows the net change between them, for the period as a whole, by owner and by source.

Go to Reports and click Pipeline created vs closed under Revenue.

The report covers the opportunities your role can view. It opens on This quarter, by month.

Use the row of filters above the numbers:

  • The period: a preset such as This quarter or Last month, All time, or Custom range with a from and a to date. A deal counts as created in the period its Created date falls in, and as won or lost in the period its Close date falls in.
  • The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities. People who have left are listed last, marked (inactive).
  • The pipeline: All pipelines or one pipeline. This filter appears when you have more than one.
  • The source: All sources or one source, matched to the deal’s Source.

Below the row, Grain sets what each row of the first table is: a Week, a Month or a Quarter. Weeks start on the day set under Settings > Company, the same day the dashboards and quotas use.

The dates the period covers are shown at the right of the filters. Your filters and the grain are kept in the page address, so a bookmark opens the same view.

Click any count or amount to open the deals it counts, with Company, Owner, Stage, MRR, One-time fees, Total value and Close date. The list’s total matches the figure you clicked. A figure with no deals behind it is plain text, and a net figure is never a link: its deals are the row’s created, won and lost deals together. Click a deal to open it, or Pipeline created vs closed in the trail at the top to go back to the report.

Figure What it is
Created The deals created in the period, in any stage, including ones that have since closed, with their Value added up. Under the amount, how many deals, and their MRR and One-time fees
Won The deals in a won stage whose close date is in the period, the same deals the Win/loss report counts as won
Lost The deals in a lost stage whose close date is in the period, as Win/loss counts them
Net change Created minus won minus lost, for the count and for each amount. Above zero, the pipeline grew; below zero, shown with a minus in red, more left the pipeline than came in

This is not a waterfall. A deal whose amount changed, or whose close date was pushed, is not shown: the report says only what was created and what closed. A deal that is created and closed in the same week, month or quarter counts in both Created and Won (or Lost), and so adds nothing to the net.

One row per bucket of the grain you chose, with buckets that have no deals kept so a quiet week is visible. Each row counts the deals created in the bucket against the deals won and lost in it, so the net column shows which weeks the pipeline grew and which it shrank.

  • Under a period, the rows are the buckets the period touches. A bucket the period starts or ends part way through is still one row, labelled by the days it covers, such as Oct 1–4, 2026 for a quarter that starts on a Thursday. A period touching more buckets than the table lists shows the latest ones, with one row Before the first of them holding the earlier part of the period, so the columns still add up to the totals. The line above the table says how many are listed. Choose a shorter period, or a larger grain, to see them apart.
  • Under All time, the rows are the current bucket and the ones before it, with a row Before them for earlier deals and a row After them for deals dated later than the current bucket. A close date can be edited, and an import can bring a creation or close date in the future, so After is where to look when the rows add up to less than the totals.

The Amount control above the tables swaps the money columns between Value, MRR and One-time, so recurring growth can be read apart from project work. The counts stay the same.

One row per owner with a deal created, won or lost in the period, most deals first. Deals with no owner are last, as Unassigned. A rep whose net is below zero quarter after quarter is closing out a pipeline nobody is refilling.

One row per source that one of those deals names, most deals first. Deals with no source are last, as No source. Compare what each source adds with what it closes.

A closed deal with no close date falls in no period and no bucket. Under every period a line below the tables says how many won and lost deals have none; click the count to open them and set their dates. Under All time they are in the Won and Lost totals and in the owner and source tables, but still in no row of the first table.

  • A deal counts as created on its Created date, the day it was added to Gabriel, whatever its stage now. A deal converted from a lead is created on the day it was converted.
  • A deal is won or lost by its stage’s Outcome (Won or Lost), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. It is dated by its Close date, which Gabriel sets to the day the deal is marked won or lost. The Win/loss report and the dashboards date won and lost deals the same way, so they agree.
  • A period and a bucket are whole days in your own time zone, or your company’s if you haven’t set one. This month, This quarter and This year run to the end of the period.
  • Amounts are shown rounded, such as $12.5K.
  • Watch the net, not the created count. A busy month of new deals means little if more value closed or was lost. Net below zero for two or three buckets in a row is the early sign of a thin quarter ahead.
  • Read it by week during a push. Month and quarter are the right grain for a review; week shows whether this week’s prospecting is landing.
  • Compare owners on net. A rep who creates little but loses less can have a healthier net than one who creates a lot and loses most of it. Open the lost deals to see why.
  • Keep close dates on closed deals. A closed deal with no date is in no bucket and no period but All time, so the quarter’s net is computed without it. Check the line below the tables and clear it.

The report says no deals were created, won or lost in this period. Nothing happened in the period with these filters. Set the period to All time and clear the other filters.

The rows add up to less than the totals. Under All time, look at the Before and After rows: deals dated earlier or later than the listed buckets are there. Under a long period, the Before row holds the earlier part of the period. Closed deals with no close date are in no row; see the line below the tables.

A deal is counted twice. It was created and closed in the same bucket, so it is in Created and in Won or Lost. That is expected, and the two cancel out in the net.

The net is below zero but we won a lot. Net is created minus won minus lost: a won deal leaves the open pipeline just as a lost one does. A quarter of closing out deals that were created earlier will read below zero. That’s the report doing its job: it’s telling you the pipeline needs refilling.