Aug 30, 2018 9:53 PM
The HubSpot field "total revenue" on the company record totals all the "amounts" from all closed won deals at that company. We need that, but it's not accurate if a contract has expired. We created a contract end date field on the deal record and would like to be able to subtract that amount once the contract expires.
This is important for any company that sells multiple times (eg, multiple SKUs) into one company.
This is also important for calculating Churn values which currently isn't possible in HubSpot.
Aug 30, 2018 11:03 PM
Help other HubSpot searchers find this post quickly by accepting this solution today.
Excellent suggestions. You may wish to add to a new or existing thread in HubSpot Ideas.
You'll typically get much more traction from the HubSpot Community AND the Ideas Forum is where HubSpot Product Teams monitor suggestions for popularity -- i.e., VOTES! 🙂
Does that help answer your question? If so, remember to accept this solution today so other searchers will find it fast.
Sep 2, 2018 7:22 PM
I'd like to understand the business case a little more.
Do I have this right?
Sep 5, 2018 9:31 PM
Hi @robsobers, thanks for the reply.
Actually the case is the following:
1. Close deal for $1,000 at Company X for SKU 123 with contract end date in September 2018 (Total revenue = $1,000)
2. Close deal for $2,000 at the same Company X for SKU 456 with contract end date in April 2019 (Total revenue = $3,000)
3. Company X does not renew deal #1 for SKU 123
4. HubSpot "total revenue" field decreases from $3,000 -> $2,000, subtracting the SKU revenue they are no longer subscribed to
Hope this helps clarify.
Sep 7, 2018 10:08 AM
I think maintaining a separate custom property called "Total Current Revenue" is smart. It obviously won't update automatically based on deal values like the built-in "Total Revenue" field does.
It sounds like you need to sum up all Deals for a Contact where "Expired = False" and that's your Total Current Revenue value. I can't think of a good way to do this without using the API.
Sep 7, 2018 12:17 PM
Last ditch attempt:
I've done a bunch of Deal automations like this in Zapier before with HubSpot.
Sep 7, 2018 2:31 PM
@robsobers thanks a ton for that idea. We are implementing and integrating ChurnZero right now and hoping it will do that math for us. Otherwise I'll come back to this Zapier idea and may ping you if I have trouble setting it up.