Medallia Experience Cloud reusable field mapping
Use Medallia Experience Cloud reusable field mapping to add fields already built in Medallia Experience Cloud to Digital’s reusable field library, making it available for selection in Digital Feedback configuration. Add fields individually through the Command Center user interface or through a bulk operation using the Import and Export functionality. Open the reusable field mapping as an XLSX file showing all of the fields in the library. Make bulk changes using your favorite spreadsheet editor.
Once a field is added to the library, it is part of the Digital Integration to Experience Cloud. Fields that are added into the reusable field library are highly sensitive to changes made in Experience Cloud. Modifying the field in Experience Cloud after this point could break the mapping. For example, suppose a field has been added as text to the reusable field library. Changing that field in Experience Cloud to autoindexed text causes a synchronization error for the Digital integration.
The Experience Cloud Mapping page is only visible for users with Admin-level role or user permissions in Experience Cloud.
When you open the EC Mapping page it displays a list of the current mapping between Experience Cloud and Digital.
Filter the list of mappings to see them across your properties and forms. Select one option in each category: EC Type, Usage, Share Level, Property. If you select "Account" share level then the Property filter is not visible.
For example to find a list of all text fields available for use in survey forms, choose to filter by "Text" (EC Type), "Form Field" (Usage), and "Share Level" (Account). You cannot select multiple options within a single category. For example, you cannot select "Email" and "Text" under EC Type to find a list of all email and text fields
See fields by the selected type. This list also defines the types of fields that are currently supported in the integration to Experience Cloud. If a field type is not listed, it means that it cannot currently be used in Digital Feedback.
See fields available for use in surveys with Form Fields, fields available for custom parameters Custom Parameter, or both.
See fields available for the entire account, fields available to specific properties, or both.
List all properties in the Digital account..
Select an individual property or any of the available properties..
The columns show the different mapping's values.
- EC Key: The field name in Experience Cloud
- EC Type: The field’s ContentKind in Experience Cloud
- EC Friendly Name: This name appears on your field mapping drop-down
- Usage: The usage of the field in Experience Cloud
- Share Level
- Property Names: The properties that use this field
- If share level is Account, no property names are displayed
Actions
Hover the cursor over a row and these icons are visible.
- Pencil: Open the Edit Mapping to MEC options. Use this menu to update the EC Friendly Name or the Share Level. You cannot edit the EC Key or the EC Type.
- Trash Can: Initiate deletion of the field from the Reusable Field Library
Adding fields
To make minor additions to the reusable field mappings, use the Command Center interface. Alternatively, to make larger changes to the reusable field mapping use the bulk operations.
Add fields individually by clicking New Mapping.
"New Mapping to MEC" opens in a side panel. Provide this information:
- EC Key
- Full field keyname - with e_ or q_ prefix
- EC Type
- Must match the ContentKind of the field in Experience Cloud and is validated upon upload
- Incorrect Content
- EC Friendly Name
- Usage
- Share Level
- EC Key
After providing all required details, click the Create button.
You cannot click Create if any of the required details are missing.
If the selected EC Type is correct, a success message appears and the field appears in the Experience Cloud Mapping table.
The field is now available for use in survey or custom parameter configuration.
If the selected EC Type is incorrect, an error message appears after clicking Create. You need to identify the correct EC Type by referencing Experience Cloud, and then repeat the process of adding the mapping.
Bulk edits
To make a lot of changes to the reusable field mapping, it can be more convenient to work with the data in an external tool such a spreadsheet. Use the import and export to save the reusable field mapping as an XLSX format file. Then make the changes to the fields using your spreadsheet editor and import the modified reusable field mapping.
Export reusable field mapping
Use the Export function to fetch an XLSX file with the reusable field mapping, showing the required column headers.
Export a table of all reusable field mappings in the library by clicking the Export button.
The mappings are exported to an XLSX file that is downloaded to your local machine.
To make bulk changes to the reusable field mapping load the XLSX file in a spreadsheet editor.
The exported file has these columns:
- EC Key
- EC Type
- EC Friendly Name
- Usage
- Share Level
- Properties (populated only if Share Level is set to "Properties")
Import (Bulk Mapping)
Use the Import function to add fields to the reusable field library by uploading an .xlsx file. You should export the existing library to fetch the correct format (.xlsx) and column headers.
The required column headers are (in order, from left to right):
- EC Key
- EC Type
- EC Friendly Name
- Usage
- Share Level
- Properties (only required if Share Level is ‘Properties’)
The uploaded file must also have the sheet title labeled as ‘Reusable fields’. This is already set by default in the export file.
Import: Allowed Values
Column | Allowed Values (Case Sensitive) | Can be modified after Import | # of Allowed Values, per field | Description |
---|---|---|---|---|
EC Key | MEC Field Keyname - must have e_ or q_ prefix | No | 1 | The Experience Cloud field that you are making available for use in Digital Feedback configuration |
EC Type | autoindex_text comment date datetime ecGrading0to10 ecGrading1to10 ecGrading1to5 ecGrading1to7 email enumeration enumerationMultiValues firstname hyperlink lastname phone text translatable_comment | No | 1 | The ContentKind of the field, which determines what questions the field can be used in. Note that rating scale fields have the "enumeration" ContentKind, but must be imported with the appropriate ecGrading EC Type to be available for rating scale questions. |
EC Friendly Name | Freeform text | Yes | 1 | The display name to use in the Report Field Mapping dropdown in Form Builder |
Usage | FormField CustomParameter | No | 1 | Define if the field should be used as a question mapping or as a custom parameter mapping. A field can only have 1 usage type. |
Share Level | Account Properties | Yes | 1 | Define if the field should be available for usage in configuration across the entire Digital account or only for specific properties. If only for specific properties, you need to populate a comma-separated list of Property ID numbers that the field is available in. |
Properties | Property ID numbers, comma-separated if multiple | Yes | Multiple | A comma-separated list of property IDs to make the field available to. A list of all properties (and IDs) you have access to is listed in the Switch Property menu, accessible in the right hand corner. This column should only be populated if the "Share Level" of the field is set to "Properties". Leave this column blank if "Share Level" is "Account" |
Import: Adding new fields
Export the current list of fields to fetch the correct file format and required column headers.
For each new field you would like to add, provide the requested details in a new row.
Add new fields by adding to the end of the existing list.
You can also add new fields by removing the existing fields in the list (rows with the gray shaded cell) and keeping the column headers. If you have no updates to make to the existing list of fields, Medallia recommends removing them from the Import file and only including the new fields you would like to add.
When populating the file with new fields, you must fill out all required details:
- EC Key
- EC Type (Reference this table for the values to use - they are slightly different from the values in the Command Center picklist)
- EC Friendly Name
- Usage
- Share Level
- Properties (populated only if Share Level is set to "Properties")
Delete all empty rows.
Uploading empty rows can result in extra error messaging, indicating that the empty row was not processed. This has no impact on rows successfully processed, but can be confusing to see.
Save the Import file after adding all desired fields and verifying that all entered values are correct. Note the case sensitivity of some values.
To import the file, click Import button on the Experience Cloud Mapping screen, and select your updated import file
A success message is displayed if all required values pass validation with Experience Cloud. New fields added become visible in the Experience Cloud Mapping table, and are now available for use in configuration
Import: Error Messages and Troubleshooting
During the import process you could encounter these errors.
If you have been logged out due to timeout in the Experience Cloud instance and attempted to add a field, this error message is displayed.
To proceed, you need to re-authenticate to the Experience Cloud instance.
If there are rows that fail the Import validation, you are provided with an error message and link to download an error log file
The error log file can be downloaded as a plain text (.txt) file.
The file identifies the sheet and row where the error took place for you to troubleshoot further.
Error Log Text | What this means |
---|---|
Processing EC Fields failed, Failed to add ecFields, some of the fields are invalid | The "EC Type" in the Import file does not match the ContentKind value of the field in Experience Cloud. Update the Import file with the correct EC Type value, and reupload to resolve. |
Sheet name is supposed to be: Reusable fields | The Import file does not have the correct sheet title. Update the sheet title to ‘Reusable fields’ and reupload to resolve. |
Processing EC Fields failed, No enum constant com.kampyle.kampylepersistence.entities.experienceCloud \\ .ReusableField.Usage.customparameter | The value for "Usage" in the Import file does not match the case-sensitivity rules. In this example, the value in the file is "customparameter" instead of "CustomParameter" |
Processing EC Fields failed, No enum constant com.kampyle.kampylepersistence.entities.experienceCloud. \\ ReusableField.Usage.formfield | The value for "Usage" in the Import file does not match the case-sensitivity rules. In this example, the value in the file is "formfield" instead of "FormField" |
Processing reusable fields failed, ecKey is empty, skip to next reusable field | The Import file has empty rows. This does not impact rows where you have correctly populated new fields to be added. No action needs to be taken if the new fields added to the sheet are successfully processed. |
Import FAQ
- Can I use the Import function to create new fields?
- No. The Import functionality is to make existing Experience Cloud fields available for usage in Digital Feedback survey form and custom parameter configuration.
- Create new fields in Experience Cloud
- No. The Import functionality is to make existing Experience Cloud fields available for usage in Digital Feedback survey form and custom parameter configuration.
- Can I use the Import function to remove fields from the library?
- No. The Import function can only be used to edit attributes of existing fields (See which attributes are editable after creation) or to add new fields to the library.
Removing a field from the library
When a field is removed from the library, it is no longer available for selection in the Form Builder or Custom Parameter configuration.
Existing usages of the removed field in Form Builder or Custom Parameter configuration are not affected, and the linked components remain mapped to the selected field.
Remove fields from the library by clicking on the trash can icon in the Action columns.
You are prompted to confirm that they want to delete the field mapping.
After clicking Delete, the field is removed and a success message is displayed
Reference
Medallia recommends mapping questions to the field types listed below:
Question Type in Form Builder | EC Type (In-Product Dropdown) | EC Type (Import) | Field can be used as a filter in Reporting? |
---|---|---|---|
Text Input | Text | text | |
Autoindex Text | autoindex_text | Yes | |
First Name | firstname | ||
Last Name | lastname | ||
Phone | phone | ||
Text Area | Comment | comment | |
Translatable Comment | translatable_comment | ||
Drop Down Radio Buttons | Enumeration | enumeration | Yes |
Checkboxes | Multi-Value Enumeration | enumerationMultiValues | Yes |
Rating: 1 - 5 Scale | Grading (1 - 5) | ecGrading1to5 | |
Rating: 1 - 7 Scale | Grading (1 - 7) | ecGrading1to7 | |
Rating: 1 - 10 Scale | Grading (1 - 10) | ecGrading1to10 | |
Rating: 0 - 10 Scale | Grading (0 - 10) | ecGrading0to10 | |
NPS | Grading (0 - 10) | ecGrading0to10 | |
Date | Date | date | |
Field Types by Parameter Type
Medallia recommends mapping custom parameters to the fields listed below:
Parameter Type (Custom Parameter Configuration) | EC Type (In-Product Dropdown) | EC Type (Import) | Field can be used as a filter in Reporting? | Property Type Availability |
---|---|---|---|---|
Text | Text | text | All | |
Autoindex Text | autoindex_text | Yes | All | |
Hyperlink | hyperlink | All | ||
All | ||||
Number | Text | text | All | |
Boolean | Autoindex Text | autoindex_text | Yes | All |
Datetime | Date/Time | datetime | Digital Web only |