Tracking too many metrics is almost as bad as tracking none. You end up with dashboards full of numbers that don't lead to decisions. The fix is a structured checklist — a defined set of KPIs reviewed at a defined cadence, each tied to a specific action when something looks off.
This guide organizes the essential ecommerce KPIs by how often you should review them: daily, weekly, and monthly. For each metric, you'll find the definition, the formula, a benchmark range, and what to investigate when the number moves in the wrong direction.
Daily KPIs
These are your vital signs. Check them every morning in under five minutes. They tell you if something needs immediate attention.
Revenue
What it is: Total sales in the last 24 hours, net of discounts and refunds.
Formula: Gross sales - discounts - refunds = net revenue
Benchmark: Compare against the same day last week and the trailing 7-day average. A single day is noisy — what matters is whether it's within normal range.
If it's off: A sudden drop (25%+ below trailing average) warrants an immediate check. Common causes: site downtime, broken checkout, payment processor issues, or a paused ad campaign. Sudden spikes deserve investigation too — confirm it's real orders, not fraud or a pricing error.
Orders
What it is: The number of completed transactions in the last 24 hours.
Formula: Count of orders with status = completed or processing
Benchmark: Track alongside revenue. If orders are up but revenue is down, your average order value is shrinking (customers are buying less per transaction). If orders are down but revenue is stable, AOV is increasing.
If it's off: A drop in orders with stable traffic means your conversion rate fell — check for checkout issues, pricing problems, or out-of-stock products. A drop in both orders and traffic points to a marketing or SEO problem.
Conversion rate
What it is: The percentage of visitors who complete a purchase.
Formula: Orders / unique visitors x 100
Benchmark: Ecommerce average conversion rate ranges from 1.5% to 3.5%, depending on industry. Fashion tends toward the lower end; consumables and replenishment products toward the higher end. Your own historical average matters more than industry benchmarks.
If it's off: A sudden drop with stable traffic is almost always a site issue — slow load times, checkout errors, or payment problems. Check your funnel for step-by-step drop-off. A gradual decline suggests a competitive or pricing issue.
Average order value (AOV)
What it is: The average revenue per order.
Formula: Total revenue / number of orders
Benchmark: Highly category-dependent. Track your own trend line. AOV should be relatively stable day to day unless you're running promotions.
If it's off: A declining AOV can indicate customers trading down to cheaper products, discount overuse, or a shift in your product mix toward lower-priced items. An increasing AOV can be positive (upselling is working) or a red flag (fewer small orders, meaning you're losing casual buyers).
Weekly KPIs
These metrics need a slightly longer window to be meaningful. Review them every Monday (or whatever day starts your operational week).
Traffic by source
What it is: Where your visitors are coming from — organic search, paid ads, social, email, direct, referral.
Formula: Segment visits by utm_source/utm_medium or referrer
Benchmark: Track the mix over time. A healthy store typically gets 30-50% organic, 20-30% paid, 10-20% direct, and the rest from email, social, and referral. The exact split depends on your marketing mix.
If it's off: If organic traffic is declining, check for SEO issues — lost rankings, technical problems, or indexing errors. If paid traffic drops, check campaign budgets and bid performance. If direct traffic is growing disproportionately, you may have tracking problems (unattributed traffic often shows up as "direct").
Top products by units and revenue
What it is: Your best-selling products by both unit volume and revenue for the trailing 7 days.
Formula: Rank products by units sold and by revenue generated
Benchmark: Your top 20% of products typically generate 60-80% of revenue (Pareto distribution). Track whether the same products dominate week over week or if there's healthy rotation.
If it's off: If a previously top-selling product drops off, check for stockouts, negative reviews, a price change, or a competitor offering a better alternative. If a new product surges, investigate whether it's organic demand or driven by a specific campaign — and make sure you have enough inventory.
Cart abandonment rate
What it is: The percentage of shopping carts that are created but not converted into orders.
Formula: (Carts created - orders completed) / carts created x 100
Benchmark: Average ecommerce cart abandonment rate is 65-75%. Below 60% is excellent. Above 80% indicates a serious friction problem.
If it's off: High abandonment is usually caused by unexpected costs at checkout (shipping, tax), forced account creation, or limited payment options. Compare across devices — mobile abandonment is typically 10-15 points higher than desktop. A sudden spike usually means a technical checkout issue.
Discount usage rate
What it is: The percentage of orders that include a discount code or automatic discount.
Formula: Orders with discount / total orders x 100
Benchmark: 20-35% is typical for stores that run occasional promotions. If more than 50% of your orders include a discount, you may be training customers to wait for sales.
If it's off: High discount usage erodes margins and signals dependency. Check whether discounts are going to new or existing customers — if most go to existing buyers, you're subsidizing sales that would have happened at full price.
Monthly KPIs
These are your strategic metrics. They reveal trends that daily and weekly numbers can't show and inform bigger decisions about pricing, inventory, and growth.
Gross margin
What it is: Revenue minus the cost of goods sold, expressed as a percentage.
Formula: (Revenue - COGS) / revenue x 100
Benchmark: Healthy ecommerce gross margins vary by category: 40-60% for apparel, 30-50% for electronics, 50-70% for beauty and personal care, 20-40% for food and beverage. Your trend matters more than the absolute number.
If it's off: Declining margins usually come from one of four places: rising supplier costs, increasing discount depth, a shift in product mix toward lower-margin items, or growing return rates (returned products reduce effective revenue but the COGS is already incurred). Identify which factor is responsible before trying to fix it.
Customer acquisition cost (CAC)
What it is: How much it costs to acquire a new customer.
Formula: Total marketing and advertising spend / number of new customers acquired
Benchmark: CAC should be less than one-third of your customer LTV for a sustainable business. If your average LTV is $150, your CAC should be below $50.
If it's off: Rising CAC means marketing efficiency is declining. Check CAC by channel to find the problem. Cut or optimize the highest-CAC channels and reallocate to the most efficient ones.
Customer lifetime value (LTV)
What it is: The total revenue a customer generates over their entire relationship with your store.
Formula: Average order value x purchase frequency x average customer lifespan
Benchmark: Your LTV-to-CAC ratio should be at least 3:1. Track LTV by acquisition channel and by customer segment — the average obscures important variation.
If it's off: Declining LTV means customers are buying less frequently, spending less per order, or churning faster. Use cohort analysis to identify which group is underperforming. Often the issue is poor retention of new customers — improving your first-to-second-purchase rate has the largest impact on LTV.
Inventory turnover
What it is: How many times you sell through your average inventory in a period.
Formula: COGS / average inventory value
Benchmark: 4-6 turns per year is healthy for most ecommerce categories. Fast-moving consumables may hit 8-12. Slow-moving durable goods might be 2-4. Below 2 means capital is tied up in products that aren't selling.
If it's off: Low turnover means you're carrying too much stock relative to demand. Identify slow-moving SKUs (anything below 1 turn) and take action: mark it down, bundle it, or discontinue it. High turnover can also be a problem if it means you're frequently stocking out of popular items — check your in-stock rate alongside turnover.
Return rate
What it is: The percentage of orders that are partially or fully returned.
Formula: Returned orders / total orders x 100
Benchmark: Average ecommerce return rate is 15-30%, varying significantly by category. Apparel: 20-30%. Electronics: 10-15%. Beauty: 5-10%.
If it's off: Rising returns erode margins directly and signal product or expectation problems. Analyze returns by SKU to find problem products. Common causes: inaccurate descriptions, sizing issues, quality problems, or shipping damage.
Cash flow from operations
What it is: The actual cash generated (or consumed) by your business operations in a month.
Formula: Cash receipts from sales - cash payments for inventory, operating expenses, and marketing
Benchmark: This should be positive for a sustainable business. Many growing ecommerce businesses are cash-flow negative because they're investing in inventory ahead of sales — that's acceptable short-term but needs to be tracked closely.
If it's off: Negative cash flow means you're spending more cash than you're generating. Usual culprits: overstocking, unfavorable payment terms, or marketing spend that isn't converting fast enough. Model your cash conversion cycle — the gap between paying for inventory and receiving customer payments.
Using this checklist
Print this checklist (or bookmark it) and build it into your weekly routine. Monday morning: review daily KPIs for the past week and weekly KPIs for the current period. First of the month: review all monthly KPIs.
The value isn't in the numbers themselves — it's in the pattern of checking, comparing to benchmarks, and taking action when something deviates. A KPI without a response plan is just a number on a screen.
Spark tracks all of these KPIs automatically across your connected stores. Instead of logging into multiple dashboards and running manual calculations, you can ask Spark for any metric — daily revenue, margin trends, cart abandonment, LTV by segment — and get answers that reflect data from every connected platform in real time.
Track every KPI in one place
Spark monitors your daily, weekly, and monthly KPIs across all your sales channels — so you never miss a signal.