Skip to main content
Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Map Org Hierarchy Units (EE)

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


Qtip: This page describes functionality that will begin gradually rolling out September 8, 2021. It will be finished rolling out to all eligible customers by October 8, 2021.

About Mapping Org Hierarchy Units

After you’ve built your hierarchy, you may want to make sure it aligns with one you’ve built from a previous year. The ability to Map Org Hierarchy Units is useful because it allows you to dynamically display historical data in your dashboards. For example, maybe you want to create comparisons between two different engagement surveys, or you have a widget with an older survey as the source. You don’t want these widgets to stop displaying data when your dashboard is manually filtered by the hierarchy, or when accessed by someone whose permissions only lets them see their own hierarchy unit’s data. Therefore, you must map the old hierarchy to the new one so the widgets know how to adjust to the filtering.

Even if members of your company have left or been replaced, you can still map your current hierarchy to an older one. Two mapped hierarchy units do not need to have the exact same people inside them – you just need to map over which employees are in the same position.

Qtip: Your hierarchies have to be built before you can map them! You cannot build an Ad Hoc hierarchy using the hierarchy mapper.
Qtip: This page describes functionality available to Engagement projects, but not Lifecycle or Ad Hoc Employee Research projects. For more details on each, see Types of Employee Experience Projects.

How to Map to Historical Units

  1. Navigate to the Participants tab.
    using the org hierarchy tools menu to select map org hierarchy units
  2. Navigate to the Org Hierarchies section.
  3. Go to Hierarchy Tools.
  4. Choose Map Org Hierarchy Units.
  5. Under Project, select the Employee Engagement project your historical hierarchy is saved in.
    Images shows what the screen should look like for the next few steps. Menu along the left for selecting current & historical hierarchies, and the right has a preview of the current hierarchy you can expand
  6. Under Hierarchy, choose the older (historical) hierarchy you are mapping your newer (current) hierarchy to. A preview of this hierarchy should appear to the right.
  7. Click Continue.
  8. Qualtrics will automatically generate a mapping. The historic hierarchy (chosen in step 6) will appear to the left, and the current hierarchy will be listed on the right.

    Qtip: If portions of the hierarchy are not automatically linked to each other, an icon will appear showing what units are not mapped. Click the units to expand them and find the unmapped portions.
    Icon looks like a broken link in orange; image shows how top units will warn that there are unlinked units beneath
  9. To map units together: Click on a unit you wish to map, then click the gray connect button next to another unit you’d like to map it to.
    Image of the gray line potentially linking two units, and the link icon you can click on the right to map them together

    Qtip: You can map multiple units onto each other! In the example shown here, Sales split into two different teams the following year, so we mapped them together.
    Image shows just sales on the left historic hierarchy; on the right, the Sales unit has expanded to Sales and 2 teams within sales, so all 3 are mapped to what was previously just sales
  10. To unmap units: Click on a unit you wish to unmap and then the blue disconnect button to break a connection.
    Image shows how hovering over a unit displays its connections in blue and gives the option to break them
  11. When ready to finish up, click Save and Continue.
  12. If this is your first time mapping something to this hierarchy, the following options will appear:

    • Yes, map automatically at once: You can automatically apply previous mappings to your current hierarchy, and use the selected hierarchy (the one you’re trying to map to your current project) as your reference hierarchy moving forward. This will make sure you have a complete picture of your historical data from previous projects.
      Example: Let’s say you ran a pulse in August, July, and June. July and June are already mapped. Now you go to map August to July – the automatic mappings option would make it so that in that same instance, you could also map August to June, making your historical data more comprehensive.
    • No, map manually one by one: You will not automatically map any additional hierarchies; anything additional you add will be done manually on your own.
      Qtip: Even if you choose to automatically map historical hierarchies, that doesn’t mean you can’t add additional, manual mappings.
  13. Click Continue.
  14. A list of mapped hierarchies will appear.
    Qtip: The number for “units not mapped” is generated based on what’s missing from the current hierarchy. For example, the current and historical hierarchy may both have a single unit unmapped, but rather than saying two units total are unmapped, because the current hierarchy only has one, it will say one.
  15. To map another hierarchy, click Map another hierarchy.
  16. To return to your project’s hierarchy, click Close.

Once two hierarchies are mapped, you can reload this mapping for later and make changes. All you have to do is repeat steps 1-3 to reopen the Map Org Hierarchy Units window, and your mappings will be listed there.

Important considerations when mapping hierarchies

  • Make sure all of your hierarchy units are mapped across both projects.
  • You are allowed to map hierarchies of different types (such as Parent-Child to Level-Based), but in these cases, the automatic mapping feature will not work and you will have to do the mapping manually.
  • If you make changes to a historical data source, make sure to update all responses with new metadata. This will update the dashboards connected to the data source.

Reference Hierarchies

You can more quickly map multiple hierarchies together at once using the automatic mapping feature. This can be useful in situations where you want multiple hierarchies to be linked for a fuller picture of the historical data, but don’t want to have to manually map everything one by one.

Example: You ran an employee pulse in June and July, and it is now August. You are setting up the hierarchy mappings for August, mapping your hierarchy to July’s. July was already mapped to June, so you’re asked if you’d like to link all these mappings, thus mapping August to June. If you say yes, all the hierarchies will be mapped, and July will become the reference hierarchy.

A reference hierarchy is thus a hierarchy with multiple mappings that becomes the reference for other automatic mappings in that family.

The limit of hierarchies you can reference is 25.

How to establish a reference hierarchy

If you choose to automatically map hierarchies, the hierarchy you were mapping to will become a reference hierarchy.

Screenshot of a series of hierarchy mappings, one which is marked by a dark gray icon that says "your reference hierarchy"

Qtip: If you do not choose to automatically map hierarchies during the setup process but later change your mind, that’s okay. You can connect related hierarchies by opening the Map Org Hierarchy units menu and clicking the dropdown next to a specific hierarchy. Then click Connect previous hierarchies. This option only appears if you don’t already have a reference hierarchy.

Edits to reference hierarchies

Let’s say that when you originally mapped your hierarchies, you realized your reference hierarchy was missing something. If your references has units unmapped or incorrectly mapped, your other automatic mappings re using that information, and will reflect similar errors. Luckily, you can edit your reference hierarchy and update all resulting mappings to match your fixes.

Any time you click your reference hierarchy to edit it, you will receive a pop-up explaining that if you make changes to your reference hierarchy, you will need to reconnect your hierarchy mappings to reflect changes across connected hierarchies.

When you’re finished making edits to a reference hierarchy, you will be asked if you want to push those changes to the other hierarchies mapped to it. If you click Update automatically, those changes will be applied without you having to do anything else.

Qtip: You can also reconnect mappings later by opening the Map Org Hierarchy units menu and clicking the dropdown next to a reference hierarchy.

Org Hierarchy Default Mapping Behavior

Default org hierarchy mapping behavior is dependent on how your current and historical hierarchies are configured. This section will explain how the platform maps your hierarchy between data sources. Default mapping is only available if both the historical and current hierarchies share the same hierarchy type (parent-child or level-based) or both hierarchies use org unit IDs.

Both Hierarchies Use Org Unit IDs

If both the historical and current hierarchies use org unit IDs, then units with matching org unit IDs will be mapped, regardless of where those units appear in the hierarchy or what the names of the units are.

Both Hierarchies Are Parent-Child

If both the historical and current hierarchies are parent-child hierarchies, then units with matching Manager ID values will be mapped, regardless of where those units appear in the hierarchy or what their names are.

Both Hierarchies are Level-Based

If both the historical and current hierarchies are level-based hierarchies, then units will be mapped by their unit names:

  • If the unit name is unique within the current & previous hierarchy and the unit name is an exact match, the units will be mapped.
  • If the unit name appears more than once in either the current or previous hierarchy and the names of the units above those units are exactly the same across hierarchies, the units will be mapped.
  • If the unit names do not match, they will not be mapped.

Options

When mapping your hierarchies, you have several other options to explore in the upper-right, including the ability to download your mappings and upload them again.

The Options menu in the Hierarchy Mapper opened to reveal Mapping Options, Upload Options, and Download Mapping

Qtip: None of these options are available until you specify which historical hierarchy you want to map your current hierarchy to.

Mapping Options

When you click Mapping Options, you are given two options for how your historical data will be presented in the dashboards:

  • Org hierarchy in the historical project: This option will make it so data shown in historical comparisons follows its hierarchy placement in the historical project. Another way of thinking about this is, “How does everything that rolled up to me this year compare to everything that rolled up to me last year?”
  • Org hierarchy in the current project: This option will make it so that data shown in historical comparisons follow its hierarchy placement in the current project. Another way of thinking about this is, “Of those units who rolled up to me last year and who still roll up to me, how do the scores compare?”
Example: Let’s say that in your historical project, you have three units: A, B, and C. In the historical hierarchy, B and C both report to A. In your current hierarchy, B still reports to A, but C now reports to a new unit, D. If Org Hierarchy in the historical project is selected, C’s data will be included in the comparisons for unit A and excluded from the comparison for unit D. If Org Hierarchy in the current project is used, C’s data will be included from the comparison for unit D and excluded from the comparison for unit A.

Generally, selecting Org Hierarchy in the historical project will keep your historical scores the same as they were in the historical project because units will roll up to the same place they were in the historical org hierarchy. Any units that have moved to a new location in the hierarchy will not have their historical results roll up to their current hierarchy location.

Selecting Org Hierarchy in the current project will ensure the historical results of units that have moved in the hierarchy roll up to their new location in the hierarchy. This will change your historical scores for parts of the hierarchy where units moved because those units’ historical results will no longer roll up to where they were previously located.

Download Mappings

When you select Download mappings, you can download a CSV of your mapped units. Direct reports and managers are not included in this file.

Window that has a columne for choosing a metadata field for the historical hierarchy on the left and the current hierarchy on the right

There are two options for each of your hierarchies:

  • Qualtrics Org Unit ID: Represent each unit with the internal IDs that Qualtrics assigns to units. This is an internally generated ID, different from any org unit metadata you might create and assign yourself. This format is helpful if you’d like to upload a mapping (see content below).
  • Hierarchy Metadata: Download metadata that was important to building the hierarchy. For example, Parent-Child hierarchies let you download the Manager IDs and Skeleton hierarchies let you download the Parent Org Unit IDs. Level-Based hierarchies do not offer any additional metadata columns in this export.

Every CSV comes with a column for Left Unit Name, containing the historical hierarchy’s units’ names, and a Right Unit Name, containing the current hierarchy’s units’ names. This makes the CSV a good reference if you need to use the Qualtrics internal IDs elsewhere, such as when you upload mappings (see content below).

Qtip: You can also download mappings by opening the Map Org Hierarchy units menu and clicking the dropdown next to a specific hierarchy.

Upload Mapping

You have the opportunity to map your org hierarchy units in a CSV file and then upload this file into Qualtrics.

Qtip: Your mapping upload file should only contain units that you can map across projects. Any unmapped units should be excluded from the file.
Attention: If you want to update your mapping with another upload, you must include all existing hierarchy mapping in your upload. If you are missing information that is currently mapped in your upload, then those hierarchy mappings will be deleted upon uploading your file. To obtain your current mapping, download your mapping.
  1. Navigate to the Participants tab.
    using the org hierarchy tools menu to select map org hierarchy units
  2. Navigate to the Org Hierarchies section.
  3. Go to Hierarchy Tools.
  4. Choose Map Org Hierarchy Units.
  5. Under Project, select the Employee Engagement project your historical hierarchy is saved in.
    Images shows what the screen should look like for the next few steps. Menu along the left for selecting current & historical hierarchies, and the right has a preview of the current hierarchy you can expand
  6. Under Hierarchy, choose the older (historical) hierarchy you are mapping your newer (current) hierarchy to. A preview of this hierarchy should appear to the right.
  7. Click Continue.
  8. Click the dropdown in the upper-right.
  9. Select Download mappings.
  10. Select Qualtrics Org Unit ID for both the historical and current hierarchies.

  11. Select Download.
    Qtip: The IDs in this file are just examples and should not be used to create a mapping.
  12. Edit the CSV according to the changes you want to make. Map the units in the left-hand columns to the units on the right.
  13. Once you are done editing your CSV, go back to Qualtrics and select Upload mappings from the dropdown.
  14. Click Choose File to select your CSV.
  15. Click Upload.
    Qtip: If you’re running into issues uploading your CSV file, read the CSV/TSV Upload Issues page for common CSV troubleshooting tips.
  16. Feel free to make final edits on the hierarchy editor, then click Save when you’re finished.

Clearing Org Hierarchy Mapping & Restoring Auto-Mapping

If needed, it’s possible to clear your org hierarchy mapping and restore the auto-mapping functionality to your project. You can clear your org hierarchy if you made a mistake when mapping, or if you want to restart mapping using the auto-mapping feature.

Qtip: You cannot delete a reference hierarchy until you delete the other connected mappings. For example, let’s say your reference is hierarchy B, and it facilitated the mapping of C and D to your current A hierarchy. You have to delete A’s mappings to C and D before you can delete B.
Warning: Be careful of clearing your mappings if your hierarchies are currently being used in live dashboards. Breaking the connection between hierarchy mappings will change the data that’s being pulled into your dashboards!
  1. In the Org Hierarchies section of the Participants tab, click Hierarchy Tools.
    clicking hierarchy tools and then map org hierarchy units
  2. Select Map Org Hierarchy Units.
  3. You should see your existing mappings listed. On the right of the mapping you wish to remove, click the dropdown.
  4. Select Delete mapping.
  5. Read the warning. If you’re sure, click Delete to confirm your choice.
  6. If you want to restore auto-mapping behavior, you must repeat these steps for all mapped hierarchies.

This method completely clears the mapping between two hierarchies. After clearing hierarchy mapping, you will have the option to use the auto-mapping feature when you reopen the hierarchy mapping window.

FAQs