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!
Weitere Ideen mit folgender Beschriftung anzeigen:
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.
I am trying to achieve the same report as @rboniek. I am trying to achieve the % percentage by Sales rep. It should be a pretty simple calculation (Offers sent/deals won), but I can't seem to find any properties able to report this by Sales rep. The portal I am trying to achieve this with includes reporting add-on and Sales hub Enterprise + Marketing Hub Professional.
This seems like a pretty basic CRM feature since Close % is a key metric for tracking Sales team performance.
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.
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
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.
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?
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
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)
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.
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.
Sie müssen ein registrierter Benutzer sein, um hier einen Kommentar hinzuzufügen. Wenn Sie sich bereits registriert haben, melden Sie sich bitte an. Wenn Sie sich noch nicht registriert haben, führen Sie bitte eine Registrierung durch und melden Sie sich an.