I have a question regarding the new customer formula in the Scenario method workshop. I understand the logic of the formula from a monthly context but could you help me understand how the formula works on a yearly context.
For example, if I apply the same formula to the cumulative year 2018 (not broken down by months),
is the formula … Going to compare a table with the entire 2018 customer list with a table of customers in the 3 month priors to 2018 (Oct, Nov, Dec).
does the formula in essence goes through each month with the monthly logic you mentioned in the video and then returns an average of new customers?
Any help is much appreciated. Just trying to understand if this formula works for a yearly context as well.