Platform: Enolytics DTC
Summary:
What it calculates: This measures how many times your Average Order Value fits into your total Net Sales — essentially telling you how efficiently each dollar of sales translates to order value. It compares your total net sales (including all orders) against your AOV calculated from paid orders only, filtering for Order Status = 'Completed' and Payment Status IN ('Paid', 'Refunded', 'External').
Variants:
• CP: Current period ratio
• PP: Prior period ratio
• Δ: Change in ratio between periods
• Δ%: Percentage change in ratio
How to use it:
• Spot pricing strategy opportunities — if this ratio is much higher than your order count, you might have room to increase AOV through bundling or upselling
• Compare channel performance to see which sales channels are driving the most efficient revenue per transaction
• Track the impact of promotional campaigns on the relationship between total sales volume and individual order sizes
Related measures: Items (Excl $0), Refunds (Excl $0)
Tip: A declining ratio over time might signal that while sales are growing, individual order values aren't keeping pace — a perfect cue to focus on increasing basket size.
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
Net Sales to AOV (Excl $0) Ratio CP
🔢 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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
Output Format: $#,###.00
Formula Last Updated: 2025-05-02T14:02:07Z
ℹ️ Additional Details
Key:
[calculation].[Net Sales to AOV (Excl $0) Ratio CP]ID:
4cd4c1cc-d09e-4780-b71d-3f6223469ecc
🏷️ Tags
Completed Date
Is 0 Dollar Order
Net Sales
Net Sales to AOV (Excl $0) Ratio CP
Order Eid
Order Status
Payment Status