✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView Charts dashboard for Metrilo Ecommerce CRM

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

1

Map the WooCommerce customer tables

Point SleekView at wp_users and wp_usermeta for customer attributes, wp_wc_orders for transactions, and woocommerce_order_items for line data. The dataset exposes columns to every card, so the join is configured once.
2

Choose a chart type per question

Map each reporting question to a chart type. Repeat-customer ratio wants a Donut, daily new signups wants an Area, top countries wants a Bar, total active customers wants a Number card. Pick the visualization that fits.
3

Set groupBy and aggregation

Each card declares its groupBy column, aggregation (Count, Sum, Average), and valueColumn where relevant. For repeat-customer cards, group by user_id. For revenue cards, sum total_amount from wp_wc_orders by day.
4

Save and pin the dashboard

Save the configured Charts view as a named dashboard. Ecommerce ops checks customer health Monday, marketing audits country mix Friday. The same data powers both views without leaving WordPress for the Metrilo console.

Sample dashboard

Charts you can build from the data Metrilo tracks

A representative four-card dashboard combining a customer KPI, the order status mix, a country breakdown, and a new-customer signup trend over the last 90 days.
Number · Default

Repeat customers count card

Count of distinct customer_id values in wp_wc_orders with two or more completed orders. The headline retention KPI most ecommerce teams check before each weekly review, with the previous month's value rendered underneath for context.
Count
Pie · Donut

Order status mix breakdown

Donut split across processing, completed, on-hold, refunded, and failed using the status column on wp_wc_orders, so order health and fulfillment backlog show at a glance alongside the customer-focused cards on the same board.
Count group by status
Bar · Horizontal

Top customer countries

Horizontal bar of customer counts grouped by the billing_country key in wp_usermeta. Reveals which geographic markets produce enough volume to justify localized email campaigns or country-specific landing pages in the next quarter.
Count group by billing_country
Area · Gradient

New customers per day

Daily count of new rows in wp_users with the customer role over the trailing 90 days, grouped by user_registered. Surfaces acquisition velocity, campaign-driven spikes, and slow weeks worth investigating before budget reallocation.
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_usermeta usable 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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