You can’t improve what you can’t see. For ecommerce businesses, that means getting the right chart for each KPI — not just dumping all your numbers into a spreadsheet. This guide covers exactly which chart type to use for every major ecommerce metric, and how to organize them into a dashboard that actually drives decisions.
What Are Ecommerce KPIs?
Ecommerce KPIs (Key Performance Indicators) are the metrics that directly measure the health and performance of an online store. Unlike vanity metrics (total page views, follower counts), KPIs link directly to revenue, profitability, and customer value.
The most important ecommerce KPIs fall into five categories:
| Category | Key Metrics |
|---|---|
| Revenue | Total revenue, GMV, revenue per visitor, MoM growth |
| Conversion | Conversion rate, cart abandonment rate, checkout completion rate |
| Customer | Customer LTV, repeat purchase rate, churn rate, NPS |
| Product | Best sellers, return rate, inventory turnover, AOV |
| Marketing | CAC, ROAS, email open rate, traffic by channel |
The challenge isn’t collecting these metrics — most ecommerce platforms provide them. The challenge is visualizing them in a way that makes the right insight obvious at a glance.
Revenue Metrics: Charts That Show Growth
Total revenue over time → Line chart
Revenue is a time series. A line chart showing daily, weekly, or monthly revenue is the foundation of any ecommerce dashboard. Use a 13-month view to compare this month against the same month last year.
Key design tips:
- Add a reference line for your target or last year’s value
- Color the line green when above target, red when below
- Use weekly or monthly granularity — daily revenue is noisy
Revenue by product category → Horizontal bar chart
To compare revenue across product categories, use a horizontal bar chart sorted by revenue descending. This immediately shows which categories drive the business and which are marginal. If you have more than 8–10 categories, group the tail into “Other.”
Revenue composition by channel → Stacked area chart
If you sell through multiple channels (direct, marketplace, wholesale), a stacked area chart shows both total revenue and channel mix over time. You can see if a revenue dip was across all channels or concentrated in one. See our guide on area charts for the details.
Average Order Value (AOV) → Line chart with moving average
AOV tends to be noisy day-to-day. Plot it as a line chart and add a 7-day or 30-day moving average to see the underlying trend. A declining AOV over time is a warning signal worth investigating even if total revenue looks healthy.
Conversion Metrics: From Visitor to Buyer
Conversion rate over time → Line chart
Plot your site-wide conversion rate as a line chart over time. Dips in conversion rate that don’t correspond to traffic dips suggest a product, pricing, or UX issue — not a marketing problem.
The conversion funnel → Funnel chart
The funnel from visitor → product page view → add to cart → checkout started → purchase is the heart of ecommerce conversion analysis. A funnel chart shows the drop-off at each stage. The biggest percentage drop-off is where you focus optimization effort.
Example funnel values:
- Visitors: 100,000
- Product page views: 40,000 (40% view rate)
- Add to cart: 8,000 (20% add-to-cart rate)
- Checkout started: 5,000 (62.5% checkout rate)
- Purchase: 3,000 (60% purchase completion rate)
This funnel shows the biggest drop-off is from visitors to product page views — a traffic targeting or landing page problem, not a checkout problem.
Cart abandonment rate → Line chart + single metric KPI widget
Display cart abandonment rate both as a trend line (to see if it’s getting better or worse) and as a single current-period KPI number prominently on the dashboard. The industry average is around 70% — if you’re above that, cart recovery flows are worth prioritizing.
Checkout completion rate by device → Grouped bar chart
Mobile vs. desktop checkout completion rates often differ dramatically. A grouped bar chart comparing completion rates across device types immediately shows if mobile checkout is underperforming — a common and fixable problem.
Customer Metrics: Loyalty and Lifetime Value
New vs. returning customers over time → Stacked bar chart
A stacked bar chart showing new vs. returning customers each month tells the loyalty story. A store with a growing returning customer base is building sustainable revenue; one where nearly all customers are first-time buyers has a retention problem.
Customer Lifetime Value (CLV) by cohort → Line chart
Cohort analysis plots how much customers who first purchased in a given month are worth over time. Plot each monthly cohort as a separate line. If newer cohorts’ CLV lines are rising faster than older ones, your customer experience is improving. Flat or declining cohort lines signal churn problems. See our guide on time series charts for cohort visualization tips.
Repeat purchase rate → Single metric trend
The percentage of customers who purchase more than once is one of the most important long-term health metrics for an ecommerce business. Track it monthly as a line chart with a clear target reference line.
Product Metrics: What’s Selling
Best-selling products → Horizontal bar chart
A horizontal bar chart ranked by units sold or revenue is the clearest way to show product performance. Sort descending and highlight the top 3 in a distinct color. If a product suddenly drops or rises in rank, it’s worth investigating.
Product return rate → Bar chart
High return rates on specific products are a quality or expectation-management problem. A bar chart sorted by return rate (highest first) identifies problem products that may be costing more than their revenue is worth.
Inventory turnover by category → Bar chart
Slow-moving inventory ties up cash. A bar chart of inventory turnover by product category shows which categories have healthy sell-through rates and which ones are sitting in a warehouse. For products and categories with very different scales, consider a waterfall chart to show the net impact on working capital.
Marketing Metrics: Acquisition and ROI
Traffic by channel → Stacked bar chart
Monthly traffic broken down by source (organic search, paid search, direct, email, social, referral) shows how your traffic mix is evolving. A stacked bar chart makes it easy to see if you’re becoming more or less dependent on paid channels.
Customer Acquisition Cost (CAC) by channel → Grouped bar chart
CAC varies dramatically across channels. A grouped bar chart comparing CAC across paid social, paid search, influencer, and email over several months shows which channels are becoming more or less efficient and where to reallocate budget.
Return on Ad Spend (ROAS) over time → Line chart
Plot ROAS as a line chart for each major paid channel. When ROAS declines on a channel, it’s a signal of audience saturation or creative fatigue before the revenue numbers show a problem. Early detection is the value of good visualization.
Email campaign performance → Scatter chart
For email marketers sending regular campaigns, a scatter chart with open rate on one axis and revenue per email on the other reveals which campaigns are truly high-performing vs. just generating opens. See our correlation charts guide for how to read this type of analysis.
Building Your Ecommerce Dashboard
A great ecommerce dashboard is organized by the questions executives ask, not by the data you have. Here’s a proven layout:
Top row: Single-number KPIs (today vs. yesterday or this month vs. last month)
- Total revenue
- Orders placed
- Conversion rate
- Average Order Value
Second row: Trend charts (last 30 or 90 days)
- Revenue over time (line chart)
- Conversion funnel (funnel chart)
Third row: Breakdown charts
- Revenue by product category (horizontal bar chart)
- Traffic by channel (stacked bar chart)
- New vs. returning customers (stacked bar chart)
Fourth row: Deep dives (weekly review)
- Best-selling products (ranked bar chart)
- CAC by channel (grouped bar chart)
- Cohort LTV curves (line chart)
For the data prep side, most ecommerce platforms export CSV or Excel. See our CSV to chart tutorial for turning raw exports into dashboard charts without any coding.
Frequently Asked Questions
What are the most important ecommerce KPIs to visualize?
The most critical KPIs to visualize are conversion rate (funnel chart), revenue over time (line chart), average order value (line chart), and customer acquisition cost by channel (grouped bar chart). These four metrics together show whether your store is growing profitably.
What chart type is best for showing a conversion funnel?
A funnel chart is the clearest way to show the conversion funnel from visitor to purchase. It makes drop-off rates at each stage immediately obvious, directing attention to where optimization will have the most impact.
How do I visualize ecommerce data without coding?
Export your data as CSV from your ecommerce platform (Shopify, WooCommerce, etc.), then use CleanChart to create the charts you need. Our CSV to chart tutorial walks through the process step by step.
What is a good ecommerce conversion rate?
Average ecommerce conversion rates typically range from 1% to 4%, depending on industry and traffic source. More important than the absolute number is the trend — whether your conversion rate is improving or declining over time.
How should I visualize cohort analysis for ecommerce?
Plot each cohort (customers who first purchased in a given month) as a separate line on a line chart, with months since first purchase on the x-axis and cumulative revenue or purchase count on the y-axis. This shows how customer value develops over time and lets you compare cohort quality.
Related CleanChart Resources
Chart Makers
- Line Chart Maker — Revenue trends, conversion rates, AOV over time
- Bar Chart Maker — Product performance, channel comparisons
- Area Chart Maker — Channel mix and stacked revenue
- Funnel Chart Maker — Conversion funnel visualization
Converters
Related Blog Posts
- How to Visualize Sales Data Effectively
- How to Create a Funnel Chart
- Charts for Business Reports
- CSV to Chart Tutorial
- Correlation Charts and Scatter Plots
External Resources
- Shopify: Essential Ecommerce Metrics to Track — Platform-specific guidance on KPI definitions
- Baymard Institute: Cart Abandonment Rate Research — Industry benchmark data on cart and checkout abandonment
- NerdSip — Micro-learning for data analysis and ecommerce analytics
Last updated: March 2, 2026