The calculation formula for the Blended curve for month X is (Total retained in month X across 6 cohorts) / (Total customers acquired in 6 cohorts). Is this correct? Could you please explain a little on the usage of SUMPRODUCT in your excel?
I'll be rereading all your posts in Growth Croissant, probably a third or even fourth time each, Reid. It is quite complex, eh? Especially for a small fry like me. I can only execute what you're presenting to us if I radically simplify it, which will take me some time. Any thoughts on streamlining it for those of us who have micro-businesses?
Measuring Retention and Making Your CLV Model Reliable
Thanks for the great post!
The calculation formula for the Blended curve for month X is (Total retained in month X across 6 cohorts) / (Total customers acquired in 6 cohorts). Is this correct? Could you please explain a little on the usage of SUMPRODUCT in your excel?
Another helpful post - thanks Reid
I'll be rereading all your posts in Growth Croissant, probably a third or even fourth time each, Reid. It is quite complex, eh? Especially for a small fry like me. I can only execute what you're presenting to us if I radically simplify it, which will take me some time. Any thoughts on streamlining it for those of us who have micro-businesses?