This article explains the basics of how Survey Flattening operates within Gainsight. By default, survey response data is spread out among several objects. Survey Flattening places this information into a single MDA object formatted with survey respondents in rows and each question in its own column to allow for easy reporting and insights into survey data.
Enable Survey Flattening
Survey Flattening is enabled by default for Survey 2.0. An object containing response data for the survey will be created after the survey receives its first response. To create a report on a flattened survey 2.0 object, navigate to Administration > Report Builder, and select the object with the same name as your survey.
Surveys that are migrated from survey 1.0 to survey 2.0 have their dedicated survey flattened table in MDA. These survey flattened objects are labeled as MIG-XXX.
Reset Flattened Table
The MDA table created through this process will flatten new data automatically through a job running in the background.
Users can also manually refresh the table with up-to-date data. Click Reset Flattening, to reload the data for that specific survey. You can see a message displaying ‘Request to reload data in MVP NPS® Survey initiated, will be notified via email once done’ at the bottom of the page. Here, 'MVP NPS® Survey' in the message is the name of the survey.
Once the data is reloaded, you will receive an email notification.
Using Flattened Labels
A flattened survey will have each survey question saved as a separate column within the flattened MDA table. By default, the header of this column will be the full text of the survey question. Since the full length of a question would often be difficult to display in a report, users have the option to change the label of the question column.
Flattened objects based on Survey 2.0 surveys will have the same name as the survey. It is not possible to change this object name at this time.
You can update the label of any survey question within the flattened object by editing the questions Flattening label. To access the Flattening label, navigate to Survey 2.0 > Design > edit the question and update the Flattening Label text under Settings.
For more information on editing 2.0 survey questions, refer to Survey 2.0 Design.
|NPS, Net Promoter, and Net Promoter Score are registered trademarks of Satmetrix Systems, Inc., Bain & Company and Fred Reichheld.|