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

Users.csv to get the users and the sub-account_id where they belong.

Domains.csv is a list of all domain relationships in Bridge, which includes users to a sub-account and users to a manager.

Pull the users.csv and the domains.csv into the same document to prepare to do a VLOOKUP.

Start by working in the users.csv sheet. Insert a column to the right of sub_account_id and name it “VLOOKUP to DOMAIN_ID.”

For the domain_id VLOOKUP, you will want to compare the sub_account_id column (column V) to the id (column A) and name (column B) columns in the domains.csv sheet.

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

This will give us the account name where the user lives in Bridge.

SIDE NOTE. The sub_account_id 1 is always the root account. All other numbers are the respective sub-accounts.

The file will look something like this (we have hidden columns D-U):

You can easily navigate the sub-accounts using these IDs by adding them into the URL when in the sub-accounts area of Bridge:

To know the number of provisioned users in each account, you can create a pivot table based on the domain_ID name (rows) and the count of UIDs (value) that belong to that name.

If you would like to know which users are assigned to each smart group in a single account, click here.

Please reach out to support@bridgeapp.com if you have any questions!