How to Use Product Category Mix Analysis in Squarespace: Step-by-Step Tutorial

Introduction to Product Category Mix Analysis

Understanding which product categories drive the most revenue is fundamental to running a successful e-commerce business on Squarespace. Product category mix analysis helps you answer critical questions: Are you over-investing in low-performing categories? Should you expand your bestselling lines? Is your inventory allocation aligned with customer demand?

Unlike simple sales reports that show total revenue, product category mix analysis reveals the underlying patterns in your business. It identifies which categories contribute disproportionately to your bottom line, which ones have the highest profit margins, and where you should focus your marketing efforts. This analytical approach transforms raw sales data into actionable insights that directly impact your profitability.

In this comprehensive tutorial, you'll learn how to perform a complete product category mix analysis for your Squarespace store. We'll walk through data extraction, preparation, analysis, and interpretation—giving you the knowledge to make confident, data-driven decisions about your product portfolio.

Prerequisites and Data Requirements

What You'll Need Before Starting

Before beginning your product category mix analysis, ensure you have the following:

• Squarespace Commerce Account: You need an active Squarespace Commerce plan (Business or Commerce) with order history
• Administrator Access: Full admin permissions to access your Squarespace analytics and export order data
• Minimum Data History: At least 3 months of order data for meaningful analysis (6-12 months recommended)
• Product Categories: Your products should be organized into clear categories within Squarespace
• Analysis Tool: Access to MCP Analytics Product Category Mix tool

Data Quality Checklist

For accurate analysis results, verify that your Squarespace data meets these quality standards:

• All products are assigned to appropriate categories (no "uncategorized" items)
• Category names are consistent (avoid duplicates like "Accessories" and "accessories")
• Product costs are accurately recorded for profit margin calculations
• Test orders and cancelled transactions are properly marked
• Currency is consistent across all transactions

Step-by-Step Analysis Process

Step 1: Export Your Squarespace Order Data

The first step is extracting your complete order history from Squarespace. This data forms the foundation of your category mix analysis.

1. Log into your Squarespace account and navigate to Commerce → Orders
2. Click the Export button in the upper right corner
3. Select your date range (recommended: last 12 months for trend analysis)
4. Choose CSV format for maximum compatibility
5. Ensure "Include all order details" is selected
6. Click Export Orders and download the file

Expected Output: You'll receive a CSV file named something like squarespace-orders-2024-01-01-to-2024-12-31.csv. The file should contain columns including Order Number, Date, Product Name, Category, Quantity, Price, Total, and Customer Information.

Order Number,Date,Product Name,Category,Quantity,Unit Price,Line Total,Order Total
#1001,2024-01-15,Leather Wallet,Accessories,1,45.00,45.00,45.00
#1002,2024-01-15,Cotton T-Shirt,Apparel,2,25.00,50.00,75.00
#1002,2024-01-15,Baseball Cap,Accessories,1,25.00,25.00,75.00
#1003,2024-01-16,Yoga Mat,Fitness,1,65.00,65.00,65.00

Step 2: Prepare Your Data for Analysis

Raw export data often requires cleaning and structuring before analysis. This step ensures accuracy and prevents misinterpretation of results.

Data Cleaning Checklist:

1. Remove Test Orders: Filter out any test transactions or cancelled orders
2. Standardize Categories: Check for inconsistent category naming (e.g., "T-Shirts" vs "T-shirts")
3. Handle Multi-Category Orders: Ensure line items are properly attributed to their respective categories
4. Verify Currency Consistency: If you sell internationally, ensure all values are in the same currency
5. Check for Missing Values: Identify and address any blank category fields

import pandas as pd

# Load your exported data
df = pd.read_csv('squarespace-orders.csv')

# Check for missing categories
missing_categories = df[df['Category'].isna()]
print(f"Orders with missing categories: {len(missing_categories)}")

# Identify unique categories
unique_cats = df['Category'].unique()
print(f"Total categories found: {len(unique_cats)}")
print("Categories:", sorted(unique_cats))

# Check date range
df['Date'] = pd.to_datetime(df['Date'])
print(f"Date range: {df['Date'].min()} to {df['Date'].max()}")

Expected Output: After validation, you should see a summary showing 0 missing categories, a list of all your category names, and confirmation of your date range. Address any issues before proceeding to analysis.

Step 3: Run Product Category Mix Analysis

Now you're ready to perform the actual analysis using the MCP Analytics platform. This automated analysis will calculate key metrics across all your product categories.

1. Navigate to the Product Category Mix Analysis tool
2. Upload your cleaned CSV file from Step 2
3. Map the required fields:
   • Order Date → Date column
   • Product Category → Category column
   • Revenue → Line Total or appropriate revenue column
   • Quantity → Quantity column
4. Configure analysis settings:
   • Select time period granularity (monthly recommended)
   • Choose whether to include returns/refunds
   • Set minimum order threshold if desired
5. Click Run Analysis

Processing Time: Analysis typically completes in 30-60 seconds for most Squarespace stores (up to 50,000 orders). You'll see a progress indicator while the system processes your data.

Step 4: Interpret Your Results

The analysis generates multiple visualizations and metrics. Understanding each component is crucial for making informed decisions.

Key Metrics to Review:

1. Revenue Contribution by Category

This shows what percentage of total revenue each category generates. Look for your "power categories" that drive the bulk of revenue.

Category          Revenue      % of Total    Orders    Avg Order Value
Apparel           $125,400     41.2%        890       $140.90
Accessories       $78,200      25.7%        1,240     $63.06
Fitness           $52,100      17.1%        420       $124.05
Home Goods        $31,800      10.4%        310       $102.58
Gift Cards        $16,500      5.4%         165       $100.00

Interpretation: In this example, Apparel dominates with 41.2% of revenue despite having fewer orders than Accessories. This suggests higher-value transactions and indicates Apparel should remain a core focus.

2. Category Performance Trends

Time-series analysis reveals whether categories are growing, stable, or declining. This helps you identify emerging opportunities and fading product lines.

What to Look For:

• Consistent Growth: Categories showing steady month-over-month increases deserve more investment
• Seasonal Patterns: Understanding seasonal fluctuations helps with inventory planning
• Declining Trends: Persistent downward trends may signal market saturation or changing customer preferences

3. Profit Margin Analysis (If Cost Data Available)

Revenue alone doesn't tell the full story. Profit margins reveal which categories are most valuable to your business after accounting for costs.

4. Category Concentration Risk

The analysis calculates a Herfindahl-Hirschman Index (HHI) to measure how concentrated your revenue is across categories. Values closer to 1.0 indicate higher concentration (more risky), while values closer to 0 indicate better diversification.

• HHI below 0.15: Well-diversified product mix with low concentration risk
• HHI 0.15-0.25: Moderate concentration, typical for focused stores
• HHI above 0.25: High concentration, consider diversifying to reduce risk

Step 5: Make Data-Driven Product Mix Decisions

Now comes the most important part: translating insights into action. Here's how to apply your analysis results to optimize your Squarespace store.

Decision Framework:

For High-Performing Categories (Top 20% by Revenue)

• Expand Product Selection: Add complementary products within these successful categories
• Increase Inventory Depth: Stock more units of bestsellers to avoid stockouts
• Prioritize Marketing: Allocate more ad spend to promoting these categories
• Create Bundles: Package related items to increase average order value
• Optimize Pricing: Test price increases on strong performers to maximize margin

For Mid-Tier Categories (Middle 60% by Revenue)

• Test and Learn: Experiment with new products to find potential stars
• Cross-Promote: Feature these alongside bestsellers to boost visibility
• Analyze Customer Overlap: See if buyers of top categories also purchase these items
• Optimize Product Pages: Improve descriptions, images, and SEO for better conversion

For Low-Performing Categories (Bottom 20% by Revenue)

• Evaluate Strategic Value: Do they drive traffic or serve as entry-point products?
• Consider Discontinuation: If profit margins are low and they don't support other goals, phase them out
• Clearance Strategy: Liquidate slow-moving inventory to free up capital
• Reposition or Rebrand: Sometimes poor performance stems from positioning, not product quality

Category      Revenue %   Profit Margin   Growth Trend   Action
Apparel       41.2%      32%            +15% YoY       EXPAND - Add 10 new SKUs
Accessories   25.7%      28%            +5% YoY        MAINTAIN - Optimize existing
Fitness       17.1%      35%            +25% YoY       INVEST - Increase ad spend
Home Goods    10.4%      18%            -5% YoY        REVIEW - Test promotions
Gift Cards    5.4%       5%             Flat           KEEP - Drives new customers

Step 6: Verify Your Changes

After implementing product mix adjustments, establish a monitoring system to track their impact. This creates a continuous improvement loop for your business.

Verification Checklist:

1. Set Baseline Metrics: Record current performance before making changes
2. Define Success Criteria: What metrics will improve if your decisions are correct?
3. Establish Timeline: Give changes 4-8 weeks to show measurable impact
4. Re-run Analysis: Use the same category mix analysis service after your test period
5. Compare Results: Did revenue distribution shift as expected? Did profitability improve?

Expected Outcomes: Successful product mix optimization typically shows a 10-25% increase in revenue from expanded categories within 3 months, along with improved overall profit margins from reducing low-performing SKUs.

Ready to Optimize Your Product Mix?

Stop guessing which product categories deserve your investment. Get instant, data-driven insights into your Squarespace store's category performance with MCP Analytics.

Our Product Category Mix Analysis tool provides:

• Automated revenue contribution analysis across all categories
• Profit margin calculations by category
• Trend identification and seasonal pattern detection
• Concentration risk assessment
• Actionable recommendations for portfolio optimization

Analyze Your Product Categories Now →

No credit card required. Get results in under 60 seconds.

Common Issues and Solutions

Issue 1: "Category Field is Empty or Missing"

Symptom: Analysis fails or shows errors about missing category data.

Cause: Some products in your Squarespace store aren't assigned to categories.

Solution:

1. Go to Commerce → Inventory in Squarespace
2. Filter for products without categories
3. Assign appropriate categories to all uncategorized products
4. Wait 24 hours for changes to propagate to order exports
5. Re-export your data and run analysis again

Issue 2: "Too Few Data Points for Meaningful Analysis"

Symptom: Warning message about insufficient data or unreliable results.

Cause: Your store is new or has very low order volume (fewer than 50 orders).

Solution:

• Extend your date range to capture more historical data
• If truly limited data exists, consider this directional guidance rather than definitive analysis
• Re-run analysis monthly as more data accumulates
• For very new stores, focus on overall sales trends before diving into category analysis

Issue 3: "Inconsistent Category Names Detected"

Symptom: Analysis shows duplicate-looking categories like "Apparel," "apparel," and "APPAREL" as separate entities.

Cause: Category naming inconsistencies in Squarespace or during data export.

Solution:

1. Open your CSV file in a spreadsheet program
2. Use Find & Replace to standardize category names (capitalize consistently)
3. Create a category mapping document for future reference
4. In Squarespace, standardize category names to prevent future issues

Issue 4: "Revenue Numbers Don't Match Squarespace Dashboard"

Symptom: Total revenue in analysis differs from Squarespace's built-in reports.

Cause: Different handling of refunds, taxes, or shipping fees.

Solution:

• Verify date ranges match exactly between Squarespace and your analysis
• Check whether your export includes or excludes refunded orders
• Ensure you're comparing like-to-like (e.g., gross revenue vs. net revenue)
• Review your field mapping—ensure you selected the correct revenue column

Issue 5: "Analysis Shows Extreme Seasonality"

Symptom: Category performance fluctuates wildly month-to-month.

Cause: This might not be an issue—many categories have genuine seasonal patterns.

Solution:

• Compare year-over-year data rather than month-to-month to account for seasonality
• Use moving averages (3-month or 6-month) to smooth out fluctuations
• Adjust inventory and marketing strategies to align with seasonal demand
• Consider statistical significance testing, as covered in our A/B testing guide, to distinguish real trends from random variation

Next Steps with Squarespace Analytics

Product category mix analysis is just the beginning of optimizing your Squarespace store with data. Here are recommended next steps to deepen your analytical capabilities:

1. Customer Segmentation Analysis

Now that you understand which categories perform best, discover which customer segments prefer which categories. This enables targeted marketing campaigns and personalized product recommendations.

2. Time-Series Forecasting

Build on your category trends to forecast future demand. This improves inventory planning and helps you avoid both stockouts and overstock situations. Learn more about time-based analytical approaches in our Accelerated Failure Time (AFT) guide.

3. Cohort Analysis

Track how customer behavior evolves over time. Do first-time buyers in certain categories have higher repeat purchase rates? Understanding these patterns refines your customer acquisition strategy.

4. Advanced Predictive Analytics

Apply machine learning techniques to predict which new products will succeed, which customers are at risk of churning, and how to optimize pricing. Our article on AdaBoost for data-driven decisions provides an introduction to ensemble methods for prediction.

5. Automated Analysis Pipelines

Manual monthly analysis works initially, but as your business grows, automation becomes essential. Explore AI-first data analysis pipelines to streamline your analytics workflow and get insights in real-time.

Recommended Analysis Frequency

• Monthly: Run full category mix analysis to track trends and adjust strategy
• Quarterly: Deep-dive review including profit margins and competitive positioning
• Annually: Strategic portfolio review with consideration of major additions or eliminations

By making analytics a regular part of your business operations, you'll develop an intuitive understanding of what drives performance and be able to act quickly when opportunities or challenges arise.

Conclusion

Product category mix analysis transforms how you make decisions about your Squarespace store. Instead of relying on intuition or anecdotal evidence, you now have a systematic, data-driven approach to understanding what's working and where to invest your resources.

The process—export, prepare, analyze, interpret, act, verify—creates a virtuous cycle of continuous improvement. Each analysis builds on the last, deepening your understanding of your business and your customers.

Remember that analysis without action is just interesting data. The real value comes from implementing changes based on your insights and measuring their impact. Start small, test your assumptions, and scale what works.

Ready to take control of your product strategy? Start your product category mix analysis now and discover which categories deserve more of your attention—and which ones might be holding you back.