For some strange reason the subject of Weighted Revenue has been on my mind lately. Strange in the sense that I don\u2019t own our Opportunity Management feature and I haven\u2019t written an sales pipeline report in a while. Perhaps I\u2019m having flashbacks to an earlier stage in my career where I was passionate about such calculations.<\/p>\n
Opportunities (or Deals if you prefer) have an estimated revenue attribute. This revenue estimation is usually derived be one of two methods: a sum of products to be sold or a guess by the salesperson as to the total deal value. This revenue estimation is then \u2018weighted\u2019 based on the success chance of that deal.<\/p>\n
Now this is where things can turn a little crazy. Most companies weight the revenue based on the opportunity success %. For example, if you have an opportunity with $150K estimated revenue and a 50% success chance then the weighted revenue will be $75K. This weighted revenue amount for each opportunity is then aggregated by the estimated close date (or estimated payment date). This aggregation is supposed to estimate the amount of revenue which a company will revenue in that timeframe. This approach is what I call \u2018simplistic weighting\u2019.<\/p>\n
Consider some<\/i> of the flaws of this approach:<\/p>\n Improving your weighted revenue calculations is critical to understanding the short to medium term performance of your sales team. It\u2019s important to never<\/b> use weighted revenue as a performance incentive. You need the flexibility to change your revenue weighting at any time. You should also consider running multiple weighting models in parallel.<\/p>\n You should try and test your revenue weighting model on a regular basis. How accurate was it in predicting the actual revenue which flowed in? Which salespeople did it accurately predict? What were the characteristics of their specific pipelines? What are the effects of a great marketing campaign on your pipeline?<\/p>\n Having a good revenue weighting model is key to having a deep understanding of your companies \u2018sales dynamic\u2019. A CRM system has many function (improving customer relationships, increasing sales productivity etc) \u2013 but it also must tell you one fundamental data point: How much money are we going to bring in next week\/month\/quarter\/year?<\/p>\n Remember: [Estimated Revenue] * [Close %] just isn\u2019t good enough!<\/p>\n","protected":false},"excerpt":{"rendered":" For some strange reason the subject of Weighted Revenue has been on my mind lately. Strange in the sense that I don\u2019t own our Opportunity Management feature and I haven\u2019t written an sales pipeline report in a while. Perhaps I\u2019m having flashbacks to an earlier stage in my career where I was passionate about such<\/p>\n","protected":false},"author":4391,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[4690],"topic":[],"audience-type":[],"audience":[],"ms-author":[],"coauthors":[2650],"class_list":["post-14315","post","type-post","status-publish","format-standard","hentry","content-type-news-and-product-updates","review-flag-1593580425-950","review-flag-1593580768-560","review-flag-never-1593580311-709"],"yoast_head":"\n\n