We've released a way to see this data directly in your interface by going into the course and clicking into 'Associated Content.' If you'd like to pull the raw data, feel free to take the steps below.
In the Interface
This new feature allows Authors to see which program a course belongs to, and it will show the active number of enrollments in that program. This feature provides more visibility into how content is being used across your organization.
Pulling Reports
You will need to go to the Download All Data (data dump) page and pull three files:
Course_templates.csv is a list of all active, archived, and deleted courses.
Program_items.csv references each program item by the program_id it belongs to and the item type and corresponding item ID for each program item.
Programs.csv is a list of all active, archived, and deleted programs.
Pull the course_templates.csv and the programs.csv sheets into the same document as the program_items.csv to prepare to do a couple VLOOKUPs.
In the program_items.csv, filter for item_type (column F) for “CourseTemplate.”
In the program_items.csv, insert a column to the right of program_id and name it “VLOOKUP to program_id” and a column to the right of item_id and name it “VLOOKUP to course_id.”
For the program_id VLOOKUP, you will want to compare the program_id column (column B) to the id (column A) and title (column B) columns in the programs.csv sheet.
EXAMPLE FORMULA: =VLOOKUP(B:B,programs!A:B,2,FALSE)
For the course_id VLOOKUP, you will want to compare the item_id column (now column F) to the id (column A) and title (column B) columns in the course_templates.csv sheet.
EXAMPLE FORMULA: =VLOOKUP(F:F,course_templates!A:B,2,FALSE)
For more best practices around using the data dump, click here.
Please reach out to support@bridgeapp.com with any questions!
Related to