---
title: "Remove empty tracker and topic records"
slug: "remove-empty-tracker-and-topic-records"
updated: 2024-04-16T07:22:51Z
published: 2024-04-16T07:22:52Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.gong.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Remove empty tracker and topic records

Gong for Salesforce creates topic and tracker records in the context of each Gong Conversation in Salesforce. Reduce Gong for Salesforce's data storage consumption by deleting empty tracker and topic records, i.e. those that contain either no duration (topics) or no occurrences (trackers).

There are two ways to remove the records: through Salesforce Developer Console, or using Salesforce Data Loader (or similar tools).

## Remove empty tracker and topic records via Salesforce Developer Console

1. Go to the Salesforce Developer Console > **Query** tab.
2. To identify all the topic records that have the **Topic Duration (Sec.)** equal **0**, type:

**SELECT Id FROM Gong__Topic__c WHERE Gong__Topic_Duration_Sec__c = 0**

![Salesfoce_remove_empty_records](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883047180557.png)
3. Press RETURN.
4. Select all the IDs and click **Delete Row**.
5. To identify all the tracker records where Tracker Occurrences equal 0, type:

SELECT Id FROM Gong__Tracker__c WHERE Gong__Tracker_Occurrences__c=0
6. Press RETURN.
7. Select all the IDs and click **Delete Row**.

## Remove empty tracker and topic records via Salesforce Data Loader

1. Login to Dataloader and click **Export**.
2. Select the Topic object:

**Topic (Gong_Topic_c)**

![Salesfoce_remove_empty_records2](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883053958541.png)
3. Set the generated query fields to:

**Select Id FROM Gong__Topic__c WHERE Gong__Topic_Duration_Sec__c = 0**

![Salesfoce_remove_empty_records3](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883062899981.png)
4. Click **Finish**.

A .csv file is created containing all the record IDs of empty topics that can be deleted.
5. Click **Delete**.
6. Select the Topic object and the .csv file you just created.

![Salesfoce_remove_empty_records4](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883078345101.png)
7. Click **Next** and then **OK** in the field mapping step.
8. Click **Create** or **Edit a Map**, and select **Auto-Match Fields to Columns** to match the ID column with the Id field.

![Salesfoce_remove_empty_records5](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883078408333.png)
9. Click **OK**.
10. Click **Next** and then click **Finish**.
11. Click **Yes** to confirm the deletion.
12. Repeat these steps for empty trackers using the following query:

**Select Id FROM Gong__Tracker__c WHERE Gong__Tracker_Occurrences__c = 0**

![Salesfoce_remove_empty_records6](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/24883070848269.png)