Skip down to the research record

Check deal stage duration across 4 CRM tools

Quota Forecast Editorial Team · Published · 10 min read

Freshsales Analytics provides two distinct metrics to evaluate deal lifecycle and progress through the pipeline, according to Freshworks.

How to check deal stage duration and progress in CRM tools

To identify stalled deals, you must distinguish between total deal existence and stage-specific efficiency. Freshsales Analytics offers two metrics to help sales teams evaluate the lifecycle and progress of deals through the pipeline: “Age in Days” and “Days in Stage,” according to Freshworks. These metrics provide different perspectives on how long deals have existed and how efficiently they move through each stage, according to Freshworks.

Review your current pipeline view to determine which of these two perspectives is displayed. If your standard report shows total age, you are seeing the full lifecycle duration. If it shows stage-specific time, you are seeing completed stage time, because Days in Stage leaves out the current stage until the deal moves. Verify which metric your team uses for weekly forecasts to ensure consistent interpretation of stalled opportunities.

Key takeaways for how to check deal stage duration and progress in crm tools

  • Freshsales excludes the current stage's duration from the Days in Stage metric until the deal moves to the next stage, according to Freshworks.
  • The Pipedrive deal progress bar displays the number of days taken to complete each stage in the detail view, according to Pipedrive.
  • Pipedrive Insights reports lock the date of entering stage filter because it is needed to assess deal progress, according to Pipedrive.
  • One HubSpot catalog line allows up to 10 stages and 10 unique steps, and is limited to 36 months of data or 20 million events, whichever comes first, while another line allows up to 15 stages and is limited to 60 months of data or 20 million events, whichever comes first, according to HubSpot.
  • The Pipedrive progress bar does not update once a deal is won, according to Pipedrive.

Freshworks: age in days and days in stage

Freshsales Analytics defines two distinct duration metrics for tracking deal movement. The "Days in Stage" metric excludes the current stage's duration, which only becomes available once the deal moves to the next stage, according to Freshworks. This exclusion means the metric reflects completed stage transitions rather than ongoing time in the active stage. When a deal sits in a stage for an extended period, the "Days in Stage" value remains unchanged until the next stage change occurs. Revenue leaders must account for this lag when identifying stalled deals, as the metric does not capture real-time duration in the current stage.

The "Age in Days" metric provides a different perspective by measuring total deal activity. When used in combination with "Group By" conditions such as "Deal Name" and "Stage," it provides insights into the current stage of each deal along with the total number of days the deal has been active since its creation, according to Freshworks. This metric includes the ongoing time in the current stage, offering a continuous view of deal age. For example, if a deal has spent time in New, Discovery, and is currently in Demo, the "Age in Days" value reflects the time the deal spent in New, Discovery, and the ongoing time in Demo, according to Freshworks. This distinction is critical for forecast accuracy: "Days in Stage" tracks historical stage completion, while "Age in Days" tracks total lifecycle duration including the current stage.

To verify pipeline health, check which metric your standard report displays. Days in Stage omits the current stage until the deal moves, and Age in Days is total time since creation, so Age in Days alone does not show a stall in the current stage. Open your Freshsales Analytics report and confirm the "Group By" conditions include "Stage" to see the current stage context alongside total age.

Pipedrive: Progress Bar and Report Filters

Pipedrive’s Deal detail view includes a deal progress bar that displays the current pipeline stage and the number of days taken to complete each stage, according to Pipedrive. This visual indicator helps you see at a glance how long a deal has spent in previous stages before it reaches its current position. However, Pipedrive specifies that the progress bar won’t be updated once the deal is won, according to Pipedrive. For closed-won deals, the bar remains static at the point of closure, so you cannot use it to track post-close activity or final stage adjustments.

For broader pipeline health analysis, Pipedrive offers the Insights deal progress report, which allows you to view the movement of your deals through stages within a specified time frame, according to Pipedrive. This report shows how well your deals are progressing through your sales cycle by aggregating stage duration data across multiple opportunities. When configuring this report, you can adjust or add filters according to the data you want to see, but the date of entering stage filter is locked in since it’s needed to assess deal progress, according to Pipedrive.

The predictive model analyzes the time that closed opportunities have spent in each stage to provide insights about open opportunities, according to Microsoft. This historical data serves as the baseline for evaluating current pipeline health. If an opportunity gets stuck at a specific stage for a longer period compared to the time the other won opportunities have spent in the same stage, it could be a cause for concern, according to Microsoft. If an open opportunity stays in a stage longer than won opportunities stayed in that stage, it could be a cause for concern.

The system assigns a trend direction to each opportunity to indicate its trajectory. It specifies the direction in which an opportunity is trending such as Improving (up arrow), Declining (down arrow), Steady (right arrow), or Not enough info, according to Microsoft. These visual indicators help distinguish between deals that are progressing normally and those that are stalling.

Opportunities with a higher grade have more chances of converting into won deals. Opportunities with higher grade have more chances of converting into win deals, according to Microsoft. This grade provides a prioritization tool for revenue leaders reviewing the pipeline. The predictive model does not guarantee a win but offers insights and prioritization based on historical data.

To use this for your weekly forecast call, review the trend arrows and grades for all open opportunities. Identify any deals marked as Declining or with a low grade that have also exceeded the typical stage duration. Focus your conversation on these specific accounts to determine if they need additional support or should be re-evaluated for the forecast.

For more context on how these scores fit into your overall forecast categories, see Pipeline, Best Case, Commit: Forecast Categories Explained.

HubSpot: Report Stage and Event Limits

The HubSpot product catalog lists two report limits. According to the HubSpot Product & Services Catalog, one catalog report line can include up to 10 stages and 10 unique steps. This same source states that this report line is limited to 36 months of data or 20 million events, whichever comes first. These caps mean that this report line stops at 36 months of data or 20 million events, whichever comes first. A separate catalog line allows 60 months of data or 20 million events, whichever comes first.

A second catalog line sets another report limit. According to the HubSpot Product & Services Catalog, each such report can include up to 15 stages, with 1-5 events in each stage and up to 15 unique events. The catalog specifies that these reports allow 1-5 events in each stage, with a maximum of 15 unique events total. These reports are limited to 60 months of data or 20 million events, whichever comes first. This extended window allows you to compare stage duration trends over five years, which is useful for identifying long-term slowdowns in specific deal stages. However, the 20 million event cap still applies, so high-activity accounts may hit this limit before the 60-month mark.

Beyond report limits, HubSpot imposes constraints on how datasets are used across workflows and exports. According to the HubSpot Product & Services Catalog, each use of a dataset in a workflow, segment, CRM sync, or export is limited if the primary source contains more than 5 million rows. This rule affects how you can aggregate pipeline data for broader analysis. A dataset use in a workflow, segment, CRM sync, or export is tied to more than 5 million rows in the primary source.

For a deeper look at how these limits interact with other pipeline metrics, see Stage duration: 8 checks before the weekly call. This guide helps you verify that your report settings align with the specific duration metrics you need to track.

A filled reference table comparing stage duration metrics

The following table compares the specific duration metrics and constraints documented for Freshworks, Pipedrive, and HubSpot.

PublisherPrimary Duration Metric or DisplaySpecific Constraint or LimitSource Document
Freshworks"Age in Days" and "Days in Stage"Age in Days is total days since creation and includes the current stage, while Days in Stage leaves out the current stage until the deal moves to the next stageFreshworks
PipedriveDeal progress bar showing stage and days in each stageThe progress bar will not be updated once the deal is wonPipedrive
PipedriveInsights deal progress reportThe date of entering stage filter is locked in since it‘s needed to assess deal progressPipedrive
HubSpotReport including up to 10 stages and 10 unique stepsLimited to 36 months of data or 20 million events (whichever comes first)HubSpot

Use this table to verify which metric your current view displays before the forecast call.

FAQ: How to check deal stage duration and progress in crm tools

Does Freshsales include the current stage duration in the Days in Stage metric?

No, the current stage's duration is not included in this metric. It only becomes available once the deal moves to the next stage, according to Freshworks.

Is the date of entering stage filter locked in Pipedrive deal progress reports?

Yes, the date of entering stage filter is locked in because it is needed to assess deal progress. You can adjust or add other filters according to the data you want to see, according to Pipedrive.

How many stages can a HubSpot catalog report include?

Each report can include up to 15 stages, with 1-5 events in each stage and a maximum of 15 unique events. These reports are limited to 60 months of data or 20 million events, whichever comes first, according to HubSpot.

Does winning a deal affect Pipedrive deal progress results for skipped stages?

The progress bar won't be updated once the deal is won.

What does the Microsoft predictive model analyze to identify stalled opportunities?

The model analyzes the time that closed opportunities have spent in each stage to provide insights about open opportunities.

Sources