Has anyone successfully written a report or built a CTA to fire when the Number of Contacts tracked in Sponsor Tracking is 0? We haven't solved for this one yet, mainly because Gainsight (and a lot of force.com, for that matter) cannot detect the absence of something.
My leadership team wants to see how many customers have 0 tracked contacts, and then to fire a CTA when this occurs so it can be remediated.
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Your rule will count the # of records in the 'SponsorTracking' object (by doing a COUNT on ID) and then you can map that value into CustomerInfo.
Then you can use that value on CustomerInfo to create your CTA rule.
One thing to note: If for some reason you had Sponsors tracked and then all of the Sponsors became untracked (so you had a value but now you have null) then your value will persist in CustomerInfo (because there's nothing to overwrite the value). So you may want to consider adding a rule that resets all the CustomerInfo values to 0 before running the rule described above.