Report for Deal Stage Status per Month

SOLVE
New Contributor

Hi, 

 

I am trying to create a report that for each month it will show how many deals per deal stage are. I had thought I had figured it out by tracking it by last modified date, but just recently found out that the last modified date related to editing contact info and not the deal modified date. Anyone know how to properly track this?

 

image1.PNGimage2.PNG

1 Accepted solution

Accepted Solutions
Solution
HubSpot Employee

Hi @chewbecca  The issue here is that we don't have a filter option to include all reports. The Date Property/Date Range filters required that you select a date property as a filter. You can select Create Date /  All Data but then you won't be able to break down by month. 

 

You can also select Create Date / Last Month or Custom time frame  but that will only include deals created in that month, not all open deals.

 

Instead of one report, you may need to create a series of reports focused on a specific month, using specific date properties, or you can narrow your focus, such as using create date or close date as filters.

 

Hope this helps.

 

Thank you,

Ed Justen

 

 


Did my post help answer your query? Help the Community by marking it as a solution

View solution in original post

Reply
0 Upvotes
4 Replies 4
Solution
HubSpot Employee

Hi @chewbecca  The issue here is that we don't have a filter option to include all reports. The Date Property/Date Range filters required that you select a date property as a filter. You can select Create Date /  All Data but then you won't be able to break down by month. 

 

You can also select Create Date / Last Month or Custom time frame  but that will only include deals created in that month, not all open deals.

 

Instead of one report, you may need to create a series of reports focused on a specific month, using specific date properties, or you can narrow your focus, such as using create date or close date as filters.

 

Hope this helps.

 

Thank you,

Ed Justen

 

 


Did my post help answer your query? Help the Community by marking it as a solution

View solution in original post

Reply
0 Upvotes
New Contributor

Hi - thank you for the quick response and suggestion. 

 

Do you know if there are plans to add the filter ability for this in the future?  Or a way to create reports for tracking deals types per month / quarter?

 

 

Reply
0 Upvotes
HubSpot Employee

Hi @chewbecca At this time, no.  Great suggestion though. Can you add this as a post to our ideas forum for further comment?

 

Thank you,

Ed Justen


Did my post help answer your query? Help the Community by marking it as a solution
Reply
0 Upvotes
Occasional Contributor | Platinum Partner

I would not call this solved but more of a hack.  Most sales reporting tools provide a; This Month, Last Month, Calendar Year to date, Prior Year, etc. reporting options.  We also need to be able to report on the Entered into Stage metric.  Manually creating reports that require ongoing filter updates is far from best practice.

Reply
0 Upvotes