Transformation Tasks in Rules Engine
Gainsight NXTThis article supports Gainsight NXT which 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 NXT, 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.
- A Rule is demonstrated here and in this rule you can count unique Page views for every page by different customers.
Create Rule
- Navigate to Administration > Operations > Rules Engine.
- Click +RULE.
- In the Create Rule screen, enter:
- Rule For: Company
- Rule Name Use Case
- (Optional) Description
- Click NEXT. The Setup Rule screen is displayed.
- Click DATASET TASK.
Configure DataSet (Fetch Task)
- In the Dataset task, enter:
- Task Name
- (Optional) Task Description
- 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.
- Add the following fields, in the Show section.
- Date Field
- GS Created Date
- GS Modified Date
- Views
- Page name
- Company Name
- Click SAVE.
- Click <- , to go back.
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.
- In the Setup Rule screen, navigate to + TASK > Transformation.
- Enter:
- Task Name
- (Optional) Task Description
- Select Fetch data as source object of dataset.
- Add the following fields to the Show section:
- Company Name
- Page Name
- Views
- Add Company Name to the GroupBy section.
- Select Count_distinct of views for Views field, in the Show section.
- Click SAVE.
You can now setup an Action on the output dataset.
See Also: