When I was a VP of sales, we did this report on a spreadsheet, % of likelihood X Deal Amount. The value wasn’t in the standalone number, the value was in how that number was trending.
We would track by Month, Quarter and Year.
If your quarterly forecast on the 1st day of each quarter averaged $1M and was going up 15% every quarter, and right now it’s $500K, you have a problem coming.
Particularly important when business gets soft to see just how soft your pipeline is getting.
A trend report by month, quarter and year triggered by the same day (1st of that period) and showing trend lines with the ability to get at the underlying data would be huge right now.