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.
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.
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
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 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 | 19, 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
Shopify analytics: common questions.
The things merchants ask before they install.
How do I build a custom sales report in Shopify?
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a reporting worksheet. Pick what the rows are, such as products, collections, customers, or months, then choose a metric and a timeframe for each column. The cells fill with numbers calculated from your store's orders straight away.
Which metrics can I report on?
Net sales, gross sales, total sales, orders count, average order value, net quantity sold, discounts, refunds, returns, taxes, shipping, duties, cost of goods sold, gross profit, net profit, and gross margin, among others.
Do I have to run a report to refresh the numbers?
No. Cells update within seconds of your store changing, so the spreadsheet is current whenever you open it. You can leave it on a screen and treat it as a live dashboard.
Can I compare date ranges side by side?
Yes. Each column carries its own timeframe, so last 7 days, the prior 7 days, this month, and year to date can sit next to each other in one sheet, with your own formulas calculating the change between them.
How is this different from Shopify's built-in analytics?
Shopify Analytics gives you a fixed set of reports in a fixed layout. Mixtable calculates its own metrics from your store's order, product, and customer data and puts them into cells you arrange yourself, so you can mix metrics, write formulas across them, add your own columns, and keep as many separate spreadsheets as you need.
Can I export my Shopify reports to Excel?
Yes. The spreadsheet exports to a real .xlsx file, and the worksheet you are on exports to CSV, keeping the layout you built.
Do I have to build reports from scratch?
No. There are 19 pre-built templates covering sales, products, customers, collections, channels, markets, returns, and B2B. Each one is a starting point you can edit rather than a fixed report.
Stop running reports.
Open a spreadsheet instead.
Install Mixtable Analytics free on your Shopify store. Pick a template. Watch the numbers move.