Close Rate Report

[rboniek]

Hi everyone! 

I'm looking to create a report that shows the closing rate percentage for each sales rep. Normally it would just be a simple (deals closed/total leads) calculation, but I can't seem to find that on HubSpot. Is there a way to do this? 

Thanks in advance! 

[MrBean]

Hey guys! 

One way to show your close rate is by average forecast probabilities of closed deals. Because those of closed deals will simply be either 0% or 100%-- If you had 2 closed-won deals and 2 closed lost:

(100% + 100% + 0% + 0%) / 4  = 50%

Just be sure and only include Closed Deals (ie won/lost deals)

Hope this helps 🙂 

[kvlschaefer]

This is great! Thanks for sharing, @MrBean! 

[efellefred]

brilliant work around!

[ESparks-Visme]

why has this never been created? It's the most basic of sales reports. I just chatted with support and learned it still doesn't exist. 

Rep 1: 32%
Rep 2: 27%
Rep 3: 33%

Please Hubspot, prioritize making this report work. 

[kvlschaefer]

Hi @ESparks-Visme,

Thank you for feedback.

I would highly recommend you to please post this product suggestion at our ideas forum.

Our product team, who monitors the forum regularly, can read your specific use case and understand why this would be a useful functionality or change. It also helps other customers facing the same issue to advocate for its implementation on your behalf by upvoting on the thread as well.

Thank you,

Kristen

[ESparks-Visme]

Is there a reason why this current thread with the same concern/question won't work? It has lots of comments with people wanting the same.

[amandafann]

Thanks for the pie chart work-around @Lanny  and @rboniek! 
@Lanny question for you...when using the Funnel Report, when I filter the data range, for example by last year, I realized that this excludes Deals that were created prior to last year, even though they may have closed-won during last year. If I were creating the same report for each year, they'd be left out of the year before as well, since they didn't Close in that year. How do you handle reporting on those?

[Lanny]

Only seing this now @amandafann .

Sounds like some sort of filter issue. You have to select close date not create date in the filters. Hope that helps. Otherwise, please drop me an email l.heiz@bee.digital

[Lanny]

two (not so ideal) ways of doing this. 

1. Single Object Report (deals), filter by rep (optional), filter by deal stages "Closed won" and "closed lost", visualize as a pie chart

2. Funnel Report (Deals), all stages, filter by rep (optional) , all deals + closed won. 

Ideal? no not in the least. Especially this is such a basic sales metric and the raw data is clearly there. I still do not understand why in the most recent reporting rollout there wasn't a "custom metric" (not custom properties) option. Every basic analytics tool has that. 

I'm actually doing most of my monthly reporting that I use for management updates & decision meetings in databox. For everyday use, quick checks and for my reps it's mostly sufficient. Still frustrating knowing the power of SFDC however. 

[andrulobruzzo]

I'm on the same issue here. There should be an option to display the % of close rate . 

[hkfreem]

We also need this - the deal stage funnel does not work since so people skip steps and go to won/lost

[JonathanElkin]

My goal: Include a number (%) to show Closed Rate for an individual Sales Rep's dashboard
Workaround: Single Object report (Deals) -> Deal Owner = "Me" + Stages = 'Closed Won' and 'Closed Lost' > Visualisation as Pie Chart

[Shinojosa]

I am trying to create this same report. Any Updates?

[efellefred]

also looking for a built-in report

[jennysowyrda]

Hi @rboniek,

Can you send along what reports you have created so far? Additionally, are you working with the available reports, or do you have access to the reporting add on?

For a full list of the default sales reports, I wanted to share this resource. For creating custom reports, I wanted to share this article.

Thank you,

Jenny

[hellokyliep]

This isn't a full list. This is a page on managing dashboards. I don't quite understand why a simple close rate report is nowhere in Hubspot. It's a critical metric to understand and forecast revenue based on past activity. 

[MrBean · Accepted solution]

Ignore the shameless self promoting apps/third party in this thread. 

Can't say I know why hubspot hasn't released a default report in sales analytics or their reporting library. . . seems very critical. 

But I can say with certainty there is an elegant solution using Single Object Deal Reports.

After filtering to only won & lost deals. Taking the Average of 'Deal Stage Probablity' or 'Likelihood to close' will give you the win rate report your looking for. 

You could then visualize as bar charts, in a table, as one single percentage etc. 

[LDerderian]

Thank you! This isn't exactly what I wanted, but it really helped. @ Hubspot work on getting this as a default deal report, please.  

[hellokyliep]

I don't find this elegant. I've spent 30 minutes trying to recreate what you've described, with no luck. I'm also then unable to build on that to try to understand close rates for certain products or line items. Elegant would be clicking on a report showing Close Rate by Rep or Hubspot Owner, which seems like a very basic default report for any CRM.

[danielruby]

You can do that with third-party apps from the App Marketplace (cough cough, Demand Sage, cough cough).

Other than that, I think the easiest way to do it is probably to make a bunch of clones of the "Deal stage funnel with deal totals and conversion rates" report and filter each only for deals owned by a particular rep.

Daniel Ruby

Head of Marketing

Better HubSpot Reporting In Sheets