Getting Started with Custom User Hierarchy

Intelligence understands that every business works a little differently and that the adaptability of the Platform to your process is paramount in accurately and efficiently analyzing, reporting, and giving insight to your data. If the typical Platform Hierarchy, which includes a CRM User/Manager or User Role Hierarchy, doesn't fit your business model, you can import a CSV to create your own custom hierarchy!


Creating a Custom Hierarchy Instance

  1. Mediafly Users: go to Settings > Report Management > Hierarchies > + New Hierarchy
    Revenue Intelligence only Users: go to Settings > Hierarchies > +New Hierarchy
    Screen_Shot_2023-03-06_at_4.18.10_PM.png

    Pro tip: You can repeat this process as many times as you want to create as many custom hierarchies as needed.

  2. Search for and select Custom CRM User Hierarchy, then click next in the upper right-hand corner.

  3. Enter a Name for your hierarchy instance and click save.
    Screenshot 2026-02-25 at 3.50.56 PM.png

  4. Once saved, enable the definition by toggling the new hierarchy to ON. 
    (Toggled ON = light blue dot, OFF = dark blue dot.)

Screenshot 2026-02-25 at 3.52.35 PM.png

Building the CSV for Upload

  1. Mediafly Users: Navigate to the CRM icon in the left nav & select People
    Screenshot 2026-02-25 at 4.17.02 PM.png
    Revenue Intelligence only Users: Expand the "Explore" tab in the left nav and select People 
    Screenshot 2026-02-25 at 4.25.16 PM.png

  2. Select the main user group (eg. Insightsquared Users) and ensure there are no filters applied. (When there are no filters, you'll see a screen like the one below saying "add a new filter or select a saved filter to view data for this report", in this case, we do not want to add any filters before exporting data.)

  3. Click Export Data and open the downloaded CSV file, you'll use this file in the next section.
    Screenshot 2026-02-25 at 4.20.21 PM.png

 

Creating the Hierarchy to Upload to Intelligence

  1. Make a copy of this google sheet.

  2. Paste your exported CSV from above into the first sheet of the workbook where indicated below.
    Screenshot 2026-02-25 at 4.48.37 PM.png

  3. Navigate to the "email hierarchy" sheet (the second sheet of the workbook) and build your hierarchy! On this sheet, start building your hierarchy by copy and pasting email addresses from the User report sheet into the email and manager email columns. The "email" column represents a user you want to represent in the hierarchy and the "manager email" column represents the manager for that user.
    Note: Every hierarchy needs at least 1 root, this is accomplished by leaving the manager email cell blank for one user (the top of the hierarchy i.e. CEO)
    Screenshot 2026-02-25 at 4.48.55 PM.png

  4. Navigate to the "Output" sheet
    Screenshot 2026-02-25 at 4.49.20 PM.png

  5. Verify that there are no red error cells present

  6. Export the "Output" Sheet to CSV by selecting File > Download > Comma-separated values (.csv, current sheet)


Uploading a Hierarchy CSV to Intelligence

  1. Navigate to the hierarchy settings instance we created earlier.

  2. Open the Hierarchy CSV Uploader Section and select the .csv file to upload.

  3. Save your hierarchy by clicking save in the upper right corner.

  4. Preview your hierarchy by using the preview tab.

Enjoy! You can now find your custom hierarchy in the Intelligence Hierarchy navigator:

Screenshot 2026-02-25 at 4.56.11 PM.png
Is this article helpful?
0 0 0
Leave a Comment
 
Attach a file