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!