SleekView Charts for Thrive Comments: engagement dashboards
Thrive Comments stores its layer on top of wp_comments, with up and down votes, likes, and share events written into wp_commentmeta under tcm_* keys. SleekView Charts reads both tables and turns them into Number, Bar, Pie, and Area cards.
♾️ Lifetime License available
From wp_comments and tcm_* meta to a real dashboard
Thrive Comments does not fork the comment schema. It extends wp_comments with the standard comment_post_ID, comment_author, comment_date, comment_approved, and comment_parent columns, then adds engagement signals in wp_commentmeta under keys like tcm_upvote, tcm_downvote, tcm_likes, and the social share counters that the plugin captures.
SleekView Charts reads both tables straight from WordPress. Each card picks a column or meta key to group by (post ID, author, status, date, upvote count) and aggregates with Count, Sum, Average, Maximum, or Minimum. Cards refresh against the live tables every time the dashboard loads, so a comment posted a minute ago appears on the next card refresh without any export step.
A typical setup combines a Number card for total approved comments this week, an Area card for daily comment activity, a Pie card for the approved-versus-spam ratio, and a Bar card for the most up-voted comments. Editors get a dashboard that finally answers questions the default comment screen cannot: which posts are pulling discussion, which commenters are driving votes, and whether the spam queue is growing.
Workflow
Chart Thrive Comments engagement in four steps
Point a card at wp_comments
wp_comments for raw counts. For engagement, join to wp_commentmeta on the tcm_upvote or tcm_likes keys to bring vote signals into the same card.
Group and aggregate the data
comment_post_ID, comment_author, comment_approved, or comment_date. Aggregate with Count, Sum, Average, Max, or Min to drive each card without SQL.
Pick the chart shape
Save the role-scoped dashboard
wp_comments and wp_commentmeta tables. Editors and community managers each open the slice that matches their job.
Sample dashboard
Charts you can build from Thrive Comments data
Approved comments this week
wp_comments rows where comment_approved is 1 and comment_date falls in the last seven days. Previous week shown underneath for context.
Count
Daily comment volume
wp_comments.comment_date, scoped to the date range on the card. Reveals weekday rhythm and the lift from featured posts.
Count
group by comment_date
Approved vs spam vs trash
wp_comments.comment_approved. Shows whether the spam filter is keeping pace or the queue is creeping up.
Count
group by comment_approved
Most up-voted comments
tcm_upvote meta key on wp_commentmeta. Surfaces the comments doing the actual community heavy lifting.
Sum(tcm_upvote)
group by comment_ID
Comparison
Default Thrive Comments admin vs SleekView Charts
Default WordPress comments screen
- WordPress comments screen is a list table with paging, not a trend chart
- Upvote and downvote counts live in commentmeta but never roll up to a dashboard
- Approved versus spam ratios require manual filtering, not a chart
- Top commenters by votes need third-party tools to surface
- No daily or weekly trend of comment volume in the default admin
SleekView Charts
-
Count and Average over
wp_commentswithcomment_approvedfilters -
Time-series Area cards from
comment_datefor daily volume - Pie cards for approved, pending, spam, and trash splits
-
Bar cards for top-voted comments using
tcm_upvotemeta -
Per-post leaderboards from
comment_post_IDjoined to post titles
Features
What SleekView Charts gives you for Thrive Comments
Charts over live wp_comments rows
Every card reads wp_comments and wp_commentmeta directly. The dashboard never drifts from the moderation queue because both views read the same rows at the same moment.
Spam queue visibility
A pie over comment_approved shows the share of approved, pending, spam, and trash rows at a glance. Moderators see whether the spam filter is keeping pace or the queue is silently filling up.
Community manager dashboards
Save a dashboard per role and gate it by capability. Editors land on the daily-volume view, community managers on the top-comments leaderboard, all from one SleekView install.
Audience
Who runs Thrive Comments dashboards with SleekView
Editors and content leads
Daily comment volume plus a top-posts-by-comment bar, so the editor sees which articles are pulling actual discussion versus which are silent without scrolling the comment list.
Comment moderators
A pie over comment_approved for queue health, paired with a daily Area card for trend. Spotting a spam spike on a Saturday stops requiring a manual page refresh.
Community managers
Top up-voted comments from tcm_upvote and top commenters by total approved rows. Identifies the community members who consistently drive engagement on the site.
The bigger picture
Why comments need a dashboard, not just a list
Comment health is a trend question. Is weekly volume climbing or sliding compared to last quarter. Which posts are pulling discussion and which are silent.
Which commenters consistently drive up-votes and which sit at zero. Thrive Comments stores all of that in wp_comments and the tcm_* commentmeta keys, but the default WordPress comment screen shows a list table sorted by date, not a chart. Editors and community managers either scroll for hours or export rows to a spreadsheet and pivot them manually, which never happens consistently enough to drive decisions.
SleekView Charts puts a daily volume Area, an approved-versus-spam Pie, and a most-voted Bar on one dashboard, refreshed against the live tables. The team finally has a real picture of what the comment system is doing, and the engagement layer becomes something they can manage like the rest of WordPress.
Questions
Common questions about SleekView Charts for Thrive Comments
It complements the comments screen. SleekView Charts reads wp_comments and wp_commentmeta directly, so moderators keep using the default screen for actions and open the SleekView dashboard for trends, ratios, and leaderboards that the list table never shows.
Yes. Thrive stores votes in wp_commentmeta under tcm_upvote and tcm_downvote. A Bar card grouped by comment_ID and aggregated by Sum over those keys ranks the most-voted comments on the site.
Group wp_comments by comment_post_ID and aggregate with Count where comment_approved is 1. The post titles resolve through a join to wp_posts, so the bar legend reads as real titles instead of numeric IDs.
Yes. A Pie card over comment_approved shows the current ratio, and an Area card grouped by comment_date with the same status filter shows how it trends. Pairing the two on one dashboard reveals whether the spam filter is holding.
Yes. The base cards use wp_comments columns that exist on every WordPress install. The tcm_* meta cards only fire on rows where Thrive Comments has written that meta, so the dashboard degrades gracefully if Thrive is disabled.
Cards run against the live wp_comments and wp_commentmeta tables every time the dashboard loads or a card refreshes. There is no export step, so a comment moderated a minute ago shows up on the next card refresh.
Cards use indexed queries against the same columns WordPress itself reads, so a busy comments table loads cards in roughly the same time the standard comment screen takes. For very large datasets, scope cards to a date range to keep aggregations tight.
 Yes. Save a dashboard, gate it by capability or role, and each persona lands on the right view. Editors open the volume-and-engagement view, moderators open the queue health view, community managers open the leaderboard.
 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
- Woocommerce Table Rate Shipping
- Wt Woocommerce Customer History
- Bigcommerce
- Yith Subscriptions
- Winwar Aelia Currency Switcher
- Woocommerce Cart Abandonment Recovery
- Woocommerce Csv Import Suite
- Woocommerce Paypal Checkout
- Variation Swatches
- Wpc Smart Wishlist
- Woocommerce Subscriptions
- Woocommerce Deposits
- Woo Order Export Lite
- Fkcart
- Yith Woocommerce Customize Myaccount Page