LinkedIn Learning is an online learning platform that offers a variety of courses and videos on business, creative, and technology topics. It includes functionality to track learner progress and generate reports for individuals and organizations. As an administrator or manager, you may need to pull reports from LinkedIn Learning to assess overall usage, course completion rates, top courses, learner engagement, and more.
There are a few ways to extract reports from LinkedIn Learning depending on your needs. The main methods are:
– Downloading standard reports directly from the LinkedIn Learning admin console
– Using the LinkedIn Learning APIs to pull custom report data
– Exporting report data to CSV files for additional analysis
In this article, we’ll walk through the steps and options for extracting standard and custom reports from LinkedIn Learning. We’ll also look at how to export LinkedIn Learning data to CSV format. With the right approach, you can get comprehensive insights into how learners in your organization are using LinkedIn Learning.
Downloading Standard Reports from LinkedIn Learning
The easiest way to get reporting data from LinkedIn Learning is to use the admin console to download standard reports. LinkedIn Learning offers around 10 pre-configured report templates that administrators can access.
Here are the main types of standard reports available:
Course Reports
– Course Completions – Shows all course completion details for a date range
– Course Starts vs. Completions – Compares course starts and completions
– Top Completed Courses – Lists the most completed courses
Learner Reports
– Learner Course Starts – Shows course starts by learner
– Learner Course Completions – Shows course completions by learner
– Top Learners – Shows learners with the most course activity
Curriculum Reports
– Curriculum Completions – Details on curriculum course completions
– Curriculum Starts vs. Completions – Compares curriculum starts and completions
– Top Completed Curricula – Lists the most completed curricula
Group Reports
– Group Course Starts – Course starts broken down by group
– Group Course Completions – Course completions broken down by group
– Top Groups – Shows groups with the most course activity
To download any of these standard reports:
1. Login to your LinkedIn Learning admin console
2. Click on the ‘Analytics’ tab
3. On the Reports tab, select the report you want to download from the list
4. Configure the report settings like date range and learner filters
5. Click ‘Download Report’ and select the file format – CSV, XLSX, or PDF
The report will be generated and downloaded to your computer in the selected format. You can then review and analyze the report data as needed.
The advantage of standard reports is they provide one-click access to common reporting needs. However, the data is limited to the predefined report fields and configurations. For more flexible analytics, you’ll need to use the LinkedIn Learning APIs.
Pulling Custom Reports using the LinkedIn Learning APIs
The LinkedIn Learning APIs provide programmatic access to pull custom reports from LinkedIn Learning. With the APIs, you can build queries to get exactly the data points you need.
There are two main APIs to use for reporting:
– Learning API – Returns learner progress and activity data
– Insights API – Provides summary statistics and aggregates
To call the LinkedIn Learning APIs, you’ll need:
– LinkedIn Learning account configured for API access
– Understanding of API syntax and structure
– Ability to make API calls from your application
Here is an overview of the process to pull a custom report with the APIs:
1. Determine the data fields you want in your custom report
2. Reference the LinkedIn Learning API documentation to find the relevant endpoints
3. Set up API authentication using OAuth 2.0
4. Construct the API call syntax with parameters for your report
5. Make the API call from your application
6. Handle the API response and parse the report data
7. Output or store the report data as needed
So for example, you could make a Learning API call like:
“`
GET https://api.linkedin.com/v2/learningAssets/{assetId}/courses/{courseId}/users?q=completionStatus:COMPLETED&startDate=2022-01-01&endDate=2022-12-31
“`
This would return all users who have completed the specified course between January 1, 2022 and December 31, 2022.
With the Insights API, you could get aggregate statistics like:
“`
GET https://api.linkedin.com/v2/learningAssets/{assetId}/courses/{courseId}/aggregateStats?timeRange=MONTH
“`
This provides monthly aggregate stats for a particular course.
The APIs allow endless customization and flexibility for LinkedIn Learning reporting. The main challenges are understanding the API syntax, properly authenticating, and handling large result sets. But for advanced reporting needs, the LinkedIn Learning APIs provide access to build any type of custom report.
Exporting LinkedIn Learning Report Data to CSV
For further analysis and integration, you may want to export LinkedIn Learning report data to CSV file format. CSV stands for “comma-separated values” and is a standard file format that can be imported into other systems.
Here are some scenarios where exporting to CSV is helpful:
– Bringing report data into Excel or Google Sheets for additional calculations and visualizations
– Importing completion records into your LMS or HR system
– Combining LinkedIn Learning data with reports from other sources
Both standard and API-generated reports can be exported to CSV format:
**Exporting Standard Reports to CSV:**
When downloading a report from the LinkedIn Learning admin console, choose the CSV file format option. The report will be exported as a CSV file that can be opened in Excel or other tools.
**Exporting API Reports to CSV:**
The LinkedIn Learning APIs return report data in JSON format. To convert this to CSV:
1. Make your API call to generate the report data
2. Parse and extract the JSON response in your application
3. Transform the JSON objects into a CSV structure
4. Write the CSV data to a file
Most programming languages like Python and Java provide libraries to streamline this JSON-to-CSV conversion.
The result is a CSV file containing your custom report data, which can be easily analyzed and integrated with external systems.
Use Cases and Examples
To put this reporting functionality into practice, here are some common use cases and examples for generating and exporting LinkedIn Learning reports:
Tracking course completions for compliance:
Pull a ‘Learner Course Completions’ report to get full details on completed courses. Export to CSV and import into your LMS to maintain compliance records.
Monitoring curriculum metrics:
Use the Curriculum API to get custom statistics like completion rates for curricula. Export to CSV and chart in Excel to view trends.
Analyzing top performers:
Download the ‘Top Learners’ standard report. Bring into your HR system to correlate top learning activity with performance.
Reporting by department:
Leverage the Groups API to get customized course metrics by department. Export to share across your organization.
Combining with other data:
Join LinkedIn Learning CSV exports with data from your LMS, HCM, etc. to uncover combined insights.
Conclusion
Accurately reporting on LinkedIn Learning utilization across your organization is critical for maximizing your learning investment. By leveraging the available standard reports, APIs, and CSV export capabilities, you can obtain comprehensive data to identify trends, surface insights, demonstrate value, and optimize learning. Use the methods outlined in this guide as a toolkit to build the right reports for your LinkedIn Learning analysis and reporting needs.
