Use case for Mixtable Analytics Spreadsheet
Net sales, gross sales, orders, average order value, discounts, refunds, taxes, shipping, and duties for your whole store, laid out month by month in a spreadsheet that stays current. The monthly report you rebuild by hand, already built.
Monthly Store Performance - Acme Apparel From Shopify Trusted by thousands of Shopify stores
What you can do
Mixtable's reporting worksheets turn store-level Shopify sales data into rows and columns you can keep working with. Start from the Monthly Store Performance template and shape it from there.
Gross sales, discounts, refunds, net sales, taxes, shipping, duties, additional fees, and total sales, so your report reconciles instead of approximating.
Monthly Store Performance lays out thirteen store metrics across the last twelve months, one worksheet, zero setup.
Order count, average order value, and average items per order, gross and net, beside the revenue numbers.
Report on a fixed month or quarter, or keep living views like last 30 days, last 60 days, or last 6 months that update themselves.
Filter store metrics by sales channel, customer segment, discount code, order tags, or B2B versus B2C, or split them by Shopify Market.
Add growth formulas, targets, and variance columns on top of the metrics, then export to Excel or CSV for whoever needs the file.
Reporting worksheets cover supported metric and filter combinations. These are the core store-level metrics.
In the spreadsheet
Monthly Store Performance From Shopify Most stores rebuild the same report every month: pull the numbers, paste them into a sheet, fix the formulas. The Monthly Store Performance template is that sheet, fed directly by your store, with the last twelve months laid out when you create it.
Guide: Monthly Store Performance template June - Gross to Net From Shopify A single revenue number hides more than it shows. Mixtable keeps the components separate, gross sales, discounts, refunds, net sales, then taxes, shipping, duties, and fees on top, so you can see exactly why a month came in high or low.
Guide: See the definitions Sales - Last 30 Days From Shopify A report for last quarter should stay frozen. A view of the last 30 days should move every day. Mixtable supports both: fixed date ranges for reporting, rolling windows for monitoring, in the same spreadsheet.
Guide: Rolling and fixed timeframes June Net Sales - Slices From Shopify The store number is where questions start, not where they end. Filters let you compute supported store sales metrics for a slice: one sales channel, one customer segment, one discount code, or B2B orders only. Market rows in a Pivot Table worksheet split the same metrics by Shopify Market.
Guide: Filter analytics reportsCompare
Shopify's analytics answers the standard questions. Here is how the options compare when you need the numbers in a form you can keep working with.
| Reporting task | Mixtable | Shopify analytics | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Monthly store performance in one view | Yes, a template | Across several reports | Rebuilt by hand monthly | Yes, after setup |
| Gross, discounts, refunds, and net broken out | Yes, separate metrics | Yes | Manual math | Yes, after modeling |
| Add growth and variance formulas | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Rolling views like last 30 days | Yes, update themselves | Yes | No, re-export | Yes, via pipelines |
| Store totals by channel, market, or code | Yes, per metric | Some reports | Manual pivot work | Yes, after modeling |
| Company-wide BI across many data sources | No, by design | No | No | Yes, their core job |
| Setup time | Minutes, from templates | None | Every single time | Days to weeks |
Comparison reflects typical store reporting workflows. Mixtable analytics covers supported metric and filter combinations.
Getting started
No exports, no pipelines. Start from the template and shape it to your store.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
The template lays out thirteen store metrics across the last twelve months.
Keep the monthly layout, add fixed ranges for reports, or rolling windows like last 30 days.
Filter metrics by channel, segment, discount code, or order type, and split them by market where you need detail.
Add growth and variance formulas, then export to Excel or CSV for whoever needs the file.
Questions
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open the Monthly Store Performance template. Thirteen store-level metrics load across the last twelve months in a live worksheet, and you can reshape it with your own periods, filters, and formulas.
Net sales, gross sales, total sales, order count, average order value, average items per order, discounts, refunds, taxes, shipping, duties, and additional fees, all at store level and matching how Shopify defines them.
Yes. Rolling windows like last 30 days, last month, or last 6 months keep themselves current as time moves, while fixed date ranges stay frozen for month-end and quarter-end reporting. In the Monthly Store Performance template, the current month keeps filling in as orders arrive, and you add a column when a new month starts.
Yes. Store metrics accept filters for order source, sales app, publication, POS retail location, customer segment, customer country, discount code, order tags, and B2B versus B2C. For markets, a Pivot Table worksheet with Market rows gives each Shopify Market its own row.
Yes. Reporting worksheets behave like regular spreadsheets, so you can add month-over-month growth, variance against targets, or any other formula column on top of the metrics.
It complements them. Shopify's reports are great for standard questions. Mixtable puts the same store data in a spreadsheet, where you can reshape it, combine periods and slices, and keep your own calculations attached.
Store-level metrics cover sales, orders, discounts, refunds, taxes, shipping, duties, and fees. Cost-based profit and margin metrics are computed per product variant from your Shopify cost data, so profitability analysis lives in the product sales view.
Yes. Share the spreadsheet with teammates with per-worksheet permissions, or export any worksheet to Excel or CSV when someone just needs the file.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and stop rebuilding the same report every month.
