Skip to main content
Gainsight Inc.

Rules Engine - Prerequisite Knowledge and Limitations

Prerequisite Knowledge

This article provides you the prerequisite knowledge to start using Rules Engine and the limitations.

Before you begin building Rules in Gainsight, it is helpful to know the following:

  • Understanding of Vlookup and Joins for Merge Tasks
  • Gainsight Object Glossary

Additionally, you must be familiar with basic Gainsight objects, to some extent. The three very basic objects are Company, User, and Person.


The following table lists the limitations that are applicable to all the Rules:

Description Limitation Additional Info
Maximum number of tasks allowed 15  
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 10  
Maximum number of filters allowed in each task and action 26 No limits in action filters
Task Name length 80 Alphanumeric, _ and space are supported here
Task Description 200 All characters
Output Dataset Name 60 Alphanumeric, _ and space are supported here
Maximum number of Actions allowed 50  
  • By default, Gainsight provides a name to Dataset and S3 Dataset. However, if you modify the default name and if the modified name contains a reserved keyword, you must modify the Output Field Label name before clicking SAVE, otherwise it displays an error message.
  • Merge task does not support filters. 

The following table lists various collections which are supported/not supported in Rules Engine.

Object Type Supported in Rules Engine
Standard objects Yes
Maximum number of Show fields in each task Yes
Unsubscribed Emails Yes
Email log Yes
Email RAW events Yes

The following table displays the limits at the fetch level in Rules Engine:

Fetch Data From Record Limits
Fetch data from SFDC - Largest org 6.3 Million
Fetch data from Gainsight - largest dataset 2 Million
Processing 6 Billion

Note: The rule will be aborted automatically by the system and marked as failed, if it takes more than 3 hours to run. Gainsight recommends that you 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 available in the rules. It gives basic information along with the task flow diagram.
  • Rules at Company 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 Company level, Rules do not support the Send Email action, since Journey Orchestrator is used for this.
  • In the Pivot task, 50 measures + 200 columns are allowed on a single Pivoted field.
  • Transformation task supports date functions in Group by like Day, Week, Month, Quarter and Year.

Rules Processing

Gainsight follows the following points for Bionic rules to process:

  • Disable Bionic Rules: Rules are disabled in the following scenarios and an email notification is sent to the Admins if the

    • Rules which fail to run three times consecutively
    • Any Data Highway failures such as if any fields are deleted from Salesforce, Malformed Query, and invalid query filter operator.
  • Skip other Instances of a Rule in Queue: Gainsight does not add another instance of the rule to the queue if an instance of a Rule is already present in the queue for execution. For example, consider a rule that is scheduled to run every 2 hours. In this rule, if the rule that needs to run at 6 AM is not completed it's run even by 8 AM then the rule which is scheduled to run at 8 AM is skipped. If that rule completes its run by 9 AM then the rule which is scheduled to run at 10 AM is not impacted.

The following are the benefits of this change in processing the rule:

  • Overall waiting time of a Rule in the queue is minimized.
  • Any sub-optimal schedules are automatically taken care of.

Additional Resources

Rules Engine Path Articles - A series of articles that help you easily understand and start building rules.


  • Was this article helpful?