I'm importing "Open Support Cases" and setting a score based on certain criteria for high risk vs. low risk. There are instances when a customer(s) wouldn't appear in the "Open Support Cases" file and I'd like to set a score for when data is "Not Available" for those particular customers. Do I have to take a few steps back and manually add the customers that do not have open support tickets before running the rule I have in place? Is there a way to set a score for a particular measure for specific customers that do not have open support cases?
Thank you in advance,
Jasmine
Question
Setting Scores for Customers that have "Not Available" data
+5Hi Jasmine, in your rule you'll want to query all customers, then merge in the case data to your all customers dataset. That way you'll be able to assign scores to all your customers, not just those with case data available. Let me know if this helps.
Hi Spencer,
Thanks for following up with me on this. I'm going to give this a try and i'll let you know what happens.
Left Merge? Right Merge?
Thanks,
Jasmine
Thanks for following up with me on this. I'm going to give this a try and i'll let you know what happens.
Left Merge? Right Merge?
Thanks,
Jasmine
+5If your Customer data set is the first thing you select in the merge set up, then left merge. You want to retain all your customers.
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.