Why you need a real dashboard
Your CMS (PrestaShop, WooCommerce, Shopify) displays basic statistics: revenue, order count, top-selling products. But this data is insufficient for running a profitable business.
What native dashboards lack: - Real net profit (after all costs) - LTV and customer value over time - Cohort analysis to measure retention - RFM segmentation to identify your best customers - Cross-referencing CMS data with advertising spend
Without these metrics, you are flying blind. You know how much you sell, but not how much you earn.
Essential KPIs to track
An effective e-commerce dashboard should display 4 categories of KPIs:
1. Sales performance: net revenue, order count, average order value (AOV), conversion rate.
2. Profitability: gross margin, net profit, net margin, POAS, profit per order.
3. Customers: new customer count, repeat purchase rate, LTV, RFM segmentation, churn rate.
4. Marketing: blended ROAS, blended CPA, MER, ad spend by channel, acquisition cost.
The key is not to overload the dashboard. Display 10 to 15 KPIs maximum on the main view and allow drill-down for detailed analysis.
Dashboard tools comparison
Several options exist for building your e-commerce dashboard:
- Native CMS dashboard: free but limited to revenue and orders. No profit, no cohorts, no LTV.
- Google Sheets / Excel: flexible but manual. Data becomes outdated as soon as it is entered. No order-level granularity.
- Google Looker Studio: free and customizable. Requires a structured data source and technical skills for setup.
- Specialized tools (Fullmetrix, Triple Whale, Polar Analytics): automatic CMS connection, real-time profit calculation, built-in cohorts and segmentation.
The choice depends on your volume and needs. Below 100 orders per month, a spreadsheet may suffice. Beyond that, automation becomes essential.
Common mistakes to avoid
Mistake 1: tracking gross revenue. Gross revenue includes refunds, discounts, and taxes. It overestimates your actual performance. Use net revenue.
Mistake 2: ignoring variable costs per order. A $100 order with $80 in costs is not a good order. Track profit per order.
Mistake 3: comparing incomparable periods. Comparing December (Black Friday, Christmas) to January skews the analysis. Compare to the same period from the previous year.
Mistake 4: tracking too many metrics. A dashboard with 50 KPIs is unusable. Focus on the 10 metrics that guide your decisions.
Mistake 5: not including advertising spend. Your revenue may increase by 30% but if your ad spend increased by 50%, you are less profitable.
Fullmetrix: a complete dashboard in 2 minutes
Fullmetrix connects to your CMS (PrestaShop, WooCommerce, Shopify) and automatically syncs your orders, customers, and products.
The dashboard displays in real time: - Net profit per order, product, category, and period - Monthly and weekly retention cohorts - RFM segmentation with automatic sync to Meta and Google Ads - Gross and net LTV by customer segment - ROAS, POAS, and MER by cross-referencing your ad spend
Setup takes 2 minutes: install the module on your CMS, connect your ad platforms, and Fullmetrix syncs the complete history.
Data is hosted in the European Union in GDPR compliance.