Follow the Metric Recipe below to calculate Deals Entered Deal Stage X: Win Rate in HubSpot CRM by combining two previously created metrics.
1. Create the base metrics
This metric is calculated using two other metrics:
Deals Entered Deal Stage X (Closed Won) โ Follow the setup in this recipe: Deals Entered Deal Stage X (Closed Won) [HubSpot CRM]
Deals Entered Deal Stage X (All Closed) โ Follow the setup in this recipe: Deals Entered Deal Stage X (All Closed) [HubSpot CRM]
Ensure both metrics are created and saved in your Databox account before proceeding.
2. Create the Calculated Metric
Once both metrics are available, create a Calculated Metric using the Data Calculations feature:
Navigate to Metrics > Data Calculations in Databox.
Click + New Calculation.
In the calculation editor, set up the formula:
[Deals Entered Deal Stage X (Closed Won)] รท [Deals Entered Deal Stage X (All Closed)]
Set the Format to Percentage.
Name your metric: "Calculated Metric: Deals Entered Deal Stage X: Win Rate".
Save the Calculated Metric.
You now have a Deals Entered Deal Stage X: Win Rate metric, ready to add to your dashboards or reports.