There's currently no way to create dashboard reports for looking at the average sales cycle length.
'Time to close' doesn't do it, because that uses all close dates, not just dates for sales that have actually closed.
The nearest you can get is displaying deal created date alongside the date the deal entered the current deal stage 'order received' (in our case)... but that's not much use.
This must be a common requirement, particularly for SaaS companies.
Having to export deals and do a manual workaround is a pain.
Weitere Ideen mit folgender Beschriftung anzeigen:
The only workaround solution is to pull a report for a list of contacts, export those contacts, throw them into excel, and grab the averages that way.
For example, we wanted to see on average how long it took someone to book a consult call. We made a Lifecycle stage report of everyone who went into the Sales Qualified Lead Stage and the date that activity happened, and we also added create date. I exported that data, and we were able to find our average that way.
It's mind-blowing that software that tracks all of these dates, and can pull workaround reports, can't track this. At least, giving us a report that shows how long it takes between each Lifecycle Stage or Lead Status.
I'm not sure if it helps but I use the deal property "Days to Close."
Then I filter the report by only ones that reach the "closed won" stage. If it helps, you could also filter by the properties, "deal create date" and "deal close date."
For our company, we also have different services which I filtered on so I can see the sales cycle for each service.
The premise is that we only create a deal when it's a SQL. If it isn't, then it remains in the MQL stage. So our sales cycle literally starts on "deal create date," and ends on "deal close date.
I was able to calculate my average sales cycle length by using the "Days to Close" property.
1. Create a single-object report (deals) 2. Date > Deal Stage, Close Date, Days to Close 3. Filters > Close Date is (enter date range you want to report on) & Deal Stage is All Closed Won 4. Visualization > Displaying: Close Date & Measured by: Days to Close (use the drop down arrow to set to 'average') 5. Frequency > Yearly 6. Personal preference, but I'm doing a bar graph to compare average days to close from last year to this year so far.
Hi @DylanWickliffe this is amazing and so helpful! I am finding that the days to close average isnt calculating right, its showing 5.3 days when our average is like 30-40 days. I might be doing something wrong? I feel like saying Deal stage is maybe the issue what would be causing it to show a faster closing date than the reality?
We have a sales pipeline for our existing customers, and we really need to know the average time between a customer's (deal's) start date property and 'today', not another date property such as close date.
We have several 'time between' reports, which work fine, but they only calculate the average time between two dates. This works for customers (deals) that have signed up with us and then left, but it doesn't account for existing customers.
We need to know the average time our existing customers have been with us, and date property that looks at 'today' rather than a date picker would solve this.
Sie müssen ein registrierter Benutzer sein, um hier einen Kommentar hinzuzufügen. Wenn Sie sich bereits registriert haben, melden Sie sich bitte an. Wenn Sie sich noch nicht registriert haben, führen Sie bitte eine Registrierung durch und melden Sie sich an.