topic Get total value of all deals in pipeline by stage in APIs & Integrations

Get total value of all deals in pipeline by stage

brian929394 — Wed, 02 Apr 2025 18:35:28 GMT

Hi, Can I get the total value of all deals in the pipeline by stage? And/or forecast totals? I have a nice forecast chart in my hubspot, but I just want to retrieve those values by API.

Thanks!

Re: Get total value of all deals in pipeline by stage

BérangèreL — Thu, 03 Apr 2025 09:47:14 GMT

Hi @brian929394, I hope that you are well!

Thanks for asking the HubSpot Community!

For information, I'd like to share these endpoints that might be of interest to you:

- Deals API
- Pipelines API
- Deals V1

Also, I'd love to put you in touch with our Top Experts: Hi @sylvain_tirreau, @zach_threadint and @Bortami do you have suggestions to help @brian929394, please?

Have a lovely day and thanks so much in advance for your help! ⭐
Bérangère

Re: Get total value of all deals in pipeline by stage

sylvain_tirreau — Thu, 03 Apr 2025 17:44:10 GMT

Hi,

This isn't data that's delivered ready-made by the API. You have to retrieve deal data on one side, pipeline data on the other, and then aggregate everything yourself.

Best.

Re: Get total value of all deals in pipeline by stage

sylvain_tirreau — Fri, 04 Apr 2025 10:17:03 GMT

Hi,

Take a look at this to see if you can find something that looks like what you want: https://www.linkedin.com/posts/hubspot-tips-and-tricks_hubspottipsandtricks-hubspotunderrated-reporting-ugcPost-7310582780118065153-Rtta

Best

Re: Get total value of all deals in pipeline by stage

BérangèreL — Fri, 04 Apr 2025 14:03:08 GMT

Bonjour @sylvain_tirreau, thanks a lot for going the extra mile and sharing the LinkedIn HubSpot Tips and Tricks post with @brian929394! ⭐

Thanks for all your valuable contributions, it is really appreciated and it helps many HubSpot Community Members ❤️

Bon week-end !
Bérangère