SleekView Charts for Metrilo Ecommerce CRM: customer dashboards
The Metrilo plugin sends WooCommerce orders and customers to the Metrilo SaaS, but the source data lives in WordPress: customers in wp_users, orders in wp_wc_orders, lines in woocommerce_order_items. SleekView reads those tables to render chart cards in WP Admin.
♾️ Lifetime License available
Reporting on Metrilo data inside WordPress
Metrilo is a hosted analytics and CRM platform that connects to WooCommerce. The Metrilo plugin itself does not warehouse customer data in WordPress; it forwards orders, customers, and product events to the Metrilo SaaS where the dashboards live. The source-of-truth stays in your database: customers in wp_users with attributes in wp_usermeta (billing_country, billing_city, last_order_id), orders in wp_wc_orders under HPOS, and line items in wp_woocommerce_order_items.
Metrilo's hosted dashboards are excellent for retention cohorts and behavior segmentation, but several reporting questions are awkward to answer when the data also needs to stay visible inside WP Admin. "How many customers placed a second order this month?" "What does new-customer revenue look like per day?" "Which countries account for the most repeat customers?" These benefit from a board pinned next to the WooCommerce screens the team already uses.
SleekView Charts maps the WooCommerce tables that feed Metrilo to chart cards in WP Admin. A Number card counts customers with two or more orders, a Donut splits orders by status, a Bar ranks countries by customer count, an Area plots daily signups. Cards refresh as WooCommerce writes new orders, so the in-WordPress view stays current alongside whatever Metrilo shows in its own console.
Workflow
Build a Metrilo-style dashboard in four steps
Map the WooCommerce customer tables
Choose a chart type per question
Set groupBy and aggregation
Save and pin the dashboard
Sample dashboard
Charts you can build from the data Metrilo tracks
Repeat customers count card
Count
Order status mix breakdown
Count
group by status
Top customer countries
Count
group by billing_country
New customers per day
Count
group by user_registered
Comparison
Default Metrilo reporting vs SleekView Charts inside WordPress
Default Metrilo SaaS console
- Dashboards live in the Metrilo SaaS console, not next to WooCommerce screens in WP Admin
- Adding a chart-shaped view in WordPress itself requires a separate analytics plugin
- Custom WooCommerce usermeta keys are not first-class groupBy dimensions in the SaaS
- Switching between the WordPress admin and the Metrilo console adds friction to weekly ops
- Exports follow Metrilo's schema, not the WooCommerce table shapes the team already knows
SleekView Charts
-
A WP Admin dashboard reading
wp_users,wp_usermeta, and order tables - Donut and Bar cards for order status and country distribution across the full customer base
- Area and Line cards for new-customer velocity and revenue trends per day or per week
-
Billing and shipping meta from
wp_usermetausable as chart groupBy dimensions - Cards refresh as WooCommerce writes new orders, so the in-WordPress board never goes stale
Features
What SleekView Charts gives you for Metrilo Ecommerce CRM
Customer KPI cards
Total customers, repeat customers, average order value this month: Number cards surface the figures ecommerce teams normally rebuild in spreadsheets every Monday before the weekly review opens in the standup call.
Status and geography distribution
Donut and Bar cards render the order status mix and the top billing countries, so fulfillment-health and market-mix questions answer themselves at a glance instead of requiring drill-down across multiple screens.
Customer and revenue trends
Area and Line cards over the trailing 30, 60, or 90 days surface customer-acquisition velocity and revenue rhythm, the long-running patterns that drive next-quarter ecommerce planning across the team.
Audience
Who builds Metrilo-style dashboards inside WordPress
Ecommerce ops leads
Pre-standup dashboard: repeat customers, order status, top countries, and signup velocity on one screen. The same view doubles as the monthly review without leaving WooCommerce for Metrilo.
Customer retention managers
Retention dashboard tracking second-order and third-order customer counts as trend lines. Spot retention erosion the week it starts, not the quarter after lifetime value drops on the SaaS dashboard.
Email marketing managers
Country and source mix dashboard pivoting billing_country and acquisition source into Bar cards. Plan localized campaigns from the same WordPress admin where the customer records actually live.
The bigger picture
Why ecommerce teams want this view inside WordPress
Ecommerce teams running Metrilo on top of WooCommerce live in two places. The Metrilo console is the right home for retention cohorts and behavioral segments. The WordPress admin is the right home for daily WooCommerce work: fulfilling orders, editing products, answering customer questions.
The friction shows up in the gap between the two. Asking "how is the customer base trending this week" while standing inside a customer profile means a tab switch, a login check, and a context reset. SleekView Charts collapses that gap by rendering the same customer and order shapes as chart cards directly inside the WordPress admin.
The Metrilo SaaS keeps doing what it does well, and the in-admin board carries the cross-cutting questions that benefit from being one click away from the WooCommerce screens the team already touches every day.
Questions
Common questions about SleekView Charts for Metrilo Ecommerce CRM
No. The Metrilo console remains the right place for retention cohorts, behavioral segments, and the email automation tied to Metrilo's tracking. SleekView Charts adds an in-WordPress dashboard that lives alongside the WooCommerce screens, so the team has one less tab switch when the question only needs the source-of-truth WooCommerce data.
 Directly from the WooCommerce tables in your WordPress database. Customers come from wp_users and wp_usermeta, orders from wp_wc_orders (HPOS) or shop_order posts, and line items from woocommerce_order_items joined to order_itemmeta. SleekView reads the same WooCommerce data Metrilo's plugin forwards upstream.
 Yes. Any wp_usermeta key, whether added by Metrilo, WooCommerce, or a custom plugin, can be pivoted into a named column at the SleekView dataset layer and then used as the groupBy dimension on any chart card. Country, city, last order id, and any client-defined attribute all become valid chart axes without writing SQL by hand.
 Both. SleekView's dataset layer reads from wp_wc_orders when HPOS is enabled and from wp_posts plus wp_postmeta with post_type equal to shop_order when it is not. The same chart configuration covers either storage model, so a store mid-migration does not need to rebuild the dashboard after switching.
 Yes if the source is captured in wp_usermeta or wp_postmeta. Metrilo tracks source for its own dashboards, and most stores also store a copy locally via UTM-capture plugins or custom signup forms. Wherever the value lives in WordPress, SleekView can use it as a groupBy dimension for a Bar card or as a filter on a Number card.
 Live. SleekView Charts queries the WooCommerce tables on render, so every new order and every new customer registration shows up on the next dashboard load. Cache windows are configurable per dataset for very large stores, but the default is fresh data on every visit to the board, matching how WooCommerce admins expect their reports to behave.
 By default, SleekView reads every row in wp_wc_orders, and each chart card declares its own status filter. Most teams exclude refunded and failed from revenue cards while keeping them on the status-mix Donut, which is exactly the behavior the chart configuration supports out of the box without code.
 Each chart card can be exported as CSV via the SleekView dataset layer, so the underlying numbers travel cleanly into a deck or a board pack. The dashboard itself lives in the WordPress admin, gated by capability, so the live view stays internal to the team that already has WooCommerce access.
 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
- Paystack Woocommerce
- Mercado Pago Payments For Woocommerce
- Woocommerce Conditional Shipping And Payments
- Edd Recurring
- Woocommerce Multi Currency
- Surecart
- Cart66 Cloud
- Mailchimp For Woocommerce
- Woocommerce Customer Order Csv Export
- Ti Woocommerce Wishlist
- Yith Woocommerce Deposits And Down Payments
- Advanced Dynamic Pricing For Woocommerce
- Automatewoo
- Woocommerce Bulk Stock Management
- Yith Woocommerce Color And Label Variations
- Tva Thrive Apprentice
- Content Control Cm
- Ultimatemember Bbpress
- Buddypress Media
- Wp Community
- Content Restriction By Userrole
- Paid Memberships Pro Elementor
- Memberships By Supsystic
- Cimy User Extra Fields
- Ultimatemember Reviews
- Kleo Membership
- Restrict User Access
- Memberium Infusionsoft
- Buddymeet
- Memberium For Keap