web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to track the time ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to track the time spent between different stages in a sales pipeline in Dynamics 365?

(2) ShareShare
ReportReport
Posted on by Ethan202305 5
Hello everyone, 
I am using Dynamics 365 to track the time spent between different stages in a sales pipeline. The sales pipeline includes 4 stages, that is, "Qualify, Develop, Propose, and Close". 

For example, I want to track the time spent from Quality to Develop. If the sales rep enters the information into Qualify at 9:00 am on April 25, 2025, and then it goes to Develop at 10:00 am on April 30, 2025. 

How can I track this time?

Can anyone give some suggestions? 

Thank you very much!!

 
Categories:
Dynamics 365 general
Screenshot 2025-0...
I have the same question (0)
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 2,393 Super User 2025 Season 2 on at
    How to track the time spent between different stages in a sales pipeline in Dynamics 365?
    There are a few approaches, and it depends a bit on your full requirement.
     
    Option 1: Date and Time Stamps on your Sales Records
    • Create Date and Time Fields for the entry point at each stage
    • Create a workflow/action and fire on stage change to populate this field when the user updates the BPF stage
    • Use Formula Fields to calculate the time between stage timestamps, or to the current date and time if you are in the current stage
    This works if you expect users to only move forward in the BPF, and if your stages are very static If this is not the case, look for option 2.
     
    Opton 2: Custom audit table for BPF
    • Create a custom table to track the stage updates
    • Add fields for stage name, date and time, and a Lookup field to relate it to the sales record (such as Opportunity)
    • Create an Action/Workflow that grabs the current stage and date/time when the BPF stage is moved, and use it to create a record on this table
    This option is great if the stages might move back and forth sometimes, but it adds complexity and the reporting is going to look different since you are now looking at another table.
     
    If this answer helped, please consider marking as verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 72 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 58

#3
Martin Dráb Profile Picture

Martin Dráb 54 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans