Create a sales performance dashboard
Objective: Closely following sales performance metrics, such as time to close, conversions rates and average order amount is vital for any business. It is mandatory to have this information when working with investors. It also helps you understand when to accelerate on sales as you notice your metrics are getting better.
In this guide, we will learn how to build a report that will:
Display our average order amount and total revenue
Track our sales velocity over time
Monitor our sales pipeline conversions rates
This guide is targeting Hubspot CRM, but the principles can be used with other CRM data.
Here is what we will build :
High level plan:
Creating our Deal exploration
Creating our "new revenue" metric
Creating our "average order amount" metric
Creating our sales velocity chart
Creating our deal conversion funnel
Creating our report
Creating our Deal exploration
Let's start with the easy stuff and create a new exploration. We will start our exploration from our Deal table as we want to see 100% of our deals in our sales dashboard.
Let's create the exploration and add the column property_createdate
as a dimension.
Creating our "new revenue" metric
In order to display our new revenue, we will want to count the total amount for the deals won. It's easy to create such a metric:
Create a new metric
Set it to
Sum
of the columnproperty_amount
In the advanced settings, set a filter on
property_dealstage
equalsclosedwon
Set a suffix to €
Creating our "average order amount" metric
To display the average order amount, we will will recreate the same metric as for total revenue but we will use the aggregation "average" instead of sum:
Create a new metric
Set it to be
Average
of the columnproperty_amount
In the advanced settings, set a filter on
property_dealstage
equalsclosedwon
Don't forget the suffix and the name 🤓
Now you can use these two metrics on our dashboard:
Creating our sales velocity chart
Hubspot provides a column named property_days_to_close
on the deal table which contains the number of days from the deal creation date to the deal closed date. To monitor our sales velocity, we will create a new metric:
Create a new metric
Set it to average of the column
property_days_to_close
In the advanced settings, set a filter on
property_dealstage
equalsclosedwon
You can add
days
as a suffix in the advanced settings
Creating our deal conversion funnel
In order to closely monitor our sales pipeline, we will create a conversion funnel on top of our sales process. In this guide our funnel is composed of three steps: Demo -> Trial -> Customer
First, we will create a metric for each of our pipeline steps : number of trial done, number of demo done and number of customer. Let's do it:
Create a new metric
Set it to count
In the advanced settings, set a filter to on
property_hs_date_entered_in_xxx
tois set
, wherexxx
is the corresponding stage id in Hubspot.Give it a name (for example, number of demo done)
The matching between the pipeline stage id and the pipeline label (displayed in hubspot) in available in the Deal pipeline stages table.
This allows us to monitor our sales funnel by month:
As well as displaying our global sales funnel:
We will also calculate our conversion rate between our pipeline stage. Here we will need to create two calculated metrics:
Demo conversion rate, which is
number of trial done / number of demo done
Trial conversion rate, which is
number of customer / number of trial done
This will allow us to monitor our conversion rates in time:
Creating our report
Now we have all the elements we need to build our sales performance report. Let's just assemble everything and apply some formatting to get our final result :
Last updated