If you sell products — online, in-store, or both — analytics is how you stop guessing and start knowing. But "analytics" has become one of those words that means everything and nothing. Platforms throw the term around to sell dashboards. Consultants use it to justify retainers. And most merchants end up with a dozen reports they never look at.
This guide cuts through the noise. We'll cover what analytics actually means for a merchant, the five metrics that matter most, how online and in-store data differ, and how to build a practice that drives decisions — not just charts.
What analytics really means for merchants
Analytics is the practice of collecting data about your business, making sense of it, and using those insights to make better decisions. That's it.
You don't need a data science degree. You don't need a warehouse full of servers. You need to answer questions like:
- Which products are actually making me money after all costs?
- Are my customers coming back, or am I on a treadmill of acquisition?
- Is my inventory investment paying off, or am I sitting on dead stock?
Good analytics connects the dots between your revenue, your costs, your customers, and your operations. The goal isn't more data — it's better decisions.
The 5 key metrics every merchant should track
Not all metrics are created equal. These five form the foundation of a healthy analytics practice.
1. Revenue and gross margin
Revenue is the headline number, but margin is what keeps the lights on. Gross margin — revenue minus cost of goods sold, shipping, transaction fees, and discounts — tells you how much you actually keep from each sale.
A store doing $100,000/month at 20% margins is less healthy than one doing $60,000/month at 45% margins. If you're not tracking margin at the product level, you're flying blind.
Key question: "Which of my top-selling products have the lowest margin — and am I promoting them by accident?"
2. Customer lifetime value (LTV)
Acquiring a customer costs money. LTV tells you how much revenue (or profit) that customer will generate over their entire relationship with your store. If your acquisition cost exceeds your LTV, you're losing money on every new customer.
For most merchants, LTV is driven by repeat purchase rate and average order value. Even a small improvement in either metric compounds over time.
Key question: "What percentage of my customers buy more than once, and what's the average gap between their first and second purchase?"
3. Inventory turnover
Inventory turnover measures how many times you sell through your stock in a given period. High turnover means your capital isn't sitting on shelves. Low turnover means you're paying to store products that aren't moving.
The ideal turnover rate varies by industry, but the principle is universal: unsold inventory is a cost, not an asset. Track turnover by category and by SKU to find the dead weight.
Key question: "Which products have been in stock for more than 90 days without a sale?"
4. Conversion rate
Conversion rate is the percentage of visitors (or store walk-ins) who complete a purchase. Online, this is straightforward to track. In-store, it requires foot traffic counters or POS data.
What matters more than the raw number is the trend. A declining conversion rate with stable traffic means something in your funnel — pricing, product selection, checkout friction — is breaking down.
Key question: "Has my conversion rate changed in the last 30 days, and can I connect the change to anything I did differently?"
5. Average order value (AOV)
AOV is your total revenue divided by the number of orders. It's a lever you can pull through bundling, upselling, free-shipping thresholds, and product placement.
AOV is especially useful when combined with LTV. If you can increase AOV without increasing acquisition cost, your profit per customer rises directly.
Key question: "What's the most common product pairing in orders above my average AOV?"
Online vs. in-store: what's different
If you sell through both channels, you already know the data looks different. Here's what to watch for.
Online advantages: You get granular traffic data, session recordings, cart abandonment rates, and attribution. Every click is logged. The challenge is connecting that behavioral data to actual profitability.
In-store advantages: You see the customer. You know what they picked up and put back (if you're tracking it). Transaction data is clean. The challenge is that you lose the "funnel" — you rarely know how many people walked in versus how many bought.
The unification problem: Most merchants have one system for online orders and another for in-store POS. Unifying these into a single view of revenue, inventory, and customers is the single biggest analytics challenge for omnichannel retailers. Until you solve it, you're making decisions with half the picture.
Platforms like Spark exist specifically to bridge this gap — connecting Shopify, WooCommerce, Square, Odoo, and other systems into a unified analytics layer.
The analytics maturity ladder
Not every merchant needs predictive modeling on day one. Here's a realistic progression:
Level 1 — Reporting: You can pull a revenue report by date range. You know your top products. This is where most merchants start.
Level 2 — Analysis: You're comparing periods, segmenting by category or channel, and asking "why" questions. You've moved from "what happened" to "why it happened."
Level 3 — Diagnostics: You're combining data sources — revenue plus COGS plus inventory plus returns — to diagnose issues. You can identify margin leaks, slow-moving stock, and customer churn patterns.
Level 4 — Prediction: You're using historical patterns to forecast demand, anticipate stockouts, and project cash flow. This is where AI-powered tools start to pay for themselves.
Most merchants are somewhere between Level 1 and Level 2. The goal isn't to jump to Level 4 overnight — it's to move up one level at a time with each analytics capability you add.
Common mistakes to avoid
Tracking too many metrics: If you're watching 30 KPIs, you're watching none. Start with the five above. Add more only when you have a specific question.
Confusing revenue with profit: Revenue growth with declining margins is a trap. Always pair revenue metrics with cost data.
Ignoring cohort effects: Your "average customer" doesn't exist. Customers acquired through a holiday sale behave differently than organic customers. Segment before you conclude.
Checking dashboards without acting: A dashboard you look at but never act on is entertainment, not analytics. Every metric should have a threshold that triggers a decision.
Waiting for perfect data: Your data will never be perfect. Start making decisions with what you have, and improve data quality incrementally.
Choosing the right tools
The analytics tool landscape ranges from free built-in reports to enterprise-grade platforms. Here's how to think about it:
Platform built-in reports (Shopify Analytics, WooCommerce reports): Good for basic revenue and order tracking. Limited on margins, inventory, and cross-platform views.
Spreadsheets: Flexible but manual. Fine for ad-hoc analysis, painful for anything recurring. Breaks down when you need to combine data from multiple sources.
Dedicated analytics tools: Purpose-built for merchants. The best ones connect to your platforms, normalize the data, and surface insights you wouldn't find manually. Spark falls in this category — it connects to your store, understands your data model, and lets you ask questions in plain language instead of building reports.
Full BI platforms (Looker, Tableau): Powerful but complex. Require data engineering to set up. Overkill for most SMB merchants.
The right choice depends on your scale, your technical comfort, and how many data sources you need to connect. For most merchants, a dedicated analytics tool that integrates with your platform is the sweet spot — you get depth without the setup cost of a full BI stack.
What comes next
This guide covers the foundations. In the next parts of this series, we'll go deeper into intermediate techniques — cohort analysis, RFM segmentation, contribution margin analysis, and basket analysis — and then into advanced topics like predictive LTV modeling, price elasticity, and demand forecasting.
The most important step is the first one: pick one metric from the list above that you're not currently tracking, and start measuring it this week. Analytics is a practice, not a project.
See your metrics in one place
Spark connects to Shopify, WooCommerce, Square, Odoo, and more — and surfaces the insights that matter.