-
Qualtrics Platform -
Customer Journey Optimizer -
XM Discover -
Qualtrics Social Connect
Preparing a User File to Make a Hierarchy (CX)
About Preparing a User File to Make a Hierarchy (CX)
This page covers what you’ll include in a file not only to successfully import users to your dashboard, but to then later organize them into a hierarchy.
There are 2 types of fields to consider for your file. There are default fields included in every import, regardless of hierarchy, that identify the user, such as name and email. There are also additional columns called “metadata,” which can vary based on the type of hierarchy you choose.
Default Required Fields
When importing users to your CX Dashboard, there are a few important things to keep in mind. For example, every import will need the following columns:
- First Name: The user’s first name.
- Last Name: The user’s last name.
- Email: The user’s email address. This detail is the most important. Email can act as username for each user or as a way to remember which users already exist in the User Admin.
- Username: If your organization uses SSO, you must include a Username column. This column should contain the same information as the Email column, because the#brandId will be automatically added to the end.
- Language: This column is technically optional. However, if you choose to include this, you must be careful to capitalize Language as seen here, and enter the value for each user as a language code.
Preparing the File for a Hierarchy
In addition to the required fields in the previous section, you’ll want to make sure that you’ve chosen the right hierarchy for your project. The type of hierarchy you want to use affects the metadata, or custom columns of user data, that you will include in your CSV/TSV file.
- Level-based hierarchies: These hierarchies are more common with companies that organize employee data by distinct levels, location, or functional breakout. You don’t necessarily have to know each employee’s manager.
- See a list of metadata you need to include in your file for a level-based hierarchy.
- Once your data’s uploaded, you can Generate a Level-Based Hierarchy.
- Parent-child hierarchies: These hierarchies are the best option if your HR data is formatted so you have a list of employees’ IDs and the managers each employee reports up to.
- See a list of metadata you need to include in your file for a parent-child hierarchy.
- Once your data’s uploaded, you can Generate a Parent-Child Hierarchy.
- Skeleton hierarchy: Skeleton hierarchies are used when you know the identity of your managers, but not their direct reports. We generally do not recommend this option for CX clients, and only in very specific use cases for EX clients.
See also maximum and supported characters for help keeping your file contents accurate.