Add your own columns and data to Uncanny Groups and LearnDash course reports and empower your Group Leaders with the tools they need.
As an e-learning educator or administrator, you know how important it is to have accurate and detailed course reports. And while LearnDash has some built-in reporting tools, oftentimes, you need additional information. Custom data fields such as a user’s job title, age, department/organization or even last login date can be invaluable for administrators, instructors and LearnDash Group Leaders.
So, if you’ve been looking for a way to add more columns and custom data to your Uncanny Groups and LearnDash course reports, then you’ve found the right page. In this article, we’ll show you a few simple ways to customize your Uncanny Groups and LearnDash course reports. We’ll also show you how to make those reports visible right from your WordPress dashboard so that Group Leaders can access them.
Trust us, this will be the easiest course you take all day.
Custom Columns in CSV Files for Administrators
For WordPress and LearnDash administrators, one of the simplest reporting tools available are LearnDash’s native CSV reports. These reports provide administrators with the ability to export basic information on users’ course and quiz data to CSV files where they can perform in-depth analysis and keep track of their KPIs. As useful as these native CSV reports are, however, they don’t always contain the information that you’re looking for.
Enter Uncanny Toolkit Pro.
To customize your LearnDash user reports, follow these simple steps.
- Download Uncanny Toolkit Pro
As the leading add-on for LearnDash users, Uncanny Toolkit expands and improves upon the features and functionalities of your LMS website. If you’ve ever found yourself wishing that LearnDash could do “X” (such as report customization) or show you “Y” (such as unique metadata), Uncanny Toolkit is the add-on you need. With 30+ modules and first-in-class support, you’ll have total control over your ability to customize your LearnDash site and your users’ e-learning experience.
To gain access to additional modules, such as the Enhanced LearnDash CSV Reports module that we’ll be using to improve LearnDash Reports, you’ll need the Pro version of Uncanny Toolkit. Click here to download Uncanny Toolkit Pro.
- Select the Enhanced LearnDash CSV Reports Module
After downloading Uncanny Toolkit Pro, from your WordPress dashboard, navigate to Uncanny Toolkit > Modules. Scroll down to Enhanced LearnDash CSV Reports and toggle the module “On”. The toggle switch will appear green when enabled.
- Configure the Module Settings
To add columns to LearnDash user reports, click on Settings in the Enhanced LearnDash CSV Reports module. A pop-up window will appear where you can select from predefined columns such as Username, Language and Website.
If you scroll down, you’ll also see that Toolkit Pro lets you add user and course metadata as columns when you enter the meta key. These fields are particularly useful when you want to include custom metadata. For example, we have created the custom metadata department, job title, age and last login to better understand our user engagement and performance.
Having entered the meta key into the Usermeta Key fields, we were able to add those keys as columns in our exported CSV reports.
If you don’t know how to create and retrieve custom metadata on WordPress, jump down to the section Create Custom Metadata for WordPress.
We’ve seen how, with the Toolkit Pro add-on for LearnDash, you can drastically improve your LearnDash course reports. But CSV files don’t suit everyone’s workflows. Not to mention, Group Leaders and other instructors without administrator access to the back-end of your WordPress website won’t be able to retrieve their own LearnDash course reports.
If you’re using the Uncanny Groups for LearnDash add-on, however, you can add columns to reports on the front-end of your WordPress website for Group Leaders and instructors to access. Furthermore, you’ll be able to export the reports to Excel if that format suits your workflows better than CSV files.
Custom Columns for Uncanny Groups Course Reports
If you’ve been using the Uncanny Groups for LearnDash add-on then you already know about all of the amazing features such as front-end management and reporting tools for Group Leaders. However, sometimes, your Group Leaders will need more information than what the default reports contain.
Fortunately, there’s an easy way to add custom columns and data to your Uncanny Groups course reports. Follow these steps to help your Group Leaders drill down into their course and user data. We’ll also show you how easy it is to export course reports to Excel so that Group Leaders can track their KPIs and customize their analytics.
- Add Column Titles
First, you’ll need to add the titles of your custom columns to your Uncanny Groups course reports. To do this, you’ll need to add some code to the functions.php file of your child theme. The code snippet to add column titles to Uncanny Groups course reports is:
In the code snippet above, $columns[‘custom_key’] = ‘My custom column’ is where you can input the column title that you want. For example, we would like to add the column title Last Login so our code snippet would look like this:
Of course, you’d rarely only want to add only one column to your Uncanny Groups course reports. If you’d like to add multiple columns, simply include additional lines as follows:
- Add Column Values
Now that you’ve added the column titles to your Uncanny Groups course reports, it’s time to add the values. To input the values of your custom columns into your Uncanny Groups course reports, add the following code snippet to the functions.php file of your child theme:
In the code snippet above, $user_data[‘custom_value’] = get_user_meta( $user_id, ‘custom_value’, true ); is the line that will retrieve the user’s metadata that you want included in your Uncanny Groups report. In our example, with the meta values for all of our corresponding column titles, the code snippet would look like this:
Note: The snippet $user_data[‘learndash-last-login’] = get_user_meta( $user_id, ‘learndash-last-login’, true ); will return a timestamp value. If you want your course report to return the learndash-last-login value as the date format from your WordPress settings, you can use this code snippet:
- Export Uncanny Groups Reports to Excel
Navigate to the page(s) where you have your Uncanny Groups course reports. Note, you can include Uncanny Groups course reports on any page with the shortcode: [uo_groups_course_report]. As you can see in the image below, our custom columns along with the corresponding metadata have been added to our course report.
To export the report to Excel, simply click Excel export in the upper right-hand corner.
That’s all it takes!
Create Custom Metadata for Your LearnDash Reports
By default, WordPress stores a lot of data about your users. But it’s not always the data that you’re looking for. Throughout this article, we’ve been using custom WordPress metadata that suit our specific needs and workflows. Perhaps you’re already doing this on your site, like capturing “job title” or “department” in registration forms from your favorite form plugin, or a plugin like Advanced Custom Fields that adds extra data to users and posts. But, for greater control and management over your user and content records, you might need some additional help.
One popular solution for creating and manipulating custom WordPress metadata is our Uncanny Automator plugin. With Automator, you can craft recipes to create and alter unique metadata that you wouldn’t otherwise be able to. For example, we could help our Group Leaders by putting some key analytics right at their fingertips.
The recipe pictured above is the same one that we used to create some of the unique user metadata that you saw throughout this article. Whenever a user registers with our WPForms registration form, Automator creates the user meta organization and job_title along with the three unique key/value pairs quiz_100, quiz_85 and quiz_60 to track the number of quizzes a user passes with a given percentage score. We can then use subsequent recipes to alter that metadata, saving our Group Leaders hours of administrative work.
With these recipes and the ability to add custom columns to Uncanny Groups course reports, Group Leaders can easily keep track of their learners’ progress.