Dashboards & Reporting

chewbecca
Member

Report for Deal Stage Status per Month

SOLVE

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
edjusten
Solution
HubSpot Employee
HubSpot Employee

Report for Deal Stage Status per Month

SOLVE

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

0 Upvotes
5 Replies 5
edjusten
Solution
HubSpot Employee
HubSpot Employee

Report for Deal Stage Status per Month

SOLVE

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
0 Upvotes
Amoore6
Participant | Platinum Partner
Participant | Platinum Partner

Report for Deal Stage Status per Month

SOLVE

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.

EAube
Participant

Report for Deal Stage Status per Month

SOLVE

I agree. Definitely not solved, and still not.

chewbecca
Member

Report for Deal Stage Status per Month

SOLVE

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?

 

 

0 Upvotes
edjusten
HubSpot Employee
HubSpot Employee

Report for Deal Stage Status per Month

SOLVE

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
0 Upvotes