How to Filter Out Deleted Deals in Hubspot

How to Filter Out Deleted Deals in Hubspot

An API limitation in Hubspot makes it impossible to remove deleted deals from your data set. Follow the instructions in this article to learn how to filter out deals that you no longer want in your reports.

Looker Studio

Select a chart that contains the field Deal ID. If a chart does not contain the field, you can add it by selecting the chart and dragging Deal ID to Dimensions.



Click Add a Filter.



Click Create a Filter.



Name the filter something you can remember, like "deleted deals." Choose Exclude > Deal ID > Equal to (=) > (Deal ID number).
If you need to exclude more than one Deal ID number, click OR.



Each Deal ID number must be added separately. Click Save when you have added all of your deleted Deal ID numbers.



The filter must be applied to each chart that includes the Deal ID field.



Google Sheets or Excel

Select Filter on the Power My Analytics sidebar and complete the form as follows:
  1. Method: Exclude data.
  2. And/Or: Or.
  3. Select field: Deal ID.
  4. Comparison Operator: Equal to.
  5. Comparison value: Enter the Deal ID number you wish to exclude.
Then click Save.



Each Deal ID number must be added separately. Click Set Filter when you have added all of your deleted Deal ID numbers.


    • Related Articles

    • HubSpot Data Connector User Guide

      <div> <div></div> <div> <div><span style="background-color: rgb(193, 225, 244); border-right: 5px solid rgb(167, 212, 234); margin: 10px 0px; position: relative; display: inline-block; padding: 10px 10px 10px ...

    • How to Connect to HubSpot

      This article will help new subscribers to connect to HubSpot. If you are new to Power My Analytics, begin at our Getting Started page to learn how to activate your free trial and start automating your reports. Before you begin Required permissions ...

    • Why Can't I Create Breakdowns by Objective in Facebook Ads?

      This article will help you learn to make breakdowns by Objective in Facebook Ads. Problem Breakdowns by Objective are available in Facebook Ad Manager, but they are not available in the API. Attempts to create a breakdown by objective will result in ...

    • Create a GA4 Checkout Journey Funnel with Filters

      <div> <div><span class="KB_New_Editor_Highlights" style="background-color: rgb(193, 225, 244); border-right: 5px solid rgb(167, 212, 234); margin: 10px 0px; position: relative; display: inline-block; padding: 10px 10px ...

    • Incorrect Summary Row Whenever Filter Is Applied

      This article will address the following issue: Data in the summary row for Unique fields is incorrect whenever a filter is applied in Looker Studio. This bug only affects Unique fields. Cause This is an issue with Looker Studio and Google Sheets that ...