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

Program_group_enrollments.csv to get the group ids associated with the program ids.

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

Programs.csv is a list of all active, archived, and deleted programs.

Group_enrollment.csv to get the group ids and the courses being assigned to those groups.

Course_templates.csv is a list of all active, archived, and deleted courses.

Pull the groups.csv, program.csv, group_enrollments.csv, and the course_templates.csv sheets into the same document as the program_group_enrollments.csv to prepare to do some VLOOKUPs.

Start by working in the program_group_enrollments.csv sheet. Insert a column to the right of group_id and name it “VLOOKUP to group_id” and a column to the right of program_id and name it “VLOOKUP to program_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 program_id VLOOKUP, you will want to compare the program_id column (now column D) to the id (column A) and title (column B) columns in the programs.csv sheet.

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

This will give us the programs being assigned to groups. We will also want to see if individual courses are being assigned to groups to have an overview of all content being assigned to learners when entering into Bridge.

Next, we’ll work in the group_enrollments.csv sheet. Insert a column to the right of group_id and name it “VLOOKUP to group_id” and a column to the right of course_template_id and name it “VLOOKUP to course_template_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 course_template_id VLOOKUP, you will want to compare the course_template_id column (now column D) to the id (column A) and title (column B) columns in the course_template_id.csv sheet.

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

You can aggregate all of this information into one place a couple different ways. 

We copy and pasted the values from the VLOOKUPs into a new sheet called “ALL CONTENT” within two columns: Group Name and Learnable Name. 

We then added a third column called Type to recognize if this was a course or a program.

Last step was to sort from A→Z by Group Name so that all the content for a group was in sequence (or you could create a pivot table).

This should be a comprehensive list of learnables by group.

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

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

If you would like to know which rules are set for each smart group, click here.

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