How can we help? 👋

Sales Room Impact Reports and Dashboard

This article will guide you through setting up 7 recommended HubSpot reports so you can understand the impact of your Arrows Sales Rooms.

These 7 reports will help you get a sense of the impact your Arrows sales rooms are having on your sales process.

Set them up and add them to a dashboard so you can understand how your rooms impact your deals, plus use the information to optimize your process!

Start by creating a dashboard.

Then create and add each report to your dashboard so it looks something like this:

Notion image
💡

The following reports are contingent on the following data points synced from Arrows into HubSpot, the will appear as these properties on your deal record…

  • Arrows room URL
  • Arrows room total views
  • Arrows room last viewed timestamp

An Arrows admin will need to sync the data here - https://app.arrows.to/settings/hubspot/synced_room_properties

When syncing the data points, they’ll be labeled respectively as…

  • URL
  • Total opens
  • Last opened

Report types

All 7 of these report types are custom reports created from scratch in HubSpot. For each report below, you’ll need to create a new report with these conditions…

 

The report type will be Single object:

Notion image
 

And the data source for each report type will be Deals:

Notion image
 

Report 1 - Days to Close w/ Sales Rooms

This report will help you understand the average days to close for deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Days to close as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “0”
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image
 

From the Visualization tab…

  1. Select the Summary chart type
  1. Add Days to close as the displaying property
  1. Change the display type to Average
  1. Save your report
💡

When you save each report, you’ll get the option to add it directly to your newly created dashboard.

You can adjust the size of each report on the dashboard to make it appear how you’d like.

 
Notion image
 

Report 2 - Average Closed Revenue w/ Sales Rooms

This report will help you understand the average revenue from closed deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Amount as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “0”
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image
 
 

From the Visualization tab…

  1. Select the Summary chart type
  1. Add Amount as the displaying property
  1. Change the display type to Average
  1. Save your report and add it to your dashboard
Notion image
 

Report 3 - Total Closed Revenue w/ Sales Rooms

This report will help you understand the total revenue from closed deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Amount as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “0”
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image

From the Visualization tab…

  1. Select the Summary chart type
  1. Add Amount as the displaying property
  1. Change the display type to Total
  1. Save your report and add it to your dashboard
Notion image
 

Report 4 - Sales Rooms Views by Open Deals

This report will help you understand the number of total views for each room based on each deal with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Deal Name as a property (blurred out in this example)
  1. Add Arrows room total views as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “1”
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image
 

From the Visualization tab…

  1. Select the Horizontal graph chart type
  1. Add Deal Name as the displaying property
  1. Add Arrows room total views as the measured by property
  1. Change the measured by type to Total
  1. Save your report and add it to your dashboard
Notion image
 

Report 5 - Sales Room Views by Sales Rep

This report will help you understand the total views each room has based on sales rep for deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Deal owner as a property
  1. Add Arrows room total views as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “1”
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image

From the Visualization tab…

  1. Select the Horizontal graph chart type
  1. Add Deal owner as the displaying property
  1. Add Arrows room total views as the measured by property
  1. Change the measured by type to Total
  1. Save your report and add it to your dashboard
Notion image
 

Report 6 - Sales Rooms Views by Pipeline stage

This report will help you understand the total room views based on pipeline stage for deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Deal Stage as a property
  1. Add Arrows room total views as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “1”
  1. Add a filter for Pipeline to filter down to just your sales pipeline
  1. Adjust your time range
  1. Select Visualization to continue setup
Notion image

From the Visualization tab…

  1. Select the Vertical graph chart type
  1. Add Deal Stage as the displaying property
  1. Add Arrows room total views as the measured by property
  1. Change the measured by type to Total
  1. Save your report and add it to your dashboard
Notion image
 

Report 7 - Last Activity Date vs Last Room Activity

This report will help you compare the last time there was a recorded HubSpot activity (meeting, call, etc.) compared to the last time the sales room itself had a view for deals with an attached Arrows room.

After you create the report, start by…

  1. naming your report
  1. Add Deal name as a property
  1. Add Last Activity Date as a property
  1. Add Arrows room last viewed timestamp as a property
  1. Select advanced filters
  1. Add a filter for Arrows room URL is known
  1. Add a filter for Is Open is equal to “1”
  1. Adjust your time range
  1. Select Visualization to continue setup
 
Notion image

From the Visualization tab…

  1. Select the Table chart type
  1. Configure the table to be an Unsummarized data table
  1. Add Deal Name as a displaying property
  1. Add Last Activity Date as a displaying property
  1. Add Arrows room last viewed timestamp as a displaying property
  1. Save your report and add it to your dashboard
Notion image

Did this answer your question?
😞
😐
🤩