If you are using Bridge to distribute your content to customers through subaccounts, you can use these metrics to speak to content engagement and LMS adoption.
Number of Subaccounts Created
If your content distribution is based on the number of B2B customers to whom you sell your content, an increase in domains likely correlates to an increase in sales. You can see the number of domains in your account by going to Admin > Download All Data > Domains.
You’ll filter parent_id (Column C) for 1, which represents the root account.
You’ll then filter for the deleted_at (column F) as blank, meaning that it is active.
If you then highlight name (column C), you can get a count of all subaccounts. To break this down more granularly, you can leverage the created_at date (column D) as a filter to see the number of sub-accounts created by year.
In this example, 442 subaccounts have been created in this root account and are still active.
Enrollments and Completions MoM and YoY
To pull a month or year of enrollments, go to Analytics > Transcript. Change the “Enrollment Date” to a year. For the “Account Name,” open the filter and delete the root account to pull enrollments for all accounts.
You may also want to open “More” and choose to show archived learnables in case you have archived content in that calendar year that would still be relevant to the analysis.
Download this report by clicking on the hamburger icon in the top right corner.
You’ll highlight all content in the CSV and go to Insert > Pivot Table.
Use the “Account Name” for the rows and the “count of enrollment date” and “count of completion date” for the values.
You could leverage a formula in the far right column to gather the percentage of completions by account.
Number of User-Created Courses
If your subaccounts have a content creator and you are giving your customers access to the LMS, you can see how many courses are being created by those users.
Go to the Download All Data (data dump) page and download the course_templates file, which will pull all courses across all accounts.
You want to start by filtering the file for only active courses, which means going to the deleted_at date (column P) and filtering for blanks.
If you want to only pull active content from the moment in which you are pulling the file, you can go to the archived_at date (column AB) and also filter for blanks (or pull only content that was live between a certain time period).
Anything belonging to sub_account_id (column R) 1 is a course from the root. Any other values are sub-accounts.
You can then create a pivot table where the sub_account_id (column R) is the rows paired with the “count of titles.” You can use the domains.csv to do a VLOOKUP of the sub_account_id to get the account name.
Unique and Total Logins MoM and YoY
To pull the number of logins for every subaccount, go to Analytics > Usage Metrics and remove the root account name from the “Account Name” filter.
You will then click on any month in either of the top widgets.
The “Monthly Unique Users - Seat Model” widget only registers a single login for the same unique user in the month. The “Monthly Logins” widget registers every login for every user into the instance. Clicking on the month gives you an option to drill into the value.
Clicking into that drill down will then expose the account name to whom that login belongs.
Downloading this report and creating a pivot table will show the number of logins affiliated to any account in a given month. This can then be easily tracked MoM and YoY.
Please reach out to support@bridgeapp.com if you have any questions!