Excel Analyst And Reporting For E-commerce Order Data Management

Hello, I need a Report for my e-commerce company so I can better understand the customer base and customer purchasing behavior per month/year on each of the 3 websites we sell on: ebay, amazon, direct site.

Order History Analysis Report:

I can provide all the data for the past 3-4 months for order history including on an excel or csv file from the order download history including: order date, order value, quantity ordered, cogs, price, city, state, product name, weight, manufacturer, shipping time.

I need a macro or macros built on excel that will show me data and graphs/pivot tables for:
- $ Ordered product sales by any given date
- Average order values on any given date
- Average units per order
- Refund rate
- Growth month to month and compared to last year
- Analysis per platform (we sell on ebay, amazon, and our direct website)
- Conversion rate
- Repeating customers % by month or year
- Order $ growth on each platform (ebay, amazon, direct website)
- Sales by sku on each platform
- Profit determined by each sku
- Profit/loss per manufacturer by month or year

There are more variables and these are just to list out a few. The macro must be created so I can use this report for future use as well. I can be available to chat on skype at any time as well.

Please provide any examples that are relevant to this. Can pay hourly or project base if need be. Thank you

Search All Jobs:
  • Fixed Price Project
  • Max $80
  • 2 years, 11 months left

APA, Chicago, Harvard, MLA Styles

Hello writers, READ THIS CAREFULLY AS WE WANT A NUMBER OF WRITERS AND THOSE WHO FOLLOW INSTRUCTIONS. We are in search of a number of ACADEMIC writers on: 1. MEDICAL AND HEALTH 2. Technology 3. Project Management 4. English 5. Engineering 6. Finance 7. Thesis/Dissertation Proposal 8. Essay 9...

  • Fixed Price Project
  • Max $1000
  • 1 year, 10 months left

Are YOU Ready Australia / New Zealand?

After months of preparation and setting up we are soft Launched in Australia and New Zealand and we need dedicated Sales people to take us to the top in this area. We have pre launch Events in Melbourne / Hobart / Adelaide / Perth / Brisbane / Auckland / Wellington and Sydney over the next 2 weeks..

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • 4 months, 3 weeks left

Call Centers & Call Center Brokers Wanted

OUR INTERNATIONAL CLIENTELE IS SEEKING TO PARTNER WITH SMALL/MEDIUM CALL CENTER OPERATORS FOR LARGE CREDIT CARD & LOAN PROGRAMS BEING OFFERED TO CONSUMERS IN THE USA,CANADA, UNITED KINGDOM ETC QUALIFIED CALL CENTERS MUST BE ABLE TO PROVIDE A MINIMUM 25 X SEATS FOR THE OUTBOUND CONSUMER CALL CEN

  • Fixed Price Project
  • Max $10
  • 2 months, 1 week left

Monthly Sales Article For Newslette - Tips And How To

I am looking for someone who has professional sales training and experience to write high quality articles. It's an ongoing project every month (budget is monthly for one article)...

Skills Required: sales-management sales
  • Fixed Price Project
  • Max $75
  • 12 months left

Japan Is Now Fully Open For Business

Japan is now fully open for Business and we are looking for Team Leaders in all the major Cities to take our products to a wider market in Japan and Worldwide. Our product range is consumed every day so is therefore a big market place...

  • Fixed Price Project
  • Max $1500
  • Job Expired

Customer Service Rep CSR

We are looking for a self-motivated person to set appointments for free estimates. visit our website at http://jpcomputerbiz.wix.com/jpbiz We are looking for a self-motivated person to set appointments for free estimates. We have a family-like atmosphere and a friendly work environment...

  • Fixed Price Project
  • Max $5
  • 8 months, 1 week left

Trinidad - We Are Growing Fast In Your Country.Join Us!

We are a Market Leader in Jamaica and we are soft Launched in Trinidad. We need a hard working driven person who can take our products to the Top in Trinidad. We are in 27 Countries with another 30 slated for opening over the next year...

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • Job Expired

Credit Card Payment Processor Needed

We are a company outsourced by international Client that needs payment processing for her online shop. Volume is high with a minimum of $50,000 and maximum of $400,000 monthly...

  • Fixed Price Project
  • Max $1500
  • 1 year, 2 months left

Looking For Freelance Sales Professionals

YourSales is looking for freelance sales professionals worldwide for a range of missions we carry out for clients. Let us know when we could have a talk about how it might be interesting for you to work with us? Contact us here on oDesk for further discussion. Jakob Thusgaard Founder & CEO,

  • Fixed Price Project
  • Max $50000
  • 8 years, 4 months left

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • Max $200
  • Start Date
  • 04/17/2012 07:03:08 AM
  • Job Status
  • Job Expired