You will need to go to the Download All Data (data dump) page and pull three files:

Memberships.csv to get the group ids and the users in those groups.

Users.csv to find the unique identifiers with the user ids.

Groups.csv is a list of all active and deleted groups.

Pull the users.csv and the groups.csv sheets into the same document as the membership.csv to prepare to do a couple VLOOKUPs.

In the memberships.csv, insert a column to the right of group_id and name it “VLOOKUP to group_id” and a column to the right of user_id and name it “VLOOKUP to user_id.”

For the group_id VLOOKUP, you will want to compare the group_id column (column B) to the id (column A) and name (column B) columns in the groups.csv sheet.

EXAMPLE FORMULA: =VLOOKUP(B:B,groups!A:B,2,FALSE)

For the user_id VLOOKUP, you will want to compare the user_id column (now column D) to the id (column A) and uid (column C) columns in the users.csv sheet.

EXAMPLE FORMULA: =VLOOKUP(D:D,users!A:C,3,FALSE)

This will align with what can be seen inside of Bridge by navigating to Admin > Users & Permissions > Manage Groups > Select a Smart Group > Members.

To know which users are in each manager group, we recommend doing an export of users and filtering for manager_id values. In Bridge, every manager is allocated their own group with their entire reporting line, both direct and indirect reports.

Please reach out to support@bridgeapp.com with any questions!