How to Use Order Value Distribution in Squarespace: Step-by-Step Tutorial

Category: Squarespace Analytics | Reading Time: 10 minutes

Introduction to Order Value Distribution

Understanding your order value distribution is one of the most powerful analytics exercises you can perform for your Squarespace e-commerce store. While average order value (AOV) gives you a single number, order value distribution reveals the complete story: how your customers actually spend, where revenue clusters occur, and most importantly, where untapped opportunities exist to increase profitability.

Order value distribution analysis shows you the spread of transaction amounts across your entire order history. Instead of just knowing that your average order is $75, you'll discover that 40% of orders fall between $50-$100, 25% are below $30, and 10% exceed $200. This granular understanding enables you to make strategic decisions about pricing, bundling, free shipping thresholds, and promotional strategies that actually align with customer behavior.

In this comprehensive tutorial, you'll learn how to extract order data from Squarespace, analyze the distribution using MCP Analytics' Order Value Distribution tool, interpret the statistical insights, and apply data-driven strategies to increase your average order size without alienating customers.

Prerequisites and Data Requirements

What You'll Need Before Starting

Understanding Your Data Structure

Squarespace order exports contain multiple fields, but for order value distribution analysis, you primarily need:

The analysis becomes more powerful when you have sufficient historical data to identify patterns. Seasonal businesses should ensure they capture complete seasonal cycles, while year-round operations benefit from at least three months of recent data for actionable insights.

Step 1: Export Your Squarespace Order Data

The first step is extracting your order data from Squarespace in a format suitable for analysis. Squarespace provides built-in export functionality that creates a comprehensive CSV file containing all order information.

Detailed Export Process

  1. Log into your Squarespace account and navigate to your website dashboard
  2. Access Commerce: Click on "Commerce" in the left sidebar menu
  3. Open Orders: Select "Orders" from the Commerce submenu
  4. Set Date Range: Use the date filter at the top to select your desired analysis period (recommended: last 90-365 days depending on order volume)
  5. Export Data: Click the "Export" button (typically in the upper right) and select "Export All Orders" or "Export Filtered Orders"
  6. Download CSV: Squarespace will generate a CSV file and either download it immediately or send it to your email address

Expected Output

You should receive a CSV file named something like orders-export-2024-01-15.csv. When opened in a spreadsheet application, you'll see columns including:

Order ID, Order Date, Customer Name, Email, Order Total, Status, Shipping, Tax, Subtotal...
#1001, 2024-01-15 10:23:45, John Smith, john@email.com, $87.50, Completed, $5.00, $7.00, $75.50...
#1002, 2024-01-15 14:18:22, Jane Doe, jane@email.com, $142.00, Completed, $0.00, $11.36, $130.64...
#1003, 2024-01-15 16:45:09, Bob Johnson, bob@email.com, $23.99, Completed, $5.00, $1.52, $17.47...

Validation Checkpoint

Before proceeding, verify your export:

Step 2: Upload Data to MCP Analytics

Now that you have your order data exported, you'll upload it to the Order Value Distribution analysis tool for processing. This specialized tool is designed to handle Squarespace commerce data and automatically extract the relevant fields for distribution analysis.

Upload Process

  1. Navigate to the Analysis Tool: Visit https://mcpanalytics.ai/analysis/#commerce__squarespace__orders__order_value_distribution
  2. Prepare Your File: Ensure your CSV file is ready and note its location on your computer
  3. Upload Data: Click the "Upload CSV" or "Choose File" button and select your Squarespace order export
  4. Field Mapping: The tool will automatically detect columns. Verify that "Order Total" is correctly mapped to the value field
  5. Filter Options: Configure any filters (e.g., exclude cancelled orders, select specific date ranges, remove outliers)
  6. Initiate Analysis: Click "Analyze Distribution" to process your data

Configuration Best Practices

When setting up your analysis, consider these configuration options:

Analysis Configuration:
{
    "currency": "USD",
    "exclude_status": ["Cancelled", "Refunded"],
    "minimum_order_value": 0,
    "remove_outliers": false,
    "bin_strategy": "auto",
    "date_range": "all"
}

Currency Settings: Ensure the correct currency is selected to match your Squarespace store configuration.

Status Filtering: Generally, you should exclude cancelled and refunded orders to analyze only completed transactions that represent actual revenue.

Outlier Handling: For most stores, keeping outliers provides valuable insights about high-value customers. However, if you have extreme anomalies (like test orders), consider enabling outlier removal.

Expected Processing Time

Analysis typically completes within 5-30 seconds depending on dataset size:

Step 3: Interpret Your Distribution Results

Once the analysis completes, you'll see a comprehensive dashboard displaying your order value distribution through multiple visualizations and statistical measures. Understanding how to read these results is critical for extracting actionable insights.

Understanding the Distribution Histogram

The histogram is your primary visualization tool, showing how orders are distributed across different value ranges. The x-axis represents order values, while the y-axis shows the number (or percentage) of orders in each range.

Key Patterns to Identify:

Statistical Measures Explained

The analysis provides several statistical measures that quantify your distribution:

Distribution Statistics:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Mean (Average):        $87.42
Median (50th %ile):    $72.50
Mode (Most Common):    $65.00
Standard Deviation:    $43.18
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Percentiles:
25th Percentile:       $48.00
75th Percentile:       $115.00
90th Percentile:       $168.00
95th Percentile:       $225.00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Mean vs. Median: If your mean is significantly higher than your median (as in the example above: $87.42 vs. $72.50), you have a right-skewed distribution with some high-value orders pulling the average up. This is common in e-commerce.

Standard Deviation: Measures the spread of order values. A higher standard deviation indicates more variability in order sizes. In this example, $43.18 suggests moderate variability around the mean.

Percentiles: These show the order value at specific distribution points. For instance, the 75th percentile of $115 means that 75% of orders are below $115, and 25% are above it. This is crucial for setting strategic thresholds.

Practical Interpretation Example

Let's say your analysis reveals:

This pattern suggests most customers naturally spend around $50-$100, but there's a distinct segment willing to spend $150+. The gap between $100-$150 represents an opportunity: customers who might spend more with the right incentive, but not quite enough to reach the premium segment naturally.

Understanding statistical significance is crucial when making decisions based on your data. Similar to A/B testing methodologies, you need sufficient sample sizes to draw reliable conclusions from your distribution analysis.

Step 4: Identify Optimization Opportunities

With your distribution understood, you can now identify specific, data-driven opportunities to increase average order value. This step transforms statistical insights into actionable business strategies.

Setting Strategic Free Shipping Thresholds

One of the most effective applications of order value distribution analysis is optimizing your free shipping threshold. The goal is to set it just above where many customers naturally spend, encouraging them to add one more item.

Calculation Strategy:

Current Distribution Analysis:
Median Order Value: $72.50
60th Percentile: $82.00
70th Percentile: $95.00

Recommended Free Shipping Threshold: $89.99 - $94.99

Logic:
- Set above median (60-70th percentile range)
- Encourages 40-50% of customers to add items
- Not so high that it feels unattainable
- Psychologically appealing number (ending in .99)

If you set free shipping at $89.99 when your median is $72.50, customers spending around $70-$80 need to add just $10-$20 worth of products—a reasonable ask that often succeeds.

Identifying Bundle and Upsell Opportunities

Look for gaps in your distribution histogram. These represent price points where few customers currently purchase, which can indicate missing product offerings or bundling opportunities.

For example, if you have strong clusters at $50-$75 and $125-$150, but very few orders between $75-$125, consider creating product bundles or sets priced at $95-$110 to capture that middle segment.

Tiered Discount Strategies

Use percentile data to create tiered discount or reward programs that encourage customers to reach the next spending level:

Tiered Incentive Structure Based on Distribution:

Tier 1 (Below 50th percentile - $72.50):
- Standard checkout experience
- Goal: Move to Tier 2

Tier 2 ($72.50 - $115.00 | 50th-75th percentile):
- 5% discount on next order
- Goal: Reinforce this value range

Tier 3 ($115.00+ | Top 25%):
- 10% discount on next order
- Free shipping on all orders
- Early access to new products
- Goal: Retain high-value customers

Product Pricing Optimization

If you notice your distribution has multiple distinct peaks (multi-modal distribution), these represent different customer segments with different spending capacities. Ensure you have products priced specifically for each segment.

For instance:

This data-driven approach to decision-making mirrors advanced analytical techniques. Just as AI-first data analysis pipelines leverage multiple data sources to generate insights, your order value distribution connects customer behavior data with revenue optimization strategies.

Step 5: Implement and Test Changes

After identifying optimization opportunities, it's time to implement changes strategically and measure their impact. This step ensures your data-driven hypotheses translate into actual revenue improvements.

Implementation Approach

Never implement all changes simultaneously. Instead, use a phased rollout:

  1. Baseline Measurement (Week 0): Document current metrics 
    Baseline Metrics (Record These):
- Current Average Order Value: $87.42
- Median Order Value: $72.50
- Orders per week: 145
- Revenue per week: $12,676
- Distribution shape: Right-skewed
  2. Phase 1 (Weeks 1-3): Implement free shipping threshold
    • Add prominent banner: "Free shipping on orders over $89.99"
    • Display progress bar in cart: "Add $12.50 more for free shipping"
    • Track daily AOV changes
  3. Phase 2 (Weeks 4-6): Introduce product bundles targeting distribution gaps
    • Create 2-3 bundles at identified price points ($95, $125)
    • Feature prominently on homepage and product pages
    • Monitor bundle adoption rate and impact on distribution
  4. Phase 3 (Weeks 7-9): Launch tiered loyalty program
    • Communicate tiers based on order value thresholds
    • Track tier progression and repeat purchase behavior

Measuring Impact

After each phase, re-run your order value distribution analysis to measure changes:

Post-Implementation Analysis (After 6 Weeks):

Original Distribution:
- Mean: $87.42
- Median: $72.50
- 75th Percentile: $115.00

New Distribution:
- Mean: $94.18 (+7.7% ↑)
- Median: $82.00 (+13.1% ↑)
- 75th Percentile: $125.00 (+8.7% ↑)

Orders clustered near free shipping threshold ($85-$95):
  Before: 18%
  After: 32% (+14 percentage points)

Statistical Validation

Ensure your improvements are statistically significant, not just random variation. With sufficient order volume (100+ orders in each period), look for:

Testing changes systematically and measuring impact with statistical rigor follows principles similar to those used in machine learning approaches for data-driven decisions, where iterative improvements are validated against measurable outcomes.

Continuous Monitoring

Order value distribution isn't a one-time analysis. Schedule regular reviews:

Use the Order Value Distribution tool each time to maintain consistent methodology and track changes over time.

Common Issues and Solutions

Issue 1: Insufficient Data Volume

Symptoms: Highly irregular distribution, inconsistent percentiles, wide confidence intervals

Solution: Expand your date range to include more orders. If you're a new store, wait until you have at least 50-100 orders before drawing strong conclusions. Focus on directional insights rather than precise optimizations.

Issue 2: Extreme Outliers Skewing Distribution

Symptoms: Mean significantly higher than median (more than 50% difference), long thin tail extending far right

Solution: Investigate whether outliers are legitimate or data errors. For analysis, consider viewing both "with outliers" and "without outliers" distributions. For business decisions, focus on median and percentiles which are less affected by extremes.

Issue 3: Flat/Uniform Distribution

Symptoms: Orders spread evenly across all value ranges with no clear peaks

Solution: This may indicate:

Consider segmenting your analysis by product category, customer type, or acquisition channel to find more meaningful patterns.

Issue 4: Multiple Peaks (Multi-Modal Distribution)

Symptoms: Two or more distinct clusters of order values

Solution: This is actually valuable! It indicates distinct customer segments. Analyze each peak separately:

Issue 5: Distribution Changes Don't Match Implemented Strategies

Symptoms: After implementing changes, distribution doesn't shift as expected

Solution: Consider:

Issue 6: CSV Upload Errors

Symptoms: File won't upload, column mapping fails, or error messages appear

Solution:

Common fixes:
1. Ensure CSV is saved as UTF-8 encoding
2. Check for special characters in order values ($, commas)
3. Verify numeric columns contain only numbers
4. Remove completely empty rows
5. Ensure headers are in first row
6. Try re-exporting from Squarespace if file appears corrupted

Analyze Your Order Value Distribution Now

Ready to unlock insights from your Squarespace order data? The Order Value Distribution analysis tool provides instant, comprehensive analysis of your e-commerce performance.

Get Started in Under 5 Minutes

  • Upload your Squarespace order export CSV
  • Receive instant statistical analysis and visualizations
  • Identify specific opportunities to increase average order value
  • Export reports and share insights with your team

Analyze Your Orders Now →

No account required for your first analysis. Simply upload your data and receive comprehensive insights immediately.

Next Steps with Squarespace Analytics

Now that you understand order value distribution, consider expanding your analytics capabilities:

Advanced Order Analysis

Integration with Other Metrics

Order value distribution becomes even more powerful when combined with:

Ongoing Optimization Strategies

Make order value distribution analysis a core component of your analytics routine:

  1. Monthly Reviews: Track key distribution metrics monthly to identify trends early
  2. Pre/Post Campaign Analysis: Before and after major promotions, analyze distribution shifts to measure effectiveness
  3. Competitive Benchmarking: While your specific data is proprietary, industry reports often provide distribution benchmarks for comparison
  4. Predictive Modeling: With sufficient historical data, build models to predict how pricing or product changes will affect distribution

Further Learning Resources

Deepen your analytical capabilities with these related topics:

Conclusion

Order value distribution analysis transforms generic average order value metrics into actionable, segment-specific insights. By understanding not just the average, but the complete pattern of how your customers spend, you can make strategic decisions about pricing, promotions, bundling, and customer experience that directly impact revenue.

The five-step process outlined in this tutorial—exporting Squarespace data, uploading to the analysis tool, interpreting distribution results, identifying optimization opportunities, and implementing tested changes—provides a repeatable framework for continuous improvement. As you iterate through this cycle, you'll develop increasingly sophisticated understanding of your customer base and the levers that drive higher-value transactions.

Remember that order value distribution is not static. Market conditions, product mix, customer preferences, and competitive dynamics all evolve over time. Regular analysis ensures your strategies remain aligned with current customer behavior rather than outdated assumptions.

Start your analysis today with the Order Value Distribution tool and discover the hidden patterns in your Squarespace order data that can drive your next revenue breakthrough.

Explore more: Squarespace Analytics — all tools, tutorials, and guides →