SleekView Charts for UM Private Messages: messaging dashboards
Ultimate Member Private Messages stores every thread and message in its own custom tables. SleekView Charts reads those rows and renders Number, Pie, Bar, and Area cards so community managers see message volume, top senders, and per-role activity on one screen.
♾️ Lifetime License available
Private message data as a real dashboard
Ultimate Member Private Messages writes its operational data into custom tables under the um_pm_ prefix: um_pm_messages for every message with sender_id, recipient_id, message body, sent timestamp, and read flag, plus a threads table linking the conversation participants. The default admin shows per-user message lists, but no real activity chart.
SleekView Charts reads the same tables and exposes them as a community-health dashboard. A Number card counts messages sent in the last 7 days. A Pie splits messages by sender role to show whether one tier is dominating the conversation. A Bar ranks top senders for moderation review. An Area plots daily message volume so spikes (a launch, a controversy, a holiday) get visible shape rather than scrolling through admin lists.
The dashboard refreshes against the live um_pm_* tables, so a message sent five minutes ago lands in the daily count immediately. Community managers gate the moderation view, growth managers watch the trend, and the chart never drifts away from the underlying inbox.
Workflow
From private message tables to a community dashboard
Map the messages table
um_pm_messages for the per-message rows. Charts read the indexed columns UM Private Messages already maintains, so the dashboard stays responsive even on busy communities.
Pick chart types
Configure groupBy and aggregation
Save moderator and manager dashboards
Sample dashboard
Charts you can build from UM Private Messages data
Messages this week
um_pm_messages with sent_at in the last 7 days. The headline community-health KPI, with the previous week underneath for comparison.
Count
Messages by sender role
wp_users to um_pm_messages.sender_id. Shows whether one tier is dominating the conversation.
Count
group by role
Top senders this month
um_pm_messages.sender_id by message count this month, resolved to display names. Useful for spotting active members and surfacing potential spam senders.
Count
group by sender_id
Daily message volume
um_pm_messages.sent_at. Spots launch spikes, controversy bursts, and the post-event decay shape that signals community momentum.
Count
group by sent_at
Comparison
Default UM Private Messages admin vs SleekView Charts
Default UM PM admin
- Per-user message lists, no community-wide volume chart
- Top senders not visualised, just sortable by hand
- No daily or weekly message-volume trend
- Per-role engagement mix isn't surfaced anywhere
- Cannot mix Number, Pie, Bar, and Area cards on one canvas
SleekView Charts
-
Count messages site-wide from a single
um_pm_messagesquery - Donut Pie of messages by sender role for per-tier engagement
- Horizontal Bar leaderboard of top senders for moderation review
- Gradient Area on sent_at for daily community-momentum trends
- Per-role saved dashboards (moderators, managers, support)
Features
What SleekView Charts gives you for Ultimate Member Private Messages
Live volume KPIs
Number cards count messages sent in the last 7 days, unread totals, and threads opened this month, all from indexed columns on um_pm_messages. Refresh times stay flat as the table grows.
Daily activity trends
Group sent_at by day, week, or month for the Area card that surfaces launch spikes, weekend lulls, and the decay shape after a community event. The shape is the engagement signal.
Top-sender leaderboards
A Horizontal Bar ranked on sender_id with a Count aggregation makes the top contributors and the potential spam accounts visible without scrolling. Mods can act from the same screen they see the chart on.
Audience
Who builds UM PM dashboards with SleekView
Moderators
Open the top-sender Bar and the unread Number each morning. Spam patterns and stalled conversations both surface on one screen without combing through inboxes.
Community managers
Watch the daily trend Area against event dates and the per-role Pie for engagement balance. Drives the next AMA or community challenge decision from observed activity.
Support leads
Track support-team senders separately on a filtered Bar. Spots underloaded or overloaded support agents inside the messaging system itself.
The bigger picture
Why community messaging needs a trend dashboard
Messaging volume is the heartbeat of any community plugin. Up week over week means engagement is healthy, flat means momentum is dying, spiking unevenly means an event or a problem is driving the traffic. UM Private Messages records every message in um_pm_messages with timestamps and sender identifiers, but the default admin only shows per-user inbox lists.
Community managers who want a real activity chart either build one themselves or trust their gut. SleekView Charts runs against the same tables the inbox screen reads, so the daily message-volume Area matches the inbox counts and the top-sender Bar matches the moderation queue. The trend stays honest, the team works from one source, and the dashboard updates as new messages land in the table.
Questions
Common questions about SleekView Charts for Ultimate Member Private Messages
Yes. An Area or Line card on um_pm_messages.sent_at with a Count aggregation produces a daily trend. Bucket weekly or monthly for longer-range views, and place the daily and weekly cards side by side for both operational and strategic perspectives.
Yes. A Horizontal Bar grouped on sender_id with a Count aggregation ranks senders by message volume, joined to wp_users for display names. Useful for surfacing active community members and potential spam accounts together.
Yes. Join um_pm_messages.sender_id to wp_users for the role, then group a Pie on role. Shows whether engagement is dominated by one tier or spread evenly across the membership, useful for tier-design decisions.
Yes. A Number card counts rows with read = 0 in um_pm_messages. Moderators use it as a workload indicator and managers watch it against the daily volume Area to make sure the moderation team is keeping up.
Yes. If your UM PM setup stores attachment references in the messages table or a sibling table, an additional Pie can group by has_attachment for the media-vs-text mix. The dashboard joins both sources transparently.
Cards run against the live um_pm_messages table on each refresh. A message sent minutes ago appears in the daily count, the trend Area, and the top-sender Bar at the next refresh, in lockstep with the UM inbox.
Yes. Saved dashboards are gated per WordPress capability. Moderators see the top-sender Bar and unread KPI, community managers see the trend Area and per-role Pie, and support leads get a filtered Bar scoped to support agents.
Yes. The same SleekView dashboard can mix the message-volume Area with the signup Area from wp_users.user_registered. One screen answers both "how fast is the community growing" and "how active is it".
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
- Wpc Frequently Bought Together
- Wt Woocommerce Sequential Order Numbers
- Woocommerce Customer Order Csv Export
- Yith Woocommerce Subscription
- Cartflows
- Woocommerce Afterpay
- Restropress
- B2bking
- Woocommerce Clearpay
- Woocommerce Xero
- Yith Woocommerce Gift Cards
- Advanced Woo Search
- Ecwid
- Woocommerce Product Filter
- Yith Woocommerce Role Based Prices
- Memberpress Importer
- Wp User Frontend Pro
- Memberium For Keap
- Ultimatemember Bbpress
- Memberpress
- Ultimatemember Paid Content
- Ultimatemember Friends
- Restrict Content
- Ultimatemember Content Restriction
- Profile Builder Pro
- Memberships By Supsystic
- Memberium Active Campaign
- Easy Affiliate
- Rcp Stripe Checkout
- Ultimate Affiliate Pro