Accumulated goals and forecast report

Andreas Scholz

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?

Screenshot 2024-03-01 163917.png

Reeve Lui

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

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

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

@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

I have something like so far:

Andreas Scholz

Looks promising. How did you do that?

Reeve Lui

Hi Andreas, here's the latest:

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