Dashboards & Reporting

Tim_dgn
Participante

Track the evolution of my estimated transactions over time

resolver

Hello everyone,

 

I'd like to use Hubspot to track and analyze the evolution of all my transactions between different periods. To give you a precise example:
- I estimate that it is possible to carry out a transaction and register it on Hubspot with an estimated turnover at a given date,
- Two months later, following my discussions with the customer, I realize that the amount of the transaction needs to change, so I change the estimate made on Hubspot.


I'd like to have a tool that lets me see the evolution between these two sales estimates (which Hubspot keeps in its history), for all my current transactions. It doesn't seem possible at the moment to build a report, as I can't find the "historical transaction amount" data.

 

Do you know of another tool that would allow me to do this? For the moment, I've only seen the forecasting tool that comes closest to what I want to do.

 

Thanks in advance for your help and input! Have a nice day!

 

I don't know if you'll have an answer but I mention you @trevordjones and @Jnix284 for your previous help, thank you again !

 

Tim

2 Solução aceitas
Jnix284
Solução
Participante de valor | Parceiro Elite
Participante de valor | Parceiro Elite

Track the evolution of my estimated transactions over time

resolver

@Tim_dgn I did a little digging into this and the historical values for the properties are only accessible via the Property History API.

 

Essentially you'd need to custom code a solution to show the values of an individual property over time.

 

The alternative is to create a complex workflow that looks at whether the value changes and stamps the previous value in an additional custom property - you'd need to have as many of those as you'd need based on how many times you think it would change, which increases the complexity of the if/then branch.

 


If my reply answered your question please mark it as a solution to make it easier for others to find.



Jennifer Nixon - Delivery Lead at Aptitude 8

connect with Jen on Linkedin

Exibir solução no post original

trevordjones
Solução
Especialista reconhecido(a) | Parceiro Diamante
Especialista reconhecido(a) | Parceiro Diamante

Track the evolution of my estimated transactions over time

resolver

Hi @Tim_dgn ,

 

Are you using Quotes?  If you did a Quote for each change in price, you could build a report in the custom reports builder that displays the amount of each quote by the quote create date, broken down by deal, like this:

 

2024-02-28 - 09_29_09 - Custom Report Builder.png

If you haven't been using quotes, I agree with @Jnix284, at least for your past data, and perhaps you should start using them going forward if this sort of history is important to you.  Just create  a new quote associated with the same deal each time you change the price.

 

I can think of a few hacks using custom properties and workflows to build a price history that you can report on, but I really think the quotes tool is your best bet.

 

- Trevor
If my post solves your problem, please accept it as a solution.

Exibir solução no post original

4 Respostas 4
trevordjones
Solução
Especialista reconhecido(a) | Parceiro Diamante
Especialista reconhecido(a) | Parceiro Diamante

Track the evolution of my estimated transactions over time

resolver

Hi @Tim_dgn ,

 

Are you using Quotes?  If you did a Quote for each change in price, you could build a report in the custom reports builder that displays the amount of each quote by the quote create date, broken down by deal, like this:

 

2024-02-28 - 09_29_09 - Custom Report Builder.png

If you haven't been using quotes, I agree with @Jnix284, at least for your past data, and perhaps you should start using them going forward if this sort of history is important to you.  Just create  a new quote associated with the same deal each time you change the price.

 

I can think of a few hacks using custom properties and workflows to build a price history that you can report on, but I really think the quotes tool is your best bet.

 

- Trevor
If my post solves your problem, please accept it as a solution.

Tim_dgn
Participante

Track the evolution of my estimated transactions over time

resolver

Thank you both for your great help! I will try it ! @trevordjones @Jnix284 

Jnix284
Participante de valor | Parceiro Elite
Participante de valor | Parceiro Elite

Track the evolution of my estimated transactions over time

resolver

Nice call on the Quotes option @trevordjones, that'd likely be the easiest/simplest route to go. 


If my reply answered your question please mark it as a solution to make it easier for others to find.



Jennifer Nixon - Delivery Lead at Aptitude 8

connect with Jen on Linkedin

Jnix284
Solução
Participante de valor | Parceiro Elite
Participante de valor | Parceiro Elite

Track the evolution of my estimated transactions over time

resolver

@Tim_dgn I did a little digging into this and the historical values for the properties are only accessible via the Property History API.

 

Essentially you'd need to custom code a solution to show the values of an individual property over time.

 

The alternative is to create a complex workflow that looks at whether the value changes and stamps the previous value in an additional custom property - you'd need to have as many of those as you'd need based on how many times you think it would change, which increases the complexity of the if/then branch.

 


If my reply answered your question please mark it as a solution to make it easier for others to find.



Jennifer Nixon - Delivery Lead at Aptitude 8

connect with Jen on Linkedin