There are multiple ways to export or download data from Watershed. You can:
- Use the report sharing feature to email fully interactive reports directly from Watershed or create shareable links, which you can send yourself.
- Embed complete Watershed reports into other applications.
- Download CSVs from individual reports.
- Use the Aggregation API to pull filtered, aggregated learning data into the systems that learners use, or the Statement API to pull unprocessed xAPI statements.
- Export all of your organizations raw interaction statements in one file or create a connection that pushes interaction statements to another LRS.
- Download archived learners' data from the Learner Status page.
All Watershed reports can be shared via links so others can view reports outside of Watershed. You have the option to either email the link to recipients directly from Watershed, or you can create a shareable link and deliver it yourself. Furthermore, shared reports can be configured to either always show the most up-to-date data or show snapshots of historical data.
Report sharing is most useful when you want to share the same view with multiple people (e.g., create a bar chart ranking learners to stir competition, or share a leaderboard of the most popular content to inspire other learners to check out the recommended favorites). The report sharing feature is easy to set up and doesn’t require integration with other systems.
Related: Learn how to Share Reports.
You can embed Watershed reports directly into other applications, saving you from having to rebuild or recreate those same reports outside of Watershed. These embedded reports can appear in LMSs or CRMs like Salesforce, and users do not have to be logged into Watershed to see the interactive reports.
Related: Learn how to Embed Reports.
Downloading CSV Data from Reports
You can download CSV data from reports in one of two ways: download the data as it's presented in the reports (Download Data Tables) or download the raw xAPI statements that make up the report (Download the Interaction Statements associated with a Report).
Related: Learn how to Download Data from Reports.
Pulling Data via the API
Watershed collects activity data in the form of xAPI interaction statements, aggregates that data into tabular structures, and then creates visualizations of that data. Because tabular data is designed for reporting, it’s much easier to work with than xAPI statements—which are optimized for collecting and sharing data, not processing it.
Your applications can access both the raw xAPI statements and the aggregated tabular data via Watershed’s Aggregation, Data Export and Statement APIs. While statement data can be used for activity streams, aggregated data typically is most useful for reporting and displaying indicators to your learners.
Watershed’s APIs are most useful for:
- integrating Watershed insights into your learning platform (e.g., creating a progress indicator on a course page)
- enabling your learning platform to make intelligent decisions based on data (e.g., unlocking new content based on learner performance data in Watershed)
- pulling data into an external BI tool for further analysis
Tableau Web Data Connector
Tableau is a popular BI tool used for visualizing data. Watershed's Tableau Web Data Connector makes it easy to connect data aggregated by Watershed to Tableau such that you can fetch up to date data from Watershed simply by pressing a button in Tableau.
Related: Learn how to Connect Watershed Report Data to Tableau using a Web Data Connector.
Exporting All Data
On the Export Data page in the Data section, you can export all raw interaction statements in a CSV or JSON file, or you can create a connection that pushes interaction statements to another LRS.
Only Global Admins can access the Export Data page in the Data section.
To do either, go to the Export Data page in the settings section:
To download all of your organizations data in one file, first choose a format (CSV or JSON) then click Download Interaction Statements.
Heads up: Depending on how much data your organization has, processing and downloading the file could take a long time. Don't close the window while you wait.
To create a connection that pushes interaction statements to another LRS, click Add Outbound Data Source:
Enter credentials provided by the other LRS. Different LRSs can have different names for some of the fields.
- Name: Name this something that will help you remember what it is. It won't effect the actual connection.
- Endpoint: The endpoint URL from the LRS that you’d like to push statements to
- Username: The username/app ID from the LRS that you’d like to push statements to. This will likely be different from the username you use to log into the LRS.
- Password: The password/secret key from the LRS that you’d like to push statements to. This will likely be different from the username you use to log into the LRS.
Click Save. If the connection is successful, Watershed will begin to push data to the other LRS. All existing data will begin to be sent over, and so should any future statements made in Watershed:
Heads up: Depending on how much data your organization has, the process for sending all of your data to the other LRS could take hours or even days. You do not need to keep the Export Data page up while the data is being sent to the other LRS.
Downloading Archived Learners' Data
On the Learner Status page, you can download individual archived learners' data.
Related: Learn how to download archived learners' data.