SOLVD BLOG

How can I report on Opportunity Stage duration

If you’re in sales, you know how important it is to understand where deals get stuck. One of the best ways to see this is by looking at how long each opportunity stays in each sales stage.

The good news? You don’t need custom code or complex tools. Salesforce already tracks this—you just need to know where to look.

At SOLVD, we help companies unlock simple ways to use Salesforce better. In this blog, we’ll show you how to use a built-in report to track how long deals sit in each stage—so you can spot delays, coach reps, and improve your sales process.

“Can I report on opportunity stage duration? And if so, how?”

Yes, you can—and here’s how to do it.

Step 1: Understand What Salesforce Tracks Automatically

Salesforce keeps track of every time an opportunity changes stages—like moving from Qualification to Discovery or from Proposal to Negotiation.

“Salesforce automatically keeps track of how long something… has been in each of the stages.”  – Brendan Lowe, SOLVD Consultant

But while you can see this info on a single opportunity, it doesn’t show up in regular reports by default.

That’s where the Opportunity History report comes in.

Step 2: Create an Opportunity History Report

To get started:

  1. Create a new report using the Opportunity History report type.
  2. Group the report by Opportunity Name so you can see each stage change for every deal.
  3. Add the field called Stage Duration—this shows how long the opportunity stayed in each stage.
  4. Add a filter for Stage Change equals TRUE so you only see real changes.

“If you don’t do that, you will see… from stage Close Won to stage Close Won. And that’s not super helpful.”  – Brendan Lowe, SOLVD Consultant

Now you can see exactly how long each opportunity was in each stage.

Step 3: Use the Data to Improve Sales

This report gives you a powerful view of your sales process.

You can:

  • See how long deals stay in each stage
  • Spot where reps are getting stuck
  • Compare stage duration by team, rep, or opportunity type
  • Create formulas to calculate average time in stage

“It’s a very easy way to drill down and see how’s the sales process going.”  -Brendan Lowe, SOLVD Consultant

You don’t need to create custom fields or complex flows. This data is already there—Salesforce just hides it in a place most people don’t look.

Final Thoughts

Salesforce automatically tracks your opportunity history—you just have to pull it into a report. With a few clicks, you can get insights that help you shorten deal cycles, improve rep performance, and close more business.

“Using standard Salesforce functionality, you can have access to all this information.”  – Brendan Lowe, SOLVD Consultant

Need Help Making Salesforce Work Better for You?

We help teams like yours find simple, practical ways to use Salesforce to save time and close deals faster.

📅 Book a free consultation at SOLVD.cloud—we’ll help you build the reports, automations, and tools your team actually needs.

yellow cloud solvd logo
Testimonials

Our clients say

From my initial call with Spencer through project implementation with John and Evan, my experience with the SOLVD team was excellent. They were quick to understand our business needs, clear when explaining the reasoning behind proposed solutions, transparent when reporting on progress and timeline, and all around enjoyable to work with. Would highly recommend and looking forward to continue working with them in the future!

Veronica Wong Director of Operations at Pathstream

SOLVD was very straight forward with everything needed to complete the project. No surprises, no issues, and cost was aligned with the estimate. They made implementation easy and quick.

Matt Benzaquen Sr Manager, Sales Strategy at Instabug

As a rule, I'm pretty stingy with my recommendations. So it's a pleasure for me to recommend Solvd as a top-flight Salesforce consultancy. Solvd recently led our company's conversion to the Lightning interface and did it on time, on budget and made it easy for me and my team. I know I'll use their services again, and am confident they can do the same for you.

Tim Tuttle CFO at Relevate Health Group

HIGHEST RATED ON SALESFORCE