- Print
- DarkLight
- PDF
Delete large number of conversations
You may want to delete a large number of Gong conversations and their associated child records to reduce the amount of data storage used in Salesforce. Gong for Salesforce creates 25-40 records for each conversation, and therefore customers may want to remove older conversations. This article describes how to delete the relevant conversations together with their associated child records.
Note
Only records created by Gong are deleted. No Salesforce records are deleted.
We used dataloder.io, a free online export/import/delete solution (Acquired by Mulesoft), to export the conversations to delete. You can use any tool for this action.
Queries in the article contain explicit dates. Make sure to update these values based on your requirements
We recommend this process instead of a direct deletion of the records, as conversation records are updated over time, for example if trackers are updated. Conversations that are updated by Gong are first deleted together with their associated records and then recreated. This process ensures all the relevant objects are deleted.
Identify records to delete
This section explains how to identify the conversation records you want to delete and export the IDs to a CSV file.
To export a list of conversation IDs to delete using SOQL queries:
Select New Task > Export
Select the Tracker object and click Next
In the Fields pane select Record ID. In the Filters section, build the query that will define which Tracker records to export. This filter should relate to the start date of the Conversation records, through the Gong__Gong_Interaction__r.Gong__Call_Start__c field.
Click + to add the query
Check the selected field and the SOQL query are correct and click Next
Review the summary and click Save & Run
Click the success link to download the .csv file with the IDs of the Tracker records you want to delete
Repeat steps 1 to 7 for all the related conversation child records, and save all the .csv files.
Create the .csv file for the conversation object.
Below are the queries to identify the conversation and child records to be deleted. Adjust the dates as needed.
Export Tracker Ids:
SELECT Id FROM Gong__Tracker__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Export Topic Ids:
SELECT Id FROM Gong__Topic__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Export Interaction Stats Ids:
SELECT Id FROM Gong__Call_Stat__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c > 2020-05-20T00:00:00.000Z
Export Scorecards IDs:
SELECT Id FROM Gong__Gong_Scorecard__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c <
2020-05-20T00:00:00.000Z
Export Participant Ids:
SELECT Id FROM Gong__Call_Participant__c WHERE Gong__Gong_Call__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Gong Related Accounts IDs:
SELECT Id FROM Gong__Related_Account__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Gong Related Contacts Ids:
SELECT Id FROM Gong__Related_Contact__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Gong Related Leads Ids:
SELECT Id FROM Gong__Related_Lead__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Gong Related Opportunities Ids:
SELECT Id FROM Gong__Related_Opportunity__c WHERE Gong__Gong_Interaction__r.Gong__Call_Start__c <
2020-05-20T00:00:00.000Z
Gong Conversation Ids:
SELECT Id FROM Gong__Gong_Call__c WHERE Gong__Call_Start__c < 2020-05-20T00:00:00.000Z
Delete records with IDs in CSV file
This section displays how to delete records in the Tracker object.
To delete the records:
Select New Task > Delete
Select the Tracker object
Click Upload CSV, browse to Tracker IDs.csv file you created in the previous step and click Next.
Review the summary, select Use Bulk API. Click Save & Run.
Review the task execution
Repeat steps 1 to 5 to delete the records for each .csv file.
Update conversation export dates
In Gong, update the date you started importing conversations to Salesforce so that the conversations aren’t exported again.
You must have tech admin permissions to do this.
To update conversation export dates:
Go to Company Settings → Salesforce.
In Export to Salesforce, change the date for Export call data to Salesforce from to the relevant date.
Click Update to save the changes.