Customer 360 Analytics
Refresh
Export
Alerts
Total Customers
4,821
+11.2% YoY
Avg CLV
$48,200
+8.4% YoY
NPS Score
67
+5pts YoY
Churn Rate
3.8%
-1.1pp YoY
Avg Order Freq.
6.2 / yr
+0.4 YoY
Customer Base Growth & Churn Over Time
BigQuery · customers
CLV by Customer Segment
clv.view
NPS Trend (Promoters vs Detractors)
interactions.view
Customer Segment Mix
segments.view
Order Frequency Distribution
orders.view
Tenure vs CLV Scatter
Scatter
Top Customers – LookML Explore: customers
| Customer ID | Name | Segment | CLV | Orders / Yr | Tenure | NPS |
|---|---|---|---|---|---|---|
| C-0041 | Apex Livestock Co. | Enterprise | $182,400 | 18 | 7 yrs | 9 |
| C-0087 | Northern Prairie Farms | Enterprise | $145,200 | 14 | 5 yrs | 8 |
| C-0124 | Sunrise Poultry Ltd. | Mid-Market | $92,800 | 10 | 4 yrs | 7 |
| C-0203 | Valley Beef Operations | Mid-Market | $74,100 | 8 | 3 yrs | 6 |
| C-0318 | Prairie Harvest Inc. | Growth | $41,600 | 5 | 1 yr | 8 |
| C-0412 | Great Plains Growers | At-Risk | $28,900 | 3 | 2 yrs | 4 |