Getting specific stages from all deals

[Diego_Lutckmeier]

I would like to get when did happen the stage 3 and 6 from all the deals. I don’t know if it’s possible.
I will analyse how many deals passed from stage 3 to stage 6.

Just an example of information:
deal_id: 1
stage_id: 3
stage_id_3_datetime: 15/08/2018

Case1
deal_id: 1
stage_id: 6
stage_id_6_datetime: 27/08/2018
or
Case2
deal_id: 1
stage_id: 6
stage_id_6_datetime: null

Result:
Case1 = 100%
Case2 = 0%

Best regards,
Diego S. Lutckmeier

[David]

Hey Diego,

Just in case I don’t fully understand you - could I have you check out this thread? It might be what you’re trying to achieve:

Stage Movement Details

Question asked through support Is that possible to get details about when a Deal has been moved to from which stage to which stage, with a timestamp? Right now I’m seeing in Deals updates there’s something like that, but unfortunately it’s full text, so I can’t get the id of the stage. Right now for the first time I’m trying to get all the deals, and fetch their stage information, including the information they are deleted or not. Then creating a webhook about any stage updates, so there I’m t…

[Diego_Lutckmeier]

Thanks for the reply! I thing I got the idea

I would like to get the information from Test endpoint, but I think it’s not possible to get all the historical from all deals from there. Algo because of the 500 deals limit.

Thank you,
Diego S. Lutckmeier