Dear all,
I have an excel file which contains a column of the mobile phone of the customer and the other column the date of the order. I want to now how many returned customers for each month how can I do that?
Hey @Feras95p ,
attaching update one.
This will definitely work.
Could you please add some sample data for the same, and is there any reference point based on which we calculate returned customer, e.g.,date of return.
Thanks
Hi @rupali_bhise ,
The reference point is the mobile phone, so that if the mobile phone is repeated that's mean he's a returned customer if it's not repeated that's mean he's a new customer. So the reference point to identify the customer status by checking the mobile phone, but how can I identify the total number of the returned and new customers for each month?
Note that, I have attached the sample file but I removed the mobile phones due to privacy.
Thanks in advance for your kind help.
This is a fairly common problem, with a number of different solutions depending on your use case and the level of detail that you're attempting to calculate.
In your case, you can find the minimum order month for each phone number, and then join this data back to your order set. If the order date is equal to the minimum date, then this is a new customer. Otherwise this person is a returned customer. See attached workflow.
Excuse the sudden drop in new customers in the mockup. Badly mocked up data!
Hey @neilgallen ,
I tried yours and I checked one day to make sure everything fine and it shows me for that's day 5 new customers and 9 returned while in that day I have the total customers 10 customers 5 out of them are returned !
