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

Tags.csv is a list of all active and deleted tags.

Tag_relevance.csv tells you which categories and tags are assigned to your courses.

Groups.csv tells you which categories and tags are assigned to your courses.

Pull the tag_relevance.csv, tags.csv, and groups.csv into the same document to prepare to do some VLOOKUPs.

The reason that we’re pulling the tags files is because categories and tags are stored in the same database in Bridge. Tags cannot have relevance, so all the items in the tags_relevance.csv file are categories.

Start by working in the tag_relevances.csv sheet. Insert a column to the right of tag_id and name it “VLOOKUP to TAG_ID.”

For the tag_id VLOOKUP, you will want to compare the tag_id column (column B) to the id (column A) and name (column B) columns in the tags.csv sheet.

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

This will give us the category names.

Now, we can leverage the groups.csv to know the names of the groups with visibility to that category name. In the tag_relevances.csv sheet, insert a column to the right of enrollable_id and name it “VLOOKUP to GROUP_ID.”

For the group_id VLOOKUP, you will want to compare the enrollable_id column (now column D) to the id (column A) and name (column B) columns in the groups.csv sheet.

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

This will give us the group names.

SIDE NOTE. Relevance in Bridge exists in three states: required, recommended, and available in Learning Library. Because categories can only be available in Learning Library, the relevance value will always be 0 in that column, which is the identifier for that specific relevance.

The file will look something like this:

If you would like to know which categories and tags are assigned to what content, click here.

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