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. 

0
0 votes

· Last Updated -

Comments

  • Markus Funk
    Markus Funk Posts: 120
    100 Comments Second Anniversary Name Dropper Photogenic
    edited February 2021 #2

    @Mike van der Valk 

    Great idea from @Damian Bown 

  • Mike van der Valk
    Mike van der Valk Posts: 4,290 PIPEDRIVE PRODUCT MANAGER
    2500 Comments Third Anniversary 25 Likes First Answer
    edited February 2021 #3

    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.

  • Damian Bown
    Damian Bown Posts: 4
    edited February 25 #4

    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: Stage

    thanks

  • Mike van der Valk
    Mike van der Valk Posts: 4,290 PIPEDRIVE PRODUCT MANAGER
    2500 Comments Third Anniversary 25 Likes First Answer
    edited April 2021 #5

    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: Stage

    thanks

    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...