We have one question on our survey that goes as follows:
"Please provide any additional feedback that may help us improve your customer experience."
This is a text-only question. I am trying to make a CTA right from the Survey based on this question NOT being NULL. However, the question is not showing up in the list of options under the CTA tab of the survey.
Anyone know to accomplish this?
Solved
Can you make a CTA if comments are present on a comment-only question?
Best answer by seth
Actually, in this case, you can get away with using a Data Space to do all the Joins for you, which is easier than rigging up the Joins manually in the Bionic Query.
I have a Data Space based on the "Survey User Answer" object, so that I can easily get access to info like the Participant's Contact ID and Account ID, and the Question info.
The "Answer Text" field in "Survey User Answer" is the one that will be populated if they responded to the open-ended question.
View originalI have a Data Space based on the "Survey User Answer" object, so that I can easily get access to info like the Participant's Contact ID and Account ID, and the Question info.
The "Answer Text" field in "Survey User Answer" is the one that will be populated if they responded to the open-ended question.
I would enable survey flattened reporting for the survey then create a rule based on the MDA object that is automatically created. The rule filters could then look for a not null value in the desired field. At that point you can add an action to create the CTA.
+7Agreed with Britton, except Bionic Rules allow you dodge around survey flattening by doing all the joins within the Rule.
You're probably right, Seth, and that would keep your instance of Gainsight cleaner. I find it's easier and simpler to set up with the survey flattening method though. Depends on what your priorities are I guess.
+7I admit I have an unhealthy and beyond-logical affinity for table joins
Program Director, CS Innovation @ Gainsight
1 person likes this
So if I am reading this right, I would just do a join of the table that has the comments and the table that has the questions? I'll have to review the object glossary to find the exact tables, but I do get what you are saying. I just don't know the backend MDA tables for Surveys as well as I do for other areas.
Thanks!
Thanks!
+7Actually, in this case, you can get away with using a Data Space to do all the Joins for you, which is easier than rigging up the Joins manually in the Bionic Query.
I have a Data Space based on the "Survey User Answer" object, so that I can easily get access to info like the Participant's Contact ID and Account ID, and the Question info.
The "Answer Text" field in "Survey User Answer" is the one that will be populated if they responded to the open-ended question.
I have a Data Space based on the "Survey User Answer" object, so that I can easily get access to info like the Participant's Contact ID and Account ID, and the Question info.
The "Answer Text" field in "Survey User Answer" is the one that will be populated if they responded to the open-ended question.
Program Director, CS Innovation @ Gainsight
1 person likes this
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.