Use case for Mixtable Analytics Spreadsheet
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.
Sales by Customer - Acme Apparel From Shopify Trusted by thousands of Shopify stores
What you can do
Mixtable's reporting 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.
See what each customer is worth in profit: their Net Sales minus the estimated cost of what they bought, for all time or any period. The ready-made Customer lifetime value & orders worksheet sets it up for you.
Add supported analytics fields to a customers worksheet, so buying history sits next to the profiles you already manage. With Mixtable Spreadsheet Editor, edit those profiles in the same spreadsheet and sync the changes to Shopify.
Reporting worksheets cover supported metric and filter combinations. These are the core metrics for customer analysis.
In the spreadsheet
Top Customers - All time From Shopify Shopify's customer list stops at lifetime orders and amount spent. A spreadsheet adds average order value, refunds, and Net Sales for any period: sort by any of them, and your VIP list writes itself.
Guide: Rank your customers One Time Customers From Shopify 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.
Guide: One Time Customers template Sales by Customer Segment From Shopify 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.
Guide: Compare your segments Customer Buying Behavior From Shopify 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.
Guide: See buying patternsCompare
Shopify's customer list shows lifetime orders and amount spent. Here is how the options compare when you need more than lifetime totals across 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 | Lifetime totals only | 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.
Getting started
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.
Questions
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and create a spreadsheet 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 Spreadsheet Editor does that in the same spreadsheet, where changes are previewed and only sent when you sync to Shopify.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and see who actually carries your revenue.
