📋 Summary:
What it is: A dimension tracking the number of months an outlet has been ordering from the winery since their first purchase.
How to use it:
• Filter sales reports to identify newer vs. long-established retail/on-premise accounts
• Segment performance analysis to understand revenue trends by account longevity
Tip: To analyze accounts within their first year, select multiple tenure values (3-month, 6-month, 9-month, 12-month) to create a comprehensive view of newer customer segments.
This summary was generated by AI.
📊 Quick Stats:
🏷️ Type: int
📁 Build Beyond Limits Group: Outlet Health Indicators
📝 Description
How many months this account has been ordering from you, calculated from their first order date to today.
📁 Build Beyond Limits Group
Outlet Health Indicators
🔗 Other Dimensions in this Group
ML Outlet Churn Probability
ML Outlet Predicted Churn
ML Outlet Risk Category
Outlet Avg Cases Per Order
Outlet Avg Days Between Orders
Outlet Cases 9L Last 180 Days
Outlet Category Diversity
Outlet Days Since Last Order
Outlet Exclusion Reason
Outlet Has Declining Volume
Outlet Has Extended Gap
Outlet Has Low Diversity
Outlet Lifetime Cases 9L
Outlet Lifetime Order Count
Outlet M Score
Outlet Order Frequency Trend 180
Outlet Order Frequency Trend 365
Outlet Order Frequency Trend Ratio 180
Outlet Orders Last 180 Days
Outlet Primary Risk Reason
Outlet Product Diversity
Outlet R Score
Outlet RFV Category
Outlet RFV Segment
Outlet SKU Diversity Last Year
Outlet Style Diversity
Outlet Top Category
Outlet Top Category Concentration
Outlet Top Product
Outlet Top Product Concentration
Outlet V Score
Outlet Volume Trend 180
Outlet Volume Trend 365
Outlet Volume Trend Ratio 180
⚙️ Technical Details
Type: int
ℹ️ Additional Details
Created: 2025-11-07T22:52:21Z
Key:
[dimension].[Outlet Tenure Months]ID:
870592a7-e1c8-4c69-a0c6-3bac8b4d3dcd
🏷️ Tags
Outlet Health Indicators
Outlet Tenure Months