Remove Test Survey Data

Hi Lane!  You can do this via a tool such as Workbench or Jitterbit by querying the Survey Response table then deleting records tied to the survey.  If you'd like me to walk to you through it, feel free to reach out to me via email and we can set up a time.

smorris@gainsight.com

For anyone else curious, we used Developer Console to delete all survey responses and participants to the specific surveys.  We deleted all records from both objects as they were just test records.  If you are deleting these for specific surveys, a WHERE clause would need to be added to the delete line.

1.  delete [SELECT Id FROM JBCXM__SurveyResponse__c];

2.  delete [SELECT Id FROM JBCXM__SurveyParticipant__c];

Hi Scott - had a question about your response. What is the functional difference between a SurveyResponse and a SurveyParticipant? I'm looking into different ways to query the system and wasn't sure how these two objects differentiated and worked

Hi Billy:

If you're using the standard Survey functionality (not Copilot) then here are how the objects interact:

When you add participants to the survey, they are added as records in the JBCXM__SurveyParticipant__c object.  Once they respond, their answer (with a lookup to the Participant object), is store in the JBCXM__SurveyResponse__c object.

Let me know if this helps.

Scott

Gotcha - that makes sense! Thanks Scott. How about in the Copilot scenario? 

In the case of Copilot, the response record is created in the same fashion, however the participant record isn't created until the user responds to the survey.  

Got it. Thanks again Scott! 🙂

HI Scott,
Are there plans to allow for deletion of survey's through your interface? Seems that it would be more efficient than to do hard queries.

Thanks
Richard

Agree with Richard. Capability to delete an unwanted survey is needed.

One added note, I deleted the Survey Response and Survey Participant records, and was then able to delete the survey via the UI. Apparently the survey is not really deleted, because it was appearing in the reports on the NPS tab dashboard. So I had to hard delete the survey record from the NPS Survey Master object.