Platform: Enolytics DTC

Summary:

## Net Sales to AOV (Excl $0) Ratio Presets

What it calculates: This ratio compares your total net sales (including all orders) to your net sales excluding zero-dollar orders, then divides by your average order value for paid orders only. Essentially, it shows you how your overall revenue performance relates to your core paid business by filtering out complimentary orders, tastings, and promotional giveaways when calculating the baseline AOV.

Variants:
• All Time: Complete historical ratio across all periods

How to use it:
• Assess how much your promotional and complimentary activities impact your overall revenue picture compared to your core paid business metrics
• Understand the relationship between your total business activity and your cash-generating transactions to better evaluate true commercial performance

Tip: A ratio close to 1.0 suggests most of your business comes from paid transactions, while a higher ratio indicates significant promotional or complimentary activity that inflates total sales relative to your paid order baseline.

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: Σ Net Sales to AOV (Excl $0) Ratio Presets

Net Sales to AOV (Excl $0) Ratio All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

🔢 Formula

m₁  ÷  (m₂  ÷  (m₃ - m₄))
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
m₂ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₃ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₄ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')

Output Format: $#,###.00

Formula Last Updated: 2025-05-02T13:53:21Z

Total AOV (Excl $0) Ratio All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

🔢 Formula

(m₁  ÷  (m₂ - m₃))
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₂ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₃ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')