How to Export Data in Bridge: Data Export Reference Guide

A data export “data dump” is a full export of your account's learning, skills, and performance data, delivered as a set of CSV files inside a zip folder.

This guide covers how to generate a data export in Bridge, what each file in the export contains, and how to cross-reference files like course completions, enrollments, and user records to build custom reports.

Before You Begin

Some features may be restricted based on your role permissions.
Download All Data must be enabled in your Bridge account.
If you have access to Bridge’s skills development and performance management capabilities via Full Suite, the corresponding files are automatically exported with every data dump.

How to Export Account Data in Bridge

Go to Admin > Tools > Download All Data.
By default, all files are selected for export. Use Select All and Select None, or check the boxes next to the file names to export specific files.
After you select the files you want to include, click Generate Export to begin downloading your data.
The status will display as pending once the export begins. The export date and time are also displayed and will update automatically each time you create a new data export. You can cancel the export at any time by clicking the Cancel button at the top of the screen.
Once the download is complete, click the Download button to save a zip folder to your device. This will contain all of your CSV files.

Bridge Data Export Reference Guide

The following files are generated when you export all account data in Bridge. You can also choose to download any of the following files:

Learning Reports Glossary

affiliated_sub_account_sources: includes the learning item ID and the subaccounts where learning is found.
affiliated_sub_accounts: provides overview information about the subaccounts created within the root account.
approval_events: includes the approval item ID and the date events were created and updated.
approvals: includes approver IDs and the approval state.
attachments: provides the URL of each learning item attachment, and whether that file is visible to learners.
attempts: overview information for learning attempts and scores.
clone_objects: data points used when an account is cloned.
comments_ratings: provides raw comment data from learning items (doesn't include free-text).
comments: overview information of comments made in Bridge.
content_editor_groups: an overview of editor groups including content ID, type, group ID, and timestamps.
content_editors: when learning items were created and deleted, and the most recent update timestamp (user ID included).
content_providers: overview of content IDs and the affiliated subaccounts, and last-sync date.
course_template_versions: IDs for all learning items, the item type, and the name and description of the learning item.
course_templates: a list of all active, archived, and deleted courses, including the date of creation, where the course was originally authored, who authored it, whether or not it was deleted or archived, etc.
custom_fields: each custom field in an account, date of creation, and date of last update. Each time a custom field is added to an instance within Bridge, a record is created within this table.
devices: device ID values and user ID, including creation, update, and deletion dates.
domain_hierarchies: the domain tree and associated direct/indirect parents/children/grandchildren, etc.
domains: the origin and creation of the root account and any subaccounts.
downloads: downloads executed within the account, including user ID.
enrollment_profiles: raw data for the enrollment information found in the Settings section of a learning item.
enrollments_sources: the ID for the enrollment source (group, user, program, Journey, etc.)
enrollments_versions: the create, update, destroy, and restore events for enrollments and the “whodunnit” values for those events.
enrollments: all enrollments for all learnable types and users.
grant_versions: information for role versions assigned to each user.
grants: Overview of the information associated with users' roles.
group_enrollments_versions: when permissions were given to a particular user.
group_enrollments: enrollments and the group that created it.
group_hierarchies: an overview of the group ‘tree’, including row_id; ancestor_id; descendant_id, and generations columns.
groups: all groups (manual and smart).
hosts: an overview of the root host and all subaccount hosts.
import_columns: an overview of the host account, and subdomains and their vanity details (if applicable).
import_objects: fields imported via CSV, along with timestamp.
import_profile_versions: profile information imported into Bridge.
import_profiles: file information and URL location for the file that was uploaded to update user information.
import_scorm_objects: raw data from individual SCORM file imports.
import_scorm_profiles: an overview of SCORM upload data (SFTP location, etc.)
integration_fields: information used for some integrations (may be blank if not utilized.)
learner_custom_field_values: an overview of unique ID, custom field ID, and values.
learning_items: an overview of learner assignments to individual items and their status.
library_item_sources: items available in the Learning Library, including their relevance and enrollment source.
library_items: items in the Learning Library, including course type, title, duration, and description.
live_course_enrollment_sources: live training enrollment sources with timestamps.
live_course_enrollments: individual user enrollments and the associated timestamps.
live_course_group_enrollments: live training group enrollments and registrations.
live_course_session_instructors: live training session IDs and instructors.
live_course_session_registrations: live training IDs, UIDs, and respective enrollments, including timestamps.
live_course_session_versions: live training versions, types, and creation dates.
live_course_sessions: an overview of live training data including start/end date, seats available, ID and creation date, subaccount associations, etc.
live_course_web_conferences: an overview of live training provider information, meeting URL, password, and registration link.
live_courses: includes live training title, creation date, session count, etc.
local_saml_service_provider: an overview of SAML service information.
lti_content_item_enrollment_sources: an overview of LTI enrollment sources.
lti_content_item_enrollments: a list of individual learner enrollments triggered via LTI and enrollment status.
lti_content_items: content details for resources utilizing an LTI placement.
lti_placements: an overview of LTI placement information and respective titles.
lti_tools: an overview of LTI tools and descriptions, and XML data and launch URLs.
memberships: when users were added to specific groups.
notification_profiles: an overview of notifications sent to users.
oauth_clients: OAuth details (if enabled).
open_sesame_tenants: information about OpenSesame content if utilized.
open_sesame_users: OpenSesame user information, including Bridge UID and OS learner ID.
program_enrollment_sources: an overview of creation, update, destroy, and restore events for program enrollments and sources.
program_enrollment_versions: program enrollments, versions, events, and the associated raw data.
program_enrollments: individual program enrollment data.
program_group_enrollments: program enrollments by group ID.
program_items: an overview of items within a program.
program_sections: an overview of programs by title, description, and domain ID.
program_versions: creation and update timestamps of programs.
programs: all programs and IDs.
questions_responses: numerical responses and scores of learner quiz attempts (doesn't include free text answers).
retain_questions: an overview of Retain questions, answers, score, etc.
retain_quizzes: an overview of Retain enrollments.
rules: smart group logic to place users into groups.
scorm_dispatches: an overview of SCORM uploads.
slide_versions: updates made to individual slides.
slides: edits made to slides.
survey_distributions: survey distribution details.
surveys_questions: survey questions.
surveys_recipient_group_members: an overview of surveys sent to group members.
surveys_recipient_groups: survey distribution by group details.
surveys_recipients: a list of individuals that a survey was distributed to.
survey_responses: an overview of survey responses.
surveys_submissions: an overview of survey submissions.
surveys_surveys: an overview of surveys, title, creation date, and distribution count.
tag_relevance: tag names and associated course IDs.
taggings: an overview of tag IDs and their placements, context, creation date, and the subaccounts they’re associated with, etc.
tags: an overview of tag names, domains they’re used in, subaccounts they’re utilized in, etc.
task_enrollment_sources: checkpoint enrollment sources (tasks is a legacy term for current checkpoints).
task_enrollments: an overview of checkpoint enrollments.
task_group_enrollments: checkpoint enrollments by group.
tasks: checkpoints.
temporary_enrollments: temporary enrollments.
user_course_visit_logs: learners' activity in a course, including IP address.
user_course_visits: an overview of learners' activity in a course.
user_versions: a record of changes made to Users in Bridge.
user_visit_logs: an overview of user visits and duration in Bridge.
users: a record of all users within your Bridge account.
user_visits: an overview of users' visits and timestamps, along with the browser used.

Skills and Performance Management Reports Glossary

performanceConversationsAllUsersReport: an all-user export of performance conversations, including the reviewee, reviewer, the final rating, and the final comment made by both the reviewer and reviewee
performanceConversationsManagerReport: a numerical report of percentage completed, completed conversations, completed employee reviews, etc.
cadence_group_member: an overview of group agenda cadence member details (doesn't include free text entries).
goal: goal names, timestamps, assignees, goal type, status, and visibility.
cadence_group: an overview of 1on1 cadence.
to_do: tasks created in 1on1 agendas.
goal_task: an overview of individual goals created in the account.
company_goal: company goals created in the account.
assessment_grade: assessment scores, comments, and timestamps.
question_topic: data from the Question Bank.
skill_descriptor: an overview of skill descriptions.
achievement: achievements created by learners.
assessor: assessors and timestamps.
question: questions found in the Question Bank.
agenda: agenda creation and status. (Doesn't include free text entries).
skill_job: an overview of skill data and the associated accounts.
agenda_item: agenda details, including type, completion date, etc.(Doesn't include free text entries).
job: an overview of job titles and creation and updated dates.
to_do_participant: the tasks in group agendas.
skill: a list of skills and associated descriptions.

Note: Access to skills development and performance management insights requires access to Bridge Full Suite. Contact your Account Manager or fill out the form to learn more.

Tip: Find out how to export your performance conversation reports.

How to Use the Files Generated in a Data Export

Your zip file will include multiple files that help you track training and report on success. Use the suggestions to cross-reference your data.

Agendas (agenda)

Each time an agenda is created in Bridge, it will be reflected in the agenda file. You can combine the file with the users, agenda_item, and domains files to see which users participate in discussions and how often.

Column Header	Description
account_id	The ID of the account the 1on1 agenda is located in.
sub_account_id	The ID of the subaccount the 1on1 agenda is located in (can be combined with the domains file to define the subaccount name).
id	The ID of the individual 1on1 agenda form.
manager_id	The unique Bridge ID of the manager involved in the 1on1 agenda.
employee_id	The unique Bridge ID of the employee involved in the 1on1 agenda (can be combined with the users file to define the employee’s name).
created_at	The date and time the 1on1 agenda was created.
updated_at	The date and time the 1on1 agenda was last updated.
completed_at	If complete, the date and time the 1on1 agenda was completed.
state	The state the 1on1 agenda is currently in (Active, Completed, Dismissed, Requested, Withdrawn).
agenda_type	Indicates the 1on1 agenda type. Check-in (Check_in), Peer, or Performance Conversation (Perf_Conv).

Note: Access to 1on1s requires Bridge Full Suite.

Agenda Items (agenda_item)

This file shows you each agenda item created in Bridge. You can combine it with the course_templates, agenda, users, and domains files to track conversation cadence and trends across your company.

Column Header	Description
account_id	The ID of the account the 1on1 agenda is located in.
sub_account_id	The ID of the subaccount the 1on1 agenda is located in (can be combined with the domains file to define the subaccount name).
id	The ID of the individual 1on1 agenda form.
manager_id	The unique Bridge ID of the manager involved in the 1on1 agenda.
employee_id	The unique Bridge ID of the employee involved in the 1on1 agenda. Can be combined with the users file to define the employee’s name.
created_at	The date and time the 1on1 agenda was created.
updated_at	The date and time the 1on1 agenda was last updated.
completed_at	If complete, the date and time the 1on1 agenda was completed.
state	The state the 1on1 agenda is in (Active, Completed, Dismissed, Requested, Withdrawn).
agenda_type	Indicates the 1on1 agenda type. Check-in (Check_in), Peer, or Performance Conversation (Perf_Conv).

Assessor (assessor)

The file shows assessments created in your Bridge account and can be combined with the users and domains files to check learning progression and proficiency across your company.

Column Header	Description
account_id	The ID of the account the assessment is located in.
sub_account_id	The ID of the subaccount the assessment is located in, if applicable.
id	The ID of the assessment record.
assessment_id	The ID of the assessment that relates an assessor with the assessment.
employee_id	The unique Bridge ID of the employee completing the assessment (can be combined with the users file to define the employee’s name).
completed_at	The date and time the assessment was marked complete, if applicable.

Custom Fields (custom_fields)

This file shows you the custom fields added to your Bridge instance. You can combine it with the learner_custom_field_values file to find a name/title in the corresponding records, and the domains file to find the corresponding domain or subaccount.

Column Header	Description
id	The ID number of the mapped custom field.
name	The name of the custom field.
created_at	When the custom field was first added using a CSV file upload.
updated_at	When the custom field was last updated.
deleted_at	When the custom field was deleted.
domain_id	The account or subaccount ID number where the custom field was created.

Course Templates (course_templates)

This file shows you every new course created in Bridge. You can combine it with the users, enrollments, and domains files to track what content exists in your Bridge accounts and which user created it. By combining the course_templates and domains files, you can also find the total number of courses across all accounts.

Column Header	Description
id	The ID number of the course.
title	The title of the course.
estimated_time	The estimated completion time of the course.
user_id	The ID of the user who created the course.
created_at	The date the course was created.
updated_at	The date the course was last updated.
passing_threshold	The required minimum passing score.
published_at	The date the course was published.
has_unpublished_changes	If the course has unpublished changes. Yes: ‘t’ (true) or N: ‘f’ (false).
has_certificate	If the course has certificates enabled for users. Yes: ‘t’ (true) or N: ‘f’ (false).
external_id	External ID number of uploaded and shared courses. The originating Bridge account name is used as a prefix.
draft_external_id	External ID number of uploaded and shared courses that have not been published. The originating Bridge account name is used as a prefix.
external_status	The status of uploaded courses (pending, complete, attached, etc.).
course_type	Indicates course type: Bridge native (0), SCORM (1), Lynda (2), OpenSesame (3), LinkedIn Learning (4), Udemy (5), Skillsoft (6).
domain_id	The account or subaccount ID where the course was created.
deleted_at	The date of course deletion, if applicable.
attachments_count	The number of attachments added to the course, including media added to course slides.
sub_account_id	The account or subaccount ID where the course is held.
open_book	If the course has the Open Book option enabled for users (Yes: t or No: f).
description	The course description.
third_party_course_id	The course ID provided by the third-party source.
quizzes_count	The number of quiz questions in the course.
external_status_message	Information provided for failed course upload, if applicable.
manual_estimated_time	If the estimated completion time of the course has been manually set by the author (Yes: t or No: f).

Enrollments (enrollments)

The file shows all user enrollments in courses. You can join each record to the corresponding user and course using the user_id and course_template_id fields.

Column Header	Description
id	Unique enrollment ID.
user_id	User ID for the enrollment.
state	Which state the enrollment is currently in (Created, Active, Complete).
created_at	The date the enrollment was created.
updated_at	The date the enrollment was last updated.
completed_at	The completion date.
score	The score the user received upon completion.
end_at	Due date of the enrollment.
course_template_id	The course in which the user enrolled.
attempts_count	How many attempts have been completed by the user.
required	If the course is a required course (Yes: t or No: f).
external_id	External ID number of uploaded and shared courses. The originating Bridge account name is used as a prefix.
deleted_at	The date of enrollment deletion, if applicable.
sources_count	How many methods have been used to enroll a user in an item (groups, learning library, program, etc.).
config	Enrollment configuration relating to the Office 365 integration (calendar) and Retain participation set using API (retain_opt_out).
expires_at	When the user’s enrollment completion will expire.
inactive	If the course enrollment is inactive.
renew_by	The date the previous enrollment will expire.

Goal Tasks (goal_task)

This file shows each task created for a goal in Bridge.

Column Header	Description
account_id	The ID of the account the goal task is located in.
sub_account_id	The ID of the subaccount the goal task is located in.
id	The ID of the individual task record.
goal_id	The ID of the goal that the task is linked to.
name	The text entered as the task name.
created_at	The date and time the task was created.
updated_at	The date and time the task was last updated.
completed	Indicates task completion status (t/f).
due_at	The date and time of the task due date, if applicable.
completed_at	The date and time the task was completed, if applicable.
deleted_at	The date and time the task was deleted, if applicable.

Note: Access to Goals requires Bridge Full Suite.

Learner Custom Field Values(learner_custom_field_values)

Each time a value is added to a user’s custom field, a record is created. You can map the file to the corresponding user through the user_id column, and to the corresponding custom field through the custom_field_id column.

Column Header	Description
user_id	The user ID that the custom field value corresponds to.
custom_field_id	ID of the custom field which the value belongs to.
value	The value residing within the corresponding custom field.
deleted_at	The date of custom field value deletion, if applicable.

Live Course Enrollments (live_course_enrollments)

This file shows each time a user enrolls in live training and can be combined with the users and live_courses files using the user_id and live_course_id fields.

Column Header	Description
id	Unique identifier for the live training enrollment.
user_id	ID of the enrolled user.
live_course_id	The ID of the live training the user is enrolled in.
created_at	The date when the user was enrolled in the specified live training.
updated_at	The date the enrollment was updated.
state	0 = Invited, 1 = Registered, 2 = Attended.
deleted_at	The date of enrollment deletion, if applicable.
sources_count	How many methods have been used to enroll a user in the live training (groups, learning library, program, etc.).
expires_at	The date the enrollment will expire.
inactive	If the live training enrollment is inactive (Yes: t).
renew_by	The date the previous enrollment will expire.

Live Courses (live_courses)

The file shows each live training session created in your Bridge account. You can combine it with the users and domains files using the user_id and domain_id fields.

Column Header	Description
id	The unique identifier of the live training.
title	The title assigned to the course by the live training creator.
description	The description assigned to the live training session by the creator.
created_at	The date the live training session was created.
updated_at	The date the live training session was updated.
user_id	The user ID of the user who created the live training session.
domain_id	The domain to which the live training session belongs.
deleted_at	The date the live training session was deleted, if applicable.
sessions_count	The number of sessions in the live training.
enrollments_count	The number of enrollments in the live training session.
attachments_count	The number of attachments within the live training session.
sub_account_id	The ID of the subaccount to which the live training belongs (can be combined with the domains file to define the subaccount name).
external_course_id	External ID number of a shared live training.The originating Bridge account name is used as a prefix.

Live Course Sessions (live_course_sessions)

This file shows each session created for live training. You can combine it with the live_courses file using the live_course_id field.

Column Header	Description
id	The unique identifier assigned to the live training session.
start_at	The planned start date/time of the session.
end_at	The planned end date/time of the session.
location	Where the session will be located.
seats	The maximum number of users that can register for the session.
live_course_id	The ID of the live training in which the session was created.
created_at	The date when the session was created.
parent_id	The ID of the first session in a multi-part session.
updated_at	The date when the last update was made to the session.
registered_count	The number of users registered for the session.
concluded_at	The date/time when the session actually ended.
deleted_at	The date of session deletion, if applicable.
notes	Any notes added to the session by the session creator.
domain_id	The ID of the domain to which the session belongs.
sub_account_id	The ID of the subaccount to which the session belongs.
present_count	The number of attendees who have been marked as present.

Live Course Session Registrations (live_course_session_registrations)

This file details every registration for a live training session. You can combine it with the users, live_course_sessions, and live_course_enrollments files using the user_id, live_course_session_id, and live_course_enrollment_id fields.

Column Header	Description
id	The unique identifier assigned to the session registration.
live_course_session_id	The ID of the session the user has registered for.
user_id	The ID of the user who is registered.
created_at	The date/time when the registration was created.
updated_at	The last date/time the registration was updated.
live_course_enrollment_id	The ID of the live training enrollment the registration is tied to.
deleted_at	The date of registration deletion, if applicable.
config	Enrollment configuration relating to the Office 365 integration.
marked_complete_at	The date the registration was completed.

Users (users)

This file contains a record of all users created in your Bridge account and can be combined with other files within the data export using the id field. You can also find the subaccount that created the user by combining the domains file using the sub_account_id field.

Column Name	Description
id	The user’s unique Bridge ID.
email	The user’s email.
uid	The user’s unique ID as defined by your organization.
created_at	The date when the user was created.
updated_at	The last time the user and any corresponding information was updated.
avatar_url	The location of the user’s avatar used within Bridge.
first_name	The user’s first name.
last_name	The user’s last name.
external_id	The user ID defined by your organization.
domain_id	The foreign key used to join the users and domains files.
deleted_at	If a user is deleted, the deletion date appears here.
tac_accepted_at	The date the user accepted the Terms and Conditions in Bridge.
tagline	The user's tagline.
locale	The user’s locale parameters (i.e. language, region, etc.).
unsubscribed	If a user has unsubscribed from Bridge, a ‘t’ (true) will appear here.
welcomed_at	The date when the user was sent a welcome email from Bridge.
logged_in_at	The date the user last logged in.
config	Configuration relating to the Office 365 integration (calendar), accessibility (a11y), Retain tutorial walkthrough (bridge_retain_onboarding_pending), and timezone.
full_name	The user’s full name.
sortable_name	The user’s name (formatted as Last Name, First Name).
uuid	The Universally Unique Identifier.
sub_account_id	The ID of the subaccount the user belongs to (can be combined with the domains file).
hris_id	The user’s unique identifier used within the HRIS.
support_user	Users identified as being from Instructure support.
hire_date	The date the user was hired (as defined by your company).
hidden	Users identified as being hidden within Bridge

Get Additional Insights From Your Data

For support with additional files not listed in this document and to make the most of your learning data, join an Office Hours session hosted by the Customer Empowerment team or explore Bridge’s On-Demand Consulting for dedicated support with your analytics and reporting.

Related to