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.



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

      • Related Articles

      • HubSpot Data Connector User Guide

        HubSpot is a powerful customer relationship management and marketing automation platform that provides valuable insights into your sales, marketing, and customer service efforts. By connecting HubSpot to Power My Analytics, you can automate data ...

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

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