Skip to content

Reports

Reports turn the calls, meetings, leads and deals in Gabriel into numbers you can act on. Each report answers one question, and nothing runs until you open it.

Open Reports from the Reporting group in the sidebar. The page lists every report by category; click a card to run it.

Category Report What it answers
Activity Calling How many dials, conversations and first meetings the team produced, and where calls are lost
Revenue MSP revenue How much recurring revenue (MRR and ACV) and one-time revenue you’ve won and have in the pipeline, kept apart
Revenue Pipeline & forecast What you expect to close and when, by month, stage and forecast category, with recurring and one-time value apart and a probability-weighted total
Revenue Pipeline created vs closed Whether you are adding pipeline faster than you close or lose it, by week, month or quarter, by owner and by source
Revenue Bookings by revenue type What was sold each week, month or quarter, with MRR, ACV, one-time fees and total value apart, new business against expansion, by owner, source and deal type
Pipeline health Stale and at-risk deals Which open deals need attention now: nobody has touched them, they’re past their close date, or they’ve sat too long in one stage
Leads & conversion Lead funnel Where your leads sit, which sources convert, and what converted leads turned into
Leads & conversion Win/loss How often you win, by month, owner and source, and why you lose, with the loss note behind every lost deal
Leads & conversion Sales cycle & velocity How long won deals take from creation to close, how long they spend in each stage, and how much revenue the pipeline produces per day
Leads & conversion Stage conversion Where deals drop out of a pipeline: how many created in the period reached each stage and were won, and what happened to the deals that entered each stage

Each report has its own page. Click Reports in the trail at the top of a report to come back to the list.

The Reports page listing each report with a short description.

Every report shows the records your role can see, the same records your lists show you. Your admin sets this under Settings > Roles & Permissions (see Roles and permissions):

  • Calling follows how far your role can see Contacts. If your role sees all contacts, the report covers the whole team and you can narrow it to one rep. Otherwise it shows only your own calls and the meetings you booked.
  • Lead funnel follows your Leads reach.
  • MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Stale and at-risk deals, Win/loss, Sales cycle & velocity and Stage conversion follow your Opportunities view reach.

On Lead funnel, MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Stale and at-risk deals, Win/loss, Sales cycle & velocity and Stage conversion, a role that reaches its team’s or everyone’s records also gets an owner filter, to narrow the report to one person. It never widens what you see: picking a person shows only their records that your role already reaches.

Two people can open the same report and see different totals. That’s expected when their roles reach different records.

Filter Lead funnel, MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Win/loss, Sales cycle & velocity and Stage conversion

Section titled “Filter Lead funnel, MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Win/loss, Sales cycle & velocity and Stage conversion”

These reports have the same row of filters above their numbers:

  • The period: This month, Last month, This quarter, Last quarter, This year, Last 12 months, All time, or Custom range with a from and a to date. A report opens on This quarter.
  • The owner: Everyone (or My team), or one person. People who have left are listed last, marked (inactive), so you can still pick out their records.
  • The pipeline (MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Win/loss, Sales cycle & velocity and Stage conversion, when you have more than one): All pipelines or one pipeline. Stage conversion reads one pipeline at a time, so there it picks which; with none picked it reads your default.
  • The source: All sources or one lead source.

Sales cycle & velocity also has a deal type below the row, All, Recurring or Fixed, so recurring contracts and fixed projects can be measured apart. Pipeline created vs closed has a grain below the row, Week, Month or Quarter, which sets what each row of its first table is. Bookings by revenue type has all three below the row, the grain, the deal type and a business kind, All, New business or Expansion.

Your filters are kept in the page address. Bookmark a filtered report, or paste its address to a colleague, and it opens with the same filters. They still see only the records their own role reaches.

Stale and at-risk deals has the owner, pipeline and source filters but no period: it shows what is true of your open deals today. In place of a period it has two thresholds, Idle for and In stage for, in days. See the report’s article.

Click a number on any report to open the records behind it: calls and meetings on Calling, deals on MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Stale and at-risk deals, Win/loss, Sales cycle & velocity and Stage conversion, leads and deals on Lead funnel. The list opens with the report’s filters, so its total matches the number you clicked. Click a row to open the record, or the report’s name in the trail at the top to go back to the report with your filters in place. A list of lost deals also shows each deal’s loss reason and note.

Reports and these lists can’t be exported. To export, open the list the records come from (Leads, Contacts or Opportunities) and export from there, if your role has export permission.

  • Every number is counted live when you open the report. There’s no overnight delay.
  • Calling has its own date range and grouping controls. Lead funnel, MSP revenue, Pipeline & forecast, Pipeline created vs closed, Bookings by revenue type, Win/loss, Sales cycle & velocity and Stage conversion share the period filter and open on This quarter.
  • A period is 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, so deals expected to close later in it are included. Last 12 months ends today.
  • Each report dates its records its own way: MSP revenue, Bookings by revenue type, Win/loss and Sales cycle & velocity by a deal’s close date, Pipeline & forecast by an open deal’s expected close date, Pipeline created vs closed by the day a deal was created against the day it closed, Lead funnel by the day a lead was created, Stage conversion by the day a deal was created (its funnel) or moved into a stage (its outcomes). Each report’s article has the detail.
  • Stale and at-risk deals has no period. It reads each open deal’s last touch, stage and expected close date as they are now, against thresholds you can change on the page. Idle defaults to Settings > Stalled deals, so it agrees with the dashboard.
  • A deal counts as won or lost by its stage’s Outcome (Won, Lost or Open), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. See Pipeline and stages.
  • Managers: open Calling weekly and the others monthly. Calling compares each range with the period before it, so a weekly look catches a slipping rep early. Lead funnel and MSP revenue move more slowly; set the period to Last month for a monthly review. The Calling report has a weekly coaching routine.
  • Reps: start the day on Stale and at-risk deals. It is the one report that is a to-do list. Work it top down, longest idle first.
  • Bookmark the views you review. The filters live in the page address, so a bookmark of MSP revenue on This quarter for one pipeline opens that view every time, with the dates moving on as the quarter changes.
  • Review MSP revenue monthly and plan on Weighted pipeline MRR. The open pipeline total assumes every deal closes. The weighted figure scales each deal by its win probability, so it’s only as good as the probabilities on your stages. Set them from your real close rates.
  • Read Conversion by Source before you spend on a channel. A source with many leads and a low rate is costing reps time. Merge duplicates in Picklists, because the report groups leads by source name.
  • Read the loss notes on Win/loss monthly. The reason table says what kind of loss you have; the notes behind each lost deal say what to change. Open Lost on the report and read them in one sitting.
  • Watch the slow stage on Sales cycle & velocity. The stage where won deals spent the most days is where the pipeline waits. Read the median beside the average, and compare recurring and fixed deals apart.
  • Watch the net on Pipeline created vs closed. A net below zero for two or three months in a row means more is closing or being lost than is being added, and the quarter after next will be thin. Set the grain to Week during a prospecting push to see whether it is landing.
  • Read Bookings by revenue type by month for the recurring base. MRR sold is what was added to the base each month; the new business share says whether the base is growing or only being farmed.
  • Start Stage conversion at the biggest drop-off. It names the step that loses the most deals; open the deals that reached the stage before it and read why they went no further.
  • Make sure reps mark meetings as held or no-show. Gabriel marks a past meeting as held on its own only for a Zoom meeting someone outside the host’s team joined, so FTAs held and the show rate undercount until someone updates the others.
  • Admins: give managers the reach they report on. A manager whose role sees only their own or their team’s contacts gets a Calling report of their own calls only. For team-wide calling numbers, their role needs All on Contacts.

A manager sees only their own calls on the Calling report. Their role’s Contacts reach is Own or Team. The team-wide view and the rep picker need All.

A rate shows a dash instead of a percentage. Fewer than 10 dials are behind it, too few for the rate to mean anything.

Won deals are missing from MSP revenue. The deal’s stage needs the Won outcome. A stage named “Closed Won” with the Open outcome counts as open pipeline. Also check the period: a deal counts as won in the period it closed in, so a deal won last quarter isn’t under This quarter.

A report shows less than you expect. It opens on This quarter. Set the period to All time to see everything your role reaches.