Actiondesk Tutorial: Calculate the Number of HubSpot Deals per Stage per Month

Stephanie Lehuger
Stephanie Lehuger
Apr 29, 2021 · 5 min read
Sales calendars

Forget third-party connectors and complicated coding. Use Actiondesk to build custom HubSpot reports that illuminate what’s happening at every stage in your sales funnel. Simply import your HubSpot data into Actiondesk’s intuitive spreadsheet interface and gain immediate access to greater insight.

Ready to get started? Here’s how to calculate the number of deals per stage per month based on your Hubspot data:

Step 1: Import deals

  1. Create a new sheet called "Demo HubSpot"
  2. Click the “Import” button
  3. In the data source dropdown menu, select your HubSpot account
  4. In the "Table to import" dropdown menu, select "Deals"
  5. Choose the columns you want to use: you'll need at least the "dealId," "Create Date," and "Deal Stage" columns

Step 2: Add a calculated column for months

Add a calculated column to return the created month of each deal in a convenient format:

  1. Place your cursor on the cell to the right of your table headers
  2. Title the column "Month"
  3. In the first cell of the column, add the formula:

             =YEAR(#'Create Date')&"_"&MONTH(#'Create Date')

Step 3: Build the layout of your dashboard

  1. Create a new sheet called "Dashboard"
  2. Go back to "Demo HubSpot" and copy the unique values of your "Deal Stage" column by right clicking on the "Deal Stage" column and choosing "Copy unique values"
  3. In your "Dashboard" sheet, paste the uniques values in cell B4
  4. In cells C3 to E3, write the months for which you'd like to see data, for example:
  • 2021_1
  • 2021_2
  • 2021_3

Step 4: Write your countifs formula

     1. In cell C3, write the following formula:

             =COUNTIFS('Demo Hubspot'!#Month,C$3,'Demo Hubspot'!#'Deal Stage',$B4)

     2. Copy/paste or drag your formula downward and to the right to fill the whole table

Keep reading

Please wait...
Oops! Something went wrong while submitting the form.