Kapalı

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]

Beceriler: Veri Girişi, Veri İşleme, Excel, Web Scraping, İnternet Araştırması

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Mexico City, Mexico

Proje NO: #19760141

Bu iş için 17 freelancer ortalamada $132 teklif veriyor

P0L

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 gün içinde
(295 Değerlendirme)
7.2
tiaratechies

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(50 Değerlendirme)
6.4
aubrey03

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

$100 USD in 3 gün içinde
(96 Değerlendirme)
5.6
smsaurabhv

‌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 Daha Fazla

$88 USD in 3 gün içinde
(48 Değerlendirme)
4.9
nelumindralal

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 gün içinde
(28 Değerlendirme)
4.4
Itblast

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 Daha Fazla

$155 USD in 3 gün içinde
(7 Değerlendirme)
4.1
abdulkarim97

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 gün içinde
(17 Değerlendirme)
4.3
xiaolong1112

Hi, I looked at your description carefully and I am very interested in providing my skills in hopes of working with you. I have ample experience in web scraping. -scrap any website using selenium, beautifulSoup, reque Daha Fazla

$150 USD in 3 gün içinde
(2 Değerlendirme)
2.5
rnaushad

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 Daha Fazla

$55 USD in 2 gün içinde
(1 Yorum)
0.4
qsattar

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 gün içinde
(0 Değerlendirme)
0.0
filipovaer

I offer fast and efficient service. I have experience in data entry, export, sort and summary of information. I have worked with ERP system and I have experience with Excel and Google. I would appreciate if you give Daha Fazla

$111 USD in 3 gün içinde
(0 Değerlendirme)
0.0
AiniAbal

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 gün içinde
(0 Değerlendirme)
0.0
foramthakkar1

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 gün içinde
(0 Değerlendirme)
0.0
pranjaliganvir64

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 gün içinde
(0 Değerlendirme)
0.0
stephanieemoody

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 Daha Fazla

$222 USD in 4 gün içinde
(0 Değerlendirme)
0.0
missnaser

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 gün içinde
(0 Değerlendirme)
0.0
KiharaLab

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 gün içinde
(0 Değerlendirme)
0.0