Mixtable Analytics Spreadsheet
Net Sales, orders, average order value, and margin, calculated from your store's orders and laid out the way you want. There is no report to run and no dashboard you can't rearrange.
Monthly store performance From Shopify Trusted by thousands of Shopify stores
Why a spreadsheet
You already know how spreadsheets work. Now they know your store, and they stay up to date on their own.
A new order comes in and the numbers update. You stop running reports because there is nothing to run.
Choose what goes down the rows and across the columns: products, vendors, metrics, months. Add your own formulas right beside them.
One for weekly performance, one for the holiday comparison, one for the buying team. Share the ones that matter.
Templates
Pick a ready-made spreadsheet and start editing. Rename it, rearrange it, add rows, or change the timeframes.
Products
Monthly sales for every product. Spot seasonality, rising products, and fading ones.
Seasonal
September to December, year against year. Plan inventory and promotions for the next run.
Customers
Your top customers by Net Sales, order count, and average order value.
Suppliers
Which vendors drive revenue: quantity sold, discounts, refunds, and Net Sales per vendor.
Operations
Gross quantity against returned quantity for every product, so you know where to look first.
Retention
Everyone who has ordered exactly once. A ready list for win-back campaigns.
19 ready-made templates in all, including Sales by Product Type, Sales by Product Tag, Sales by Market, Collection Sales, Monthly Store Performance, and Order Fulfillment.
Pivot Table worksheet
A Pivot Table worksheet puts one business dimension down the rows and the metrics you choose across the columns.
Sales by vendor From Shopify Time Series worksheet
A Time Series worksheet lays the same metrics out over time, with up to 90 daily, 52 weekly, 36 monthly, or 10 yearly columns.
=B4/C4-1 for month-on-month change Net Sales by product type From Shopify Analytics columns
On a Shopify data worksheet, an analytics column adds one metric for every row, next to the fields you already have.
Products From Shopify Inventory metrics
Add inventory metrics beside every product, variant, or collection, or total them in a report. Mixtable calculates them from your store's day-by-day inventory history.
Variants From Shopify Metrics
Each metric takes a timeframe and optional filters, such as customer segment, country, sales channel, or discount.
Compare
Most Shopify analytics tools hand you a dashboard. Mixtable hands you a spreadsheet.
| Mixtable | Shopify's built-in reports | Dashboard appsPeel, Polar, Glew | Sheets plus a connectorSupermetrics, Coupler | |
|---|---|---|---|---|
| Stays up to date | Automatically | Yes | Hourly or daily refresh | Scheduled syncs |
| Arrange your own layout | Your rows, your columns | Add or remove report columns | Drag widgets | In Sheets |
| Spreadsheets per store | As many as you need | Saved custom reports | Per dashboard | In Sheets |
| Ready-made templates | 19, all editable | Default reports, most editable | Fixed | Build it yourself |
| Metrics built for Shopify | Yes | Yes | Yes | Raw tables only |
| Learning curve | It is a spreadsheet | Low | A BI tool | ETL setup |
| Price | Free, or $15 to $49/month | Included | $100 to $1,500/month | $50 to $200/month, stacked |
Walkthrough
A guided tour of adding metrics to products, collections, and customers, with different timeframes and filters.
Demo spreadsheet From Shopify Pricing
Free while your store has fewer than 1,000 lifetime orders. After that, every paid plan starts with a 7-day free trial. Every metric and template is included on every plan, and you can cancel at any time.
| Your Shopify plan | Any plan, under 1,000 lifetime orders | Basic | Grow and Advanced | Plus |
|---|---|---|---|---|
| Billed monthly | $0 /month | $15 /month | $25 /month | $49 /month |
| Billed yearly, save 20% | $0 /year | $144 /year | $240 /year | $470 /year |
Questions
The things merchants ask before they install.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a Reporting worksheet. Pick what the rows are, such as vendors, product types, or markets, then choose a metric and a timeframe for each column. The cells fill with numbers calculated from your store's orders straight away.
Net Sales, gross sales, total sales, order count, average order value, net quantity sold, discounts, refunds, returns, taxes, shipping, duties, cost of goods sold, gross profit, net profit, and gross margin, plus inventory metrics such as closing stock, sell-through rate, and dead stock.
No. The numbers update as your store changes, so the spreadsheet is current whenever you open it.
Yes. Each column carries its own timeframe, so the last 30 days, the previous month, and the calendar year can sit next to each other on one sheet, with your own formulas calculating the change between them.
Shopify's reports are tables you filter and adjust one report at a time. Mixtable calculates its own metrics from your store's order, product, and customer data and puts them into rows and columns you arrange yourself, so you can mix metrics and timeframes on one sheet, write formulas across them, and keep as many separate spreadsheets as you need.
Yes. The spreadsheet exports to a real .xlsx file, and the worksheet you are on exports to CSV, keeping the layout you built.
It's free while your store has fewer than 1,000 lifetime orders. After that, the price is matched to your Shopify plan: $15 per month on Basic, $25 on Grow and Advanced, and $49 on Shopify Plus, or save 20% by paying yearly. Every paid plan includes the same features and starts with a 7-day free trial. Development, trial, and non-profit stores use it free too.
No. There are 19 ready-made templates covering sales, products, customers, collections, markets, and returns. Each one is a starting point you can edit rather than a fixed report.
The other apps
Install Mixtable Analytics Spreadsheet on your Shopify store, pick a template, and watch the numbers fill in.