Help identifying the date a deal entered each individual deal stage.

jpearson
jpearson Member Posts: 3
Second Anniversary
edited July 2022 in Workflow Automation #1

Hello all. We have been trying to build our own external reporting system. For it to work we require to find out the date each of our deals entered each stage in our sales pipeline. PD have suggested its not possible to extract the data despite the information being stored on each individual deal and also available as a summary graph on the insights feature. The idea of having to manually go through 6000 deals seems a little much haha. Has anyone had to do anything similar and have a solution? Basically we have around 6 deal stages and we need to find the dates that each deal entered those stages so we can calculate the duration between each etc. 

Comments

  • Mike van der Valk
    Mike van der Valk Product Manager Posts: 3,240
    2500 Comments 100 Likes Third Anniversary 5 Answers
    PRODUCT MANAGER
    edited February 2022 #2

    Hi @John Pearson 

    The data is indeed available in our databases but there's unfortunately no export functionality build into Pipedrive for this. However. in case you have someone technical on your team they can use our open API to pull this information from Pipedrive and feed it into another source.

  • jpearson
    jpearson Member Posts: 3
    Second Anniversary
    edited February 2021 #3

    Hi @John Pearson 

    The data is indeed available in our databases but there's unfortunately no export functionality build into Pipedrive for this. However. in case you have someone technical on your team they can use our open API to pull this information from Pipedrive and feed it into another source.

    Thanks Mike, I will check this out. 

  • Kenny Cloft
    Kenny Cloft Member Posts: 2
    First Anniversary First Comment

    Can you recommend a Pipedrive consultant who can build this data extraction via API for us?

  • Francisca Barroso
    Francisca Barroso Member Posts: 5
    Photogenic First Comment

    I have the same problem. Did Pipedrive already find a solution for this? Calculating the sales duration cycle per stage should be a key feature of a Sales customer relationship management tool..

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,363
    1000 Comments Third Anniversary 100 Likes 5 Answers
    CONSULTANT

    You could set this up using custom fields and Pipedrive automation.

  • Kenny Cloft
    Kenny Cloft Member Posts: 2
    First Anniversary First Comment

    That is what we did. We created fields like "Date entered Ready to Invoice" and then used automations to populate the date that the deal entered the stage into that field.

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,363
    1000 Comments Third Anniversary 100 Likes 5 Answers
    CONSULTANT

    Glad to know it works. :) @Kenny Cloft