Modelling customer behavior-cohort system
Posted: Thu Jun 16, 2016 4:27 am
Hello Ladies and Gentlemen,
Hope this message finds you all well.
I am modelling a 6 stage cohort system to figure out customer behavior in my online business to then make sales projections.
Customers order on this business via a mobile app and they start their life in this model as a rate variable called "Downloads of app" (constant at 500/month) feeding a stock variable that I call "Registered on app". At this stage I have not received any order from people "Registered on App". Some of these "Registered on App" (my first stock variable) then go to place an order and trough another rate variable I move them to a second stock variable called "Customers 1 Order" and so on till a stock variable "Customers 6 orders" that is the last stage of the model and represents customers that have placed 6 orders. There is another rate variable that comes out of each stock variable that is a loss rate, representing customers that after the n-th order drop out of the system without placing the n-th+1 order.
I based this model on an age cohort model (population modelling), but instead of age I used number of orders.
My question is about rate variables and I will explain it using the real numbers I am working with:
I have had so far 5,600 downloads that is current level of the "Registered on the app" stock variable and of these 1,400 have placed one order on my mobile app (becoming customers); and this is the current level of the next stock variable in the cohort system "Customers 1 order". 750 have placed a second order and that is the level of the third stock variable in the cohort ("Customers 2 orders").
I assume that my success rate from downloads to first order is 1,400/5,600=25%. I also assume that my success rate for customers placing a second order is 1,400 (total customers that placed a first order)/750 (total customers that placed a second order)= 54%. The more I progress the more the success rate increases with 85% of customers placing a 5th order placing also a 6th order.
Am I correct or should I use for customers that place a second order a ratio of 750/5,600 ("Registered in the app")=13.39% (I don't think so as it does not sound logical, but not 100% sure)?
The success rate and churn rate for each cohort sums up to 100% so I am not adding or subtracting customers going from one stage to the next.
The behavior of the model after simulation shows that since my success rates are getting higher as customers progress in the system they would accumulate in the last stage of 6 orders (for which I assume then a 35% churn rate, but this is still unknown as the business is young).
Thank you for reading and for any comment. Uploaded a sketch of the system.
Best regards,
Dale
Hope this message finds you all well.
I am modelling a 6 stage cohort system to figure out customer behavior in my online business to then make sales projections.
Customers order on this business via a mobile app and they start their life in this model as a rate variable called "Downloads of app" (constant at 500/month) feeding a stock variable that I call "Registered on app". At this stage I have not received any order from people "Registered on App". Some of these "Registered on App" (my first stock variable) then go to place an order and trough another rate variable I move them to a second stock variable called "Customers 1 Order" and so on till a stock variable "Customers 6 orders" that is the last stage of the model and represents customers that have placed 6 orders. There is another rate variable that comes out of each stock variable that is a loss rate, representing customers that after the n-th order drop out of the system without placing the n-th+1 order.
I based this model on an age cohort model (population modelling), but instead of age I used number of orders.
My question is about rate variables and I will explain it using the real numbers I am working with:
I have had so far 5,600 downloads that is current level of the "Registered on the app" stock variable and of these 1,400 have placed one order on my mobile app (becoming customers); and this is the current level of the next stock variable in the cohort system "Customers 1 order". 750 have placed a second order and that is the level of the third stock variable in the cohort ("Customers 2 orders").
I assume that my success rate from downloads to first order is 1,400/5,600=25%. I also assume that my success rate for customers placing a second order is 1,400 (total customers that placed a first order)/750 (total customers that placed a second order)= 54%. The more I progress the more the success rate increases with 85% of customers placing a 5th order placing also a 6th order.
Am I correct or should I use for customers that place a second order a ratio of 750/5,600 ("Registered in the app")=13.39% (I don't think so as it does not sound logical, but not 100% sure)?
The success rate and churn rate for each cohort sums up to 100% so I am not adding or subtracting customers going from one stage to the next.
The behavior of the model after simulation shows that since my success rates are getting higher as customers progress in the system they would accumulate in the last stage of 6 orders (for which I assume then a 35% churn rate, but this is still unknown as the business is young).
Thank you for reading and for any comment. Uploaded a sketch of the system.
Best regards,
Dale