SleekView for Ultimate Member Reviews: profile reviews & ratings as tables
The Reviews extension lets community members rate and review each other's profiles. SleekView reads the reviews table, joins both sides' Ultimate Member profiles, and exposes rating, review text, and per-target rating averages as proper columns.
♾️ Lifetime License available
Profile reviews as a moderation table
The Ultimate Member Reviews extension stores reviews either in a dedicated table (um_reviews in many installs) or as a custom post type, depending on version. Each review carries the reviewer's user ID, the target user ID, a numeric rating, the review text, and a created-at timestamp. Both sides' profiles live in wp_users + wp_usermeta.
The default Reviews admin shows reviews per profile and a per-review moderation flow. Cross-profile views (every 1-star review from the past week, every reviewer who's submitted unusually many reviews, every target user with an average below threshold) require custom SQL. Combining review state with both sides' Ultimate Member account_status isn't a built-in screen.
SleekView reads the reviews source directly, joins wp_users twice (reviewer and target), and pivots Ultimate Member usermeta into columns for both sides. Per-target rating averages compute on demand. Inline edits flag reviews for moderation or approve them with conflict detection so concurrent actions don't overwrite each other.
Workflow
Reviews as one moderation workspace
Read the reviews source
um_reviews (or the CPT layout, depending on your install). Add joins to wp_users twice for reviewer and target.
Pivot profile fields for both sides
Save moderation and rollup views
Act inline
Sample columns
A typical review moderation view
wp_um_reviews + wp_users + wp_usermeta
| Reviewer | Target | Rating | Preview | Submitted | Status |
|---|---|---|---|---|---|
| alex@studio.co | ria@design.io | 5 | Great collaborator on the brief... | Apr 24 | Approved |
| anonymous | tom@hello.dev | 1 | scam scam scam | Apr 24 | Flagged |
| mia@brew.coop | alex@studio.co | 4 | Solid work and fast turnaround | Apr 23 | Pending |
| ria@design.io | mia@brew.coop | 5 | Easy to work with end to end | Apr 22 | Approved |
Comparison
Default UM Reviews admin vs SleekView
Default UM Reviews admin
- Reviews are moderated per-profile rather than as a cross-profile queue
- Per-target rating averages aren't surfaced inline with the reviewer rows
- Low-rating burst detection (every 1-star in the past 24 hours) needs custom SQL
-
Combining reviewer and target
account_statusisn't a built-in filter - Bulk approve / reject across many reviews is per-row work
SleekView
- Flat review table with reviewer and target as columns
-
Filter by rating + status + both sides'
account_status -
Per-target rating-average rollups (group by target
user_id) - Bulk-approve, reject, or flag inline
- Save views per role (moderator, community manager, support)
Features
What SleekView gives you for Ultimate Member Reviews
Reviews as a flat table
Each review is one row with reviewer email, target email, rating, preview text, and moderation status as columns. Sort by submit date for fresh-first moderation.
Per-target averages
Group by target user_id and aggregate rating. Spot targets with consistently low averages, or recently dropping averages, without per-profile drill-down.
Bulk moderation
Filter to pending or flagged reviews and bulk-update state. Writes route through the Reviews extension API where supported, with conflict detection on direct fallback.
Audience
Who uses SleekView for Ultimate Member Reviews
Moderators
Cross-profile moderation queue with rating, reviewer state, and recency filters. Catch 1-star bursts from new accounts in one sortable view.
Community managers
Per-target rating-average rollups to identify members whose ratings are dropping. Combine with profile fields for outreach and dispute resolution.
Support
Per-user review history visible during dispute investigations, with both sides' profile context in the same row. Faster resolution on review-removal requests.
The bigger picture
Why review-driven communities need a flat moderation table
Profile reviews change the stakes of community moderation. A 1-star review from a new account can damage a reputation built over years, and a coordinated burst from a small group can sink a target member's average overnight. The default Ultimate Member Reviews admin handles reviews one profile at a time, which is the wrong unit of work for a moderator trying to catch patterns.
The data is there, because every review row has a reviewer, a target, a rating, and a timestamp. The gap is composition. SleekView's pivot turns reviews into a flat moderation table where both sides' Ultimate Member account state lives next to the rating, and per-target average rollups expose reputation drops at a glance.
Burst detection becomes a filter (group by reviewer, count past-24-hour rows, sort descending), not a SQL ticket. Community managers get the average-trend view; moderators get the burst-detection view; support gets the per-user dispute view. For any community where reviews are a real product surface, that's the difference between trusted reputation and silent gaming.
Questions
Common questions about SleekView for Ultimate Member Reviews
Most installs use a dedicated um_reviews table with one row per review. Some extension versions use a custom post type instead. SleekView detects the layout on your install and exposes the right source.
Yes. SleekView routes through the Reviews extension API where exposed so review-state hooks fire as expected. Direct DB writes are available for silent cleanup where notifications would be noise.
Yes. SleekView joins wp_usermeta twice (once per side) so any Ultimate Member field becomes a filterable column. Filter to 1-star reviews from newly registered reviewers targeting high-reputation members for anti-spam triage.
Yes. Group by target user_id and aggregate the rating column. Combine with a date filter for trailing-30-day averages. Useful for spotting reputation drops and for surfacing top-rated members for community advocacy.
When SleekView routes through the Reviews extension API, the registered um_reviews_* hooks fire. Direct DB writes skip hooks by design, which is the right call for back-fills but the wrong call when downstream notifications should run.
Yes. Group by reviewer user_id with a created-at filter (past 24 hours, past 7 days) and aggregate count. A reviewer submitting many reviews in a short window is the classic spam pattern. Save the view, gate to moderators.
Yes. Each subsite has its own reviews table and SleekView reads the current subsite only. Cross-site moderation isn't supported in one view, but per-site moderator workspaces behave normally with role-scoped saved views.
um_reviews is typically indexed on reviewer and target IDs, so filtered moderation views stay fast. SleekView paginates server-side and only loads visible columns. Heavy aggregates (per-target averages) run on demand rather than precomputing on every dashboard load.
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
- Curcy Multi Currency
- Woocommerce Eparcel
- Woocommerce Criteo
- Woocommerce Pre Order Pro
- Sliced Invoices
- Woocommerce Sequential Order Numbers Pro
- Wcfm Delivery
- Edd Software Bundles
- Order Status Manager
- Woocommerce Payfast
- Checkout Field Editor
- Woocommerce Extra Fees
- Woocommerce Freshbooks Sync
- Woocommerce Quick View
- Woocommerce Gocardless
- Memberpress Coupons
- Content Restriction By Userrole
- Subscriber Only
- Theme My Login
- Paid Memberships Pro
- Wishlist Member X
- Paid Membership Pro Pro
- Simple Membership
- Membership By Supsystic
- Ultimate Membership Pro
- Easy Affiliate
- Magazine Paywall
- Ultimatemember Bbpress
- Ultimatemember Followers
- Academypress