CRM

Kjones11
メンバー

Total Value of Deals amount on Company Field

Hi There, 

We have multiple deals (upsells after initial deal) that are associated with our account.  How would I go about showing total amount of all closed- won deals on the company level, so we can quickly see the total amount of ARR that a company is paying us? Thank you! 

0 いいね!
7件の返信
MScaramastra
投稿者

Total Value of Deals amount on Company Field

Yes, also looking for this data point in a table. IE, total of deals in hubspot associated with given company

0 いいね!
zachh
投稿者 | Platinum Partner
投稿者 | Platinum Partner

Total Value of Deals amount on Company Field

Hi @Kjones11,

 

(Edited below)

 

For this, I would create a custom report using Companies and Deals as the data source.

 

You can start by adding Deal stage is All Closed Won as the filter:

zachh_0-1694608643849.png

 

Then, for the columns, you can add Record ID or Company Name to the leftmost column, and Total Revenue as the second column. I prefer Record ID, as it links to the company record directly so I can click into it.

zachh_1-1694608694359.png

 

Note that it does throw up an error that there may be inaccuracies when Deals is set as a data source in combination with Companies. I'm not sure what specific inaccuracies may show up, but the numbers I see on my report are correct; it just might be something to keep an eye on.

 

<EDIT>

I missed the note about ARR, but you can set the Deal Amount to be calculated as ARR in your portal's Settings:

zachh_0-1694609478968.png

 

You can use the Annual Revenue field instead of Total Revenue field in the report, as well. It may help to add a filter for Deals with a Close Date within the last year, depending on how your deals are set up.

 

- Zach

 

Kjones11
メンバー

Total Value of Deals amount on Company Field

Hi Zach! 

Thank you for the quick response! However, I am looking to add this Value as a field to the company account.  If that makes sense.  So when I go to a company account in Hubspot I can clearly see on the right hand side under company properities "Total Deal Amount".  Does that make sense? I am sorry for not being very clear 🙂 

Thanks Zach! 

0 いいね!
zachh
投稿者 | Platinum Partner
投稿者 | Platinum Partner

Total Value of Deals amount on Company Field

Hi @Kjones11,

 

Fortunately, Companies have default Hubspot properties to track this:

zachh_0-1694609764609.png

 

You can add this property to the left panel so that it's visible at a glance when you're looking at company records:

https://knowledge.hubspot.com/crm-setup/customize-record-sidebars

 

I hope this works for your needs!

 

- Zach

AliceMenhennet
メンバー

Total Value of Deals amount on Company Field

Hey Zach - that isn't quite right; the Company property 'annual revenue' is Hubspot's estimate of the annual revenue of that company, based on Hubspot Insights. It is not the annual revenue in terms of contract value.

 

Hope that helps!

0 いいね!
Kjones11
メンバー

Total Value of Deals amount on Company Field

Hi Zach!

Thank you again for your help, that field for some reason doesn't give us the correct value.   However Total Revenue does... But Total revenue doesn't take in to consideration Autorenewals...so it doesn't track the LTV of the account.  Just total deal size.  which is what I wanted.  I just assumed total revenue would be LTV for some reason.  

Do you know which Field would give you Life Time Value of the customer then?  

 

Thank you Zach! 

AliceMenhennet
メンバー

Total Value of Deals amount on Company Field

Hey - did you ever find a solution for this? I'm also looking for a way to roll-up the total value of all deals associated with a company into one Company property.