Lifecycle
Unit: days
Higher is better
About This Metric
Calculated from dateAdded to either dateCancelled (for former customers) or current date (for active customers). Longer tenure typically correlates with higher lifetime value.
Formula
AVG(days from dateAdded to dateCancelled or today)Data Sources
- diamond-customers
dateAddeddateCancelledstatusText
Caveats & Limitations
- •Active customers use current date as end point
- •Very new customers can skew the average down
Tags
#tenure
#loyalty
#duration
Calculation Source
Real-time (Cosmos DB)