Skip to main content
Gainsight Inc.

MDA Joins

Gainsight NXT

 

This article explains to admins about how to configure lookup relationships on Gainsight data fields so that users can use MDA joins efficiently.

Overview

MDA joins are used to connect two different Gainsight objects, so that you can create rules or reports on these objects. Admins can create MDA Joins by creating a lookup relationship between two different Gainsight objects. Admins can join the following type of objects in Gainsight:

  • Two standard objects
  • Two custom objects
  • Standard object to custom object
  • Custom object to standard object

Business use case: Admins can use MDA Joins to merge data of Survey and Company objects: 

  • To create a report on the Survey Responses recorded by each Industry.
  • To create a rule for Company and count of Survey responses received over the last 7 days for specific industries.

Prerequisites

  • Gainsight supports creating lookup relations only on the Gainsight objects for which joins are allowed.
  • You can apply MDA joins on two Gainsight objects, if the objects have the ’Joins allowed’ property as ‘true’.
  • The lookup relation between the two objects can be defined only on the GSID, String, and Email data type fields.
  • Decide what needs to be put in your join table: typically the Company ID, Name, CSM information, other attributes, etc.
  • At least one field that is an external identifier to your company data in Gainsight is necessary to integrate your external data with Gainsight data.

Add Lookup on a Gainsight Object

To add lookup on a Gainsight object:

  1. Navigate to Administration > Customer Data > Data Management (BETA). The Data Management page is displayed.
  2. In the Objects tab, click the three-vertical dots menu of the Object and select Edit Object. The Objects Informations page is displayed.
  3. (Optional) Modify the Object Display Name and Description
  4. Click Next.
  5. Click the Expand icon to view the details of the Field.
  6. Click Show Advanced Options. The Advanced Options page is displayed.
  1. Select any of the following fields from the dropdown list to which you would like to create a lookup relation
Fields Information
Object Select the source Object to ingest data into this field.
Field The corresponding fields of Object are displayed in this field. Select the source field to which lookup is added from the current field.

On Delete

This field helps you to reset the records, when the corresponding lookup record is deleted. This field has three options:

  • Delete: When the lookup record is deleted, the corresponding record in the current object is deleted.
  • Set Null: The corresponding value in the current field is set to Null when the lookup record is deleted.
  • None: When the lookup record is deleted, no action will be taken in the current object.
  1. Click Save.

Notes:

  • By default, when you apply a lookup relation, LEFT OUTER JOIN is performed.
  • A LEFT OUTER JOIN is performed on a base collection (the collection selected as data source).
  • You can create a lookup relation on the objects up to two sub-levels. For example, Case Data > Company > Active User, where Case Data has a lookup relation on Company, and Company has a lookup relation on Active User. You cannot have a Gainsight Object containing lookup relation at the third sub-level such as Active User cannot have a lookup relation to any other Gainsight object.
  • MDA Joins can be performed on the GSID, String, and Email data type fields.
  • Was this article helpful?