Tutorial Overview

This tutorial walks you through the process of creating a Bionic rule that triggers a CTA to customers without sponsors. This use case demonstrates how NULL values can affect results from the Rules Engine, and how to address them.

This tutorial also demonstrates that by creating a single Bionic Rule, you can achieve goals which were only possible earlier using multiple rules.

Following are the sub-steps in this Bionic rule:

  1. Query Accounts that have Sponsors
  2. Fetch Valid Gainsight Customers
  3. Merge Valid Gainsight Customers
  4. Previewing Sponsors Data from Merge Task
  5. Setup Action

Query Accounts that have Sponsors

In an ideal dataset, one Sponsor per account must be present. This dataset will fetch the total number of Sponsors tracked per account.

  1. Navigate to Administration > Rules Engine.
  2. Click Create Rule.
  3. Select the Rule Type as Bionic, and enter the Rule Name and Description (optional).
  4. Click NEXT.
  5. In the Setup Rule screen, click DATASET.
  6. Enter the Task Name. The Output Dataset Name is populated automatically.
  7. Select Salesforce as the data source and SponsorTracking as the source object.
  8. Drag and drop the following fields to the Show section:
  • Account::Id
  • Sponsor Tracking::COUNT_DISTINCT of Id
  • Account::Account Name
  • Account::CSM

Query Accounts that have Sponsors.png

Fetch Valid Gainsight Customers

In this step, filter the Active Gainsight customers using the CustomerInfo object.

  1. Create another fetch task in the same Bionic rule from the Setup Rule page.
  2. Select Salesforce as the source and CustomerInfo as the object.
  3. Drag and drop the following fields to the Show section:
  • Customer Info::Account
  • Account::Id
  • Customer Info::Account Name
  1. In the Filters section, add the Status = Active filter.
  2. Select Apply to Gainsight Customers Only check box.

Fetch Valid Gainsight Customers.png

Merge Valid Gainsight Customers

Use a Bionic Merge Task to join “Query Accounts that have Sponsors” to the “Fetch Valid Gainsight Customers” list. It's important for the “Fetch Valid Gainsight Customers” to be included as well as a Left Join. In the field highlighted below, Output field name from Data Fetch side was changed to “Account Id_Sponsors”. This is the field that will be recognized in the action to filter the accounts without sponsors.

  1. Create a merge task in the same Bionic rule from the Setup Rule page.
  2. Select the output of Fetch Valid Gainsight Customers with Query Accounts that have Sponsors and select Retain all records on left.
  3. In the Show Fields section, change the Output Field Label of the Account as Account Id_Sponsors.
  4. Click SAVE.

Merge Valid Gainsight Customers.png

Previewing Sponsors Data from Merge Task

After saving the Merge Task, navigate to the Setup Action page and click Run Now as a test run. This is allowed without having to make an action.  


This will identify all of the accounts without sponsors.

You can download the results of the last task to view in rules read only mode > EXECUTION HISTORY.

Preview and Download Results.png

Resulting Data Set from Merge

The resulting data set from the merge task:

Preview .png

Setup Action

  1. Navigate to Setup Action. Click + ACTION and select the merge task.
  2. Select Call to Action from the Action Types.
  • Name:  Used to title your CTA. Type @ to see options available for tokenized comments.
    • Include in identifiers: adds the CTA's name as part of the duplicate checker criteria for the Rules Engine. If there's an existing CTA for an account, but the CTA names have different values, then the rule will create the new CTA. If the CTA names are the same, and the CTA Type and Reason are the same, then a new CTA will not be created. The rule will simply update the existing CTA. The playbook chosen in this step will only be applied if a playbook was not previously assigned.
  • Priority:  Based on previously established Severity Types
  • Type:  Based on previously established Types
  • Status:  Based on previously established Status Types
  • Playbook: Optional.  Based on previously established Playbooks
  • Reason: Based on previously established Reason Types
  • Owner Field: Account::CSM (Your CSM Lookup field added in the previous step)
  • Due Date: Run Date + x Days.  Drop-downs below address treatment of weekends.
  • Default Owner: Lookup field of all SalesForce Users. This will be used if the Task Owner field is not filled in OR if an account has not been assigned an owner.
  • Link to an existing "Linked Object": Multiple relevant objects can be linked in a rule. All Linked Objects that are linked to the CTA type, will be available in the drop-down. When a linked object is selected from the drop-down, Admins can choose the field to which it should be linked from the Show fields.
  • Post Update to Chatter: Used to control the frequency of Chatter updates.
  • Post Update to Comments: Used to control the frequency of Comments updates.

Note: For the above fields, you can select the update frequency as Once, Always, or Never. If Once is selected, Chatter/Comments will be updated for the CTA only the first time the rule is run. If Always is selected, Chatter/Comments will be updated for the CTA every time the rule is run, and if Never is selected, Chatter/Comments will not be updated when the rule is run. These settings do not prohibit users from posting comments on Chatter as often as they like; they just control how rules update the CTA.

  • Comments: Optional and shows up in the comments section of the CTA. Type @ to see options available for tokenized comments
  1. In the Criteria section, add the following criteria and select the checkbox to include records where Count of Sponsors is null.
    • Count of Sponsors =  Value = Null value
  2. Click SAVE.

This action will trigger CTAs to the CSMs, for all the accounts without sponsors.

Setup Action.gif

Gainsight recommends scheduling the rule to run Everyday Night. For more information, refer Scheduling and Executing Rules.