SleekView Charts for Ultimate Member
Ultimate Member writes registration fields, account status, and last-login into usermeta. SleekView Charts pivots that into Number, Area, Pie, and Bar cards so moderators and community managers see signup velocity and approval load on one screen.
♾️ Lifetime License available
Charts from usermeta and the users table
Ultimate Member is structurally a usermeta-driven plugin. Account status (account_status), last login (_um_last_login), registration form fields, and any add-on values land as rows in wp_usermeta keyed by user_id. The user record itself lives in wp_users with the registration timestamp in user_registered.
The default Ultimate Member admin shows approval queues and member directories, but no charts. Site owners who want to track signup velocity, approval-queue length over time, or the distribution of members across registration-form values either build a custom dashboard or pay for a generic analytics plugin that doesn't understand the usermeta schema.
SleekView Charts aggregates over wp_users and joins wp_usermeta for the field values that matter. A Number card holds total approved members. An Area card shows signups per day from user_registered. A Pie shows account-status distribution. A Bar ranks members per role or per registration-form value. The dashboard refreshes against the live tables, so the approval queue length on the chart matches the queue length in the moderation table.
Workflow
Build an Ultimate Member dashboard in four steps
Base on wp_users
wp_users as the base for most cards, with SleekView Charts joining wp_usermeta on user_id when an aggregation needs a meta value.
Group by status or date
account_status for the approval distribution, by user_registered for signup trends, or by WordPress role for per-tier counts.
Aggregate counts and times
_um_last_login for activity recency, or Count rows in wp_usermeta for filled-field counts.
Save dashboards per role
Sample dashboard
Charts you can build from Ultimate Member data
Total approved members
wp_users joined to wp_usermeta where account_status = approved. The headline membership number for the dashboard.
Count
Signups per day
wp_users.user_registered. Spots campaign-driven spikes and quiet weeks.
Count
group by user_registered
Account status distribution
Count
group by account_status
Members per role
Count
group by role
Comparison
Default Ultimate Member reporting vs SleekView Charts
Default Ultimate Member admin
- No charts UI shipped with Ultimate Member core
- Approval queue length isn't tracked over time
-
Signup trends per day require custom queries against
user_registered - Registration-form-field distributions aren't visualised
- Role and tier counts live across separate screens
SleekView Charts
- Count users grouped by account_status, role, or registration-field value
-
Area and Line cards from
user_registeredfor signup trends - Pie of approval status (approved, awaiting, rejected)
- Number cards for total members, awaiting count, last-login freshness
- Save moderator and manager dashboards independently
Features
What SleekView Charts gives you for Ultimate Member
Aggregates over usermeta
SleekView Charts joins wp_usermeta to wp_users on user_id and aggregates over meta values. Registration fields become group columns, approval status becomes a chart axis, profile completion becomes a measurable number.
Signup trends from user_registered
Group by wp_users.user_registered with daily, weekly, or monthly buckets for clean signup trend lines. Spots campaign spikes immediately.
Approval mix at a glance
A Donut text Pie card on account_status with the total in the centre and the awaiting-count callout in the legend. The approval backlog has a visible shape rather than just a queue length.
Audience
Who builds Ultimate Member charts dashboards with SleekView
Moderators
Track approval-queue size and the time-to-approve trend. The chart answers "are we keeping up?" before the queue overflows.
Community managers
Signup velocity, member-per-role breakdowns, and the distribution of members across a registration-form field like location or tier. One screen for growth questions.
Marketing
Sees which acquisition campaign correlates with signup spikes by comparing the signup trend against campaign dates. No CSV export, no second analytics tool.
The bigger picture
Why membership sites need trend dashboards
Membership health is a velocity question. Signups per week up or down compared to last month, approval backlog growing or shrinking relative to the moderation team's capacity, member-per-role mix shifting as the site adds new tiers. Ultimate Member has all the data in wp_users and wp_usermeta, but exposes it as queues and directories rather than trends.
Site owners who want trends turn to spreadsheets or paid analytics, and the dashboards drift away from the operational tables. SleekView Charts runs against the same tables the moderation queue uses, so the approval-count card matches the queue length on the moderator's screen. The trend stays honest and the team works from one source rather than two reconciled dashboards.
Questions
Common questions about SleekView Charts for Ultimate Member
Yes. Group an Area or Line card on wp_users.user_registered with a Count aggregation. SleekView Charts buckets the timestamps daily (or weekly, monthly) and renders the trend without a custom query.
Yes. Cards can join wp_usermeta on user_id and group on a meta key value. Useful for charting account_status distribution, role-based counts, or any custom registration-form field your community collects.
Yes. Custom UM roles live in the standard WordPress role system, so a Bar card grouped on role surfaces both core and custom roles. Useful for tier audits and capability planning when the membership tiers don't match WordPress core roles one-to-one.
 
Yes. Filter users by account_status = awaiting and group on user_registered. A Line or Area card shows whether the backlog of awaiting accounts is growing faster than the moderation team can keep up with.
Yes. Each registration form writes its fields into wp_usermeta with predictable keys. SleekView Charts aggregates over any of those keys, so charts of "members per location" or "signups per tier" work the same way regardless of which Forms add-on form they came through.
Yes. Use a Bar or Number card filtered by _um_last_login older than 90 days. The card shows the stale-account count, and combining it with a per-role breakdown identifies which tier has the worst engagement.
Cards run against wp_users and wp_usermeta on each refresh. A signup that landed five minutes ago shows up on the next card refresh, and the approval-queue chart stays in lockstep with the moderator's queue table.
Yes. Save dashboards and gate per WordPress capability or role. Moderators see the approval and queue dashboards, managers see signup velocity and tier distribution, with no SQL skills required for either.
 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