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. The plugin's tables stay the source of truth.

The core enrolment and quiz columns work because the same learnpress_user_items table backs both free and Pro versions. Pro-only features (instructor commissions, certificates, announcements) populate additional tables and meta that the view surfaces when present.

Yes, where the Pro license enables commission tracking. Filter order line items by instructor user_id and surface commission amount as a column. The view becomes the per-instructor commission table for the run.

Yes. learnpress_user_items captures each attempt with start_time and status. Filter to first-attempt or best-attempt per user and quiz depending on the question the table 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.

Yes, where LearnPress Pro memberships are configured. Join the membership table to learnpress_user_items by user_id and split the table by plan_id.

No. learnpress_user_items is indexed on user_id, item_id, item_type and status. SleekView uses those indexes, so sites with hundreds of thousands of rows render in well under a second.

Yes. Any filtered table exports to CSV or JSON with the same columns the view shows. Useful for instructor commission runs, for audit exports or for combining LearnPress data with HRIS data outside WordPress.