4. Calculate Days in Stage

quantify how long opportunities spend in each stage of the sales cycle 4 1 objectives in this exercise, you will learn how to measure the amount of time opportunities spend in a specific sales stage by the end, you will understand how stage duration is calculated using derived fields and how to summarize that data using calculated metrics 4 2 exercise tensorrack has identified where opportunities slow down and where pipeline is concentrated the next step is to quantify how long opportunities spend in each stage in this exercise, you will build a summary visualization to calculate the average number of days opportunities spend in opportunity creation (stage 2) this will demonstrate how stage duration is derived and measured steps add a freeform table to your workspace drag in opportunity id as the dimension drag in the metric sales stage time – opportunity creation (prebuilt derived field) we will review how this derived field was built in section 4 3 create a calculated metric use the mean function on sales stage time – opportunity creation include zeros in the calculation name it mean days in stage 2 – opportunity creation (yourname) append your first name and last initial to the metric name add this calculated metric to the table convert the visualization to a summary number the sales stage time metrics are powered by prebuilt derived fields that calculate time spent in each stage the mean function calculates the average number of days opportunities spend in that stage you only need to build this once summary visualizations for other stages have been prebuilt using the same logic 4 3 using the date math function in derived fields to get insights into how much time occurs between two events we can leverage a recently released function in derived fields within the data view configuration called "date math" this section of the lab is an on screen demo here are the steps we used for your reference navigate to data management > data views > \[choose your data view] > components > derived fields > add derived field create a case when rule for the first event and set the condition (event or dimension value), and returns the system generated timestamp for the event create a case when rule for the second event and set the condition (event or dimension value), and returns the system generated timestamp for the event create a date math function that subtracts the two variables and produces the time between the two events set the container (in this case, opportunity) set the granularity (second, minute, hour, day, etc) set whether the timestamp should be the first or last occurence of the condition in the case when rules once you save it, remember to include the new derived field as a metric in your data view and save your data view when you refresh your components in cja, your new date math derived field should be visible 4 4 checkpoint / reflection you have now quantified how long opportunities spend in a specific stage of the sales cycle this type of analysis is critical for understanding pipeline velocity , not just volume by measuring time in stage, tensorrack can identify where delays occur and prioritize efforts to reduce cycle time, accelerate deal progression, and improve overall revenue efficiency