We are looking for someone to help us export and sort our customer data by month (cohort).
Then we need to know the number of customers from that cohort that purchased again for each month thereafter (for 6 months of data).
-420 customers acquired in January 2017, would then become our JAN 2017 Cohort
-140 customer from the JAN 2017 Cohort purchased again in February 2017
-130 customer from the JAN 2017 Cohort purchased again in March 2017
-100 customer from the JAN 2017 Cohort purchased again in April 2017
-70 customer from the JAN 2017 Cohort purchased again in May 2017
-30 customer from the JAN 2017 Cohort purchased again in June 2017
-10 customer from the JAN 2017 Cohort purchased again in July 2017
Then this data would be transferred into a google doc to show the percentage of customers who purchased in that window.
This needs to be completed for all customers from January 2017 - April 2019.
Final spreadsheet that needs to be completed here: [login to view URL]
Instructions (with video) here: [login to view URL]
17 freelancers are bidding on average $132 for this job
Hi, I went through the description . Kindly send me the details and contact me. I will start it today. I look forward to hearing from you soon thanks regards Thushara
Hello there I have seen your project and I can do it as data entry expert and I have more than two years experience in this field. So if you give me your project I will give you quality work. Thanks
Hello Boss! I have completely understand you project and am available to work and deliver the task in time. I would love to deliver clean n clear work for you. With all your requirements fulfilled.
I would like to freelance for your project and deliver the work working mentioned time. Also request you to share outlook of the project for better understanding
I am an experienced data analyst with extensive working knowledge of Google sheets and Microsoft Excel. I am detail oriented, fast, will deliver on time and can work with minimal supervision.