Always live, no refresh button.
Place an order, the cell updates. Change a product, the numbers recalculate. You stop running reports because there's nothing to run. The spreadsheet is always current.
A live analytics spreadsheet for your Shopify store.
Your store's numbers in a spreadsheet that updates itself. No "run report" button. No dashboards you can't rearrange. Drop any metric into any cell.
Overview By country Top customers Cohorts
Metric
Last 7d
Prev 7d
Δ %
YTD
1
Sales
2
Net sales
$128,430
$114,220
+12.4%
$2.81M
3
Gross sales
$141,820
$126,410
+12.2%
$3.06M
4
Total discount amount
$8,214
$7,108
+15.6%
$162K
5
Average order value
$94.18
$89.40
+5.3%
$91.22
6
Volume
7
Orders count
1,364
1,278
+6.7%
30,812
8
Net quantity sold
2,118
1,947
+8.8%
48,290
Trusted by leading Shopify stores
Analytics that behave like a spreadsheet, not a dashboard.
You already know how spreadsheets work. Now they know your Shopify data, and they stay up to date on their own.
Any metric, any cell.
Pick a metric, a time frame, a segment, and drop it wherever you want. Build the exact layout you think in, not the one a dashboard tool picked for you.
As many spreadsheets as you need.
One for weekly performance. One for Holiday 2024 vs 2025. One for the buying team. Each with its own metrics, date ranges, and filters. Share the ones that matter.
Start from a template. Bend it to your store.
Pick a ready-made spreadsheet, install it in one click, and start editing. Every cell is yours: add rows, change date ranges, drop in new metrics.
Product Sales by Month
Monthly sales trends for every product, last 24 months. Spot seasonality, rising stars, and fading SKUs.
Holiday Season Sales
Product performance from Sept 1 – Dec 31, three years side by side. Plan inventory and promos for the next run.
Sales by Customer
Your top customers by total purchases, order count, AOV, and lifetime value. Find your VIPs.
Sales by Vendor
Which vendors actually drive revenue. Units sold, returns, discounts, and net sales per vendor.
Product Returns
Return rates and patterns per product. Gross vs returned quantity, return %, and where to look first.
One Time Customers
Everyone who's purchased exactly once. Gold for win-back campaigns and second-order incentives.
Always fresh
The moment Shopify changes, the spreadsheet changes.
Orders come in all day. Products get edited. Customers get added. Mixtable tracks every change and recalculates the affected cells within seconds.
- No scheduled refreshes. No "wait 24 hours for data."
- No "run report" button. The cell you're looking at is the current value.
- Share a spreadsheet with your team. They see what you see, at the same moment.
- Leave it open on a screen in the warehouse. It's a live dashboard for free.
Metric
Today
So far this hr
Vs avg
1
Orders count
184
7
+8%
2
Net sales
$17,320
$612
+12%
3
Gross quantity sold
241
10
+4%
4
Total discount amount
$1,840
$58
+3%
5
Total refund amount
$412
$0
-18%
Customizable
Drop any metric into any cell.
Pick a metric. Pick a time frame. Optionally filter by customer segment, country, sales channel, or product. The number appears in whichever cell you're on.
- Metrics: net sales, gross sales, discounts, refunds, AOV, orders, quantity sold, customer LTV, and more
- Time frames: last 7/30/90 days, any calendar month, year-to-date, or a custom range
- Filters: customer segment, country, product, collection, vendor, tag
- Change your mind? Click the cell, swap the metric, done.
Cell C5 · Metric settings
Net sales
Last 30 days
VIP customers
All countries
All products
C5 = $412,108
One store, many views
As many spreadsheets as you need.
One store generates a dozen questions: "how's this week?", "how was Black Friday vs last year?", "which products sell in the UK?" Answer each in its own spreadsheet, opened on its own tab.
- Weekly performance · for the Monday stand-up
- Holiday compare · one worksheet per year, side by side
- Top customers · the 100 people keeping the lights on
- Buying team view · shared with your suppliers
- A sandbox · where you try ideas without touching the shared ones
Week 2024 2025
BF Week $412K $519K
Cyber Week $308K $389K
Metric Last 30d YTD
Net sales £62,410 £712K
Orders 842 9,812
AOV £74.12 £72.55
Metric Last 7d Prev 7d
Net sales $128,430 $114,220
Avg order value $94.18 $89.40
Orders count 1,364 1,278
Net qty sold 2,118 1,947
Every metric Shopify exposes, ready to drop into a cell.
Each metric is filterable by time frame, customer segment, country, product, collection, vendor, or tag. If we don't have something you need, ask and we'll build it.
Net sales Net sales (accrual basis) Gross sales Total sales Total discount amount Total refund amount Total shipping amount Total tax amount Total duties Total additional fees Orders count Refund count Average order value Average orders count Gross quantity sold Net quantity sold Refunded quantity Average order quantity Percent of orders refunded Customer lifetime value Segments customer is in Product types bought by customer Product categories bought by customer Cost of goods sold Gross profit Net profit Gross margin
Why merchants switch to Mixtable Analytics.
Most Shopify analytics tools hand you dashboards you can't rearrange. Mixtable hands you a spreadsheet.
| Mixtable Analytics | Shopify built-in | Dashboard apps (Peel, Polar, Glew) | Sheets + connector (Supermetrics, Coupler) | |
|---|---|---|---|---|
| Live-updating cells | Seconds | Yes | Hourly / daily refresh | Scheduled syncs |
| Arrange your own layout | Any cell, any place | Fixed reports | Drag widgets | In Sheets |
| Multiple spreadsheets per store | Unlimited | One set of reports | Per-dashboard | In Sheets |
| Pre-built templates | 18, editable | Fixed | Fixed | Build it yourself |
| Shopify-native metrics | Yes | Yes | Yes | Raw tables only |
| Learning curve | It's a spreadsheet | Low | BI tool | ETL setup |
| Pricing | From $19/mo | Free | $100–$1,500/mo | $50–$200/mo stacked |
Watch Mixtable Analytics in action.
A guided tour showing how you build a spreadsheet from scratch, pick metrics, add time frames, and watch cells update as orders roll in.
Product analytics examples
Net sales for all orders Collection analytics examples
Stop running reports.
Open a spreadsheet instead.
Install Mixtable Analytics free on your Shopify store. Pick a template. Watch the numbers move.