Before you begin building Bionic Rules in Gainsight, it is helpful to know the following, or to work with your Salesforce Admin to understand:
- Where is your usage data stored and how is it integrated? (Native/SFDC, Matrix/MDA, or Dataspaces)
Note: Contact Gainsight Customer Support to enable Redshift.
- What is the usage data loading frequency, granularity, and data week?
- weekly or monthly: will determine whether to sum/avg or max/min, and so on.
- granularity: user level, instance (product) level, or account level
- data week: Sun - Sat, or Mon - Sun
Additionally, you must be familiar with Salesforce and Gainsight objects, to some extent:
- Salesforce objects: Most SFDC objects only contain the present state of data.
- CustomerInfo object: The equivalent of the Account object; it only contains the present state of data. Purpose of CustomerInfo object in Gainsight is to assemble various customer data in one object. During implementation, Gainsight makes a mirror record if your account records on the CustomerInfo object.
- Usage data object: Gainsight's usage data object contains historical data on the usage and engagement measures you choose to track, as well as weekly or monthly snapshots of your current usage data.
- MDA/Matrix Data: In order to access the Data Management console, and be able to view and load data, a user must have access to the Visual Force Page JBCXM.COM.
- Gainsight Objects to Field Map: Navigate to Setup > Installed packages > click JBCXM > View Components. The list of all Apex Classes, VF Pages, Objects and Fields that are part of our Managed Package will be displayed.
The following table lists the limitations that are applicable to with all Bionic Rules:
|Maximum number of tasks allowed||10|
|Maximum number of Show fields in each task||50||In Pivot task, 200 cases can be used to pivot on a field|
|Maximum number of Group by fields in transformation tasks||5|
|Maximum number of filters allowed in each task||26||No limits in Action filters|
|Task Name length||80||Alphanumeric, _ and space are supported here|
|Task Description||200||All characters|
|Out Dataset Name||60||Alphanumeric, _ and space are supported here|
Fetch tasks support data sources from SFDC, MDA (Redshift Only), and Data Spaces.
Each field in every task can have a field label input by the user which will be used as a field alias while querying and as a header in the csv result. While querying from usage data, if any of these field aliases contains reserved keyword, you must modify the Output Field Label name before clicking SAVE, otherwise it displays an error message.
Picklist and Multipicklist includes/excludes filtering is supported with MDA.
Transform tasks include Merge, Pivot, and Aggregation.
Merge task does not support filters. Transformation and Pivot Tasks support filters.
Since MDA Join is not supported in a Bionic fetch task, you need to create two fetch tasks if you want to include both the scorecard fact and company, and merge the data in a third task.
- In Bionic Rules, you will not be able to set scores for scorecards created using Scorecard 2.0 option. The Set Score 2.0 option will not be available in the list of Actions. For this purpose, Gainsight recommends using Custom Rules to set the score for Scorecards 2.0.
- Bionic Rules are not allowed in Rule Chains. (Note: Bionic Rules will soon be allowed in Rule Chains.)
The following table lists various collections which are supported/not supported in Bionic Rules.
|Object Type||Supported in Bionic Rule?|
|Email RAW events||X|
|Segment Raw Collection||X|
|Mixpanel Raw Collection||X|
|GA Raw Collection||√|
Following are the limits at the fetch level in Bionic Rules:
|Fetch data from||Record limits|
|Fetch data from SFDC - Largest org||6.3 million|
|Fetch data from MDA - largest dataset||2 million|
|Note: The rule will be stopped from execution if it takes more than 8 hours and it will be marked as failed. Gainsight recommends you to start with 2 million records for processing the fetch task.|
- Action filter is case sensitive and it does an unresponsive check.
- Rules Preview does not show the detailed information of every task present in Bionic rule. It gives basic information along with the task flow diagram.
- Rules at Account level do not include the absence of data feature. It is not needed as users can create multiple tasks, merge data, and the rule will transform tasks.
- At the Account level, Bionic Rules do not support the Send Email action, since CoPilot is used for this.
- In Pivot, 50 measures + 200 columns are allowed on 1 Pivoted field.
- Transformation task supports date functions in Group by like Day, Week, Month, Quarter and Year.
The following articles walk you through the basic steps to create a Bionic Rule: