Mapping CX Dashboard Data

About Mapping CX Dashboard Data

You can add new fields or edit the automatically mapped fields after adding your first source to your Dashboard Data. This will edit how the fields appear or function on your Dashboards.

Mapping Data Sources

Once you have created your first dashboard, you will be asked to add a source. You will then be able to choose from any surveys (or distributions) you have in your account.

1. Click Add Source.
   
2. Choose from Surveys or Distributions.
   Qtip: To import data into your dashboard from a CSV, see the Importing a CSV as a Dashboard Source support page.
3. Decide what data should be included in the mapping. This is a great way to prevent excess fields you don’t plan on using from being added to your mapper.
   
   Example: You can use the checkbox to deselect all Metadata – this will remove fields like Response Type and Finished. If you see yourself using some, but not all metadata, you can deselect Metadata and then individually select the ones you want.
   
4. Click Add.
   Qtip: Any fields you exclude by accident, you can add back in later.
5. Data will be mapped according to your choices.
   
6. Click Save.

Dataset Utilization Limits

Our data platform imposes a limit on the number of times a single data source can be used in active datasets.  Currently, a single data source can only be in 50 active datasets to guarantee timely data processing. For external data, the limit is 5 active datasets. These limits are subject to change over time as our platform and features grow.  If your datasource reaches this utilization limit, an error dialog is displayed while adding the source in the data mapper or copying the dashboard.

Adding New Fields

1. Click on the dashboard settings gear to the right of the name of the Dashboard.
   
2. Click on the Add Field button.
   
   Qtip: Updating the Field Name will not affect your survey and will only be visible within CX Dashboards.
3. Provide or update a Field Name for your field.
4. Select the Field Type.
   Qtip: Field types define the type of data mapped into the field and consequently determine which widgets will be available for each field. If you don’t see your desired Field Name when selecting the source of a widget, you may need to change the field type or use a different widget. Be aware that changing Field Types can break widgets on any Dashboard using the affected fields. As such, we often recommend adding a new field that maps to the same question rather than editing the Field Type or Field Mapping of existing Fields (e.g., you may have a Text Set field for a NPS group as well as a separate Number Set field for a NPS value).
5. Click on the Not Mapped box.
6. Choose the field mapping of the question or embedded data field that will populate the field.
   
7. Click on the Save button at the bottom right.

Qtip: Hover over a field to see the move icon. You can use this to drag and drop the field around your mapper.

Managing Multiple Sources

After adding in your first data source, you can click on the Add Source button and select a different survey to add additional sources.

Additional data sources will not be automatically mapped, so you will need to map their fields manually. While you can map as many data sources as you want into your Dashboard Data, you cannot map the same survey or data source twice. After adding in an additional data source, you can either merge data from both sources into the same field or keep the data separate.

• To keep your data separate, make sure that you only have one source mapped on each row.
• To merge data into the same field, map both sources on the same row of the field you want to merge. In order for this to work properly, make sure that the fields you are merging are extremely similar (e.g., two NPS questions, two open ended comment questions, etc.).
  
  Qtip: You should only merge similar questions to the same field. For example, if two surveys use 7-point satisfaction scales, then it is fine to merge both questions in the same field. However, you shouldn’t merge a 7-point satisfaction scale question with an 11-point NPS question.

Merging, Mapping, & Unmapping Fields

Unmapping a field is as simple as clicking the X to the right side of the field. Subsequently, the field will be grayed out.

To map a field, click the down arrow to the right of any Not Mapped item. This will open a list of choices that will allow you to map to the appropriate Field Type.

The Field Type and the question type must be compatible. In this case, the Country field should be mapped to the survey question pertaining to countries.

Merging vs. Separating Multiple Fields

You can merge data from multiple sources into the same field or keep the data separate. For example, you may want data from CSAT questions in two different yearly surveys to show up in the same widget, but want to separate your 2016 CSAT from your 2017 NPS score.

1. Merge data into the same field by mapping both sources on the same row of the Field Type you want to merge.
   
2. Separate your fields by making sure you only have one source mapped on each row.
3. You should only merge questions if their data is in a similar format, and you are planning on mapping them with the same Field Type. In the example below, the NPS scale can only be Number Set for both sources; it cannot be mapped to two different Field Types on the same row. But this is fine, since NPS score is numerical data that suits the Number Set format.
   
   Warning: A Number Set is best for scale-point questions such as NPS (0-10) or Likert scales (1-5).  However, you shouldn’t merge a 7-point satisfaction scale question with an 11-point NPS question.
4. When mapping a second data source, you will only be presented Field Types that match the current selection (i.e., Text Set questions). Choose and map from among the matching questions in the second source.
   

Deleting Fields

Once you delete a field, the action cannot be undone. Additionally, deleting fields can break widgets that are using the field you wish to delete. Please use caution when deleting any fields.

1. Click on the X to the left of the field you want to delete.
   
2. Confirm that you want to delete the field by selecting Delete Field.
   

Additional Options

Once you’ve added your sources, you can use the Dashboard Data Sources tab to for advanced editing purposes like recoding your data or determining a field’s name and datatype.

To learn more about advanced editing in the Dashboard Data Sources tab, please see the following pages:

Fields

• Field Types
• Field Recode Values

Advanced Field Types

• Field Groups such as Drill Downs
• Date Formats

FAQs