Dashboards & Reporting

McBainKD
投稿者

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

Hey all,

 

I was wondering how to go about creating a report to show our leads that haven't moved from one stage in the sales funnel to another in a while. Just looking to get a basic display of why some deals haven't been moved along the funnel.

 

Thank you!

0 いいね!
1件の承認済みベストアンサー
jfreeman
解決策
投稿者 | Diamond Partner
投稿者 | Diamond Partner

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

Hi @McBainKD ,

 

If you use the deal cards view you should already be able to see inactive cards grayed out. That's a built-in HS feature...

Screen Shot 2021-07-21 at 9.46.53 AM.png

 

 You can customize how that feature behaves (or turn it on if you're not currently seeing it) under Board Actions > Edit Cards.

 

Screen Shot 2021-07-21 at 9.48.04 AM.png

There you can turn the feature on and set how many days should trigger the card turning gray...

Screen Shot 2021-07-21 at 9.48.55 AM.png

 

If you're instead looking for an actual report to put on a dashboard you could try customizing the "Deal time spent in each stage" report in the HubSpot Report LIbrary...

Screen Shot 2021-07-21 at 9.50.24 AM.png

 

Hopefully, this helps. Happy to hop on a screen share to help you work through it if needed.

Did this post help solve your problem? Help the community and mark it as a solution.
Joseph Freeman
Helping B2Bs grow faster with a systematic inbound marketing framework.
HubSpot Diamond Partner BadgeA Diamond Solutions Partner
Book 30 Minutes with Joseph »

元の投稿で解決策を見る

5件の返信
SB_7
参加者

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

 can y'all share what you did here? Same need

0 いいね!
shani456
メンバー

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

Thanks for updating about it, it's really awesome and infromative.   Keep sharing 

0 いいね!
jfreeman
解決策
投稿者 | Diamond Partner
投稿者 | Diamond Partner

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

Hi @McBainKD ,

 

If you use the deal cards view you should already be able to see inactive cards grayed out. That's a built-in HS feature...

Screen Shot 2021-07-21 at 9.46.53 AM.png

 

 You can customize how that feature behaves (or turn it on if you're not currently seeing it) under Board Actions > Edit Cards.

 

Screen Shot 2021-07-21 at 9.48.04 AM.png

There you can turn the feature on and set how many days should trigger the card turning gray...

Screen Shot 2021-07-21 at 9.48.55 AM.png

 

If you're instead looking for an actual report to put on a dashboard you could try customizing the "Deal time spent in each stage" report in the HubSpot Report LIbrary...

Screen Shot 2021-07-21 at 9.50.24 AM.png

 

Hopefully, this helps. Happy to hop on a screen share to help you work through it if needed.

Did this post help solve your problem? Help the community and mark it as a solution.
Joseph Freeman
Helping B2Bs grow faster with a systematic inbound marketing framework.
HubSpot Diamond Partner BadgeA Diamond Solutions Partner
Book 30 Minutes with Joseph »
McBainKD
投稿者

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決

Joseph,

Thanks for pointing me to the report.
I'm looking to build a rolling date range, of maybe a week to a  couple of weeks to a month to find deals that are still in a particular stage and have been for a while.

Let me know if that's customizable or if that's something different altgoether.

0 いいね!
jfreeman
投稿者 | Diamond Partner
投稿者 | Diamond Partner

How to build a report to show stale Deals? (Stuck in a stage for a while)

解決
Saw you booked time. We should be able to get that report dialed in together. Looking forward to chatting!
Did this post help solve your problem? Help the community and mark it as a solution.
Joseph Freeman
Helping B2Bs grow faster with a systematic inbound marketing framework.
HubSpot Diamond Partner BadgeA Diamond Solutions Partner
Book 30 Minutes with Joseph »