How can an LMS content audit identify shelfware quickly?

LMS content audit: How to identify shelfware quickly

In our experience, a focused LMS content audit is the fastest way to identify shelfware and free budget for high-impact learning. This article presents a practical, step-by-step audit process you can run without waiting months for analysis: collect raw usage data, score courses for relevance and risk, validate with stakeholders, and use dashboards to prioritize remediation.

This guide includes a ready-made learning content inventory CSV template, a sample dashboard layout, a 30/60/90 timeline, and an anonymized walkthrough so you can start today.

Step 1 — Data collection: what to export

Start any LMS content audit by gathering the raw metrics that reveal usage patterns. If you can only export limited fields, prioritize the basics that let you audit LMS usage reliably: completions, last access date, enrollments, and average time spent.

Common barriers are permissions and inconsistent exports. If exports are messy, work with IT to schedule a clean CSV pull or use the LMS API. Capture at least 12 months of history when possible to avoid false negatives from seasonality.

What metrics matter?

Export these fields to build a defensible learning content inventory and to identify shelfware quickly:

• Course ID, title, category
• Created date, last updated date
• Total enrollments, completions, completion rate
• Last access date, average time spent per user
• Number of unique logins to the course, active users last 90 days
• Owner (content owner), tags, and external link

CSV export fields template

Use this header row in your CSV to standardize imports into spreadsheets or BI tools. This is your canonical learning content inventory:

• course_id, title, category, owner, created_date, last_updated
• enrollments, completions, completion_rate, unique_logins_90d
• avg_time_minutes, last_access_date, tags, language

Step 2 — Scoring content: relevance & decay

Raw numbers alone won't tell you which courses are shelfware. Build a simple course relevance score that combines usage metrics and business value. Scoring reduces noisy spreadsheets into clear prioritization buckets: keep, review, archive.

We recommend a 0–100 score made from weighted components: completion momentum, recency, business alignment, and owner validation. The LMS content audit becomes actionable when every course has a score and a recommended action.

Scoring model example

Example weights: 30% completion rate trend, 25% last access recency, 25% enrollments per month, 20% business alignment (owner input). Map score ranges to actions:

1. 80–100: Keep and maintain
2. 50–79: Review content for updates
3. 0–49: Archive or retire (suspected shelfware)

Tip: Flag low-score courses with low owner engagement as immediate archive candidates to reduce cognitive load for admins.

Step 3 — Stakeholder interviews & governance

Numbers generate candidates; interviews produce context. A quick round of interviews with content owners, team leads, and a sample of learners closes the loop: why was this course created, is it still business-critical, and what are acceptable alternatives?

Short, structured interviews (15–20 minutes) are enough. Capture answers in the inventory spreadsheet so scores and human validation live together for governance decisions.

Who should you interview?

Start with content owners for the top 20% of content by enrollments and the bottom 20% by score. Then interview two to three team leads in high-risk categories. Use a standard 5-question script that covers purpose, audience, usage, alternative resources, and preferred lifecycle.

• Question set: Purpose, target learner, availability alternatives, update cadence, and measured outcomes.
• Output: Owner confirmation, recommended action, and estimated effort to update or retire.

Governance is the lever that prevents future shelfware: publish a lifecycle policy and require an owner and review date for each course.

Tooling options and dashboards

When admins are overwhelmed, tools that automate data pulls and dashboards shift effort from collection to decision-making. Build a dashboard that surfaces low-use, stale, and high-cost courses so your team can act.

We’ve seen organizations reduce admin time by over 60% using integrated systems like Upscend, freeing up trainers to focus on content and remediation rather than manual exports.

Which tools fill common gaps?

If your LMS lacks reporting, consider BI connectors, learning analytics platforms, or simple ETL scripts. Key features to evaluate: scheduled exports, user-level session data, tag- and owner-based filters, and an API for enrichment.

Dashboard widget	Purpose
Low usage by last access	Identify shelfware candidates quickly
Course health score distribution	Prioritize review weeks
Owner response rates	Governance follow-up list

30/60/90 day LMS content audit checklist for managers

Use a time-boxed approach to avoid scope creep. Below is a compact LMS content audit checklist for managers that fits into regular operations and produces quick wins.

30 days: Export data, build the learning content inventory CSV, run initial scores, and identify top 100 review candidates. 60 days: Complete interviews, update scores, and retire the first tranche of clear shelfware. 90 days: Publish governance rules, measure reclaimed hours and storage savings, and plan content refreshes.

How to audit your LMS for unused courses?

For a targeted audit of unused courses, filter your inventory for courses with zero enrollments in 12 months OR last access > 12 months and low completion trends. Validate high-risk items with owners before archiving to avoid false positives.

• Days 1–30: Data collection and scoring
• Days 31–60: Owner interviews, small-scale retirements
• Days 61–90: Governance, automation, and reporting

Deliverables at 90 days: Updated inventory CSV, dashboard filters, and a policy that enforces review cadence.

Example audit walkthrough: anonymized metrics

Here’s a short anonymized example that illustrates the process and outcomes of an LMS content audit. Numbers are rounded for clarity.

Inventory: 1,200 courses. Initial exports showed 420 courses with zero enrollments in 12 months and 160 courses with last access > 24 months. Using the scoring model, 280 courses fell below a score of 50.

We interviewed 60 owners across high- and low-use groups. Owner validation moved 40 courses from archive to update and confirmed 220 as archive candidates. After a 60-day pilot retirements freed 12 GB of storage and reduced course admin work by an estimated 18 hours/month.

Final metrics after 90 days: retired 220 courses, updated 45 high-priority courses, and reduced course count by 18%. The organization reclaimed budget and refocused learning design resources toward measurable programs.

Conclusion

A concise LMS content audit uses data, a simple scoring model, and targeted interviews to rapidly identify shelfware and cut waste. Focus on clean exports, an actionable score, and governance to prevent re-accumulation.

Start with the CSV template and the 30/60/90 timeline above. Expect quick wins in the first 60 days and governance benefits by day 90.

Next step: Export your LMS data with the CSV headers provided, run the scoring model on the top 300 courses, and schedule 15–20 owner interviews this month to create immediate impact.