3 ms·
It's automatically calculated based on churn. IE 10% churn would be 10 months (100/10 = 10)
by ryancarson 16y ago
It's automatically calculated based on churn. IE 10% churn would be 10 months (100/10 = 10)
- BobbyH 16y agoHi Ryan, I think that the rule of thumb used in the spreadsheet overstates the average customer tenure (as calculated by the alternate formula I outlined in another comment): https://docs.google.com/drawings/edit?id=1-9z5wczSfbM3KLZavFdM1WoQhK7q5wEyoiWWchInhwc&pli=1 https://docs.google.com/drawings/edit?id=1-9z5wczSfbM3KLZavF... In case you find this worthwhile, I uploaded a spreadsheet showing my calculations which you can see here: https://spreadsheets.google.com/ccc?key=0Ag-jmDLo09WNdHBNY1d0ejY3OWlHcGMtTWJSemI4WlE&hl=en#gid=0 https://spreadsheets.google.com/ccc?key=0Ag-jmDLo09WNdHBNY1d...