topic Re: Calculating Customer Lifetime Value Based on Deals in Tips, Tricks & Best Practices

Calculating Customer Lifetime Value Based on Deals

level-ground — Fri, 21 Mar 2025 14:47:43 GMT

I created a custom property for the Company object named Customer Lifetime Value. I want to automatically calculate the value of this property based on the sum of all associated deals.

ChatGPT suggested creating a workflow that updates the value every time a deal is marked as Closed Won, but I also want to apply this retroactively — not just for deals moving forward. What’s the best way to achieve this? Any tips, tricks or best practices?

Many thanks!

Re: Calculating Customer Lifetime Value Based on Deals

karstenkoehler — Fri, 21 Mar 2025 14:50:05 GMT

Hi @level-ground,

A nice example of generative AI giving misleading advice 😄

This can be achieved easily (and retroactively) using a roll-up property: https://knowledge.hubspot.com/properties/create-calculation-properties

Let me know if you have any follow-up questions!

Re: Calculating Customer Lifetime Value Based on Deals

edemjack72 — Sun, 23 Mar 2025 22:21:43 GMT

A workflow is a great start, but for retroactive calculations, a custom script or scheduled automation might work better. You could use a CRM report or Magistv Apk API call to sum past deals and update the property in bulk. Have you checked if your CRM allows batch updates.

Re: Calculating Customer Lifetime Value Based on Deals

level-ground — Mon, 24 Mar 2025 14:03:44 GMT

This was super helpful! I was able to calculate Lifetime Value based on past deals. For some reason, it's giving me a higher amount than the total sum of invoices. I'll keep working on it and report back 🙂