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: Determines 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 (All data sources), 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.
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||√|
Note: Standard objects are supported while creating CTA lifecycle from Company Object. You can start using MDA data sources such as SFDC Id, GSID, Picklist, Currency, Percentage etc. in rules without having to sync Account or Relationship data from SFDC through separate rules. Scorecard 2.0 related rules would also be easier. In short, you can incorporate Standard objects as sources and perform a wide variety of transformations, merge with SFDC objects, and perform actions.
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 aborted and marked as failed, if it takes more than 8 hours to run. 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: