topic Re: Cumulative time spent in a stage seems wrong in APIs & Integrations

Cumulative time spent in a stage seems wrong

ArnaudStephan — Mon, 17 Feb 2025 10:37:31 GMT

Hello,

I am using the deals API to get the cumulative time spent by my deals in each stage of our pipeline. However, the time is different between what the API returns and what I see in Hubspot.

For instance, using the API I see that this specific deal has spent 429882213 seconds in this stage. This amounts to 4975 days.

However, when looking up the deal directly in Hubspot I see that it has spent 21 days in this stage.

Am I using the API incorrectly ? How do I get the correct value ?

Re: Cumulative time spent in a stage seems wrong

BérangèreL — Mon, 17 Feb 2025 16:55:15 GMT

Hi @ArnaudStephan, I hope that you are keeping well!

Thanks for asking the HubSpot Community!

I'd like to share these similar threads that might be of interest, even though they are not via API ; but via the user interface:

- Use deal and lead stage calculated properties
- The solutions from @LRehn and @karstenkoehler on this post "Create "time in deal stage" report"
- The solution from @karstenkoehler on this post "Calculating cumulative time in deal stages?"
- The solution from @karstenkoehler on this post "Deal Stages report on time spent in each deal stage"
- The solution from @karstenkoehler on this post "Average time per deal stage (open deals)"

Also, I'd love to ask out Top Experts: Hi @Bortami, @Teun and @HubSpot_Corey do you have suggestions to help @ArnaudStephan, please?

Have a lovely day and thanks so much! ❤️

Best,
Bérangère

Re: Cumulative time spent in a stage seems wrong

Bortami — Mon, 17 Feb 2025 17:25:42 GMT

The API returns the time in milliseconds. 429882213 is 4.975 Days.

Next steps for troubleshooting should be:

compare what the API is returning to the property value on the deal and not on this UI card. There could be additional logic behind what is displayed on that card.
validate the internal id of the pipeline stage is the correct id.

Here is how the time is calculated on the properties: https://knowledge.hubspot.com/properties/stage-calculated-properties

Here is how the time is calculated on the card: https://knowledge.hubspot.com/records/use-cards-on-records#stage-tracker

Re: Cumulative time spent in a stage seems wrong

ArnaudStephan — Mon, 17 Feb 2025 18:48:30 GMT

Thanks ! The proprerty description should maybe be updated then, but that's another topic !

I will check out the documentation to understand why the app shows 21 days and the API gives 5.

Re: Cumulative time spent in a stage seems wrong

GRajput — Mon, 24 Feb 2025 14:31:24 GMT

Hi @ArnaudStephan

I think that the return value is not in seconds because 21 days is equal to 1,814,400 seconds.
So could you please check the unit of the returned value?

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!