Skip to content

Analytics metrics

Build Pivot Table and Time Series reports from your Shopify data, add analytics columns, and understand every metric Mixtable can calculate.

Getting Started

7 guides

Shopify Analytics OverviewAnalyze Shopify sales, orders, refunds, customers, and fulfillment with analytics columns, Time Series worksheets, and Pivot Table worksheets in Mixtable.
Add Analytics ColumnsAdd Shopify sales, order, refund, customer, and profitability metrics beside live product, variant, collection, customer, and B2B data.
Ready-Made Analytics ReportsChoose a ready-made Shopify analytics report for vendors, markets, categories, tags, customers, fulfillment, returns, margins, and collections.
Reporting TemplatesCreate prebuilt Shopify reporting spreadsheets for product sales, customers, vendors, markets, categories, tags, fulfillment, and returns.
Analytics TimeframesChoose All time, fixed dates, rolling periods, calendar months, calendar years, and daily, weekly, monthly, or yearly Shopify analytics windows in Mixtable.
Filter Analytics ReportsFilter Shopify analytics by customer segment, country, discount, B2B company, channel, attribution, fulfillment, returns, stock location, and more.
Analytics Metrics ReferenceUnderstand Shopify sales, order, refund, discount, profit, customer, attribution, fulfillment, and return metrics available in Mixtable.

Reporting

2 guides

Sales Analytics

11 guides

Order Analytics

4 guides

Customer Analytics

2 guides

Collection Analytics

1 guide

Collection AnalyticsCompare Shopify collection sales, orders, quantities, discounts, refunds, and refund rates with a Collections worksheet and analytics columns in Mixtable.

Refund Analytics

4 guides

Return Analytics

1 guide

Return Request AnalyticsAnalyze Shopify return requests, return rates, returned quantities, reasons, open returns, refunds, and time to close with a spreadsheet.

Discount Analytics

1 guide

Total Discount Amount AnalyticsMeasure Shopify discount amounts by product, vendor, collection, market, customer segment, or parent campaign using Mixtable analytics reports.

Fulfillment Analytics

1 guide

Fulfillment and Delivery AnalyticsMeasure Shopify fulfillment volume, fulfilled quantity, time to first fulfillment, delivery speed, carrier, service, and location performance.

Marketing Attribution

1 guide

Marketing Attribution AnalyticsAnalyze Shopify first-touch and last-touch sources, landing pages, referrers, UTM campaigns, attribution coverage, and conversion time.

B2B Analytics

1 guide

Shopify B2B Sales AnalyticsAnalyze Shopify B2B company and company-location sales, orders, quantities, refunds, duties, fees, shipping, tax, and average order value.

Related topics

Templates28 guides Customers & orders17 guides Import & export14 guides

Can't find what you need?

We read every email. Real merchants, real answers, usually the same day.

Email [email protected]

Most replies in under 4 hours, Monday to Friday
Screen shares for tricky setups, on request
Free plans get the same answers
You can also message us from inside the app