As stated above, I am trying to create a report for management that shows a list of their teams accounts that don't have an Open CTA.
Is this possible? It might not be with the current data I have via the Call to Action object, but I was wondering if anyone has found a work-around for this? I know it's difficult to report on an abscence of data in Gainsight.
Thank you for the help!!
Solved
How to create report for Accounts without an Open CTA
Best answer by toddmassey
The work around I've used in the past was like this:
1) create a boolean field on Customer Info (defualted to false)
2) Create a rule that fetchest this data Set fetch count of CTAs, with a filter for status that are open to your organization
3) Then an action that wrties to customers, and maps to the field for ctas. If CTA Count > 0 set the new field to True, if it's 0 set it to false.
View original1) create a boolean field on Customer Info (defualted to false)
2) Create a rule that fetchest this data Set fetch count of CTAs, with a filter for status that are open to your organization
3) Then an action that wrties to customers, and maps to the field for ctas. If CTA Count > 0 set the new field to True, if it's 0 set it to false.
+5The work around I've used in the past was like this:
1) create a boolean field on Customer Info (defualted to false)
2) Create a rule that fetchest this data Set fetch count of CTAs, with a filter for status that are open to your organization
3) Then an action that wrties to customers, and maps to the field for ctas. If CTA Count > 0 set the new field to True, if it's 0 set it to false.
1) create a boolean field on Customer Info (defualted to false)
2) Create a rule that fetchest this data Set fetch count of CTAs, with a filter for status that are open to your organization
3) Then an action that wrties to customers, and maps to the field for ctas. If CTA Count > 0 set the new field to True, if it's 0 set it to false.
1 person likes this
Thanks for the explanation! Haha this looks way easier than what I was setting up. I went the route of creating a full MDA object that I was loading accounts without a "New" CTA status, but your way is definitely quicker to implement!
+2Hi Manmeet - does this report need to live in a dashboard and be accessed on an ongoing basis or is this just a one off report request?
You really can't do this just in report builder, so you'd need to do this via a bionic rule. If it's just a one off report, you could run that rule and then just download the results as a csv. If it's an ongoing need, then you could push that data into an MDA table or use the method Todd mentioned below.
We are working on a new reporting engine that will bring the advantages of bionic rules to reporting, and when that happens, the scenario you described would be easy. :)
You really can't do this just in report builder, so you'd need to do this via a bionic rule. If it's just a one off report, you could run that rule and then just download the results as a csv. If it's an ongoing need, then you could push that data into an MDA table or use the method Todd mentioned below.
We are working on a new reporting engine that will bring the advantages of bionic rules to reporting, and when that happens, the scenario you described would be easy. :)
VP of Customer Success at Forcepoint
1 person likes this
Hi Dan,
This report will be on a Manager dashboard, so it would need to update regurarly.
Looking forward to that new reporting engine though! It's been tough to report on abscense of data like this without bionic rules and new custom fields/objects being involved.
I went ahead with the suggestion outlined by Todd, that helped a lot! Thanks for following up too.
This report will be on a Manager dashboard, so it would need to update regurarly.
Looking forward to that new reporting engine though! It's been tough to report on abscense of data like this without bionic rules and new custom fields/objects being involved.
I went ahead with the suggestion outlined by Todd, that helped a lot! Thanks for following up too.
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.