Analytics metrics

Analyze Shopify sales and order data in a live spreadsheet with Mixtable. Sync orders, use Excel formulas, and access pre-calculated analytics per product and variant.

Analyze Shopify Net Sales per product in Mixtable. Choose between cash basis (matching Shopify's own reports) or accrual basis (for accounting) and track revenue after discounts and returns for any date range.

Track Shopify store performance for the last 30 days in a live spreadsheet. Monitor sales, orders, refunds, and discounts in real time with Mixtable Analytics.

Analyze Shopify Gross Sales per product in Mixtable. Track total revenue before deductions across any date range, updated in real time.

Track Shopify Gross Quantity Sold (total units sold) per product in Mixtable Analytics. Updated dynamically for any date range you choose.

Track Shopify Net Quantity Sold per product in Mixtable Analytics. Total units sold minus returns, dynamically updated for any date range.

Analyze Shopify product variant performance in Mixtable. Track net sales, profit, orders, refunds, and discounts per variant in a live spreadsheet.

Track Shopify sales for the last 30 rolling days in Mixtable Analytics. Net and gross sales per product, recalculated daily and updated in real time.

View Shopify sales for last month in Mixtable Analytics. Net and gross sales per product covering the full previous calendar month, updated dynamically.

Analyze last year's Shopify sales by product, variant, and collection in Mixtable. Track net and gross sales in a live spreadsheet that auto-updates from your store.

Track Shopify sales, orders, refunds, and discounts by customer country with Mixtable Analytics. Compare multiple markets side by side in a live spreadsheet.

Export Shopify refund report data to CSV or Excel using Mixtable. Sync refund details to a live spreadsheet and download anytime.

Track the Shopify Percent of Orders Refunded per product in Mixtable Analytics. Monitor refund rates dynamically across any date range.

Track Shopify Refund Count per product in Mixtable Analytics. See how many orders were refunded for any date range to monitor store health.

Track Shopify total refund amounts by product, variant, and collection with Mixtable Analytics. Identify return patterns and reduce losses using a live spreadsheet.

Track Shopify refund totals for the last 30 rolling days in Mixtable. Automatically recalculated daily so your refund data is always current.

View Shopify refund totals for last month in Mixtable. Covers the full previous calendar month and updates dynamically as time moves forward.

Analyze Shopify refunds for last year in Mixtable. Pull refund count and total refund amount per product or collection from the previous year.

Track Shopify Orders Count per product or customer in Mixtable Analytics. Measure purchase frequency dynamically for any date range.

See Shopify order counts for the last 30 rolling days in Mixtable. Automatically recalculated daily so you always have current order data.

View Shopify order counts for last month in Mixtable. Data covers the full previous calendar month and updates dynamically as time moves forward.

Calculate Shopify Orders Net Profit per product in Mixtable. Subtract COGS from net sales to compare product profitability across any date range.

Analyze Shopify order counts for last year in Mixtable. Pull annual order data per product or collection and make data-driven decisions.

Analyze Shopify customer behavior with Mixtable. Track AOV, total sales, refunds, order count, and product categories bought per customer in a live spreadsheet.

Track Shopify customer segment performance with Mixtable Analytics. Measure sales, orders, discounts, and refunds per segment to improve targeting and retention.

Track Shopify total discount amounts by product, variant, and collection with Mixtable Analytics. Measure the real impact of your promotions in a live spreadsheet.

Track Shopify collection performance with Mixtable Analytics. View net sales, orders, refunds, and discounts per collection, filtered by country or customer segment.