SleekView Charts for myCred
myCred records every credit, debit, and rank change in wp_mycred_log. SleekView Charts turns that ledger into a dashboard of total points, reference breakdowns, and daily activity trends.
♾️ Lifetime License available
myCred ledger as a dashboard
myCred treats points as a ledger: every gain, deduction, manual adjustment, and rank promotion writes a row to wp_mycred_log with a reference like purchase_completed, daily_login, or store_redemption. The default myCred admin shows the log one point type at a time, which makes the macro view (how many points issued this month, which references drive the most activity, which users earn the most) difficult to assemble.
SleekView Charts reads wp_mycred_log directly and exposes it as a generic chart data source. A Number card sums total points issued. A Bar card ranks references by activity. A Pie card splits the log by point type. An Area card plots daily log volume so spikes and dips become visible at a glance.
Because the dashboard reads the same table the Table view reads, drill-through from a chart segment to the matching ledger rows is built in. Click the manual_adjustment Bar column and the Table opens filtered to manual adjustments for the investigation that follows.
Workflow
myCred dashboard, four steps
Connect the log
wp_mycred_log. The columns myCred maintains (user_id, ctype, ref, creds, time) all become chart data fields without any schema mapping.
Choose chart types
Configure aggregation
Save dashboards per audience
Sample dashboard
Charts you can build from myCred data
Total credits issued
wp_mycred_log.creds across all positive credit rows. The headline KPI for the rewards economy at a glance.
Sum(creds)
Activity by reference
wp_mycred_log grouped by reference (purchase_completed, daily_login, store_redemption). Ranks which rules drive the most activity.
Count
group by ref
Log volume by point type
Count
group by ctype
Daily log entries
wp_mycred_log rows grouped by day. Surfaces activity spikes (campaigns, contests) and dips (rule misfires) without paging through the log.
Count
group by time
Comparison
Default myCred admin vs SleekView Charts
Default myCred admin
- Log screen shows one point type at a time, no cross-type chart
- No reference-ranking Bar in the default UI
- No daily-activity Area for spike detection
- Per-user totals require navigating individual profiles
- No drill-through from an aggregate to the underlying rows
SleekView Charts
- Single dashboard across every registered point type
- Number, Pie, Bar, and Area cards on one canvas
- Reference-ranking and per-user-top charts as first-class
- Shared data source with the Table log view, drill-through included
- Saved layouts per audience (community, loyalty, finance)
Features
What SleekView Charts gives you for myCred
Cross-type chart canvas
Build a dashboard with Number, Pie, Bar, and Area cards reading wp_mycred_log directly. All registered point types appear in the same canvas, filterable by ctype as needed.
Reference rankings
A horizontal Bar card grouped by reference ranks which rules fire most. Spot misbehaving automations (rules firing 10x the normal rate) and high-performing rules (campaigns earning real engagement) in one chart.
Same source as Table
Charts and the log Table share a data source, so a Bar column's count and the filtered Table's row count match. Click a column to investigate the underlying ledger rows immediately.
Audience
Who builds myCred charts dashboards with SleekView
Community managers
Daily activity Area, reference ranking Bar, and a total-credits KPI on one screen for the weekly community review.
Loyalty operators
Track which rewards drive the most redemptions, which rules generate the most credits, and which days see the highest engagement to tune the rewards program.
Support and finance
Total credits issued, manual-adjustment count, and per-type distribution help finance bound the reward-cost budget while support spots anomalous user activity.
The bigger picture
Why myCred ledgers need a real chart surface
A points economy lives on aggregate behavior. The individual log row matters when a member tickets in about disappearing points, but the daily, weekly, and monthly aggregates are what tell community managers whether the rewards program is working. Are members actually logging in for the daily-login award? Is the store-redemption flow being used? Is any single rule firing 100x the normal rate because of a misconfiguration? myCred's log holds all the data needed to answer those questions, but the default admin presents the log one point type at a time and offers no chart surface.
SleekView Charts treats wp_mycred_log as a generic chart data source, so the macro view becomes a dashboard the community manager can load each Monday morning. The plugin keeps running the economy; the operational team gets the visibility to know whether the economy is healthy.
Questions
Common questions about SleekView Charts for myCred
Yes. The log table is a generic data source, so groupBy, aggregation, and filtering all work against its native columns (user_id, ctype, ref, creds, time). No custom SQL is required, and the joins to the user table happen automatically when a card adds a user dimension.
Yes. Cards either filter to a specific point type or group by the ctype column to show all types side by side. A site running points, badges, and credits as three types can display all three on one screen or split into per-type tabs.
Filter the log to the reference your campaign uses (for example, summer_quest_completed) and plot Count over time on an Area card. Add a Number card for total points issued through that reference for a campaign-cost view.
Yes. A Bar card grouped by user_id ranks members by total credits earned or total redemptions over a chosen window. Filter by reference to see top redeemers for a specific reward.
Yes. The log table is indexed on user_id, ctype, and time, and chart aggregations use those indexes. Logs with millions of rows still aggregate in under a second for typical groupings on a normally tuned WordPress install.
Yes. Click a chart segment to open the matching filtered Table view of the log. Click the manual_adjustment Bar column and the Table opens filtered to manual adjustments, ready for the investigation that follows.
Yes. Ranks promotions and Badges awards write to wp_mycred_log using their own references, so they appear in reference-ranking charts and per-type Pies alongside core credit and debit activity.
Yes. Community managers, loyalty operators, finance, and support each get a capability-gated saved layout. The same log table feeds every layout; the chart cards on the canvas vary per audience.
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