Save this Search

All JobsCSVFinance & Management

 2 results  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: Apr 11, 2014  |  Ends: 55d, 4h  |   30 Proposals
I have this excel file with PayPal/ purchase entries address, product name, item purchased and entries I want you to organize them individually as follows there are over 40000 entries. Many of these are duplicates or repeat buyers I want you to organize and chart for me 1. How many times a customer bought 2. What they bought 3. How much they spent 4. Sales by country 5. Customer life time value Then I want you to clean up the files and organize the file into US entries and international entries for both lists. Remove duplicates and give me the file as a CSV file I want this done by year. So you will have a tab for, 2012 2013, 2014 etc So again the job is twofold Chart my entries into the points above then clean up my file removing duplicates and separating US and non US entries You will therefore send me 2 excel files The first with graphs and data on the questions and the other with clean non duplicate entries with entries separated as US and non US
Category: Accounting       

Sign in to view client's details.
| J****rab
|    Canada
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job