Skip to main content
Gainsight Inc.

Transformation Tasks in Rules Engine

Gainsight Standard Edition
This article supports Gainsight Standard Edition. This Edition is built on Gainsight's state of the art Matrix Data Architecture (MDA) platform, and is designed for customer success professionals for driving revenue, increasing retention, and scaling operations. To learn more about Gainsight Standard Edition, click here.

If you are using Gainsight Salesforce Edition, which is built on Salesforce and customer business data is stored in SFDC, you can find supporting documentation 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.

Create rule_2.gif

  1. Click +RULE.
  2. In the Create Rule screen, enter:
  • Rule For: Company
  • Rule Name Use Case
  • (Optional) Description

Rule Name_3.gif

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

Creating first dataset.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?