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

Enrollment_source.csv is a list of all enrollment sources that triggered assignments to users.

Enrollments.csv is a list of all active and deleted enrollments.

Users.csv is a list of all active and deleted users.

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

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

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

We are going to be cross-referencing the IDs in the enrollment_source file to all of the other five files to understand which courses were assigned to which users from which sources. Pull all the files into the same document to prepare to do some VLOOKUPs.

SIDE NOTE. At this time, Journeys does not have a file to know which IDs belong to which Journey. You’ll need to work within the Bridge interface to get that answer.

Start by working in the enrollment_sources.csv sheet. Insert four columns to the right of enrollment_id and name them: VLOOKUP to COURSE_TEMPLATE, VLOOKUP to TITLE, VLOOKUP to USER_ID, and VLOOKUP to UID.

For the enrollment_id VLOOKUP, you will want to compare the enrollment_id column (column B) to the id (column A) and course_template_id (column I) columns in the enrollments.csv sheet.

EXAMPLE FORMULA: =VLOOKUP(@B:B,enrollments!A:I,9,FALSE)

For the Title VLOOKUP, you will want to compare the VLOOKUP to COURSE_ID column (column D) to the id (column A) and title (column B) columns in the course_templates.csv sheet.

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

For the VLOOKUP to USER_ID, you will want to compare the enrollment_id column (column B) to the id (column A) and user_id (column B) columns in the enrollments.csv sheet.

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

For the VLOOKUP to USER_ID, you will want to compare the user_id column (column E) to the id (column A) and UID (column C) columns in the users.csv sheet.

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

This will give us the courses assigned to each user.

Next, in the same enrollment_sources.csv sheet, insert one final column to the right of enrollable_type and call it “VLOOKUP to ID.” You will be leveraging the filters to do different VLOOKUPs based on the different types of enrollment sources: Group, Program, User, or Journey.

SIDE NOTE. You may see an enrollment source called “Imports::ImportObject” and this is for historical uploads of a user’s completion to a course.

Filter for “Programs” in the “enrollable_type” column (now column H). For the enrollable_id VLOOKUP, you will want to compare the enrollable_id column (now column G) to the id (column A) and title (column B) columns in the programs.csv sheet.

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

Your sheet should start to look something like this.

Next, filter for “Groups” in the “enrollable_type” column (now column H). For the enrollable_id VLOOKUP, you will want to compare the enrollable_id column (now column G) to the id (column A) and name (column B) columns in the groups.csv sheet.

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

Finally, filter for “Users” in the “enrollable_type” column (now column H). For the enrollable_id VLOOKUP, you will want to compare the enrollable_id column (now column G) to the id (column A) and UID (column C) columns in the users.csv sheet.

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

As far as the Journey IDs, you’ll need to go back into Bridge to gather this info. The number value of the Journey as the enrollable_id in the enrollment_sources.csv sheet can be leveraged in the URL to find the Journey title.

The finished file will look something like this.

By hiding some of the columns, you can easily see the titles that were assigned to specific users based on specific criteria on a specific date.

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