✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView Charts dashboard for WP Courseware Stripe

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

1

Pick the subscriptions table

Use 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.
2

Join the course enrolment table

Bring in 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.
3

Configure the chart cards

Mix Number, Pie, Bar, and Area cards. Group by status, course_id, or created date and aggregate as Sum on recurring_amount or Count on rows. Each card stays editable without touching SQL.
4

Save and share per role

Save the dashboard for the course owner and gate access by capability. Finance sees MRR and churn at the catalogue level, instructors see per-course paid enrolment counts.

Sample dashboard

Charts from WP Courseware Stripe data

A typical WPCW Stripe dashboard mixes active MRR, status share, top courses by paid enrolment, and a renewal trend area chart. Every card reads the WPCW tables directly.
Number · Default

Active monthly recurring revenue

Sums recurring_amount on wp_wpcw_subscriptions where status equals active, normalised to monthly for non-monthly periods. The single MRR KPI the team anchors weekly reporting on.
Sum(recurring_amount)
Pie · Donut

Subscriptions by status

Splits subscriptions across active, on_hold, cancelled, and expired using the status column. Surfaces the churn pipeline against active customers at a glance.
Count group by status
Bar · Horizontal

Top courses by paid enrolment

Horizontal bar ranking courses by active wp_wpcw_user_courses rows linked to an active Stripe subscription. Joined to the course post type for readable titles.
Count group by course_id
Area · Gradient

New subscriptions per day

Gradient area of new subscription rows per day from the created timestamp on wp_wpcw_subscriptions. Reveals launch impact and seasonal patterns.
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_amount on subscriptions
  • Status donut over the status column
  • Top-course bar joined through wp_wpcw_user_courses
  • Daily new-sub area chart from the created column
  • 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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