SleekView Charts for WooCommerce Points and Rewards
WooCommerce Points and Rewards writes balances to wp_wc_points_rewards_user_points and events to its log table. SleekView Charts turns both into a dashboard where outstanding points, event mix, and top earners live on one screen.
♾️ Lifetime License available
Loyalty data as a dashboard
Loyalty programs run on segmentation, and segmentation runs on knowing the shape of the program. How many points are outstanding across all customers right now, what mix of events (earns, redemptions, signup bonuses, expiry) produced them, and which customers carry the largest balances? WooCommerce Points and Rewards stores all the raw data, but the default admin presents balances and event logs on separate screens with no chart layer on top.
SleekView Charts reads wp_wc_points_rewards_user_points and the points event log directly. Total outstanding points becomes a Number card. Event reference mix (order_complete, order_redeem, signup_bonus, expiry_clear, manual_adjustment) becomes a Donut. Top earners by lifetime earned rank as a Bar chart. Points-issued versus points-redeemed over time draw an Area trend.
The dashboard sits alongside the SleekView Points and Rewards table view, so loyalty managers drill from a chart segment into the customer rows behind it. Filters on customer role, event type, or date apply across every card, so a re-engagement segment narrows the Bar ranking and the Area trend at the same time.
Workflow
Loyalty dashboards in four steps
Connect the tables
Pick your KPIs
Save segment dashboards
Drill and export
Sample dashboard
Charts you can build from WooCommerce Points and Rewards data
Total points outstanding
Sum(points_balance)
Event mix
Count
group by event_reference
Top earners by lifetime points
Sum(points_earned)
group by user_id
Issuance vs redemption over time
Sum(points_amount)
group by event_date
Comparison
Default Points and Rewards reports vs SleekView Charts
Default Points and Rewards admin
- Outstanding points liability isn't a built-in chart
- Event reference breakdown requires manual log filtering
- Top earners need a custom SQL query
- Points-issued vs redeemed over time isn't graphed
- No combined view of balance plus event mix
SleekView Charts
- Total points outstanding as one Number card
- Event mix Donut shows where points come from
- Top earners ranked on a single Bar chart
- Issuance vs redemption as a stacked Area trend
- Customer-role, status, and date filters apply across every card
Features
What SleekView Charts gives you for WooCommerce Points and Rewards
Liability KPI
Total points outstanding lives on one Number card. Currency-converted using the plugin's point ratio, finance gets the program's cash-equivalent liability at a glance.
Event mix
Donut chart breaks events into earns, redeems, signup bonuses, and expiry clears. Program managers see at a glance which mechanic actually drives the loyalty numbers.
Top earner ranking
Customers ranked by lifetime points earned, ready for VIP outreach. Sort changes update the Bar in place, so a switch from lifetime to last-90-days takes one click.
Audience
Who builds WooCommerce Points and Rewards charts dashboards with SleekView
Loyalty managers
Outstanding balance, event mix, and top earners on one screen. The dashboard answers "how is the program doing" without piecing two screens together every Monday.
Marketing leads
Top earner Bar charts feed VIP campaigns directly. Click a slice to filter the SleekView table to the matching customers and export the segment as a CSV.
Finance
Points-to-currency conversion applied at the chart layer turns abstract points into a real liability number for the balance sheet.
The bigger picture
Loyalty dashboards turn data into decisions
A loyalty program that nobody graphs is a program that nobody can defend at budget time. WooCommerce Points and Rewards captures every earn, redeem, signup bonus, and expiry, but the default admin lays them out as rows on two separate screens. The questions program managers actually ask are chart-shaped: how big is the points liability today, what mix of events produced it, who are the top earners worth a VIP push, and is the issuance versus redemption trend healthy or trending toward an expiry-driven write-off? SleekView Charts answers each of those in a single dashboard built directly on the plugin's own tables.
The Number card is the headline. The Donut explains where points come from. The Bar surfaces the customers worth the next campaign.
The Area shows the trend that determines whether the program is converting or just accumulating obligation. Combined with the SleekView table view for row-level drilling, the dashboard turns loyalty data into a tool program managers actually use weekly.
Questions
Common questions about SleekView Charts for WooCommerce Points and Rewards
Yes. The Points and Rewards conversion ratio lives in plugin options. A computed valueColumn (points_balance multiplied by the ratio) lets the Number card report the cash-equivalent liability instead of raw points. Useful when finance wants a number that maps to the shop currency on the balance sheet.
Yes. Customers carrying a balance without any orders (signup bonuses, referrals) still appear in the points table. The dashboard counts them in the outstanding-points Number card and includes them in the top earner Bar where lifetime points warrant. No order is required for inclusion.
Yes. If expiry rules are configured in Points and Rewards, expiry_clear events appear in the event mix Donut and contribute to the Area trend's redemption-side stack. Build a Number card for points expired in the last 30 days to track retention leakage.
Yes. Pair the event mix Donut with a Bar chart counting order_redeem events versus order_complete events to see what proportion of earns actually convert. That ratio is the program's effective utilisation rate.
Yes. If reward tiers map to point thresholds, the Bar chart of customers by current balance can highlight tier cohorts using grouped bars. Near-threshold customers are the most actionable segment for nudge campaigns and the chart makes them visible at a glance.
Yes. Each chart exports its aggregated data to CSV with the active filters applied. Combined with the SleekView table view's row-level CSV export, finance gets both the summary and the source rows in one workflow for audit defensibility.
Yes. Filters on customer role, status, or date range cascade across every card. A filter to dormant customers narrows the top earner Bar, the event mix Donut, and the points-over-time Area to the same cohort, so the dashboard reads as one coherent picture rather than four disconnected charts.
Aggregations run server-side against indexed user_id and event_date columns. Stores with millions of point events render the dashboard in well under a second once aggregated results are cached at a configurable interval per card.
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 checkout