Skip to main content
Gainsight Inc.

Export Reports & Report Limits

This article focuses on the export options and limitations in the Report Builder.

Export As Excel

Export As Excel

To export a report as Excel, click on the setting icon in the report builder or home page layout and click the "Export as Excel" option as shown above.

Notes:

  • Export as Excel will be available only when tabular visualization is enabled.
  • Export as Excel will only export a maximum of 1000 records.
  • Processing of Export as Excel works in MDA and hence connectivity to MDA has to be established to use the export functionality. To export your tabular data as excel, ensure that you enable 'Exporting services' option in Administrator > Matrix Data Architecture Settings > Exporting services.
  • Processing of Export as Excel also works with SFDC objects.
  • HTML tags (div, p, br, and so on) are supported in new line formatting when you export a report to CSV or Excel.
  • While exporting a report to an Excel file, the filters applied to the reports are also exported.

Notes:

  • Export of filters is supported only for Report Builder and Dashboards.
  • Filters are not exported when you export a report from the Report drill-down.

Export as Image

Export as Image

To export a report as image, click the setting icon in the report builder or home page layout and click the "Export as image" option as shown above.

Notes:

  • Export as image will be available only when graphical visualization is enabled.
  • Processing of Export as image works in MDA and hence connectivity to MDA has to be established to use the export functionality. To export your graphical report as image, please ensure that you enable the Exporting services option in Administrator > Matrix data architecture settings > Exporting services. (Same as previous)

Report View and Export Limits

The following are the reporting preview and export limits in Report Builder, Gainsight Home Dashboards, C360, and Account/Oppty widgets:

Reports (in Report Builder) built on SFDC objects:

  • Export to Excel - 2000 rows
  • Export to CSV - 100k rows

MDA reports:

  • Export to Excel - based on tenant configured limit, can vary between 1000 and 5000 (max.)
  • Export to CSV: 500K rows (Redshift)

Report Builder:

  • “Show me” field limit: 10 fields if there is 1 or more by fields
  • “By” field limit: 5

Report timeout:

  • SFDC: 60 or 120 seconds (SFDC Rest API response can have maximum of 5MB of data as response).
  • MDA: 30 seconds (Mongo can have maximum document data as 16MB).

Dashboard Export

  • SFDC: PPT max record 100 with 10 slides
  • Max. # of reports per Gainsight Dashboard: 20

Other limits:

  • Summarized by limits (SFDC) days-NA, Week-12, Month-13, Qtr- 5, Year-2 Maximum Limit for Decimal Values supported
  • Applicable for both SFDC and New Stack - Decimal places should be supported for 9 digit only
  • Max. # of reports per GS Dashboard: 20
  • Was this article helpful?