Platform: Enolytics DTC

Summary:

What it calculates: This measures the total number of bundle items sold, including both individual bundle components and fractional bundle allocations from your completed orders. It captures all bundle activity regardless of whether customers paid full price, used external payment methods, or even received refunds, giving you a complete picture of bundle product movement.

Variants:
• CP: Bundle items sold in current period
• PP: Bundle items sold in prior period
• Δ: Change in bundle items between periods
• Δ%: Percentage change in bundle items

How to use it:
• Track which bundle configurations are actually moving inventory to optimize your product groupings and pricing strategies
• Compare bundle performance across different time periods to identify seasonal trends or the impact of promotional campaigns

Related measures: AOV (Incl $0), Gross Sales (Incl $0), Net Sales, Net Sales %, Submitted Sales, Total Before Tax

Tip: Since this includes refunded items, pair it with net sales measures to understand the true economic impact of your bundle strategy versus just product movement.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Quick Stats:

Type: Calculated metric
Build Beyond Limits Group: Σ Bundles (Incl $0)

Bundles (Incl $0) CP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
        AND [Order Items].[Order Status] = 'Completed'

Output Format: #,##0.00

Formula Last Updated: 2025-12-12T12:33:24Z

Bundles (Incl $0) PP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
        AND [Order Items].[Order Status] = 'Completed'

Output Format: #,##0.00

Formula Last Updated: 2025-12-12T12:33:38Z

Bundles (Incl $0) Δ

🔢 Formula

m₁ - m₂
with:
m₁ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
        AND [Order Items].[Order Status] = 'Completed'
m₂ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')

Output Format: #,##0.00

Formula Last Updated: 2025-12-12T12:33:56Z

Bundles (Incl $0) Δ%

🔢 Formula

m₁  ÷  m₂ - 1
with:
m₁ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
        AND [Order Items].[Order Status] = 'Completed'
m₂ = Sum([Order Items].[Bundle Item Quantity])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2025-12-12T12:34:11Z