Mining the Sales Opportunity History for Insights

Continuing with yesterday’s post on the sales ops role, there’s an extremely useful table in called Opportunity History (API info). Opportunity History is based on the Opportunity object which is used to keep track of potential deals so as to manage the sales pipeline. As expected, Opportunity has fields like Account (the company), Amount (the potential value), Close Date (when it’s expected to close), Stage (the current sales stage), and more.

Now, Opportunity History comes in as the audit trail of all changes to the Opportunity object. So, if a sales rep changes the Close Date of a potential deal, a new Opportunity History object is created reflecting that change. Why is this important? Opportunity History contains a treasure trove of information relating to how opportunities progress through the sales stages, how often reps change key values like Amount and Close Date, as well helps inform projections.

Here are a few questions to ask from the Opportunity History info:

  • How often does the close date get pushed out, on average? How does it vary by sales rep?
  • When an opportunity close date is pushed out, how many days of lead time is there on average? How does it vary by sales rep?
  • How many days does an opportunity stay on a stage, on average? How does it vary by sales rep?
  • How does the number of days in a stage compare between opportunities that were won vs opportunities that were lost?
  • What’s the win rate of opportunities by stage (e.g. for all opps that reach the third stage, how many make it through to a sale)? How does it vary by sales rep (this is a much better way to do sales forecast as compared to a basic probability by stage)?
  • What’s changed recently in the pipeline? Which opportunities moved stages? How is this month/quarter progressing against the previous one?

These types of questions can be answered by exporting the data into a spreadsheet and building a model or by using an automated analytics platform. Overall, the Opportunity History object has very valuable data and should be mined for insights.

What else? What are some more questions to ask of the Opportunity History object in


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s