It is a good habit to go through your content on a yearly basis as a matter of quality control and overall integrity.

For this exercise, you will need to pull the course_templates file from the Download All Data (data dump) page.

SIDE NOTE. This same exercise can be done for programs, checkpoints (tasks), and live trainings.

Once exported, you can go through a series of filtering activities to know which content is active, which has changes that have yet to be published, the original upload date, the author, and the last time a modification was made to the content. These details can help you delete irrelevant content or modify content in the account.

Step One.

Filter for sub_domain_id 1 (column O), which is the root account. If you are the admin of the sub-account, you can repeat this exercise per sub, but for this example, we will be focusing on the root. Anything modified in the root will persist into the subs if the content is affiliated with those subs.

Step Two.

Filter for deleted_at and only include blanks (column P). This is the content that is not deleted from the account.

Step Three.

Filter for archived_at and only include blanks (column AB). This is the content that has not been archived from the account.

SIDE NOTE. Deleted content has been completely removed from the instance. The course_id no longer exists to view. If a user had taken the course, it would not appear on their transcript. Archived content still has a valid course_id, which means that if it were completed by a learner, it would still appear on their transcript (but the course cannot be accessed in any way).

Step Four.

Filter for published_at and note anything that is blank (column H). You may want to go into the course and publish.

Step Five.

Filter for the title is blank (column B). You can contact the author (this is the user_id in column D).

A quick tip to finding users in Bridge by the Bridge user_id is to take the number value (i.e. the value of “5” in this example for the author of Making Connections):

If you then put /learners/# into the URL (i.e. 5), you will land on this user’s profile, and if notifications are enabled to direct message learners in Bridge, you could send this author an email from within the tool.

SIDE NOTE. Another quick tip to finding courses in Bridge is by using the ID in column A and then placing that value in the URL.

In this example, Making Connections is ID 83:

If we put “83” after the forward slash in the URL after “courses,” we quickly land on that course page:

Step Six.

Investigate the course_type to know how much control you have over the content. There are four options:

• 0 = Bridge Native
• 1 = SCORM
• 2 = Lynda
• 3 = OpenSesame
• 4 = LinkedIn Learning

Notes on replacing a SCORM course are here.

Step Seven.

A last step would be to look at the created_at (column E) and updated_at (column F) values. You could potentially filter for anything created or updated outside of the last fiscal or calendar year. You could create calls to action to review and ensure content is up to date, archiving anything that is no longer relevant to learners.

A help article on enrollment behaviors when content is archived is here.

We also have two articles that advise on using categories for learner-facing organization and admin-facing management:

• How to use categories & smart groups to map the right content [learners]
• How do I use categories to help manage my content? [admins & authors]

If you would like to know which courses belong to which sub-account and the number of courses created per sub, you can find directions here.

If you are struggling to keep inventory of content creation requests, we advise using a form to aggregate requests to give you an opportunity to prioritize based on topic, deliverable, and deadline. We have a sample form that we’ve put together using Typeform here.

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