Primarily learnpress_user_items and learnpress_user_itemmeta for enrolments and quiz attempts, learnpress_order_itemmeta for paid course revenue, plus the lp_course and lp_order custom post types. No data is copied, the cards render straight off the tables LearnPress already maintains.

The core enrolment and quiz cards work because the same learnpress_user_items table backs both free and Pro versions. Pro-only features (instructor commissions, certificates, announcements) need the Pro license to populate their related tables; the dashboard surfaces whichever tables are populated on the site.

Yes, where the Pro license enables commission tracking. Group order line items by instructor user_id and sum the commission amount column. Render as a horizontal bar to rank instructors by gross commission across the period, useful for monthly commission runs.

Yes. learnpress_user_items captures each attempt with start_time and status. SleekView Charts can show first-attempt pass rate, best-attempt pass rate or average score per quiz, depending on which question the dashboard is built to answer.

Where SleekView writes through LearnPress's APIs (enrolment, completion, quiz grading), the standard hooks fire normally so certificates issue and notifications send. Direct table writes skip hooks by design for back-fills where side effects are not wanted.

Yes, where LearnPress Pro memberships are configured. Join the membership table to learnpress_user_items by user_id and split the dashboard cards by plan_id. Useful for membership operators auditing which plans deliver the highest completion rates.

No. learnpress_user_items is indexed on user_id, item_id, item_type and status, and SleekView's group-by queries use those indexes. Sites with hundreds of thousands of enrolment rows render the dashboard in well under a second on typical Kinsta or WP Engine hardware.

Yes. Any chart dashboard exports the underlying enrolment or order log to CSV or JSON. Useful for sending an instructor their per-course report, for combining LearnPress data with HRIS data outside WordPress or for archival to a learner-record store.