E-commerce KPI Dashboard: What to Track and Why

Most e-commerce businesses track too many metrics and act on too few. A well-designed KPI dashboard cuts through the noise — giving operators, founders, and team leads a single view of what’s working, what’s not, and what needs attention today.

In our experience, the brands that grow most predictably aren’t the ones with the most sophisticated analytics stack. They’re the ones that pick a short list of metrics, review them consistently, and build decision-making habits around them.

The Four Layers of an E-commerce KPI Dashboard

A useful e-commerce dashboard is organized by decision layer — what does each part of the business need to know to make good decisions?

Layer 1: Business Health (CEO / Founder View)

• Revenue (daily, WoW, MoM): The core number everything else flows from
• Gross margin %: Revenue minus COGS — product profitability before overhead
• Contribution margin: Gross margin minus variable costs (shipping, returns, payment processing)
• Customer acquisition cost (CAC): Total marketing and ad spend ÷ new customers acquired
• Customer lifetime value (LTV): Average revenue per customer over their full relationship with you
• LTV:CAC ratio: Target 3:1 or higher; below 2:1 is a structural problem
• Monthly recurring revenue (if applicable): Subscription and replenishment revenue

Layer 2: Acquisition & Traffic (Marketing View)

• Sessions by channel: Organic, paid, email, social, direct
• Conversion rate by channel: Traffic quality varies significantly by source
• ROAS by campaign: Return on ad spend — total revenue ÷ ad spend, per campaign
• Email open rate and click rate: Health of owned channel
• New vs. returning visitor split: Signals acquisition vs. retention performance
• Cost per click by channel: Efficiency of paid traffic

Layer 3: Conversion & On-Site (Product / UX View)

• Overall conversion rate: Sessions ÷ orders. 1–3% is typical; above 4% is strong
• Add-to-cart rate: Signals product page and listing quality
• Cart abandonment rate: Typical is 65–70%; below 60% is excellent
• Checkout abandonment rate: Separate from cart abandonment — flags UX or payment issues
• Average order value (AOV): Revenue ÷ orders; track WoW to see impact of bundles, upsells
• Product page conversion rate: Per-SKU data reveals which products convert well and which don’t

Layer 4: Operations & Fulfillment (Ops View)

• Orders shipped on time %: Target 98%+; below 95% creates support volume
• Order accuracy rate: Wrong items picked/packed rate; target 99.5%+
• Return rate: Returns ÷ orders; segment by SKU to identify problem products
• Average days to ship: From order placed to carrier pickup
• Inventory days on hand: Stock ÷ daily sales rate; flags overstock and stockout risk
• Customer service ticket volume: Leading indicator of operational issues
• First contact resolution rate: % of support tickets resolved in one interaction

Building Your Dashboard: Tools and Approaches

Option 1: Shopify Native Analytics

For early-stage brands, Shopify’s built-in analytics covers the basics: sales, conversion, customer reports, and product performance. It’s sufficient if you’re under ~$1M ARR and don’t yet need cross-channel attribution or custom metrics.

Option 2: Google Looker Studio (Free)

Google Looker Studio connects to Google Analytics 4, Google Ads, Google Sheets, and many third-party connectors. You can build a custom multi-channel dashboard that combines traffic, conversion, and ad performance data in one view — at no cost. It takes setup time but is highly flexible.

Option 3: Dedicated E-commerce Analytics Platforms

For mid-market brands ($2M+ ARR or high SKU complexity), platforms like Triple Whale, Northbeam, or Elevar provide attribution modeling, cohort analysis, and profitability metrics that Shopify native analytics can’t match. These are investments — budget $300–$800/month — but they pay for themselves when you’re spending meaningfully on paid acquisition.

Option 4: Zoho Analytics

For brands already on the Zoho ecosystem, Zoho Analytics integrates natively with Zoho CRM, Zoho Inventory, and Zoho Books to give you a combined ops + finance + CRM dashboard. Useful for businesses that want a single platform rather than a stitched-together stack.

How Often to Review Your KPIs

Cadence matters as much as the metrics themselves. A dashboard nobody looks at is useless.

• Daily: Revenue, orders, ad spend, any operational alerts (out-of-stock flags, unusual return spikes)
• Weekly: Full ops review — all four layers, WoW trends, action items
• Monthly: Trend analysis, margin review, CAC/LTV health, goal vs. actual
• Quarterly: Strategic review — channel mix, product mix, ops efficiency roadmap

Common KPI Mistakes to Avoid

• Tracking revenue without margin: Revenue growth that erodes contribution margin is not growth
• Using blended ROAS: Blended ROAS hides which campaigns are profitable. Segment by campaign and channel
• Ignoring cohort LTV: Aggregate LTV averages hide differences between acquisition cohorts — your newest customers may be less valuable than older ones
• Over-indexing on traffic metrics: Sessions and impressions are vanity metrics without conversion context
• Not connecting ops data to revenue data: A rising cart abandonment rate and a rising customer service ticket volume often point to the same root cause

---

Frequently Asked Questions

What are the most important KPIs for e-commerce?

The most critical e-commerce KPIs depend on your stage, but the universal core set includes: conversion rate, average order value, customer acquisition cost, LTV:CAC ratio, gross margin, on-time shipment rate, and return rate. These cover acquisition, monetization, and operational health.

What’s a good e-commerce conversion rate?

Industry average is 1–3% for e-commerce overall. Above 3% is strong, and above 4% is excellent. Conversion rates vary significantly by traffic source — direct and email traffic typically convert at 3–5x the rate of paid social.

What tool should I use to build an e-commerce KPI dashboard?

For early-stage brands, Shopify native analytics or Google Looker Studio (free) is sufficient. For growing brands spending meaningfully on paid acquisition, Triple Whale or Northbeam provide better attribution and profitability data. Zoho Analytics works well for brands on the Zoho ecosystem.

How do I calculate LTV:CAC ratio?

LTV:CAC = Customer Lifetime Value ÷ Customer Acquisition Cost. LTV is typically calculated as average order value × purchase frequency × average customer lifespan. CAC is total acquisition spend (ads + marketing) divided by new customers acquired in the period. A ratio of 3:1 or higher is healthy.

---

Want help building a KPI framework tailored to your e-commerce operation? Contact OpsStack Consulting — we help brands build the reporting infrastructure to make faster, better decisions.