Soon in Insights: Product revenue forecast report
To better support our customers who have subscription businesses, we are starting a release for a new report type called product revenue forecast report. The report will be available for companies on Advanced plan and onwards. The report can be found under Add new → Revenue forecast → Product revenue forecast.
The new report type helps project the revenue coming from one-time products, recurring products and payment schedules. This report type takes into account all deals that have products attached to them and showcases the revenue expected from the individual products according to the set product billing start date and frequency. NB! this report type does not take into account deals that have no products attached to them.
We will start the release on 16th of September and aim to finish it by mid of October.
Comments
-
Indeed, the revenue from recurring products will be reflected. With the use cases you mentioned:
- if a subscription gets cancelled before the end date of the subscription, the current workaround is to go to the specific Deal, where the subscription was attached to and modify the billing frequency accordingly. Adding a cancellation option for the subscription product is something that is hopefully soon worked on.
- if a subscription is upgraded and in order to reflect this on reporting, then it would make sense to end current subscription product with the current price and add new subscription product with the new price.0 -
Is it possible to have the Billing Start Date added to the List View? Also is there a way for the report to be run on an individual product at a time? I have tried introducing a new filter with Product Name set to a particular product however the report is still produced including all products from the deals.
0 -
Can you make it so we can look at revenue forecasts segmented by the deal? I'd like to look at anticipated revenue by month broken out by deals. Right now the work-around to do that seems to be through products, making a separate product for each deal. Currently when I create installments on products, it creates a separate segment for every single installment rather than the root product the installment applies to. The Revenue Forecast report also only segments by Won and Open.
0 -
Hello @Shane McL
My name is Hélio and I am a part of the Pipedrive support team.
Looking over your query, it is possible to have the start date in the List View within the report. These are the fields that include the start date:
As for running reports for specific products, it is not possible, yet, within these reports but I will submit this as feedback internally. My advice is that you segment the report by product and that way, you can see them separated within the graph.
Let me know if you have any other doubts :)
0 -
Hello @Nick Erickson
It is not yet possible to segment by deal, but I will submit this as feedback internally. On that point, you can segment by contact person or organization. If each deal has a unique contact person or organization, it would be the same as segmenting by deal. If that is not the case then there is also the possibility of adding a filter to your report if you wish to have something specific to the deal, if that makes sense for you.
I hope this helps! Let me know if you have any other doubts :)
1 -
Thanks for the response! Yes, that would be amazing if you made it possible to segment by deal. We have a number of cases where there are multiple deals for one organization, often with the same contact person. Right now I'm generating products, tied to specific deals, and then segmenting by Revenue Item. It feels like a work-around to get the visual I'm looking for. But that gives me forecast monthly subtotals, and then different colors per deal. Would love to have an auto calculation of the percentage of business each deal would contribute toward for the given timeframe that is forecast.
It would also be great to track variance between actuals and forecast, but perhaps that would happen elsewhere.
0