Company average NPS

I want to create a Company Property that is an average NPS score based on the NPS Property of every Contact associated with that Company. Please advise on the best way to accomplish this.

Hey, @AFranklin4 :waving_hand: Thanks for your question. I think your biggest limitation will be the fact that you can’t make a cross-object calculation property — “You can also create properties that calculate values based on your own criteria. Custom equations can only be set up for number properties within the same object for which you’re creating the new property” — source.

You could look at options like:

  • Webhooks and workflows
  • Custom Code Actions
  • some internal integrations like Power BI or even Google Sheets and then sync back to your portal

Best,

Jaycee

Hey @AFranklin4! Unfortunately this isn’t possible yet :disappointed_face: But you can upvote the idea! - https://community.hubspot.com/t5/HubSpot-Ideas/Ability-to-Average-NPS-Rating-by-Company/idi-p/377768