How to track average days spent in each status using Affinity Analytics
Whether you're in private capital and analyzing your deal funnel, or in business development and optimizing your prospecting pipeline, a common question we hear is “Where are we spending too much time?” We'll show you how to leverage Affinity Analytics to track average days spent in each stage of your funnel and identify areas of improvement.
There is a version available in the Funnel Analysis template, but if you’d like to create your own, here are the following steps:
- Click the ellipsis (3-dotted icon) and click Edit dashboard in the dashboard view you'd like to create the visualization in.
- Click Add tile, then choose Visualization.
- Choose the list or data source for your funnel. We highly recommend that you choose the list you're currently on.
- For this visualization, we’ll use the Funnel Analysis data points: select Next Status for the dimension, then select Average Days in Next Status for the measure, then click Run.
- Make sure to filter out null values in the Next Status dimension. Then, click the + icon right next to it to filter out more values as shown in Step 6 below.
- Make sure to also filter out deleted statuses and static statuses in the Next Status dimension.
- Deleted statuses: These will appear for historical deals, but they aren’t relevant to optimizing your current process.
- Static statuses (Lost, Won, or Passed): Once you’ve lost/won or passed on a deal, the time in that particular status no longer matters.
- Sort the Next Status dimension from first to last. This will sort the statuses in the Open category by the order that has been set in the default Status column.
- Click on Settings within the Visualization section, then click the Values tab to Add value labels.
- Name your visualization, then click Save.
- Now, you'll see what stages of the pipeline you/your team are spending the most time in and can improve upon moving forward. Click Save one more time for your entire dashboard view, and you're all set!
