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:

This May Need A Whole Team Including But Not Limited To All Aspects Of Web Development. For A Group Of Micro Real Estate & HOA Websites

Integrated - Real Estate marketing websites: AND Home Owner Association Websites: like the ones these companies build http://www.hoa-sites.com/ , http://www.hoaconnections.com/ , and http://www.associationcomm...

  • Fixed Price Project
  • Max $5000
  • 1 year, 6 months left
  • Fixed Price Project
  • Max $80
  • 1 year, 7 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
  • 6 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
  • 6 months left

Event Coordinators

We are looking for event coordinators around the world. You shud have the following skills 1. Ability to bring atleast 100 viewers 2. Ability to bring atleast 10 demonstrators with talents 3. Ability to organise events live in the web and also in the public place 4. Excellent communication skill 5.

  • Fixed Price Project
  • Max $50
  • 4 months left

German Speaking Project Manager In Vietnam

Hi, we are looking for a german speaking project manager in vietnam to work at the location of our software development team in vietnam. Your job will be to clarify tasks with customers and discuss directly with the team to get the software development jobs done. Please send your CV to us. Thanks T

Skills Required: german project-management
  • Fixed Price Project
  • Max $800
  • 4 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...

  • Fixed Price Project
  • Max $50000
  • 7 years, 4 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
  • 7 years left

Call Center For Construction Company

I am looking for the right call center to make appointments for me on a pay per appointment basis I have a construction company in the Los Angeles area...

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

Start-up Fund Looking For Limited Partners

Hello, We are an incubator start-up fund currently seeking traders wishing to become limited partners. We currently have all necessary legal structuring in place, including our LLCs and counsel...

  • Fixed Price Project
  • Max $50000
  • 4 years, 3 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