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.

Data Studio

Select a chart that contains the field Deal ID. 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. Description: Type something you can remember. In this example, I used the Deal ID number I will exclude.
  4. Select field: Deal ID.
  5. Comparison Operator: Equal to.
  6. Comparison value: Enter the Deal ID number you wish to exclude.



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


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • HubSpot Data Connector User Guide

        The following article is a guide for automating reports with your HubSpot connector. It includes metrics available and how to connect, backfill, and blend your HubSpot data. To create a HubSpot report, you will need access to at least one or more ...

      • 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 Check your HubSpot plan ...

      • How to Create a Report in Data Explorer

        Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your ...

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

        This article will help you learn to make breakdowns by Objective in Facebook and Instagram 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 ...

      • 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 ...