Retail Analytics: The Metrics That Matter for Stores and Ecommerce
The core retail metrics for physical stores and online shops, with formulas, plus the weekly and monthly reports that turn those numbers into decisions.
Retail analytics uses sales, inventory, customer and traffic data to decide what to stock, how to price and how to staff. The metrics that matter most are conversion rate, average transaction value, sales per square foot, sell-through rate, inventory turnover, GMROI, shrink, return rate and repeat purchase rate, each reviewed on a set schedule.
Photo: Unsplash
On this page
Most retailers are drowning in reports and starving for answers. The POS has 40 report templates. The ecommerce platform has a dashboard full of charts. The inventory system sends a weekly email nobody opens. Yet the questions owners actually ask are simple: what’s selling, what isn’t, and what should I do about it?
Retail analytics answers those questions. This guide defines the metrics that matter for physical stores and ecommerce, shows how to calculate each one, and lays out the reports that turn them into action. It’s built for independent retailers and small chains, but the same metrics run the biggest stores in the country.
Why retail analytics matters more now
Shoppers move between channels constantly. They browse online and buy in store, or see a product on a shelf and order it later from their phone. The US Census Bureau estimated that ecommerce made up 17.1% of total US retail sales in the second quarter of 2026, on a seasonally adjusted basis, and online sales grew faster than total retail compared with a year earlier.
That means most retailers need to read 2 sets of numbers side by side: store metrics and online metrics. They overlap more than you’d think, because both come down to traffic, conversion, basket size, margin and inventory.
The 4 questions retail analytics answers
- Are we attracting enough shoppers? Traffic and visitor metrics.
- Are we turning shoppers into buyers? Conversion and basket metrics.
- Are we making money on what we sell? Margin and inventory metrics.
- Are customers coming back? Retention and lifetime value metrics.
Every metric below answers one of these.
Sales and traffic metrics
Sales per square foot (stores)
Formula: net sales ÷ selling square footage, usually for a year.
This shows how productive your space is. Use it to compare locations, departments or fixture zones, and to decide whether a slow category deserves less floor space.
Foot traffic and website sessions
Door counters or camera-based traffic sensors count store visitors. Google Analytics 4 or your ecommerce platform counts online sessions. Traffic on its own isn’t a goal, but you need it to calculate conversion.
Conversion rate
- Store: transactions ÷ visitors.
- Online: orders ÷ sessions.
If traffic is up but conversion is down, the problem is inside the store or on the site: stock gaps, slow checkout, staffing or pricing. If both are down, the problem is usually marketing or seasonality.
Average transaction value (ATV) or average order value (AOV)
Formula: net sales ÷ number of transactions.
Units per transaction (UPT)
Formula: total units sold ÷ number of transactions.
ATV and UPT together show whether staff and site design are building baskets. A rising UPT with flat ATV may mean shoppers are trading down to cheaper items.
Inventory and margin metrics
Sell-through rate
Formula: units sold ÷ units received, for a product or category over a period.
This is the go-to metric for seasonal and fashion merchandise. Low sell-through mid-season is your signal to mark down early, before the item becomes dead stock.
Inventory turnover
Formula: cost of goods sold ÷ average inventory at cost.
Higher turnover means cash isn’t sitting on shelves. Compare against your own history by category, since a jewelry case and a snack aisle turn at very different speeds. Our guide to supply chain analytics covers inventory metrics in more depth.
Gross margin return on inventory investment (GMROI)
Formula: gross margin dollars ÷ average inventory at cost.
GMROI tells you how many dollars of gross margin each dollar of inventory earns. It’s one of the best single metrics for deciding which categories deserve more buying budget, because it combines margin and turnover.
Stockout rate
The share of SKUs, or the share of time, that an item was out of stock when customers wanted it. Track it for your top sellers. Stockouts on best sellers cost sales and push shoppers to competitors.
Shrink
Formula: (book inventory − physical inventory) ÷ sales, expressed as a percentage.
Shrink covers theft, damage, vendor errors and admin mistakes. Measure it at every physical count and by category so you can target the real cause.
Markdown rate
Formula: markdown dollars ÷ sales at original price.
High markdowns may mean over-buying, poor timing or the wrong assortment.
Customer metrics
Repeat purchase rate
Formula: customers who bought 2 or more times ÷ total customers, over 12 months.
Stores need a way to recognize customers, such as loyalty programs, email receipts or saved cards, to track this. Online stores usually have it built in.
Customer lifetime value (CLV)
A simple version: average order value × purchases per year × average years as a customer. It’s an estimate, but it tells you how much you can sensibly spend to win and keep a customer.
Return rate
Formula: units or dollars returned ÷ units or dollars sold.
Break it down by product and reason. A high return rate on one item often points to a sizing chart, photo or description problem, especially online.
Cart abandonment (ecommerce)
Formula: 1 − (completed purchases ÷ carts created).
In GA4, ecommerce events such as add_to_cart, begin_checkout and purchase must be set up for these reports to work. Many platforms, including Shopify’s Google integration, send some of these events automatically.
The reports that act on these metrics
Start with a single view of every metric above, then build a reporting rhythm around it.
Retail metrics cheat sheet
| Metric | Formula | Store, online or both | Review how often |
|---|---|---|---|
| Sales per square foot | Net sales ÷ selling sq ft | Store | Quarterly |
| Conversion rate | Transactions ÷ visitors (or orders ÷ sessions) | Both | Weekly |
| Average transaction value | Net sales ÷ transactions | Both | Weekly |
| Units per transaction | Units ÷ transactions | Both | Weekly |
| Sell-through rate | Units sold ÷ units received | Both | Weekly in season |
| Inventory turnover | COGS ÷ average inventory at cost | Both | Monthly |
| GMROI | Gross margin $ ÷ average inventory at cost | Both | Monthly or quarterly |
| Shrink | (Book − physical inventory) ÷ sales | Mostly store | Each physical count |
| Return rate | Returns ÷ sales | Both | Monthly |
| Repeat purchase rate | Repeat customers ÷ total customers | Both | Quarterly |
| Cart abandonment | 1 − (purchases ÷ carts) | Online | Weekly |
Key takeaway: If you only track 3 numbers, track conversion rate, average transaction value and GMROI. Together they tell you whether shoppers buy, how much they spend and whether your inventory is earning its keep.
A simple reporting rhythm
Metrics only matter if someone looks at them on a schedule and makes a decision. Here’s a simple reporting rhythm.
Daily flash report
Yesterday’s sales, transactions, ATV and conversion versus the same day last year. Takes 2 minutes to read. Its job is to catch problems fast, like a broken checkout or an empty display.
Weekly best and worst sellers report
Top 20 and bottom 20 items by units and margin, with sell-through and weeks of supply. Decision: reorder winners, move or mark down losers.
Weekly staffing versus traffic report
Traffic and conversion by hour, next to staff hours scheduled. Decision: shift labor toward peak hours where conversion drops.
Monthly category review
Sales, gross margin, GMROI, turnover, markdowns and returns by category. Decision: adjust open-to-buy budgets, floor space and pricing.
Monthly customer report
New versus returning customers, repeat purchase rate, average spend by segment and email or loyalty program results. Decision: plan win-back offers and loyalty perks.
Quarterly space and channel review
Sales per square foot by zone, online versus store sales, and ship-from-store or buy online, pick up in store volume. Decision: reset layouts and rebalance inventory between channels.
Tools for retail analytics
| Need | Tool type | Examples |
|---|---|---|
| Sales, items, staff | POS reports | Square, Lightspeed, Shopify POS, Clover |
| Online behavior | Web analytics | Google Analytics 4, platform analytics |
| Inventory and buying | Inventory or retail ERP | Built-in POS inventory, standalone inventory tools |
| Store traffic | Door counters, traffic sensors | Various hardware vendors |
| Combined dashboards | BI tools | Looker Studio, Power BI, Tableau |
| Customers | CRM, loyalty and email tools | Loyalty apps, email marketing platforms |
Small retailers can get far with POS reports and a spreadsheet. See data analytics for small business for the basics. For a wider view of in-store tech, read our retail tech trends 2026 guide and how technology is changing small retail shops and boutiques. AI forecasting and personalization tools are covered in AI in retail and ecommerce.
Where to start: 5 steps
- Clean your product data. Consistent SKUs, categories, costs and vendor names are the foundation. Bad item data breaks every report.
- Pick your 5 core metrics. A good starting set: conversion rate, ATV, sell-through, GMROI and repeat purchase rate.
- Set up tracking gaps. Add a door counter if you have none, and confirm GA4 ecommerce events are firing on your site.
- Build the weekly best and worst sellers report. It’s the report most likely to change a decision every single week.
- Hold a 30-minute weekly review. Look at the numbers, pick 1 to 3 actions, and check next week whether they worked.
If you outgrow spreadsheets and want to query your sales data directly, SQL for beginners uses a retail sales table for its examples.
Conclusion
Retail analytics comes down to a handful of numbers: how many shoppers buy, how much they spend, how fast inventory turns and how much margin each dollar of stock earns. Track them in both your store and your online shop, review them on a fixed schedule, and tie each report to a decision. That’s how independent retailers compete with chains that have entire analytics teams.
Sources
- US Census Bureau: Quarterly Retail E-Commerce Sales, 2nd Quarter 2026 (PDF) — ecommerce share of total retail sales and growth rates
- US Census Bureau: Quarterly Retail E-Commerce Sales Report — release schedule and historical ecommerce data
- Google Analytics Help: Ecommerce purchases report — ecommerce events required for GA4 retail reports
- Google for Developers: Measure ecommerce in Google Analytics — add_to_cart, begin_checkout and purchase event setup
Frequently asked questions
What is retail analytics?
Retail analytics is the practice of analyzing sales, inventory, customer and traffic data to improve retail decisions, such as what to buy, how to price, where to place products and how to staff. It covers both physical stores and ecommerce. Common metrics include conversion rate, average transaction value, sell-through rate, inventory turnover, GMROI, shrink and repeat purchase rate.
What are the most important retail KPIs?
The most important retail KPIs are conversion rate, average transaction value, units per transaction, sell-through rate, inventory turnover, GMROI, shrink, return rate and repeat purchase rate. Stores add sales per square foot, and online shops add cart abandonment. If you can only track 3, start with conversion rate, average transaction value and GMROI.
How do you calculate GMROI?
Divide gross margin dollars by average inventory at cost for the same period. For example, if a category earned $60,000 in gross margin over a year and you held an average of $20,000 of inventory at cost, GMROI is 3. That means each dollar invested in that inventory returned $3 in gross margin. Compare GMROI across categories to guide buying budgets.
What is a good conversion rate for a retail store?
There's no single good number, because conversion varies widely by store type, price point and traffic source. A furniture showroom and a convenience store will look completely different. The most useful benchmark is your own history: track conversion by day and hour, compare it to the same period last year, and look for drops tied to staffing, stockouts or layout changes.
How do small retailers track store traffic?
Small retailers usually track store traffic with door counters or traffic sensors mounted at the entrance, which count people entering. Some POS and retail platforms integrate with these devices to calculate conversion automatically. Without a counter, you can estimate traffic with manual counts during sample hours, but a device gives far more reliable data for staffing and conversion analysis.
What is the difference between sell-through rate and inventory turnover?
Sell-through rate measures the share of units received that have sold, usually for a specific product or season, so it's ideal for deciding markdowns. Inventory turnover measures how many times your average inventory sells and is replaced over a period, based on cost, so it's better for judging overall inventory efficiency. Use sell-through weekly in season and turnover monthly.
Do I need special software for retail analytics?
Not at first. Most POS and ecommerce platforms include the reports you need for core metrics, and a spreadsheet covers the rest. Consider a BI dashboard tool once you combine several data sources, run multiple locations or spend hours building the same reports each week. Choose tools that connect directly to your POS and ecommerce platform.
Was this guide useful
No reviews yet. Share your experience and help other readers.
Write a review
Manishdai
Manishdai writes about the technology that is reshaping every industry — from AI agents and cloud platforms to healthtech, fintech and the IT companies building it all across the United States.
manishdai.com