Use case for Mixtable Analytics Spreadsheet
Compare your online store, Shopify POS, draft orders, and every sales channel in a live spreadsheet fed by your store. Net sales, orders, and average order value per channel, down to individual retail locations.
Sales by Channel - Acme Apparel From Shopify Trusted by thousands of Shopify stores
What you can do
Mixtable's reporting worksheets compute supported sales metrics for a single channel, so each channel becomes a row you can sort, compare, and build on.
Net sales, gross sales, orders, quantity sold, average order value, discounts, and refunds, computed for one channel at a time.
Split sales between your online store, Shopify POS, and draft orders, the three ways most orders arrive.
Filter by the app or sales channel that created the order, or by the Shopify publication tied to it.
Filter POS sales down to a single retail location, and compare stores the way you compare products.
Use order tags and customer tags as filters, so wholesale, influencer, or campaign orders act like channels of their own.
Put channels in rows, periods in columns, and add share-of-total or growth formulas on top, like any spreadsheet.
Reporting worksheets cover supported metric and filter combinations. These are the core dimensions for channel analysis.
In the spreadsheet
Source Split - June From Shopify Stores that sell in more than one way rarely see the split clearly. Filtering sales metrics by order source puts your online store, Shopify POS, and manually created draft orders side by side, with the same metrics computed the same way for each.
Guide: General Shopify order filters App Channels - Q2 From Shopify Shop, Buy Button, Facebook & Instagram, marketplaces: every channel that creates orders shows up in your data. Filter sales by the order's app or publication and each one gets its own honest number, instead of blending into the total.
Guide: Filter by order app and publication POS Locations - June From Shopify If you run physical stores, each location deserves its own row. The retail location filter computes supported sales metrics for a single POS location, so the downtown store and the mall store stop sharing one blurry number.
Guide: Filter by retail location Tagged Segments - Q2 From Shopify Not every channel is official. Wholesale deals, influencer codes, corporate gifting: if you tag those orders or customers, Mixtable can treat each tag as a channel, with the same metrics as the real ones.
Guide: Filter Shopify analytics reportsCompare
Channel questions usually end in a spreadsheet anyway. Here is how the ways of getting there compare.
| Analysis task | Mixtable | Shopify analytics | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Sales split by online store, POS, and drafts | Yes, in a live sheet | Yes, in reports | Manual pivot work | Yes, after setup |
| Per-app and per-publication numbers | Yes, as filters | Partially | Manual joins | Yes, after modeling |
| Per retail location POS metrics | Yes | Yes | Manual joins | Yes, after modeling |
| Order and customer tags as dimensions | Yes, as filters | Limited | Manual parsing | Yes, after modeling |
| Share-of-total and growth formulas | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Stays current without re-exporting | Yes, dynamic ranges | Yes | No | Yes, via pipelines |
| Setup time | Minutes | None | Every single time | Days to weeks |
Comparison reflects typical channel analysis workflows. Mixtable analytics covers supported metric and filter combinations.
Getting started
No exports, no pipelines. Build the split once and it keeps itself current.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
Start with net sales, orders, and average order value at store level.
Create one metric per channel: order source, app, publication, or retail location.
Channels as rows, periods as columns, and share or growth formulas where you need them.
Use rolling date ranges for living views, and export to Excel or CSV when someone needs the file.
Questions
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and create sales metrics filtered by order source, app, publication, or retail location. Each channel becomes a row with net sales, orders, and average order value, live from your store.
Yes. The order source filter separates your online store, Shopify POS, and draft orders, so each gets the same metrics computed the same way.
Yes. The retail location filter narrows POS metrics to a single location, so you can rank stores, watch a new one ramp, and compare seasons per location.
Yes. Filter metrics by the app that created the order or by the Shopify publication tied to it, and every sales channel, from Shop to Buy Button, gets its own number.
Yes. Order tag and customer tag filters let a tag like wholesale or influencer act as a channel, with the same sales metrics as the official ones.
Yes. The order type filter splits B2B and B2C orders, and there is a dedicated B2B sales analytics view if you sell to companies with Shopify B2B.
Yes. Use rolling date ranges like last 30 days or last month and the numbers keep themselves current. Fixed ranges stay frozen for reporting.
Yes, and they complement each other. Channels answer how orders were placed: online store, POS, apps. Markets answer where they came from. Mixtable has a separate Markets sales view for the geographic split.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and see what each channel really contributes.
