I was able to accomplish this by creating a check box field on the Customer Info object called Active Success Plan, and then, I wrote a rule to check the box when there was an active Success Plan. I was then able to build reporting to show total accounts assigned to CSM and a true/false value based on whether or not they had an active plan.
https://support.gainsight.com/hc/en-us/articles/216458907
Is it possible to find accounts with or without Success Plans without changing anything on the Customer info object?
Two ways you can do this is to have a checkbox on Company object and then build a rule on success plan object. If any company has a success plan then you can check the box and similarly for companies without success plan, the box remains unchecked.
The other way is to build a data designer and in first fetch, bring all records from company and in 2nd fetch bring the data from success plans. Use left outer join in your merge and you’ll now have visibility into the accounts that do not have a success plan.
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.