-
-
2. Re: LoD Clarificaiton Customer-Sales
Ashish Chaudhari Dec 26, 2016 1:09 AM (in response to Emre Kaya)Hi Emre,
Can you elaborate your business question? I will also suggest you to provide the sample data (Dummy preferable) in order to visualize in the best possible way. Would you like to see the CAC at the year level or at the Customer level? I would also suggest you to provide the sample calculation for the one of the cases in excel which will provide better clarity and we can validate the output at our end.
If you calculate the CAC in above way you will get the same customer for the all the year along with the avg CAC. what I think is that Customers are acquired in any one of the business year and later they are retained. I think you should be only worried about the new customer for each and every year and not the all customers since you have acquired few customers for the year.
I hope this helps in someway. Let us know clear business logic. Whatever mentioned above is just my view point and I am no expert.
Thanks and Regards,
Ashish Chaudhari
-
3. Re: LoD Clarificaiton Customer-Sales
Emre Kaya Dec 26, 2016 2:31 PM (in response to Ashish Chaudhari)Hello Ashish,
I have included worksheet, any recommendation would be perfect.
thanks
Emre
-
4. Re: LoD Clarificaiton Customer-Sales
Emre Kaya Dec 26, 2016 2:31 PM (in response to lei.chen.0)Hello Lei,
I have included worksheet, any recommendation would be perfect.
thanks
Emre
-
5. Re: LoD Clarificaiton Customer-Sales
Sireesha J Dec 26, 2016 9:42 PM (in response to Emre Kaya)Hi Emre!
Probably you need to join at Customer ID=Customer ID and Join Date=Order Date.
If it does not give you what you are looking for then please share the required output value. It would be great help
Regards,
Sireesha.
-
-
7. Re: LoD Clarificaiton Customer-Sales
Emre Kaya Dec 27, 2016 6:18 AM (in response to lei.chen.0)Perfect,thats it. thank you very much !