As a CSM, there are are few fields that I recommend when you want look at pipeline hygiene--
First, I’d use a “push count” field. This field will show you how many times the opportunity close date has been pushed forward. If there is more than 2 pushes, I usually recommend an intensive inspection into the deal to see if it worth keeping in the pipeline.
Second, Slipped Reason-- are you seeing deals slip over and over again? Do you have a ton of slipped deals quarter after quarter? Adding Slipped Reason will start giving you insight into why these deals are slipping. Is it because of cost? Is it getting stuck in negotiation for months? This can lead to coaching or process changes to increase deal velocity and improve Average Deal Age.
Lastly, Age- Understanding how long your average deal cycle is can be super helpful. Adding AGE can give you insight into Average Age of a Deal by team, rep, vertical, etc. Do you find some reps close deals faster/slower than others? Here’s a great avenue into data-driven coaching.