Hi - first post! Had a search and can’t find an answer here and hence posting for comments. Looking for a report that can show a list of overdue deals, i.e. deals part their close date.
Thanks.
Hi @romiz,
Happy to help! Navigate to Menu > Reports > Reports > Create custom report > Single object > Deals.
Under Filters, choose the following settings.
In the Visualization tab, choose the following settings.
Feel free of course to adjust visualization and additional properties. You could for example include a column for the Deal owner.
Hope this helps!
@Anonymous what if I wanted to limit this report to deals that are due to close this month/quarter? We’ve got a lot of bad historic data so I’m trying to focus on what is currently live rather than trying to clean up deals from 1+ years ago.
Hello @karstenkoehler !
Great answer. I had some doubts regarding this.
Are we counting on the fact that if any deal isn’t in the “Closed Won” or “Closed Lost” stage, it is sure to be lost? What if there are other deal stages too? And the date filter is checking the deals only in the last 365 days, right?
Hi - thanks Karsten! WIll give this a go later.