ClearCompany Learning: Export Reports

The Learning Export Reports provide SuperAdmins with access to raw data exports in .CSV format. These files allow organizations to perform in-depth data analysis, support compliance and audit efforts, and integrate with external business intelligence tools. While these reports are not formatted for immediate presentation, they are a powerful resource for organizations to build customized insights outside the learning platform.

In this article:
Export Report Overview
Export Report Navigation
Export Reports Available
F.A.Q.

Export Report Overview

Export Reports are raw, unprocessed datasets pulled directly from the learning platform, available only to SuperAdmin users. Export Reports provide backend-level data access across various learning system components.

• Purpose: Raw data for custom reporting, development, and BI integration.

• Limitations: No scheduling, formatting, or automated delivery.

• Audience: Developers, data analysts, or admins needing audit-level insights.

---

Navigation

1. From the administration dashboard, click Reports, then click Export Reports.

2. Use the dropdown to select the type of export reports.

---

Export Reports Available

Assignment Batches

Tracks batch assignments created within the learning platform, detailing how and when users were assigned training.

Use Cases:

• Monitor assignment strategies and batch timelines.
• Identify who assigned the training and when.
• Audit compliance by reviewing assignment due dates and statuses.

Data Fields
Batch ID	Batch Status	Recur Type
Batch Name	Email Receipts	Recur Day No
Batch Creation Date	Allow Grandfathering	Recur Date to Use
Assign Date	Days Due	Comments
Assigned By	Due Date

---

Ecommerce Orders

Details of purchases made within the learning platform, including user, order, and payment metadata.

Use Cases:

• Reconcile the learning platform's financials with accounting records.
• Analyze purchasing trends by course, user, or payment method.
• Audit tax and discount application per transaction.

Data Fields
Order ID	Last Name	PO No
Order TS	Email	Sales Tax
Order Status	Phone	Tax Rate
User ID	Total	Discount
First Name	PMT Type	Coupon ID
	Currency

---

Faculty

Stores faculty member profiles, including contact information and biography.

Use Cases:

• Generate faculty directories.
• Analyze regional availability or qualifications of instructors.
• Sync faculty profiles to external HR or communication platforms.

Data Fields
Faculty ID	Street 2	Website
First Name	City	Biography
Last Name	State	Status
Organization Name	Zip
Street 1	Email

---

Groups

Provides group hierarchy and metadata within the learning platform.

Use Cases:

• Determine user access and visibility restrictions.
• Support organizational structure mapping.
• Troubleshoot content access issues via group relationships.

Data Fields
Group ID	Created Date
Parent Group ID	Group Status
Parent ID List	Group Code
Group Name	Group Description
Group Type ID	Creator User ID

---

Objects

Captures metadata for training objects such as courses, videos, and modules.

Use Cases:

• Diagnose content access issues via Owner Group ID.
• Track object availability and creation dates.
• Create an inventory of available training materials.

Data Fields
Object ID	Object Type	Object Thumbnail
Object Name	Duration	Duration Secs
Object Status	Object Thumbnail	Owner Group Id
Object Description

---

Tags

Lists all tags used across objects and content for classification.

Use Cases

• Standardize taxonomy and content categorization.
• Identify unused or outdated tags.

Date Fields
Tag ID	Tag Name	Tag Type

---

User Records

Captures the relationship between users and the learning objects they engage with.

Use Case:

• Analyze learning progress and outcomes.
• Support compliance tracking and historical record audits.

Data Fields
Record ID	User ID	Object ID
Parent Record ID	Grandfather ID	Start TS
Completed TS	Status	Logged TS
Batch ID	Score	Entry No
Logged By

---

Users

Provides user profile information stored in the learning platform.

Use Cases

• Identify duplicate accounts using the Created Date.
• Export user data for internal directory sync or HR audits.

Data Fields
Last Name	Status	Added by
User ID	Email	Language ID	Comments
Username	Phone	GMT Offset	Vendor User ID
First Name	Job Title	Expires On
Middle Name	Created Date	Force Password Change

---

Class Schedules

Includes scheduling details for instructor-led or time-bound training events.

Use Cases

• Coordinate training schedules with faculty availability.
• Track session participation and time-zone alignment.

Data Fields
Object ID	Object Name	Entry No	Start TS
End TS	Entry Description	Location	Reg Start TS
Reg End TS	Call Number 1	Completion Code	GMT Offset
Faculty	Creator User ID	Creation TS	Status
Event Name

---

Group Options

Provides additional configuration or metadata linked to groups. Includes details for LinkedIn Learning integration and organizational linkage.

Use Case

• Support advanced group filtering or access rules for content.
• Assist with third-party system integration where group matching is required.

Data Fields
Group Name	Group ID	LinkedIn Integration ID	LinkedIn Org Urn	LinkedIn Org Displayname

---

Company News

Captures internal company news content shared via the learning platform.

Use Cases

• Analyze communication frequency and timing.
• Archive important internal announcements.

Data Fields
Group Name	Group ID	Body	Start TS	End TS

---

F.A.Q.

Can export reports be generated on a recurring basis or scheduled for delivery?

No. Reports must be manually generated by a SuperAdmin through the admin dashboard.

Why do some fields include special characters or raw data?

Export Reports reflect unprocessed data from the learning platform database, which may contain symbols or encoding formats. These cannot be altered or "cleaned" in the report itself.

How can organizations use these reports most effectively?

Reports are best used by internal Development, BI, or Compliance teams to build dashboards, validate system usage, troubleshoot, or import learning platform data into external tools for broader analysis.