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).
-
Go to the Salesforce Developer Console > Query tab.
-
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
-
Press RETURN.
-
Select all the IDs and click Delete Row.
-
To identify all the tracker records where Tracker Occurrences equal 0, type:
SELECT Id FROM Gong__Tracker__c WHERE Gong__Tracker_Occurrences__c=0
-
Press RETURN.
-
Select all the IDs and click Delete Row.
-
Login to Dataloader and click Export.
-
Select the Topic object:
Topic (Gong_Topic_c)
-
Set the generated query fields to:
Select Id FROM Gong__Topic__c WHERE Gong__Topic_Duration_Sec__c = 0
-
Click Finish.
A .csv file is created containing all the record IDs of empty topics that can be deleted.
-
Click Delete.
-
Select the Topic object and the .csv file you just created.
-
Click Next and then OK in the field mapping step.
-
Click Create or Edit a Map, and select Auto-Match Fields to Columns to match the ID column with the Id field.
-
Click OK.
-
Click Next and then click Finish.
-
Click Yes to confirm the deletion.
-
Repeat these steps for empty trackers using the following query:
Select Id FROM Gong__Tracker__c WHERE Gong__Tracker_Occurrences__c = 0
