Skip to main content
Gainsight Inc.

Transformation Tasks in Rules Engine

Gainsight NXT

This article supports Gainsight NXT, the next evolution of the Customer Success platform. If you are using Gainsight CS Salesforce Edition, you can find supporting documentation by visiting the home page, and selecting CS > Salesforce Edition.

Not sure what your team is using? Click here.

 

This article explains about how you can create Transformation tasks in Rules Engine.

Advantages

  • A very powerful aggregation machine in Rules Engine.
  • Enables you to summarize data in various methods.
  • Enables you to aggregate data, apply various formulae on data. For more information about the Formula Fields, refer to the Formula Builder in Rules Engine article.   

Matrix data_1.png

  • A Rule is demonstrated here and in this rule you can count unique Page views for every page by different customers.

Create Rule

  1. Navigate to Administration > Operations > Rules Engine.

0C2BC3EC-F471-4605-876A-FA62CA593290.GIF

  1. Click +RULE.
  2. In the Create Rule screen, enter:
  • Rule For: Company
  • Rule Name Use Case
  • Folder: Select a folder for the rule.
  • (Optional) Description: Enter a description for the rule.

50318077-DE00-46D0-B441-7DE544E8CBB9.GIF

  1. Click NEXT. The Setup Rule screen is displayed.
  2. Click DATASET.

Snag_1d705610.png

Configure DataSet (Fetch Task)

  1. In the Dataset task, enter:
  • Task Name
  • (Optional) Task Description  
  1. Select Usage Data as the source object.
    Note: Usage Data is a Custom object. If you do not find this Object in the Objects list, you have to create the Object. Refer the Gainsight Data Management article to learn how to create, Custom Objects, Custom fields, and insert data into Custom fields.

Usage data.gif

  1. Add the following fields, in the Show section.
  • Date Field
  • GS Created Date
  • GS Modified Date
  • Views
  • Page name
  • Company Name
  1. Click SAVE.
  2. Click <- , to go back.

Save.gif

Transformation Task - Data Aggregation

In the aggregation task,  page views are aggregated against Company and Page name, in order to view unique page views for every page by various customers.

  1. In the Setup Rule screen, navigate to + TASK > Transformation.

Transformation_7.png

  1. Enter:
  • Task Name
  • (Optional) Task Description
  1. Select Fetch data as source object of dataset.
  2. Add the following fields to the Show section:
  • Company Name
  • Page Name
  • Views
  1. Add Company Name to the GroupBy section.

Groupby_8.gif

  1. Select Count_distinct of views for Views field, in the Show section.

Distinct of views_9.gif

  1. Click SAVE.

You can now setup an Action on the output dataset.

See Also:

  • Was this article helpful?