Understanding how long opportunities spend in each sales stage helps sales managers identify bottlenecks and coaching opportunities. Salesforce's Opportunity History report type tracks stage transitions and duration, making it possible to analyze pipeline velocity across the team.
This article explains how to create a Salesforce report that shows how long an Opportunity spends in each Stage, using the Opportunity History report type. It also explains how stage duration is calculated when an Opportunity returns to a previous Stage.
Note: The stage duration refers to the total number of days that an opportunity has spent in the current stage from the time it entered that stage until it moves to the next stage. For example, if an opportunity moves into the Proposal stage, stays there for 2 days, then moves into Negotiation, and later moves back into Proposal for another 3 days, the stage duration in reports will only show the duration between the first two stages, which is 2 days. This differs from paths, where the total time spent in a stage is accumulated, amounting to 5 days in the given example.
000392663

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.