Analytics metrics
Build Pivot Table and Time Series reports from your Shopify data, add analytics columns, and understand every metric Mixtable can calculate.
Analytics > Getting Started
Shopify Analytics Overview
Analyze Shopify sales, orders, refunds, customers, and fulfillment with analytics columns, Time Series worksheets, and Pivot Table worksheets in Mixtable.
›
Add Analytics Columns
Add Shopify sales, order, refund, customer, and profitability metrics beside live product, variant, collection, customer, and B2B data.
›
Ready-Made Analytics Reports
Choose a ready-made Shopify analytics report for vendors, markets, categories, tags, customers, fulfillment, returns, margins, and collections.
›
Reporting Templates
Create prebuilt Shopify reporting spreadsheets for product sales, customers, vendors, markets, categories, tags, fulfillment, and returns.
›
Analytics Timeframes
Choose All time, fixed dates, rolling periods, calendar months, calendar years, and monthly or yearly Shopify analytics windows in Mixtable.
›
Filter Analytics Reports
Filter Shopify analytics by customer segment, country, discount, B2B company, channel, attribution, fulfillment, returns, market, and more.
›
Analytics Metrics Reference
Understand Shopify sales, order, refund, discount, profit, customer, attribution, fulfillment, and return metrics available in Mixtable.
›
Analytics > Reporting
Pivot Table Worksheets
Build a Pivot Table worksheet from your Shopify data by vendor, product type, category, tag, market, or customer segment with sales and refund metrics.
›
Time Series Worksheets
Track Shopify sales, orders, refunds, quantities, and average order value by month or year with a customizable Time Series worksheet.
›
Analytics > Sales Analytics
Net Sales Analytics
Track Shopify Net Sales after discounts and returns by product, vendor, collection, market, or customer segment with Mixtable Analytics Spreadsheet.
›
Gross Sales Analytics
Measure Shopify Gross Sales before discounts and returns by product, vendor, collection, market, or customer segment with Mixtable Analytics Spreadsheet.
›
Total Sales Analytics
Calculate Shopify Total Sales including Net Sales, tax, shipping, duties, and additional fees by customer, company, location, market, or store.
›
Net Quantity Sold Analytics
Track Shopify Net Quantity Sold after returns by product, variant, collection, vendor, market, and more using Mixtable analytics reports.
›
Gross Quantity Sold Analytics
Track Shopify Gross Quantity Sold by product, variant, collection, vendor, market, and more using Mixtable analytics columns and Pivot Table worksheets.
›
Profit, Margin, and COGS
Calculate Shopify variant Gross Profit, Gross Margin, Cost of Goods Sold, Orders Net Profit, sales, and quantities with Mixtable analytics.
›
Shopify Product Analytics
Analyze Shopify product sales, orders, quantities, refunds, returns, discounts, categories, vendors, and trends with Mixtable spreadsheets.
›
Product Variant Analytics
Compare Shopify variant sales, quantities, refunds, profit, margin, cost, and inventory side by side in a live analytics spreadsheet.
›
Sales by Product Attributes
Compare Shopify sales by vendor, product type, standardized product category, tag, and collection with Pivot Table worksheets and Time Series worksheets.
›
Shopify Markets Analytics
Compare Shopify Market sales, orders, refunds, discounts, quantities, and average order value with Pivot Table worksheets and Time Series worksheets.
›
Customer Country Analytics
Calculate Shopify sales, orders, quantities, discounts, and refunds for a selected customer country with Mixtable Analytics Spreadsheet.
›
Analytics > Order Analytics
Orders Count Analytics
Count Shopify orders by product, customer, vendor, collection, market, or segment, using analytics columns, Pivot Tables, and Time Series worksheets.
›
Average Order Value Analytics
Calculate Shopify Average Order Value by customer, company, market, segment, vendor, product type, marketing channel, month, or year.
›
Tax, Shipping, Duties, and Fees
Analyze Shopify tax, shipping, duties, and additional fees by customer, B2B company, location, market, month, year, and other supported reports.
›
Orders Net Profit Analytics
Calculate Shopify Orders Net Profit per product variant using cost per item and net quantity sold with Mixtable Analytics Spreadsheet.
›
Analytics > Customer Analytics
Customer Analytics
Analyze Shopify customer lifetime value, orders, sales, refunds, product interests, segments, attribution, and returns with Mixtable Analytics.
›
Customer Segment Analytics
Compare Shopify customer segments by sales, orders, refunds, discounts, and average order value using Mixtable Pivot Table and Time Series worksheets.
›
Analytics > Collection Analytics
Collection Analytics
Compare Shopify collection sales, orders, quantities, discounts, refunds, and refund rates with a Collections worksheet and analytics columns in Mixtable.
›
Analytics > Refund Analytics
Total Refund Amount Analytics
Measure Shopify refund amounts excluding tax by product, customer, vendor, collection, market, and more using Mixtable analytics reports.
›
Refund Count Analytics
Count distinct Shopify orders with refunds by product, variant, collection, vendor, market, and more using Mixtable analytics reports.
›
Percent of Orders Refunded Analytics
Measure the percentage of Shopify orders refunded by product, variant, collection, vendor, or market with Mixtable Pivot Tables and analytics columns.
›
Refunded Quantity Analytics
Measure Shopify refunded units by product, variant, collection, company, customer, vendor, category, tag, market, or segment with a spreadsheet.
›
Analytics > Return Analytics
Return Request Analytics
Analyze Shopify return requests, return rates, returned quantities, reasons, open returns, refunds, and time to close with a spreadsheet.
›
Analytics > Discount Analytics
Total Discount Amount Analytics
Measure Shopify discount amounts by product, vendor, collection, market, customer segment, or parent campaign using Mixtable analytics reports.
›
Analytics > Fulfillment Analytics
Fulfillment and Delivery Analytics
Measure Shopify fulfillment volume, fulfilled quantity, time to first fulfillment, delivery speed, carrier, service, and location performance.
›
Analytics > Marketing Attribution
Marketing Attribution Analytics
Analyze Shopify first-touch and last-touch sources, landing pages, referrers, UTM campaigns, attribution coverage, and conversion time.
›
Analytics > B2B Analytics
Shopify B2B Sales Analytics
Analyze Shopify B2B company and company-location sales, orders, quantities, refunds, duties, fees, shipping, tax, and average order value.
›
Can't find what you need?
We read every email. Real merchants, real answers, usually the same day.