How do I export my product performance data to analyze it further?

Exporting and Analyzing Product Performance Data

Shopify's built-in analytics gives you a solid overview, but product-level analysis often requires exporting data to work with it more flexibly - building custom views, comparing periods, or combining with other data sources like ad spend or inventory costs.

Shopify Export Methods

CSV Export Steps for Product Performance

1. Admin > Analytics > Reports
2. Select "Products" in the report category
3. Set your date range (recommend 90-day or 12-month view)
4. Click "Export" (top right) - choose CSV for current view
5. Open in Google Sheets or Excel for pivot table analysis

Key Analysis to Run on Exported Data

• Revenue concentration: What % of revenue comes from your top 20% of products? (Pareto principle often applies)
• Velocity by product: Units sold per week - is velocity accelerating or declining?
• AOV by product category: Which categories drive higher basket sizes?
• Discount rate by product: Which products are most often sold with a code?

Combining with Cost Data for Profitability

Export data shows revenue and units. To find profitability, you need to add COGS (cost of goods sold) and ad spend per product. Build a simple Google Sheets template with columns: Product, Units Sold, Revenue, COGS, Gross Profit, Ad Spend, Net Profit. This gives you the true picture of which products to scale and which to phase out.