Hi all! If you already have a Community member account and get a prompt about our new Terms, all you have to do is read and accept them and continue your login as usual. No need to create a new account, and you also won’t be asked again when you come back. Thank you for growing with us!
Deal Progress report, showing all progress between Stages in a reporting window

Is there a way to generate a report/table that has rows for each Deal, and columns for each Stage, and content data that shows the date that each Deal entered that Stage?
My company has an OKR target for the number of Deals progressing to each stage of our Pipeline during the [quarter]. Today I have to create the report manually. Pipedrive Insights only shows me the current Stage and the date that the Deal entered that Stage. To find the history of Stage entry dates I have to go through each Deal detail page manually and look through the Activities history for records of Stage changes.
So Pipedrive is already holding the data.
Comments
-
Great idea from @Damian Bown
0 -
Hi @Damian Bown
We don't have a report to show that unfortunately. We do have the data and if you have someone technical in your team you can use Pipedrive's open API to pull that information from our database. So if you have someone in the team who knows about that, it can still save you a lot of time and manual work.
0 -
Hi Mike van de Valk,
Good suggestion.
Can you advise on which deal fields in the API I should be querying to access information on the date and time of all Stage changes on my deals. I imagine it should include
Deal ID:
Date and time of Stage change:
From: Stage
To: Stagethanks
0 -
Damian Bown said:
Hi Mike van de Valk,
Good suggestion.
Can you advise on which deal fields in the API I should be querying to access information on the date and time of all Stage changes on my deals. I imagine it should include
Deal ID:
Date and time of Stage change:
From: Stage
To: Stagethanks
Hi @Damian Bown
It looks I've made a mistake
I can't find this this data in our API either
I will definitely pass this on internally so we can hopefully improve this in the future... sorry...
0 -
Is this option to report deal stage change now available in the reports?
0