HubSpot Ideas

MarcusHarte

Average number of associated services per company

Idea: 
Hi 
I am trying to report the average number of unique services that each customer has using company and the number of associated deals. Currently i cant get it to work becouse theres no way to have a property that counts unique property values. 


1.

Role: HubSpot responsible within the company 

Team: Sales team
2. Goal: To have a easy way of showing how many unique products each customer is buying. 
3. Make it posible to analyse sales KPI in a meaningfull way in HubSpot so we dont swich to a different service. 


4. Example: 

Company A. 
Company A has 5 deals with us where the deal services (products) are the following five; Paint job, Paint job, Body work, Body work, and Cleaning. 
Company B.
Company B has three deals with us where the deal services (products) are the following 3: Paint job, Body work, abd Paint Job. 

Company C. 
Company C has three deals with us where the deal services (products) are the following 3: Paint Job, Paint Job, and Paint Job. 

Company D has 2 deals with us where the deal services (products) are the following 2: Paint job, and Paint job. 
What should the report/Property show: 
Company A: Number of unique service type = 3

Company B: Number of unique service type = 2 
Company C: Number of unique service type = 1

Company 😧 Number of unique service type = 1  
Property value (average) = 1,75
Picture to show how it could look (data in report is not accurate as HubSpot doesnt have this feature): 

MarcusHarte_0-1708519964154.png

 

This property will den be used in a gage report to show if our key customers are meeting out amount of bought serviceses goal. 

0 Upvotes