Skip to main content
Gainsight Inc.

Limits and Constraints of Gainsight Data Management

Overview

Gainsight Data Management is a component of the Gainsight application that enables administrators to create and manage Matrix Data Objects. As an analogy, a Matrix Data Object and its field(s) can be thought of as a database table and its columns.

This document lists various limits and constraints that exist around usage of Gainsight Data Management (GDM) and to help prevent GDM Customers and Support Teams from hitting multiple failure scenarios while performing activities such as data ingestion, object/field creation, etc.

Object and Field Level Limits/Constraints

Serial No. Limit / Constraint Value
1. Constraints around naming conventions of objects Should be unique within a Tenant
2. Constraints around naming conventions of fields/columns i.e. Display Name Should be unique within an object
3. Maximum number of fields/columns allowed in an Object (Either Standard or Custom) 200 (Recommended)
4. Maximum file size while creating a Custom Object using CSV through the option Data File Upload (CSV) 1 MB
5. Maximum number of records that can be displayed per page (applicable to All Objects view, Object specific view & Data view) 100 per page and 1000 in total
6. Decimal Places Max number of decimal places is 9 (This parameter is used for display up to number of decimal places in Reporting)
7. Maximum number of fields allowed in a formula field in GDM 26
8. Operators Supported by Basic Formula Builder +,-,*,/,(,)
9. Maximum file size while using Import Data option for data ingestion 1 MB
10. Field Names
  • A field name for a custom field is the display name appended by __gc and all the special characters will be trimmed (underscore is not trimmed).
  • Display name can be alphanumeric but it should not start with a number 
  • Display name should not contain numbers only.

Example:

Display Name Field Name
Customer123 Customer123__gc
Ernst&Young ErnstYoung__gc

    1234 Field name will not be created

  • A field name for a standard field is same as the display name

Data Type Constraints

The following table highlights the Data Types supported by GDM and constraints around the definition of these data types.

S. No. Data Type Constraints
1. String 255 Characters
2. Boolean 0 or 1; true or false
3. Number A whole number or number with decimal places
4. Date
Supported formats (Click here to expand the list)
M-d-yy
MM-d-yy
M-dd-yy
M/d/yy
MM/d/yy
M/dd/yy
MM-dd-yyyy
yyyy-MM-dd
yyyy-M-d
M-d-yyyy
MM/dd/yyyy
yyyy/MM/dd
yyyy/M/d
M/d/yyyy
yyyyMMdd
M/dd/yyyy
MM/d/yyyy
M-dd-yyyy
MM-d-yyyy
 
5. Date Time
Supported formats (Click here to expand the list)
M-d-yy HH:mm
MM-dd-yy HH:mm
MM-d-yy HH:mm
M-dd-yy HH:mm
M/d/yy HH:mm
MM/dd/yy HH:mm
MM/d/yy HH:mm
M/dd/yy HH:mm
yyyy-MM-dd'T'HH:mm:ssZ
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
yyyy-MM-dd'T'HH:mm:ssz
yyyy-MM-dd HH-mm-ss
yyyy-MM-dd HH:mm:ss.S
yyyy-MM-dd:HH-mm-ss
yyyy-MM-dd'T'HH:mm:ssSSS
yyyy-MM-dd HH:mm:ss
MM-dd-yyyy HH:mm:ss
yyyy-MM-dd'T'HH:mm:ss
MM/dd/yyyy HH:mm:ss
M/dd/yyyy HH:mm
MM/dd/yyyy HH:mm
MM/d/yyyy HH:mm
M/d/yyyy HH:mm
M-dd-yyyy HH:mm
MM-dd-yyyy HH:mm
MM-d-yyyy HH:mm
M-d-yyyy HH:mm
yyyy-MM-dd'T'HH:mm:ss.SSSZ
yyyy-MM-dd HH:mm:ssZ
 
6. SFDC ID 15 or 18 digit alpha-numeric string (Stored in 18 digits always)
7. Email
  • Presence of @ and '.'
  • After '@', It should not start with any special character
  • It should have at least 1 character before and after '.' and '@'
8. Rich Text Area
  • A maximum length of 15000 characters can be defined for this field. After data is ingested into this field, Admins can increase the maximum length of text in the field up to 15000 characters (if it was not already defined to 15000 characters) but cannot decrease it.
  • A default value cannot be assigned on this field.
  • This field does not support MDA Joins and update keys.
9. Percentage

Data Entry/Ingestion Format:

  • Number only
  • Number with decimals
  • Number with percentage symbol
Input Output
0.1 10%
10 100%

 

10. Currency
List of currencies supported (Click here to expand the list)
United States Dollar (USD)
Indian Rupee (INR)
European Currency (EUR)
Great Britain Pound (GBP)
Australia Dollar (AUD)
Brazil Real (BRL)
Canadian Dollar (CAD)
Switzerland Franc (CHF)
Israel Shekel (ILS)
Mexico Peso (MXN)
New Zealand Dollar (NZD)
Russian Ruble (RUB)
Chinese yuan (RMB)
 
 
  • Number format supported: Number / Number with decimals
  • Comma separator:  Only 1000 separator
  • Data Entry/Ingestion Format - 1000$, $1000, 1000, USD 5000, "USD 5,000.8234"
  • Data Storage Format :1000
  • Data Display Format : $ 1,000, $ 5,000.05896
9. Default Value
  • String: String field can have a default value with alphanumeric characters. Ex: "NA" or "OTHER"
  • Number: Number field can have any numerical value as a default value. Ex: 10.00 or 10 or -10
  • SFDC Id: SFDC Id can have salesforce Id of 15 digits or 18 digits as a default value. Ex: 003i000000NYZrg or 003i000000NYZrgXYZ
  • Email: Email can have a valid email address as a default value. Example: support@gainsight.comgainsightadmin@yourcompany.com
  • Percentage: Following formats are accepted as the default value for a percentage field.
    • Number with percentage symbol (10%)
    • Number without percentage symbol (0.1)
    • Number with decimal values (12.33%)
  • Currency: Following formats are accepted as a default value for the currency field:
    • Number without currency symbol (100)
    • Number with decimal values (99.72)
    • Number with currency code (USD1000, 1000USD)
    • Number with currency symbol (100$, $100)
  • Dropdown List: one default item can be assigned to a dropdown list category. When this category is mapped to any field of dropdown list data type, the field will be assigned with this default value.
  • Multi select dropdown list: A maximum of six items can be assigned to a multi select dropdown list category. When this category is mapped to any field of multi select dropdown list data type, the field will be assigned with these default values.
10. MDA Lookup Support
Source field data type Join field data type
String
  • String
  • SFDCID
  • Email
SFDCID
  • String
  • SFDCID
Email
  • String
  • Email

 

  • Was this article helpful?