SleekView Charts for Ultimate Member Friends: connection dashboards
Ultimate Member Friends records every connection, friend request, and acceptance into its own tables. SleekView Charts reads those rows and renders Number, Pie, Bar, and Area cards so community managers see connection velocity, top connectors, and pending-request volume on one screen.
♾️ Lifetime License available
Friend-graph data as a real dashboard
Ultimate Member Friends keeps the social-graph data in custom tables under the um_friends_ prefix: um_friends for accepted connections with user_id, friend_id, and connected_at, plus a request-state table for pending and rejected requests with status and requested_at. The default admin lists a member's friends on the profile, but offers no community-wide graph view.
SleekView Charts reads the same tables and exposes them as a social-health dashboard. A Number card counts total accepted connections. A Pie splits requests by status (accepted, pending, rejected). A Bar ranks top connectors by friend count. An Area plots connection volume per day so the dashboard shows whether the community is forming new ties or stagnating.
Every card runs against the live um_friends_* tables, so a connection accepted minutes ago appears in the total count and the top-connector Bar at the next refresh. Community managers gate a growth dashboard, moderators get a pending-request workload view, all from the same source the friend-list profile screen reads.
Workflow
From friend tables to a graph dashboard
Map the friends tables
um_friends for accepted connections and the request-state table for pending and rejected rows. Charts read indexed columns UM Friends already maintains, so the dashboard stays responsive on large communities.
Pick chart types
Configure groupBy and aggregation
Save moderator and manager dashboards
Sample dashboard
Charts you can build from UM Friends data
Total accepted connections
um_friends where status = accepted. The headline graph-density KPI, with last week underneath for comparison so growth shows in context.
Count
Friend requests by status
Count
group by status
Top connectors
um_friends.user_id, joined to wp_users for display names. The community influencers and the suspiciously over-connected accounts both surface here.
Count
group by user_id
Daily connections formed
um_friends.connected_at. Surfaces onboarding-driven spikes, event-driven bursts, and quiet weeks across the community.
Count
group by connected_at
Comparison
Default UM Friends admin vs SleekView Charts
Default UM Friends admin
- Friend lists per profile, no community-wide connection count
- Pending and rejected requests not visualised, just rows
- No daily or weekly connection-velocity trend
- Top connectors and isolated members aren't surfaced anywhere
- Cannot mix Number, Pie, Bar, and Area cards on one canvas
SleekView Charts
-
Count total accepted connections from
um_friendsin one Number card - Donut Pie of friend requests by status (accepted, pending, rejected)
- Horizontal Bar leaderboard of top connectors for community influencers
- Gradient Area on connected_at for daily connection-velocity trends
- Per-role saved dashboards (moderators, managers)
Features
What SleekView Charts gives you for Ultimate Member Friends
Graph density at a glance
A Number card counts accepted rows in um_friends for the site-wide connection count. The number trends week over week so managers see whether the community is forming new ties or going flat.
Top-connector ranking
A Horizontal Bar ranked on user_id with a Count aggregation surfaces the community's influencers and any suspiciously over-connected accounts. Moderation and growth teams use it side by side.
Connection velocity trend
Group connected_at by day, week, or month for the Area card. Onboarding flows, event launches, and the slow-week shape all leave a visible trace on the trend before they show in member retention.
Audience
Who builds UM Friends dashboards with SleekView
Community managers
Open the connection-velocity Area against onboarding redesign dates to validate whether the new flow actually drives more connections. Acts as the closed-loop test for community UX work.
Moderators
Watch the request-status Pie for rejected-rate spikes that signal harassment or spam patterns. The dashboard surfaces the issue before it lands in support tickets.
Growth teams
Use the top-connector Bar to identify community influencers worth featuring in launch campaigns. The leaderboard refreshes live as connections are accepted.
The bigger picture
Why social communities need a graph dashboard
Friend graphs are the value layer most community plugins try to build, but few make the data observable. UM Friends stores every connection, request, and rejection in dedicated tables, then exposes it as a per-profile friend list and nothing else. Community managers who want to know whether the graph is growing, whether onboarding drives connections, whether one account is suspiciously over-connected, end up running custom queries or trusting gut feel.
SleekView Charts runs against the same um_friends tables the profile screens read, so the connection count, the top-connector Bar, and the daily velocity Area all stay in lockstep with the live graph. One source, one dashboard, all from the WP admin without writing SQL.
Questions
Common questions about SleekView Charts for Ultimate Member Friends
Yes. A Number card counts accepted rows in um_friends for the site-wide connection KPI. Compare it to last week with a relative period underneath to surface whether the graph is densifying or going flat.
Yes. A separate Number card counts rows with status = pending in the request-state table. Moderators use it as a workload indicator and notice when the pending pile grows faster than the team can review.
 Yes. A Horizontal Bar grouped on user_id with a Count aggregation produces a ranked leaderboard, resolved to display names. The list surfaces community influencers and any suspiciously over-connected accounts on the same chart.
 Yes. The status Pie includes accepted, pending, and rejected slices. A high rejected slice signals harassment, spam patterns, or friction in the connection UX, all observable from the chart before tickets land.
 Yes. An Area or Line card on connected_at with a Count aggregation produces a daily trend. Onboarding redesigns, event launches, and seasonal patterns all leave their shape on the chart for closed-loop validation.
 
Cards run against the live um_friends tables on each refresh. A connection accepted minutes ago appears in the total count, the trend Area, and the top-connector Bar at the next refresh, in lockstep with the UM admin.
Yes. The same SleekView dashboard can mix the connection-velocity Area with the signup Area from wp_users.user_registered. One screen answers both growth and engagement questions for the community.
Yes. Saved dashboards are gated per WordPress capability. Moderators see the request-status Pie and pending Number, managers see the velocity Area and connector Bar, and growth teams get the leaderboard, all from the same SleekView setup.
 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
- Wt Woocommerce Pdf Invoice
- Woocommerce Shop As Customer
- Checkout Manager For Woocommerce
- Woocommerce Deposits
- Order Status Manager
- Woocommerce Back In Stock Notifications
- Pretty Links
- Woocommerce Zapier
- Woocommerce Subscriptions
- Woo Paytm Payment Gateway
- Klarna Payments
- Cart66 Cloud
- Woocommerce Advanced Product Labels
- Woocommerce Pre Orders
- Woocommerce Blocks
- Pmpro Buddypress
- Pmpro Subscription Delays
- Ultimatemember Mailchimp
- Pmpro Bbpress
- Memberium For Keap
- Ultimatemember Content Restriction
- Memberpress Pro
- Nextend Social Login
- Memberium Infusionsoft
- Wp Members Pro
- Memberpress Coachkit
- Woocommerce Paid Courses
- Pmpro Register Helper
- Buddypress Docs
- Ontrapages