If you run an e-commerce store, you're probably checking your Shopify or WooCommerce dashboard daily. But a dashboard inside your store platform only shows you what happened — it doesn't let you compare periods, build custom segments, or layer in data from other sources like your ad spend. An e-commerce performance report in Google Sheets gives you all of that.
The Metrics That Matter
Before building anything, decide which metrics belong in your report. The core e-commerce metrics most stores track: total revenue, number of orders, average order value (AOV), conversion rate, return rate, and revenue by product or category.
Secondary metrics that add context: revenue by traffic source, repeat vs. new customer split, and cart abandonment rate.
Importing Order Data
Export your order data from your store platform — most support CSV export with date, order ID, customer, products, quantities, revenue, and traffic source. Paste this into a raw data sheet in Google Sheets. One row per order.
For recurring reporting, consider using the IMPORTDATA function if your platform provides a CSV URL, or Google Sheets add-ons that connect directly to your store.
Calculating Key Metrics
Total Revenue for the period: SUMIFS filtered by date range.
Number of Orders: COUNTIFS filtered by date range.
Average Order Value:
=SUMIFS(Revenue, Date, ">="&StartDate, Date, "<="&EndDate) / COUNTIFS(Date, ">="&StartDate, Date, "<="&EndDate)
This gives you AOV for any date range by changing the start and end dates.
Revenue by Product
Build a pivot table from your order data. Add Product to Rows and Revenue to Values (SUM). Sort descending by revenue to see your top products immediately. Add a % of Total column:
=B2/SUM($B$2:$B$100)
Format as percentage. This tells you how concentrated your revenue is — if 80% comes from 3 products, that's a concentration risk worth knowing.
Period-over-Period Comparison
Add columns for This Period and Last Period for each metric. Calculate change:
=(C2-B2)/B2
Format as percentage. Apply conditional formatting — green for positive revenue movement, red for negative. This is the view you check weekly.
The Easy Way: Using SheetXAI in Google Sheets
Example 1: You have order export data already in the spreadsheet.
"I have a Shopify order export on Sheet 1 with order date, product, revenue, and traffic source. Build a performance report showing total revenue, orders, AOV, revenue by product, and week-over-week comparison with conditional formatting."
SheetXAI reads your order data, calculates all metrics, builds the product breakdown, and adds the period comparison.
Example 2: Your store data lives in Shopify or WooCommerce.
"Connect to our Shopify store and build a monthly performance report showing revenue, orders, AOV, top 10 products, and revenue by traffic source, compared to last month."
SheetXAI connects to Shopify, pulls the data, and builds the full e-commerce report.
Try SheetXAI free and see what it builds for you.
Published May 2026. See also: How to Track Ad Spend Across Google and Meta in Google Sheets, How to Build a KPI Dashboard in Google Sheets, and Google Sheets AI Guide.
