See order count, total spend, average order value, refunds, and the segments each customer belongs to, in a live spreadsheet fed by your Shopify store. Find your best customers, your one-time buyers, and the signups who never ordered.
Mixtable's analytical worksheets load your customers as rows with buying metrics as columns. Start from templates, filter by segment or country, and keep working the numbers with formulas.
Order count, total spend, net and gross sales, average order value, discounts, and refunds, next to each customer's name and email.
Start from Sales by Customer, One Time Customers, Customers with No Orders, or Sales by Customer Segments.
Product categories bought, product types bought, and the Shopify segments each customer belongs to, as spreadsheet columns.
Limit any metric to a Shopify customer segment, a customer country, or customers with at least one order.
Sort by any metric, then add your own columns, like spend share or a repeat-buyer flag, the way you would in any spreadsheet.
Add supported analytics fields to a customers worksheet, so buying history sits next to the profiles you already manage.
Shopify shows you one customer at a time. A spreadsheet shows you all of them at once: sort by total spend or order count, and your VIP list writes itself.
Two lists hold most of your retention upside: customers who bought exactly once, and accounts that never bought at all. Mixtable has a template for each, so both lists stay current instead of living in a stale export.
Your Shopify segments already group customers the way you think about them. The Sales by Customer Segments template turns each segment into a row with sales metrics as columns, and country filters do the same for geography.
Spend tells you who matters, categories tell you why. Columns for product categories and product types bought per customer show what each person comes back for, so campaigns and merchandising decisions start from behavior, not guesses.
Analytical worksheets cover supported metric and filter combinations. These are the core metrics for customer analysis.
Shopify's admin answers questions about one customer at a time. Here is how the options compare when the question spans your whole customer base.
| Analysis task | Mixtable | Shopify admin | Exporting to Excel | CRM tools |
|---|---|---|---|---|
| Spend and order metrics for every customer | Yes, in a live sheet | One profile at a time | Stale the moment you export | Yes, after integration |
| Rank customers by any metric | Yes, sort any column | Limited | Yes, manually | Depends on plan |
| One-time buyers and no-order signups as living lists | Yes, templates | Via segment queries | No, re-export each time | Sometimes |
| Sales metrics per Shopify segment | Yes, one row per segment | Counts, not sales | Manual joins | Own segment model |
| Add your own formulas to the numbers | Yes, it is a spreadsheet | No | Yes, manually | Rarely |
| Numbers beside editable customer records | Yes, same spreadsheet | No | No | No |
| Setup time | Minutes, from templates | None | Every single time | Days to weeks |
Comparison reflects typical customer analysis workflows. Mixtable analytics covers supported metric and filter combinations.
No exports, no pipelines. Pick a template and start asking questions.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
Start from Sales by Customer, One Time Customers, Customers with No Orders, or Sales by Customer Segments.
Choose all time, a fixed period for a report, or a rolling window like last 30 days for a living view.
Limit metrics by customer segment or country, and compare the groups that matter to you.
Sort, add formula columns, and export to Excel or CSV when your email tool needs a list.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and create an analytical worksheet from a template like Sales by Customer. Your customers load as rows with order count, total spend, average order value, and refunds as columns, live from your store.
Yes. Order count, total spend, net sales, gross sales, discounts, and refund amounts are available per customer, over all time or any date range you pick.
Yes. The One Time Customers template lists every customer with exactly one order, together with their email and order total, and the list updates as customers place new orders.
Yes. The Customers with No Orders template filters your customer list down to signups without a single purchase, so you have a ready-made conversion campaign list.
Yes. The Sales by Customer Segments template gives each segment a row with order count, gross and net sales, discounts, refunds, and average order value, using the segments you already defined in Shopify.
Yes. Columns for product categories bought and product types bought show what each customer comes back for, beside their spend and order metrics.
Yes. Any worksheet exports to Excel or CSV, so you can hand a ranked VIP list or a win-back list to your email tool whenever you need it.
No. Analytics columns are read-only analysis views. If you also want to edit customer records, Mixtable does that in regular worksheets, where changes are previewed and only sent when you sync to Shopify.
Open Mixtable for your store and see who actually carries your revenue.
