Magento Business Intelligence Help Center

Free shipping threshold

In this article, we demonstrate how to set up a dashboard that will track the performance of your free shipping threshold. This dashboard, seen below, is a great way to A/B test two different free shipping thresholds. For example, your company might be unsure whether you should offer free shipping at $50 or $100. You should perform an A/B test of two random subsets of your customers, and perform the analysis in Magento BI.

Before getting started, you'll want to identify two separate time periods where you have had different values for your store's free shipping threshold.

This analysis contains advanced calculated columns that can only be created by a Magento BI analyst, so file a support request with the subject [FREE SHIPPING ANALYSIS] before getting started with this analysis.

  • sales_flat_order table
    • Order subtotal (buckets) will be created by an analyst as part of your [FREE SHIPPING ANALYSIS] ticket
      • This calculation creates buckets in increments relative to your typical cart sizes. This can range from increments including, 5, 10, 50 100, etc

No new metrics!!!

Note: Make sure to add all new columns as dimensions to metrics before building new reports.

  • Average order value with shipping rule A
    • Metric A: Average Order Value
      • Metric: Average order value
    • Time period: Time period with shipping rule A
    • Interval: None
    • Chart Type: Scalar
  • Number of orders by subtotal buckets with shipping rule A
    • Metric A: Number of orders
      • Metric: Number of orders
    • Time period: Time period with shipping rule A
    • Interval: None
    • Group by: Order subtotal (buckets)
      • Note: You can cut off the tail end by showing the top X sorted by Order subtotal (buckets) in the Show top/bottom.
    • Chart Type: Column
  • Percent of orders by subtotal with shipping rule A
    • Metric A: Number of orders by subtotal (hide)
      • Metric: Number of orders
    • Metric B: Total number of orders (hide)
      • Metric: Number of orders
      • Group by: Independent
    • Formula: % of orders
      • Formula: (A / B)
      • Format: %
    • Time period: Time period with shipping rule A
    • Interval: None
    • Group by: Order subtotal (buckets)
    • Chart Type: Line
  • Percent of orders with subtotal exceeding shipping rule A
    • Metric A: Number of orders by subtotal
      • Metric: Number of orders
      • Perspective: Cumulative
    • Metric B: Total number of orders (hide)
      • Metric: Number of orders
      • Group by: Independent
    • Formula: % of orders
      • Formula: 1- (A / B)
      • Format: %
    • Time period: Time period with shipping rule A
    • Interval: None
    • Group by: Order subtotal (buckets)
    • Chart Type: Line

Repeat the above steps and reports for Shipping B and the time period with shipping rule B.

After compiling all the reports, you can organize them on the dashboard as you desire. The end result may look like the image at the top of this page.

If you run into any questions while building this analysis, or simply want to engage our professional services team to build the analysis for you, simply open a support ticket here.

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk