Currently, HubSpot does not support calculating the average number of deals in custom reports. While we can report on total deal counts, there’s no built-in functionality to calculate averages directly within the reporting tool.
This functionality would be incredibly valuable for sales and operations teams looking to analyze performance trends over time, such as:
- Average number of deals per rep
- Average deals per pipeline stage
- Average deals closed per month/quarter
At the moment, the only workaround is to export the data and perform these calculations manually in a third-party tool like Excel or Google Sheets. This adds extra steps and reduces the efficiency of reporting workflows.
Proposed Solution:
Add support for average calculations (e.g., average deal count, average revenue per deal, etc.) directly within HubSpot’s custom report builder. This could be implemented as a new metric option alongside sum, count, and median.
Why This Matters:
- Saves time by eliminating the need for external tools
- Enables more accurate and real-time performance tracking
- Empowers teams to make data-driven decisions directly within HubSpot
I believe this feature would benefit many users, and I encourage others to upvote if they’d find it helpful too!