Sort & compile customer data into a spreadsheet to display purchase activity

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).

For example:

-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]

Skills: Data Entry, Data Processing, Excel, Web Scraping, Web Search

See more: pivot table for sales data, how to prepare monthly sales report in excel, spreadsheet templates, excel formulas, pivot table excel, how to make sales report in excel, free excel spreadsheet, how to analyze sales data in excel, putting tech support data spreadsheet, free microsoft excel customer data entry, 2008 extract data spreadsheet, retrieving data table display page php, customer data base system, pull data sites display, link web data spreadsheet, payroll data spreadsheet, customer data entry application, aspnet create xml spreadsheet display, macro data spreadsheet, joomla customer data base

About the Employer:
( 0 reviews ) Mexico City, Mexico

Project ID: #19760141

15 freelancers are bidding on average $132 for this job


Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 2 days
(326 Reviews)

Hello, I can give you all the data in couple of hours, can you send me a message so that I can start working on this, hope you will drop a message.

$30 USD in 1 day
(53 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$100 USD in 3 days
(119 Reviews)

‌Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHO More

$88 USD in 3 days
(69 Reviews)

Trainor of Advanced Excel and VBA. Can do virtually ANYTHING in Excel. Your Excel tasks takes hours to complete? I can make it work within seconds or minutes! Your Excel tasks too tedious? I can do it within a few clic More

$155 USD in 3 days
(7 Reviews)

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

$100 USD in 3 days
(18 Reviews)

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

$100 USD in 3 days
(29 Reviews)

Hi, This problem can be solved quite accurately by using some queries on the source data which will save human errors. Please grant me access to the instructional video and some sample data so that I can provide a sol More

$55 USD in 2 days
(1 Review)

Hello. It's sort of customer base analysis and I am an Analyst. I am detail oriented and patient with data and numbers. Thank you. Regards.

$155 USD in 20 days
(0 Reviews)

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.

$166 USD in 5 days
(0 Reviews)

Hi! My name is Stephanie and I am interested in your job. I currently work full time in product development, where data entry, creating lists and project management is a part of my day to day job. Excel is also a to More

$222 USD in 4 days
(0 Reviews)

I can able to sort it and export it. Please let me know Relevant Skills and Experience excel,data entry,word

$155 USD in 3 days
(0 Reviews)

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

$166 USD in 3 days
(0 Reviews)

Hi e-Employer Let’s get started with this project and you’ll find me a trustable e-Employee. Hope to have positive feedback. Best Regards Qadeer Sattar

$111 USD in 7 days
(0 Reviews)

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.

$222 USD in 5 days
(0 Reviews)