💬 RevOps Discussions

JWasserman
メンバー

closed deals in sales analytics

解決

Is there a way to filter the data in the Sales Analytics section to show the data for deals CLOSED in a certain timeframe? I know I can see data for deals created in a certain timeframe, but if I want to see the deal funnel for deals that closed (not created) between date 1 and date 2, how might I go about that?

1件の承認済みベストアンサー
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

closed deals in sales analytics

解決

Hi @JWasserman,

 

You can easily create such a report by navigating to Menu > Reports > Reports > Create report > Single object > Deals.

 

Under Filters, change the default filter from Create date to Close date and select your desired time frame.

 

Click Hide Filters and add Close date to the Data section by clicking Add Deal Property.

 

Switch to the Visualization tab, drag and drop Amount in company currency (or Count of Deals, depending on what you're interested in) into the Displaying area, along with Close date.

 

Change the Visualization from a horizontal to a vertical bar chart and use the Frequency drop-down in the top right of the report editor to change it from Daily to Monthly.

 

Let me know if you have any follow-up questions!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

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

元の投稿で解決策を見る

1件の返信
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

closed deals in sales analytics

解決

Hi @JWasserman,

 

You can easily create such a report by navigating to Menu > Reports > Reports > Create report > Single object > Deals.

 

Under Filters, change the default filter from Create date to Close date and select your desired time frame.

 

Click Hide Filters and add Close date to the Data section by clicking Add Deal Property.

 

Switch to the Visualization tab, drag and drop Amount in company currency (or Count of Deals, depending on what you're interested in) into the Displaying area, along with Close date.

 

Change the Visualization from a horizontal to a vertical bar chart and use the Frequency drop-down in the top right of the report editor to change it from Daily to Monthly.

 

Let me know if you have any follow-up questions!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

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