Dashboards & Reporting

Tim_dgn
参加者

Track the evolution of my estimated transactions over time

解決

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件の承認済みベストアンサー
Jnix284
解決策
最優秀メンバー | Elite Partner
最優秀メンバー | Elite Partner

Track the evolution of my estimated transactions over time

解決

@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

元の投稿で解決策を見る

trevordjones
解決策
名誉エキスパート | Diamond Partner
名誉エキスパート | Diamond Partner

Track the evolution of my estimated transactions over time

解決

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.

元の投稿で解決策を見る

4件の返信
trevordjones
解決策
名誉エキスパート | Diamond Partner
名誉エキスパート | Diamond Partner

Track the evolution of my estimated transactions over time

解決

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
参加者

Track the evolution of my estimated transactions over time

解決

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

Jnix284
最優秀メンバー | Elite Partner
最優秀メンバー | Elite Partner

Track the evolution of my estimated transactions over time

解決

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
解決策
最優秀メンバー | Elite Partner
最優秀メンバー | Elite Partner

Track the evolution of my estimated transactions over time

解決

@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