How to Use Discount Analysis in Squarespace: Step-by-Step Tutorial

Introduction to Discount Analysis

Discount codes are a powerful marketing tool for Squarespace store owners, but without proper analysis, they can silently erode your profit margins. You might be offering 20% off to customers who would have purchased at full price, or running promotions that generate revenue but actually lose money when you factor in costs.

This tutorial will teach you how to perform comprehensive discount analysis on your Squarespace orders data to answer critical questions:

• Which discount codes are truly profitable versus which are costing you money?
• What percentage of discounted orders represent incremental sales versus cannibalized revenue?
• How do discount codes affect average order value, customer lifetime value, and repeat purchase rates?
• What is the optimal discount percentage for your specific product mix and margins?

By the end of this guide, you'll have a data-driven framework for evaluating discount performance and making informed decisions about your promotional strategy.

Prerequisites and Data Requirements

What You'll Need

Before beginning this analysis, ensure you have:

• Squarespace Commerce account with at least 3 months of order history (6-12 months is ideal)
• Active discount codes with measurable usage data
• Admin access to export orders from your Squarespace dashboard
• Basic understanding of your product margins and cost structure
• Access to MCP Analytics for advanced discount analysis capabilities

Data Requirements

Your exported Squarespace orders file should include:

• Order number and date
• Subtotal and total amounts
• Discount code applied (if any)
• Discount amount
• Customer email or ID (for repeat purchase analysis)
• Product details and quantities

The more complete your data, the more accurate your analysis will be. If you're missing certain fields, you can still perform basic discount analysis, but advanced metrics like customer lifetime value impact may be limited.

Step-by-Step Discount Analysis Process

Step 1: Export Your Squarespace Orders Data

First, you need to extract your raw orders data from Squarespace:

1. Log into your Squarespace dashboard
2. Navigate to Commerce → Orders
3. Click the Export button in the upper right
4. Select your desired date range (recommend at least 90 days)
5. Choose CSV format
6. Download the file to your computer

Expected Output: A CSV file named something like orders-2024-01-01-to-2024-12-31.csv containing all order details.

Step 2: Access the MCP Analytics Discount Analysis Tool

Now you'll upload your data to the specialized Squarespace Discount Analysis tool:

1. Navigate to mcpanalytics.ai/analysis/#commerce__squarespace__orders__discount_analysis
2. Click Upload Data or drag your CSV file into the upload area
3. Wait for the file to process (usually 10-30 seconds depending on size)
4. Verify that the data preview looks correct
5. Click Run Analysis

Expected Output: The tool will automatically detect discount-related columns and begin calculating performance metrics. You should see a loading indicator followed by your analysis dashboard.

Step 3: Review Your Discount Performance Metrics

The analysis tool will generate several key metrics. Here's how to interpret each one:

Discount Usage Rate

This shows what percentage of your orders use discount codes:

Discount Usage Rate = (Orders with Discounts / Total Orders) × 100

Example:
- Total Orders: 1,000
- Orders with Discounts: 350
- Usage Rate: 35%

What it means: If your usage rate is above 40%, you may be over-relying on discounts. Below 15% might indicate under-promotion or poor code distribution.

Average Order Value (AOV) Comparison

Compare AOV between discounted and non-discounted orders:

AOV Lift = ((Discounted AOV - Non-Discounted AOV) / Non-Discounted AOV) × 100

Example:
- Discounted AOV: $95
- Non-Discounted AOV: $85
- AOV Lift: +11.8%

What it means: Positive AOV lift suggests customers are adding more items when using discounts (good). Negative lift means discounts may be cannibalizing full-price purchases (concerning).

Revenue Impact Analysis

Calculate the true revenue impact of your discount strategy:

Gross Revenue from Discounted Orders: $33,250
Discount Amount Given: $8,480
Net Revenue from Discounted Orders: $24,770

Opportunity Cost (if 50% would have purchased at full price):
Lost Revenue: $4,240

What it means: This helps you understand not just what you made, but what you potentially gave up. The opportunity cost estimation requires assumptions about purchase intent, which the tool helps you model.

Step 4: Identify High-Performing and Low-Performing Codes

The analysis tool will rank your discount codes by performance. Look for these patterns:

High-Performing Codes

• High usage with positive ROI: Codes that drive volume without excessive margin erosion
• New customer acquisition: Codes that attract first-time buyers at acceptable CAC (Customer Acquisition Cost)
• Cart abandonment recovery: Codes that convert browsers into buyers

Low-Performing Codes

• High discount, low volume: Generous offers that don't drive enough incremental sales
• Existing customer overuse: Loyal customers using codes who would have purchased anyway
• Margin-negative codes: Discounts that push orders below profitability threshold

The tool will generate a visual breakdown showing each code's performance:

CODE          USAGE    AVG_DISCOUNT    REVENUE     ROI
WELCOME20     245      20%            $23,275     142%
SPRING15      189      15%            $18,921     168%
SAVE30        67       30%            $7,892      89%
VIP40         34       40%            $4,123      67%

Interpretation: SPRING15 has the best ROI (168%), while VIP40 is barely breaking even at 67% ROI.

Step 5: Calculate True Discount ROI

Standard revenue reports don't tell the whole story. You need to calculate true ROI considering:

Incremental vs. Cannibalized Sales

Not all discounted sales are "new" sales. Some customers would have purchased at full price. The tool uses statistical methods similar to those in A/B testing for statistical significance to estimate incrementality:

Incremental Sales Rate = Estimated percentage of sales that wouldn't have occurred without discount

Example Analysis:
- Total Discounted Revenue: $50,000
- Estimated Incremental Rate: 60%
- True Incremental Revenue: $30,000
- Cannibalized Revenue: $20,000
- Discount Cost on Cannibalized Sales: $5,000 (wasted)

Customer Lifetime Value (CLV) Impact

First-time discount users may become repeat customers, increasing their lifetime value:

CLV-Adjusted ROI = (Incremental Revenue + Future CLV Increase) / Discount Cost

Example:
- Incremental Revenue: $30,000
- New Customers Acquired: 150
- Average CLV Increase: $50 per customer
- Future Value: $7,500
- Total Benefit: $37,500
- Discount Cost: $12,500
- CLV-Adjusted ROI: 300%

This calculation shows that even if immediate ROI looks modest, customer acquisition value can make discounts highly profitable long-term.

Step 6: Optimize Your Discount Strategy

Based on your analysis, implement these optimization strategies:

Discount Percentage Optimization

Test whether smaller discounts achieve similar conversion rates:

Current: 25% discount, 200 orders = $20,000 revenue, $5,000 discount cost
Test: 15% discount, 180 orders = $19,125 revenue, $2,869 discount cost

Result: 10% reduction in discount saves $2,131 with only 10% fewer orders
Net Benefit: +$1,006 additional profit

Targeted Distribution

Limit discount access to specific segments:

• New visitors only: Prevent existing customers from using acquisition discounts
• Cart abandonment: Trigger codes only after abandonment
• Seasonal timing: Use discounts during slow periods, not peak seasons
• Email segmentation: Send codes only to lapsed customers

Performance Monitoring

Set up ongoing monitoring using the Discount Analysis service to track:

• Weekly discount performance trends
• Month-over-month ROI changes
• Seasonal discount effectiveness patterns
• Customer segment response rates

Interpreting Your Results

Key Metrics to Track

Focus on these primary indicators of discount health:

1. Discount ROI by Code

Benchmark: Aim for minimum 150% ROI on discount campaigns (every $1 in discounts should generate $1.50+ in incremental profit).

2. Cannibalization Rate

Benchmark: Keep cannibalization below 40%. If more than 40% of discounted purchases would have happened anyway, you're giving away too much margin.

3. New vs. Repeat Customer Usage

Benchmark: New customer acquisition codes should be used by 70%+ new customers. If repeat customers dominate usage, your targeting needs work.

4. Average Discount Depth

Benchmark: Blended average discount should stay below 20% of order value. Higher percentages require very strong volume increases to maintain profitability.

Red Flags to Watch For

• Declining non-discounted orders: Customers may be "trained" to wait for sales
• Increasing discount percentages over time: Suggests discount dependency
• Low repeat purchase rates from discount users: Acquiring price-sensitive, low-loyalty customers
• Negative correlation between discount usage and AOV: Customers buying less when using codes

Advanced Analysis Techniques

For deeper insights, consider these advanced analytical approaches similar to methods used in AI-first data analysis pipelines:

Cohort Analysis

Track discount-acquired customers over time to measure true lifetime value:

Cohort: Customers acquired with WELCOME20 in Q1 2024
- Month 0: 150 customers, $12,750 revenue
- Month 1: 45 repeat purchases, $4,275 revenue
- Month 2: 32 repeat purchases, $3,120 revenue
- Month 3: 28 repeat purchases, $2,890 revenue
- 6-Month CLV: $153 per customer

Propensity Modeling

Build models to predict which customers would have purchased without discounts, improving your incrementality estimates.

Price Elasticity Testing

Run controlled experiments with different discount levels to find the optimal balance between conversion and margin.

Analyze Your Squarespace Discounts Now

Ready to understand the true impact of your discount strategy? Stop guessing and start measuring with data-driven discount analysis.

Troubleshooting Common Issues

Issue: Missing Discount Code Data

Symptoms: Your Squarespace export shows orders but no discount code column or values.

Solutions:

• Verify you selected the correct export format (CSV with all fields)
• Check that you have discount codes active during the export date range
• Ensure you have the proper permissions to view commerce data
• Try exporting a smaller date range to see if specific periods have data

Issue: Inconsistent Order Totals

Symptoms: Subtotal minus discount doesn't equal total (due to taxes, shipping, etc.)

Solutions:

• Use the "Subtotal" field for pre-discount amount
• Use the "Discount Amount" field directly rather than calculating
• Filter out refunded/cancelled orders before analysis
• Ensure your export includes all necessary financial columns

Issue: Unable to Calculate Incrementality

Symptoms: Tool cannot estimate what percentage of discounted sales are truly incremental.

Solutions:

• You need at least 100+ orders with and without discounts for statistical validity
• Ensure your data spans multiple months to account for seasonality
• If you have test/control data from past experiments, use that for more accurate estimates
• Consider running a controlled A/B test where some customers receive discounts and others don't

Issue: ROI Calculations Seem Too High or Too Low

Symptoms: Results don't match your intuition about discount performance.

Solutions:

• Verify your product margin data is accurate (COGS + fulfillment costs)
• Check that you're including all discount-related costs (affiliate fees, promotion expenses)
• Ensure the incrementality assumption is realistic for your business
• Review the customer acquisition cost calculations
• Confirm you're analyzing the correct date range and not mixing different promotional periods

Issue: File Upload Errors

Symptoms: CSV file won't upload or shows parsing errors.

Solutions:

• Ensure file is in CSV format (not Excel .xlsx)
• Check file size is under 50MB (split into smaller date ranges if needed)
• Remove any special characters or formatting from the CSV
• Verify the file isn't corrupted by opening it in a text editor
• Try re-exporting from Squarespace with a different date range

Next Steps with Squarespace Analytics

Now that you understand discount analysis, expand your Squarespace analytics capabilities:

Related Tutorials

• Customer Cohort Analysis: Track customer behavior and lifetime value over time
• Product Performance Analysis: Identify your most and least profitable products
• Abandoned Cart Analysis: Understand why customers leave without purchasing
• Revenue Forecasting: Predict future sales based on historical patterns

Advanced Techniques

Take your analysis to the next level with these resources:

• Learn about A/B testing and statistical significance to run controlled discount experiments
• Explore AdaBoost for data-driven decisions to build predictive models for discount response
• Build automated AI-first analysis pipelines for continuous discount monitoring

Ongoing Optimization

Discount analysis isn't a one-time task. Set up monthly reviews to:

• Track discount performance trends over time
• Test new discount strategies and measure results
• Refine customer segmentation and targeting
• Adjust discount percentages based on margin changes
• Identify seasonal patterns in discount effectiveness

Get Expert Help

If you need assistance with complex discount analysis or want custom analytics solutions, the MCP Analytics team can provide:

• Custom discount attribution modeling
• Automated discount performance dashboards
• Integration with your marketing automation tools
• Advanced statistical analysis and experimentation design

Conclusion

Discount analysis is essential for profitable Squarespace store management. By following this tutorial, you've learned how to measure the true ROI of your discount codes, identify which promotions are driving incremental sales versus cannibalizing margins, and optimize your strategy for maximum profitability.

Remember: the goal isn't to eliminate discounts, but to use them strategically where they create the most value. With regular analysis and optimization, your discount codes can become a powerful tool for customer acquisition and revenue growth without sacrificing profitability.

Start your analysis today with the Squarespace Discount Analysis tool and transform your promotional strategy from guesswork to data-driven decision making.