I would like to monitor for each opportunity the number of days between date opportunity is created and date opportunity is won, then to track the average number of days of our sales cycle for a given quarter, and see the evolution over time of this metric.
I have tried to automate the update of an opportunity field once the opportunity is won, but I’m a bit stuck.
Can anyone help me on that?
Thanks a lot!
Thank you for submitting your question to our Copper Community!
By utilizing a custom field, and workflow automation you can measure Days to Close for your opportunities, and this information can be viewed in a report.
I’ve included a link to our step-by-step guide and steps to follow below. I highly recommend attending our Weekly Reporting Q&A & Workflow Automation Q&A webinars for Reporting and Workflow Automation setup guidance.
Step-by-step guide to setup and report on “Days to Close”
Create a New Opportunity Field
Days to Close - Number Field
Include the field on all pipeline you would like to measure Days to Close.
If you have an existing WFA when an Opportunity is Won and Loss, then add an update action
To Update Days to Close
Most accurate is to use the Close Date when the Opportunity is closed use this - Update Opportunity - Days to Close - Use formula - DAYS(date_created,close_date)
If you are worried about the Rep not setting the close date, you can use this to use Today’s Date - Update Opportunity - Days to Close - Use formula - DAYS(date_created,CURRENTDATE())
You can use different type of reports to display this information, but we will use the table
Date (Opp Created At)
Date (Opp Closed At)
Days to Close
Click on Days to Close Column Header
Click on the 3 horizontal lines
Click within Opp Owner
Opp Status (To choose Won or Loss or Both)
Please let us know if you have any further questions, I highly recommend our weekly webinars for live setup support.
@Chris from Copper,
Thanks a lot for your prompt answer. I did follow the steps for workflow creation. However, when building the report, I cannot find the “Days to close” field to be added in the metrics. Can you elaborate how to get it ?
Thanks a lot for your help,
No problem! Thank you, for the follow up!
To bring the Days to Close field into Reports, you’ll need to add the Field in Reports settings, then wait about 24 hours and the data will be available.
How to add in Days to Close:
Let me know if you have any further questions!
Thanks a lot
@Chris from Copper ! Much appreciated! Should be ok now, just need to wait 24 hours.