SleekView Charts for WP Courseware Stripe: subscription dashboards
SleekView Charts reads wp_wpcw_subscriptions alongside wp_wpcw_user_courses. Active subscriptions, MRR, status share, top courses by paid enrolment, and renewal trend render as Number, Pie, Bar, and Area cards in WP Admin without leaving the LMS.
♾️ Lifetime License available
WP Courseware Stripe revenue and churn, charted
WP Courseware (WPCW) Stripe adds a recurring billing layer over WPCW course access. Subscriptions live in wp_wpcw_subscriptions with status (active, on_hold, cancelled, expired), period, recurring_amount, and gateway_customer_id columns. The underlying course enrolment row sits in wp_wpcw_user_courses keyed by user_id and course_id, with course_progress_status tracking learner state.
WPCW's default subscription view is a paginated list with filters by status and date. There is no dashboard for active MRR, no share-of-total by status, and no per-course paid enrolment trend. Renewal patterns and churn over time are buried inside Stripe itself, and matching that data back to WPCW courses requires manual joins.
SleekView Charts reads the WPCW subscription table directly. A Number card anchors active MRR. A Pie splits subscribers by status. A Bar ranks courses by paid enrolment count. An Area trends new subscriptions per day. Filters carry across every card so a course-launch review by date range or product is two clicks, not a Stripe-plus-WPCW reconciliation.
Workflow
Build the WPCW Stripe dashboard from real subscription data
Pick the subscriptions table
wp_wpcw_subscriptions as the source. SleekView reads status, recurring_amount, period, created, and next_payment columns so each card aggregates revenue, count, or trend on a meaningful dimension.
Join the course enrolment table
wp_wpcw_user_courses for the course_id link to each subscription, and join the WPCW course custom post type for readable titles. The shared key is user_id.
Configure the chart cards
Save and share per role
Sample dashboard
Charts from WP Courseware Stripe data
Active monthly recurring revenue
Sum(recurring_amount)
Subscriptions by status
Count
group by status
Top courses by paid enrolment
Count
group by course_id
New subscriptions per day
Count
group by created
Comparison
Default WPCW reports vs SleekView Charts for Stripe data
Default WPCW subscriptions list
- Subscription view is a paginated list without MRR or churn aggregates
- Renewal trend over time is not a chart, only sortable created dates
- Per-course paid enrolment needs joining two screens by hand
- Status share is a filter on a table, not a saved donut
- Filters do not carry between subscription view and course enrolment screens
SleekView Charts
-
Active MRR Number card from
recurring_amounton subscriptions -
Status donut over the
statuscolumn -
Top-course bar joined through
wp_wpcw_user_courses -
Daily new-sub area chart from the
createdcolumn - Cards link to SleekView Tables for per-subscription drill-in
Features
What SleekView Charts gives you for WP Courseware Stripe
Active MRR as a real KPI
Sum on the recurring_amount column normalised to monthly produces a real MRR figure straight from WPCW data. Filters scope the same Number card to a single course or product line for a focused per-launch view.
Churn pipeline as a donut
Pie cards over the status column give a share-of-total view of active, on_hold, cancelled, and expired subscriptions. Useful for the weekly finance stand-up where the churn ratio matters more than raw counts.
Per-course paid enrolment
Bar cards group by course_id and rank by active subscription count. One glance tells the course owner which products generate recurring revenue and which are one-off flat sales.
Audience
Who builds WP Courseware Stripe dashboards with SleekView
Finance
Active MRR and churn share Number cards plus a renewal trend area chart. Replaces a monthly Stripe-plus-WPCW reconciliation with a saved dashboard view.
Course owners
Top-course bar ranks paid enrolment across the catalogue and a status donut shows churn. Decide content-refresh priorities from one screen instead of two admin tabs.
Customer success
Status donut filtered to a customer cohort and a Number card for on_hold subscriptions in the past week. Easy to surface dunning cases before they cancel.
The bigger picture
Why subscription data deserves a chart, not a list
Course businesses running WPCW Stripe look at the same handful of numbers every week. Active MRR, churn ratio, top courses by paid enrolment, and the trend of new subscriptions over time. Each one lives in wp_wpcw_subscriptions and wp_wpcw_user_courses already, but the default subscription list answers none of them in a single click.
Stripe's own dashboard has trend charts but not the WPCW course join, and WPCW has the course join but not the trend charts. SleekView Charts treats the WPCW subscription table as a source you point chart cards at, with filters that carry across the whole dashboard. The result is a real revenue dashboard that updates as subscriptions write.
Questions
Common questions about SleekView Charts for WP Courseware Stripe
Yes. The add-on is what populates the wp_wpcw_subscriptions table with Stripe subscription rows. Without it the WPCW course tables still exist but the subscription join is empty, so cards that reference MRR or renewal trend fall back to enrolment-only counts.
 Yes. Page-level filters propagate to every card, so picking a course_id, a date range, or a status recomputes every Number, Pie, Bar, and Area on the dashboard. Saved views per launch keep historical numbers stable.
 Yes. An Area card grouped by the cancelled timestamp on the subscriptions table trends churn per day or week. A second Number card computes the rolling churn rate (cancellations divided by active subscriptions at period start) for a real metric, not just a count.
 Yes. The period column on wp_wpcw_subscriptions stores the billing cycle. SleekView normalises recurring_amount to monthly using the period so MRR cards mix annual and monthly subscribers on the same basis.
 Reads run against the live tables on dashboard load, so a subscription just created or cancelled by the Stripe webhook appears immediately. Heavier aggregates (LTV by course year-to-date) opt into a configurable cache so they do not recompute on every visit.
 Yes. Each card exports its underlying aggregated rows as CSV or JSON. Useful for finance reviews that need to send the WPCW-side subscription roster alongside the Stripe export for reconciliation.
 Yes. SleekView Charts reads the same wp_wpcw_subscriptions rows the SleekView Table view writes to, so a manual status change from on_hold to active recomputes the dashboard. WPCW hooks fire normally so downstream automation continues.
 Yes. Each subsite has its own WPCW tables and SleekView Charts reads the current subsite. Cross-site aggregation is not supported, but per-site dashboards behave as expected and can be scoped per role on each subsite.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Sprout Invoices
- Booster For Woocommerce
- Advanced Shipment Tracking For Woocommerce
- Woocommerce Side Cart
- Woocommerce Csv Import Suite
- Wpc Fly Cart
- Yith Woocommerce Stripe
- Woocommerce Paypal Checkout
- Woocommerce Multilingual Currency
- Yith Woocommerce Product Slider
- Woocommerce Multistore
- Woocommerce Shipping Fedex
- Woocommerce Sezzle
- Yith Essential Kit
- Wpc Smart Wishlist
- Woocommerce Memberships
- Ontrapages
- Ultimatemember Real Time Notifications
- Profile Builder Pro
- Swpm Buddypress Integration
- Memberium For Keap
- Easy Affiliate
- Ultimate Affiliate Pro
- Wp Courseware Members
- Memberium Infusionsoft
- Memberful Wp
- Armember Membership Pro
- Profile Magic
- Ultimatemember MyCRED
- Pmpro Register Helper