SleekView Charts for LifterLMS AffiliateWP: referral revenue dashboards
SleekView Charts joins affiliate_wp_referrals, affiliate_wp_visits, and the LifterLMS lifterlms_orders post type. Top affiliates, paid vs unpaid referral mix, course revenue by affiliate, and conversion trends render as Number, Pie, Bar, and Area cards inside WP Admin.
♾️ Lifetime License available
Affiliate revenue for courses, charted properly
LifterLMS AffiliateWP bolts AffiliateWP onto LifterLMS so course sales can be referred and tracked. Referrals land in affiliate_wp_referrals with affiliate_id, reference (the LifterLMS order id), amount, and status (pending, unpaid, paid, rejected). Visits sit in affiliate_wp_visits with referrer URL and conversion flag. Affiliate profiles live in affiliate_wp_affiliates with rate and earnings fields.
The default AffiliateWP reports show totals and per-affiliate detail, but a course business wants to see referral revenue blended with the LifterLMS catalogue: which courses each affiliate sells, conversion rate by source, paid vs unpaid pipeline, and trend over time. None of that is one click in either admin.
SleekView Charts reads the AffiliateWP tables together with the LifterLMS lifterlms_orders post type. A Number card anchors paid referral revenue this month. A Pie splits referrals by status. A Bar ranks affiliates by earnings tied to course sales. An Area trends conversions per day. Filters carry across the whole dashboard so a campaign review by affiliate, by course, or by date range needs no manual SQL.
Workflow
Build the LifterLMS AffiliateWP dashboard
Point at the referrals table
affiliate_wp_referrals as the primary source. SleekView reads amount, status, affiliate_id, reference, and date columns so cards can aggregate revenue or count and group by affiliate, status, or day.
Join visits and orders
affiliate_wp_visits for conversion-rate cards and the LifterLMS lifterlms_orders post type for the course attached to each referral. The join key is the referral reference column matching the order ID.
Configure the chart cards
Save and gate per role
Sample dashboard
Charts from LifterLMS AffiliateWP data
Paid referral revenue this month
Sum(amount)
Referrals by status
Count
group by status
Top affiliates by earnings
Sum(amount)
group by affiliate_id
Daily conversion trend
Count
group by date
Comparison
Default AffiliateWP reports vs SleekView Charts for LifterLMS
Default AffiliateWP reports
- Reports are split between AffiliateWP admin and LifterLMS, not blended on one screen
- Top affiliates list shows totals but not the trend or course mix behind them
- Paid vs unpaid status is a filter, not a saved share-of-total chart
- Conversion trend over time needs export to CSV and pivot outside WP
- Filters do not carry across the relevant referral, visit, and order screens
SleekView Charts
- Number cards for paid revenue, pending payout, and conversion rate
-
Status donut over the
statuscolumn on referrals -
Top affiliates bar joined through
affiliate_wp_affiliatesto display names - Daily area trend from visits and converted referrals
- Cards link to a SleekView table for per-row payout review
Features
What SleekView Charts gives you for LifterLMS AffiliateWP
Affiliate revenue in real numbers
Sums on the amount column give actual paid revenue, not a vanity click count. Filters on status separate booked from collectible so the affiliate manager sees both pipeline and recognised payout in the same view.
Status mix as a donut
Pie cards over the status column turn pending, unpaid, paid, and rejected into a single share-of-total view. Great for the weekly payout stand-up and for spotting a sudden rejection spike.
Per-affiliate ranked breakdowns
Bar cards group by affiliate_id and rank by earnings, conversion count, or rejection rate. One glance tells you who is selling courses, who needs creative refreshed, and who is gaming visits.
Audience
Who builds LifterLMS AffiliateWP charts dashboards
Affiliate managers
Daily paid revenue and conversion trend cards alongside a top-affiliates bar. Decide promotions and creative refreshes from one dashboard instead of stitching two admin screens together.
Finance
Pending and unpaid status counts on Number cards plus a paid-revenue area chart. Reconciles affiliate payouts to the LifterLMS order ledger without exporting CSV.
Growth leads
Conversion-rate trend from visits to paid referrals scoped to a campaign date range. Replaces a manual pivot of two CSV exports with a saved dashboard view.
The bigger picture
Why blended affiliate data needs charts, not two admins
Course operators running an affiliate programme look at the same handful of numbers every week. Paid revenue this period, conversion rate from visits, top affiliates by earnings, and the share of pending versus paid payouts. Each one lives in the AffiliateWP and LifterLMS tables already, but none of them are a single click in either admin alone.
The default reports stay inside their own plugin and the most interesting view (which affiliate sells which course, how often) needs SQL or a CSV pivot. SleekView Charts treats the AffiliateWP referrals table the same way the Tables view does: as a source you point chart cards at, with filters that carry across the whole dashboard. The result is a real reporting surface that updates as referrals write, not a stack of screenshots from two different plugins.
Questions
Common questions about SleekView Charts for LifterLMS AffiliateWP
Yes. The integration is what populates the reference column on affiliate_wp_referrals with the LifterLMS order id, which is the join key SleekView uses to attach course context to each referral. Without the integration the AffiliateWP tables still exist but the course join goes empty, so cards that reference courses or LMS orders fall back to amounts only.
Yes. Page-level filters propagate to every card, so picking an affiliate (or a date range, or a status) recomputes every Number, Pie, Bar, and Area card in the dashboard. Affiliates themselves can see a scoped dashboard fixed to their own affiliate_id.
Yes. A Number card divides referrals.count by visits.count over the same date range to produce a conversion percentage, with a deltas underneath comparing to the previous range. The two source tables are affiliate_wp_visits and affiliate_wp_referrals.
Yes. Any value present in the status column on affiliate_wp_referrals shows up in the Pie. If a custom status (held, manual_review) is set by another integration, SleekView surfaces it as a fresh slice without configuration.
Reads run against the live tables on dashboard load, so referrals just-written by AffiliateWP show up immediately. Heavier aggregates (year-to-date earnings by affiliate) opt into a configurable cache so they do not recompute on every visit; the cache window is per-card.
Yes. Each card exports its underlying aggregated rows as CSV or JSON. Useful for monthly payout review where the affiliate manager needs a snapshot to send to finance alongside the LifterLMS order export.
Yes. SleekView Charts reads the same affiliate_wp_referrals rows the SleekView Table view writes to, so a status change from unpaid to paid recomputes the dashboard on the next load. The AffiliateWP hooks fire normally so downstream payout workflows continue to run.
Yes. Each subsite has its own AffiliateWP tables and SleekView Charts reads the current subsite. Cross-site aggregation is not supported (each subsite is independent), 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
- Woocommerce Xero
- Yith Woocommerce Frequently Bought Together
- Yith Woocommerce Name Your Price
- Yith Woocommerce Bookings
- Flexible Shipping
- Aelia Tax Display By Country
- Fkcart
- Advanced Dynamic Pricing For Woocommerce
- Yith Woocommerce Wishlist
- Pretty Links
- Woocommerce Pre Orders
- Checkout Field Editor
- Woocommerce Product Bundles
- Yith Woocommerce Checkout Manager
- Woocommerce Purchase Order Gateway