Why you need sales analytics (and what to measure)
Most small online sellers run their business **on feeling**. "I think Etsy is the best channel", "I think this candle sells well", "I think I have 30% margin".
But **"I think" is not a strategy**. If you don't know exactly what's happening in your business, you can't make good decisions. You can't know:
- Which channel brings you **the most profit** (not just revenue)
- Which product **loses money** (you sell it below cost without knowing)
- Which customers **return** and how much they're worth
- Whether your **margin is shrinking** or growing
In this article, I'll show you **why you need analytics** and **which 4 numbers actually matter** — without complicated tables and Excel formulas.
The problem with "by eye" business management
Imagine this situation: You sell handmade candles on Etsy and Instagram. Last month you had **€1,200 in revenue** — good, right?
But here's what you don't know:
- Etsy took 6.5% in fees — €78
- Instagram orders brought less revenue (€450), but had **lower costs** (no fees) — so they're actually **more profitable**
- You sold 8 vanilla candles, but each costs €5 to make and you sell for €11 — **Etsy fee + shipping = you lose €0.50 per unit**
- Anna bought from you 3 times — your best customer, and you never reached out
Without analytics, **all of this stays invisible**. You keep selling, without knowing where you're losing money.
The 4 numbers that actually matter
You don't need 20 reports and 15 charts. You need **4 key numbers**:
1. Revenue by channel
How much does Etsy bring, how much Instagram, how much WhatsApp? **Without this, you don't know where to invest your time.**
Many sellers think Etsy is "the best" because it has the highest revenue. But when you factor in the **6.5% fee**, Etsy often brings **less profit** than direct sales through Instagram.
2. Profit by product
For each product, you need to know:
- How much you paid (cost price)
- How much you sold it for (selling price)
- How much shipping costs you
- How much the channel takes (fee)
- How much you keep** (profit)
This is **the most important number**. If it's negative — you're selling below cost.
3. Margin
Margin = profit / selling price × 100
If you have **30% margin**, it means that out of every €100 in sales you keep €30. If margin is **below 15%**, you probably shouldn't be selling that product.
MicroStock automatically calculates margin for each product and shows you **loss-makers in red**.
4. Top customers
Retaining an existing customer is **5x cheaper** than finding a new one. But if you don't know **who your best customer is**, how can you reach out?
Top 10 customers by revenue — that's your "golden list". They deserve your attention: loyalty program, repeat purchase discount, personal thank-you card.
How to start tracking analytics
Here's a simple plan:
- Import all orders from the last 3 months (manually or from CSV).
- List all products with cost and selling prices.
- Run analytics — see revenue, profit, margin, top customers.
- Identify loss-makers — products with negative profit.
- Focus on top 20% — which bring 80% of profit.
MicroStock does all this **automatically**. One click — and you see the complete picture of your business.
Conclusion
Analytics is not "for big companies". Analytics is **for anyone who wants to know where their money goes**.
If you currently run your business "by eye", **start today**. Import 3 months of data, look at the numbers, and you'll be surprised by what you discover.
MicroStock lets you do this in **5 minutes**. No Excel, no IT team, no complications.
← Back to blog