Platform: Enolytics DTC
Summary:
## Σ Customer Net Sales vs Total AOV (Excl $0) CP
What it calculates: This ratio measures how much your filtered customers are spending compared to your winery's overall average order value for paid orders. It takes the total net sales from your selected customer segment and divides it by the total AOV across all non-zero orders during the current period, giving you a clear multiplier that shows whether your segment spends above or below average.
Variants:
• CP: Current period ratio
• PP: Prior period ratio
• Δ: Change in ratio between periods
• Δ%: Percentage change in ratio
How to use it:
• Segment customers by club status, buyer profile, or region to see which groups are your highest-value spenders — if your 3-month buyers show a ratio of 2.5x, they're spending significantly more per order than your average customer
• Compare different marketing channels or acquisition sources to identify which ones bring in customers who spend at premium levels versus those closer to your baseline AOV
Tip: A ratio above 1.0 means your segment spends more than average per order, while below 1.0 indicates lower spending — use this to prioritize retention efforts on high-ratio segments and develop strategies to elevate lower-ratio groups.
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: Σ Customer Net Sales vs Total AOV (Excl $0) CP
Customer Net Sales vs Total AOV (Excl $0) CP
🔢 Formula
m₁ ÷ (m₂ ÷ (m₃ - m₄))
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₂ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [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
[Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] IN ('Paid', 'External')
AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
m₄ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] = 'Refunded'
AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
Output Format: #,##0.0
Formula Last Updated: 2025-05-06T11:55:51Z
ℹ️ Additional Details
Key:
[calculation].[Customer Net Sales vs Total AOV (Excl $0) CP]ID:
016f4f5b-820b-4aea-a813-f7fc7a5f71c3
🏷️ Tags
Completed Date
Customer Net Sales vs Total AOV (Excl $0) CP
Is 0 Dollar Order
Net Sales
Order Eid
Order Status
Payment Status