How to build a lost-deal reason report in HubSpot

How do you build a lost-deal reason report in HubSpot?

Create a single-object report on deals, filter it to deals in the closed lost state within a date range, and chart the count of deals by your lost reason property. HubSpot's custom report builder handles this in a few minutes. The harder part is making sure the lost reason is captured consistently, so the chart means something.

This tutorial is for a founder or sales lead who keeps losing deals and cannot say why with any confidence. You have a sense that price comes up a lot, or that a certain competitor keeps winning, but you have never seen it in one view. A simple report fixes that, as long as the underlying data is clean.

I will cover the data setup first, then the report itself, then how to read it without fooling yourself. The report takes minutes. Getting reps to record honest reasons takes longer, and it matters more.

What data do you need before building the report?

You need a lost reason recorded on every closed lost deal, ideally as a dropdown with a short list of options. HubSpot includes a default deal property called Closed lost reason, described in its docs as the reason the deal was lost. If your team fills it in as free text, reporting gets hard.

Free text produces dozens of slightly different answers. "Price," "too expensive," "budget," and "no budget this quarter" might mean the same thing or different things. A chart of free text values is a chart of typing habits.

My recommendation is a custom dropdown property, something like Lost reason category, with six to eight clear options. Keep the default Closed lost reason field for a sentence of detail. The dropdown gives you the chart. The free text gives you the story behind each bar.

Which lost reason categories should you use?

Use categories that point to a decision you could make differently. A good starting set: price or budget, chose a competitor, chose to build it themselves, no decision or went quiet, timing, missing feature, and poor fit. Each category should suggest an owner, such as pricing, product, sales, or marketing, who could act on it.

Avoid a catch-all "other" option if you can. If you must include it, require the detail field whenever someone picks it. Otherwise "other" becomes the most popular answer, and the report tells you nothing.

Keep the list short enough that reps can choose quickly. Six to eight options covers most B2B sales motions. You can always split a category later if one grows too large to act on.

How do you make sure reps fill in the reason?

Require the field when a deal moves to Closed Lost. HubSpot's conditional stage properties let you show and require specific properties when a user manually moves a deal into a stage. Add your lost reason dropdown to the Closed Lost stage and tick Required, so the deal cannot close without it.

I wrote a full walkthrough of that setup in how to require deal fields before a stage change in HubSpot. In my view it is the single biggest improvement to lost deal data you can make.

For deals already lost before you set this up, do a one-time cleanup. Export the last two quarters of closed lost deals, read the existing notes, and fill in the dropdown by hand. It is tedious, but it gives the report history from day one.

How do you create the report step by step?

In HubSpot, go to Reporting, then Reports, and click Create report. Choose Single-object report, click Next, and select Deals as the data source. Add your lost reason property, filter to closed lost deals in your chosen date range, then open the Visualization tab and pick a bar chart. Save the report when it looks right.

In a little more detail: after choosing Deals as the data source, use the left sidebar to add properties. Add your Lost reason category property, plus Amount and Deal owner if you want them available. HubSpot lets you drag properties to reorder them and remove any you do not need.

At the top of the builder, set the filters. HubSpot lets you filter by a date property and a date range, plus more advanced filters. Use Close date as the date property, which HubSpot describes as the day the deal is expected to close or was closed. Then add an advanced filter so only deals where Is closed lost is true appear.

Finally, click the Visualization tab, choose a bar chart, and in the Configure chart section, drag your lost reason property into the Displaying section, then choose how the chart counts deals using the options the builder offers. Click Save report and add it to a sales dashboard so the team sees it regularly.

Which version of HubSpot do you need?

HubSpot's documentation lists custom single-object reports as available with Marketing Hub, Sales Hub, Service Hub, Data Hub, or Revenue Hub at the Professional or Enterprise tier. If you are on a lower tier, you may not see the custom report builder. Check your subscription before planning around this report.

HubSpot also notes limits on these reports, including a maximum of 20 metrics and 500 results for summarized table visualizations. A lost reason bar chart will sit well inside those limits, but keep them in mind if you extend it into a larger table.

If the builder is not available to you, an export to a spreadsheet each month gives you the same view with a pivot table. It is less convenient, but the insight is identical.

How do you read the report without fooling yourself?

Look at counts and deal value side by side, compare periods rather than reading one snapshot, and treat the biggest bar as a question, not a conclusion. "Price" losses often hide weak positioning or a poor fit. Read the detail notes behind the top category before deciding what it really means.

Small numbers mislead. If you lost twelve deals last quarter, a category with four of them is a hint, not a trend. Wait for enough deals before restructuring pricing or the roadmap around one bar.

Cross-check with conversations. A handful of short win-loss interviews will tell you whether reps are recording the real reason or the polite one. I covered how to run those in how to run win-loss interviews that improve B2B marketing.

What should you do with what the report shows?

Assign each top category an owner and one action. If competitor losses dominate, sales and marketing review positioning against that competitor. If "no decision" dominates, look at qualification and follow-up. If a missing feature keeps appearing, product gets a clear, sourced list. Review the report monthly and check whether actions moved the numbers.

Some lost deals are not really lost to a reason you control. Deals that stall because a champion left are a good example. I wrote about handling that case in what to do when your champion leaves mid-deal.

The report earns its keep when it changes a decision. If a quarter goes by and nothing changed because of it, revisit the categories. They may be too vague to act on.

What should you do next?

Create a lost reason dropdown with six to eight actionable options, require it at the Closed Lost stage, and backfill the last two quarters by hand. Then build the single-object deals report, filter to closed lost deals, and chart counts by reason. Add it to a dashboard and review it monthly with sales and marketing.

Within a quarter, you will know why you lose deals with far more confidence than a gut feeling allows. That knowledge feeds positioning, pricing, and product decisions directly.

If you want help setting up HubSpot reporting that your team will actually use, reach out. I build CRM systems and reporting for B2B teams, and I am happy to look at your pipeline data and suggest where to start.