SleekView Charts for 3CX Live Chat: native WP chat dashboards
Unlike most chat widgets, 3CX Live Chat (formerly WP Live Chat Support) stores chats locally in wp_wplc_chats, messages in wp_wplc_msgs, and agent assignments in postmeta. SleekView Charts groups all of that into one WP dashboard without webhooks.
♾️ Lifetime License available
Real local chat tables, real chart dashboards
3CX Live Chat (formerly WP-Live-Chat-Support by ColdLogic) is one of the few chat plugins that stores conversations natively in the WordPress database. Chats land in wp_wplc_chats with columns for chat ID, agent ID, name, email, status, timestamp, and IP, while messages land in wp_wplc_msgs with columns for sender, message text, and timestamp. Custom fields and chat ratings are stored in wp_wplc_chat_meta. The admin shows a chat list but no chart cards.
SleekView Charts reads those tables directly. A KPI counts active chats from wp_wplc_chats where status equals 4 (active). A donut groups chats by status across the codes (1 closed, 2 missed, 3 minimized, 4 active). A horizontal bar ranks agents by chat count from the agent_id column joined to wp_users for readable names. An area of chat starts by timestamp shows daily and weekly demand patterns.
The dashboard layers in message-volume analysis. SleekView joins wp_wplc_chats to wp_wplc_msgs on chat_id and renders average messages per chat as a number card, or a bar of message volume per agent for chattier reps. Ratings stored in wp_wplc_chat_meta feed an average CSAT KPI. No webhook, no export, just the same database tables the plugin already maintains, with WordPress capabilities applied identically to charts and tables.
Workflow
From wp_wplc_chats to a chart dashboard
Detect the 3CX schema
Pick chart aggregations
Layer in rating and meta data
Save the dashboard
Sample dashboard
Charts you can build from 3CX Live Chat data
Active chats right now
Count
Chats by status
Count
group by status
Chats by agent
Count
group by agent_id
Daily chat volume
Count
group by timestamp
Comparison
Default 3CX Live Chat admin vs SleekView Charts
Default 3CX chat list
- Chat list shows rows but no status distribution donut
- No native bar of chats per agent in the WP admin
- Volume trends need an export and a spreadsheet pivot
- Average messages per chat requires a manual SQL count
- Rating data in wp_wplc_chat_meta has no chart card view
SleekView Charts
- Chart wp_wplc_chats by status, agent_id, timestamp, or rating
- Join wp_wplc_msgs on chat_id for messages-per-chat aggregations
- Join agent_id to wp_users.ID for readable agent names on bars
- Average CSAT KPI from rating rows in wp_wplc_chat_meta
- WordPress capabilities applied identically to charts and tables
Features
What SleekView Charts gives you for 3CX Live Chat
Native WP tables
Chats live in wp_wplc_chats and messages in wp_wplc_msgs locally, so charts run on real WP tables without a webhook setup. No external dashboard tab switch and no export step in between data and decisions.
Status donut
Group chats by the status column across closed, missed, minimized, and active codes. The default admin shows lists, not distributions, so queue skew used to need a manual count by hand from a CSV export.
Agent workload bar
Horizontal bar of chats per agent from the agent_id column joined to wp_users.ID. Surfaces overloaded agents at a glance and feeds the rebalance call before the next shift starts on the support rotation.
Audience
Who builds 3CX Live Chat dashboards with SleekView
Support leads
Active chats KPI, status donut, and agent workload bar. Three cards summarize the live queue without leaving WordPress, with no webhook or external dashboard in the loop.
Operations
Daily chat volume from the timestamp column against agent hours. The area chart surfaces capacity issues a week before SLAs slip and staffing decisions land in time to prevent burnout.
Quality leads
Average rating from wp_wplc_chat_meta against agent. Spot agents whose ratings are slipping and surface the transcripts behind the trend without leaving the admin or pulling a CSV.
The bigger picture
Why local data deserves a real chart layer
3CX Live Chat is rare among chat plugins because it stores conversations and messages locally in WordPress tables rather than offloading everything to an external cloud. That makes it ideal for a charts layer: the data is already next to the user table, the posts, the postmeta, and the rest of the admin. The downside is that the plugin's own admin shows lists rather than charts, so the reporting question still pushes admins toward a spreadsheet export or a manual SQL query.
SleekView Charts closes the gap by reading the same wp_wplc tables directly. Status, agent, timestamp, and rating each become a chart dimension, and joins to wp_users and wp_wplc_msgs add agent names and message counts on the same dashboard. The triage table and the chart dashboard read the exact same rows, so a number on the dashboard always agrees with a count on the chat list.
Triage and reporting share one source of truth.
Questions
Common questions about SleekView Charts for 3CX Live Chat
Yes. Charts and tables are both views over wp_wplc_chats and wp_wplc_msgs (plus wp_wplc_chat_meta). A number on a chart card always matches a count on a SleekView table with the same filters. No duplicate data store and no sync lag between the dashboard and the chat queue.
 wp_wplc_chats.status uses integer codes: 1 closed, 2 missed, 3 minimized, 4 active. SleekView lets you label those codes in the chart settings so the donut shows human-readable slices rather than raw integers, and the same labels carry into the underlying SleekView table view.
 Yes. SleekView joins wp_wplc_chats to wp_wplc_msgs on chat_id and aggregates rows from the messages table by chat or by agent. Average messages per chat becomes a number card, and total messages per agent becomes a bar chart on the same dashboard grid.
 Yes. SleekView honors WordPress capabilities for chat data. An agent role sees only chats assigned to their user ID, while a support lead sees the full team's chats. The capability filter applies identically to chart cards and the underlying SleekView table view of the same data.
 Yes. Custom field values added by 3CX add-ons land in wp_wplc_chat_meta keyed by chat_id. SleekView reads that table the same way it reads postmeta. Numeric values become sum or average aggregations and select values become groupBy dimensions for donuts.
 Charts run aggregate queries on view load. Open the dashboard and the numbers reflect the current state of wp_wplc_chats. There is no caching layer that needs to be refreshed and no scheduled job that lags by hours behind the real live-chat queue.
 Yes. Clicking a slice or bar opens the underlying SleekView table with the same filter applied. From the agent bar with the highest workload, one click lands on the exact list of wp_wplc_chats rows they handled this week, ready for an inline transcript review.
 Charts run aggregate queries on demand against wp_wplc_chats and wp_wplc_msgs. The queries use the indexes the plugin maintains on chat_id and timestamp. On sites with hundreds of thousands of messages archived, dashboards load in well under a second from the admin.
 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
- Fkcart
- Thirstyaffiliates
- Atum Stock Logs
- Woocommerce Customer History
- Booster For Woocommerce
- Authorize Net
- Woocommerce Print Invoices Packing Slip Labels
- Woocommerce Currency Converter Widget
- Woocommerce Product Add Ons
- Wpc Buy Now Button
- Aelia Currencyswitcher
- Yith Woocommerce Affiliates
- Woocommerce Afterpay
- Flexible Shipping
- Gumroad Wp