Introduction: a good dashboard for data-driven decisions
Running an ecommerce store without a dashboard is like driving without a speedometer. You are moving forward, but you have no idea how fast, in which direction, or how much fuel you have left. Yet most online retailers still check their daily revenue in their CMS back-office without ever cross-referencing it with costs, margins, or actual customer behavior.
An ecommerce dashboard is a centralized management tool that brings your key performance indicators (KPIs) together in one place. Its purpose is not to display as much data as possible, but to present the right metrics, at the right level of detail, so you can make informed decisions quickly.
This guide walks you through building a comprehensive ecommerce dashboard. You will find the 15+ essential KPIs to track, common mistakes to avoid, a step-by-step method, and a comparison of available tools. Whether you sell on PrestaShop, WooCommerce, or Shopify, the principles remain the same.
Essential KPIs for an ecommerce dashboard
Not all KPIs are created equal. A good ecommerce dashboard covers five categories of indicators: financial, acquisition, conversion, customer, and operations. Here are the must-have metrics for each category, with their calculation formula and recommended tracking frequency.
| Category | KPI | Formula / Definition | Frequency |
|---|---|---|---|
| Financial | Revenue | Total net sales for the period | Daily |
| Financial | Gross margin | (Revenue - COGS) / Revenue x 100 | Weekly |
| Financial | Net margin | (Revenue - All costs) / Revenue x 100 | Monthly |
| Financial | P&L (Profit & Loss) | Revenue - COGS - Marketing - Logistics - Fixed costs | Monthly |
| Acquisition | Customer acquisition cost (CAC) | Total marketing spend / Number of new customers | Weekly |
| Acquisition | ROAS (Return on Ad Spend) | Ad-generated revenue / Ad spend | Weekly |
| Acquisition | Traffic by channel | Sessions per source (SEO, paid, email, direct) | Daily |
| Conversion | Conversion rate | Orders / Sessions x 100 | Daily |
| Conversion | Cart abandonment rate | (Carts created - Orders) / Carts created x 100 | Weekly |
| Conversion | Add-to-cart rate | Sessions with add-to-cart / Total sessions x 100 | Weekly |
| Customer | Lifetime Value (LTV) | AOV x Purchase frequency x Customer lifespan | Monthly |
| Customer | RFM segmentation | Score based on Recency, Frequency, and Monetary value | Monthly |
| Customer | Repeat purchase rate | Returning customers / Total customers x 100 | Monthly |
| Customer | Retention rate | Active customers at end / Customers at start x 100 | Monthly |
| Operations | Average order value (AOV) | Total revenue / Number of orders | Daily |
| Operations | Return rate | Returns / Orders x 100 | Weekly |
| Operations | Average delivery time | Mean days between order and delivery | Weekly |
| Operations | Stockout rate | Out-of-stock products / Total active products x 100 | Daily |
Beware of revenue alone
Revenue is the most tracked metric, but also the most misleading when viewed in isolation. A 20% revenue increase means nothing if your advertising costs went up by 40%. Always cross-reference revenue with gross margin and P&L to get a true picture of profitability.
The goal is not to track all 18 KPIs daily. Identify the 5 to 7 metrics most critical for your current growth stage and focus on those. The rest can be reviewed on a weekly or monthly basis.
Common mistakes in ecommerce dashboards
Before building your dashboard, identify the traps most online retailers fall into. A bad dashboard is worse than no dashboard at all: it creates a false sense of control and leads to poor decisions.
- Too many metrics displayed: a dashboard with 30+ KPIs is useless. Information overload paralyzes decision-making. Limit yourself to 5-7 key indicators on the main view and create secondary views for detail.
- No segmentation: looking at an overall conversion rate hides very different realities between mobile and desktop, between new visitors and loyal customers, between different traffic sources. Without segmentation, you cannot identify improvement levers.
- No automated P&L: tracking revenue without automatically deducting costs (COGS, marketing, logistics, platform fees) is flying blind. An ecommerce doing EUR 100,000 in revenue with EUR 95,000 in costs is not a performing business.
- Unreliable or delayed data: a dashboard fed manually through CSV exports is systematically late and error-prone. Decisions based on data from 3 days ago are not real-time decisions.
- No temporal comparison: displaying a 2.3% conversion rate is meaningless without comparing it to the previous week, previous month, or the same period last year. The trend matters more than the absolute value.
- Ignoring customer metrics: focusing solely on acquisition and sales while neglecting LTV, repeat purchase rate, and retention is a strategic mistake. Acquiring a customer costs 5 to 7 times more than retaining one.
The most costly mistake
Not including a P&L view in your dashboard is the most common and most expensive mistake. Without visibility on your actual profitability after deducting all costs, you can generate growing revenue while losing money every month. Always integrate a Profit & Loss view into your dashboard.
Building your dashboard step by step
Building an effective ecommerce dashboard follows a precise methodology. Follow these steps in order to avoid building a useless tool.
Define your business objectives
Before choosing your KPIs, clarify your priority objectives. Are you in a growth phase (focus on acquisition and revenue) or an optimization phase (focus on margin and profitability)? Your objectives determine which metrics to prioritize. Define 2 to 3 objectives maximum for the next 3 months.
Select your priority KPIs
Based on your objectives, select 5 to 7 main KPIs that will appear on your overview. For example, for a profitability objective: revenue, gross margin, P&L, CAC, and LTV. Then add 5 to 10 secondary KPIs accessible through detailed views.
Centralize your data sources
Identify all your data sources: ecommerce CMS (PrestaShop, WooCommerce, Shopify), advertising tools (Meta Ads, Google Ads), Google Analytics, email marketing tools. The more sources connected automatically, the more reliable and up-to-date your data will be.
Configure costs and charges
A dashboard without costs is just a sales report. Integrate your product costs (COGS), marketing spend by channel, logistics costs (packaging, shipping, returns), platform fees (commissions, subscriptions), and fixed costs (salaries, rent, tools). This is the foundation of your automated P&L.
Set up comparison periods
Configure relevant temporal comparisons: day vs previous day, week vs previous week, month vs same month last year. Since seasonality is strong in ecommerce, year-over-year (YoY) comparison is essential.
Create role-based views
The CEO needs a strategic view (P&L, trends), the marketing manager needs an acquisition view (CAC, ROAS by channel), the product manager needs a catalog view (top sellers, return rate by product). Create views tailored to each decision-maker to avoid information overload.
Set up alerts
Configure automatic alerts for abnormal variations: conversion rate drop of more than 20%, return rate increase, stockout on a bestseller. Alerts let you react without having to check the dashboard constantly.
The key is to start simple and enrich gradually. A dashboard with 5 well-chosen KPIs and reliable data is worth infinitely more than a complex dashboard fed by approximate data.
Tools for creating an ecommerce dashboard
Your tool choice depends on your budget, technical skills, and business complexity. Three major tool categories exist, each with its own strengths and limitations.
Excel / Google Sheets
The most accessible and least expensive solution. You export data from your CMS and marketing tools, then build your tables and charts manually. This works for small volumes but quickly becomes unmanageable as your business grows.
- Pros: free, flexible, no learning curve
- Cons: manual data entry, error-prone, no real-time data, time-consuming (2 to 4 hours per week), no automated P&L
- Recommended for: stores with fewer than 500 orders per month in early stages
Generic BI tools (Looker Studio, Power BI, Tableau)
Generic Business Intelligence tools offer considerable visualization power but require significant technical work to connect data sources, clean data, and build reports. They are not designed specifically for ecommerce, which means everything must be configured manually.
- Pros: advanced visualizations, multiple source connections, high flexibility
- Cons: complex setup, technical skills required, no pre-configured ecommerce KPIs, no native P&L, expensive for advanced versions
- Recommended for: teams with a dedicated data analyst
Dedicated ecommerce solutions
Specialized ecommerce analytics solutions (like Fullmetrix) are built from the ground up for online retailers' specific needs. They connect natively to your CMS, include ecommerce KPIs by default, and offer automated P&L without technical setup.
- Pros: native connection (PrestaShop, WooCommerce, Shopify), pre-configured ecommerce KPIs, automated P&L, multi-store support, no technical skills required
- Cons: less flexible than generic BI tools for highly specific non-ecommerce analyses
- Recommended for: any online retailer wanting an operational dashboard without development work
Fullmetrix: the all-in-one ecommerce dashboard
Fullmetrix was built on a simple observation: online retailers need a comprehensive, reliable, and immediately usable dashboard without weeks of technical setup. The platform connects natively to PrestaShop, WooCommerce, and Shopify to centralize all your data in one place.
- Native connection in a few clicks: install the module on your CMS and your historical data is synced automatically. No technical configuration, no CSV exports, no APIs to set up manually.
- Real-time automated P&L: Fullmetrix automatically calculates your profit and loss statement by integrating product costs, marketing spend, logistics fees, and fixed costs. You know at all times whether your business is truly profitable.
- Multi-store management: if you sell on multiple platforms or manage several brands, Fullmetrix consolidates data from all your stores into a unified dashboard with cross-store performance comparison.
- Pre-configured ecommerce KPIs: all essential indicators (revenue, margin, AOV, conversion rate, LTV, RFM segmentation, repeat purchase rate) are available from the first connection.
- Advanced segmentation: analyze performance by acquisition channel, product category, customer type (new vs returning), or geographic area.
- Smart alerts: receive automatic notifications for abnormal variations in your key metrics.
Native multi-platform support
Fullmetrix is one of the few solutions offering native connections to PrestaShop, WooCommerce, and Shopify simultaneously. Whether you use a single platform or sell on multiple CMS at once, all your data is centralized in a single dashboard.
FAQ: ecommerce dashboard
What are the must-have KPIs for an ecommerce dashboard?
The five essential KPIs are: revenue, gross margin (or full P&L), conversion rate, average order value (AOV), and customer acquisition cost (CAC). These five indicators cover commercial performance, profitability, sales funnel efficiency, and marketing spend effectiveness. Depending on your growth stage, add LTV and repeat purchase rate to manage customer retention.
How often should you check your dashboard?
Frequency depends on the KPI type. Operational indicators (revenue, conversion rate, AOV) deserve a quick daily 5-minute check. Tactical indicators (CAC, ROAS, abandonment rate) should be analyzed weekly. Strategic indicators (P&L, LTV, retention, RFM) call for monthly in-depth analysis. Consistency matters more than duration: 5 daily minutes are worth more than one sporadic hour.
Can you build a good dashboard for free?
Yes, with Google Sheets and manual exports from your CMS, you can build a functional dashboard. However, this approach has two major limitations: the time needed to feed and update data (expect 2 to 4 hours per week) and the impossibility of automatically calculating a complete P&L. Beyond 500 orders per month, the time invested in a manual dashboard far exceeds the cost of a dedicated tool.
How to connect your CMS to a dashboard?
Three methods exist: manual export (CSV/Excel), REST API connection, and native module connection. Manual export is the simplest but most time-consuming. REST API offers automated connection but requires technical skills. A native module (like the one offered by Fullmetrix for PrestaShop, WooCommerce, and Shopify) combines ease of installation with automatic real-time data synchronization.
