Accumulated goals and forecast report

Andreas Scholz
Andreas Scholz Member Posts: 3
First Comment First Anniversary Photogenic
edited March 1 in Sales CRM #1

In our company we have budgeted the whole year for any department and we need to achieve certain income(goals) each month to have the best cashflow and to pay our bills. Therfore I would need to see if we are on track with our sales reps by creating a accucmulated goals forecast report like the one I attached.

How do you think about that?


Answers

  • Reeve Lui
    Reeve Lui Member Posts: 41
    First Answer 5 Likes Name Dropper First Comment

    Hello,

    I regret to inform you that there is currently no direct option to create a goal report based on the attached file in Pipedrive. However, we do have a workaround available to create a goal report based on deal revenue for each month.

    If you have any questions about implementing this workaround or if there's anything else you need assistance with, please feel free to reach out. We're here to help!

  • Andreas Scholz
    Andreas Scholz Member Posts: 3
    First Comment First Anniversary Photogenic

    Dear Reeve, I know this report and I am using it as a workaround however it does not meet my requirements. This would be the above one. Any explanation why you can not do that in pipedrive?

  • Reeve Lui
    Reeve Lui Member Posts: 41
    First Answer 5 Likes Name Dropper First Comment

    Hi Andreas,

    I think this might be possible. I'm testing it out now.

    I happen to be a Pipedrive Partner and is definitely happy to help you out. Can you share with me your email address tied to the Pipedrive account?

    You can share your email address privately to me: reeve@astersense.com

  • Reeve Lui
    Reeve Lui Member Posts: 41
    First Answer 5 Likes Name Dropper First Comment

    @Andreas Scholz

    Hi Andreas,

    I got to something along this line where I basically pull the report to align with "Closed Won" status for it to reflect per month total Deal Value.


  • Reeve Lui
    Reeve Lui Member Posts: 41
    First Answer 5 Likes Name Dropper First Comment

    I have something like so far:


  • Andreas Scholz
    Andreas Scholz Member Posts: 3
    First Comment First Anniversary Photogenic

    Looks promising. How did you do that?

  • Reeve Lui
    Reeve Lui Member Posts: 41
    First Answer 5 Likes Name Dropper First Comment

    Hi Andreas, here's the latest:

    @Andreas Scholz I used Insights, Add Goal, followed by Revenue Forecast.