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.
Mixtable's analytical 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, Shopify Market, customer segment, discount code, order tags, or B2B versus B2C.
Add growth formulas, targets, and variance columns on top of the metrics, then export to Excel or CSV for whoever needs the file.
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 always filled in.
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.
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.
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 Shopify Market, one customer segment, one discount code, or B2B orders only.
Analytical worksheets cover supported metric and filter combinations. These are the core store-level metrics.
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 filtered 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.
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, market, segment, discount code, or order type where you need detail.
Add growth and variance formulas, then export to Excel or CSV for whoever needs the file.
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.
Yes. Store metrics accept filters for order source, sales app, publication, POS retail location, Shopify Market, customer segment, customer country, discount code, order tags, and B2B versus B2C.
Yes. Analytical 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.
Open Mixtable for your store and stop rebuilding the same report every month.
