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:

Part Time

Small Startup Company is need of a Part-Time Developer Position New tech Development group. This Opening Budgeted for at least 1 year...

  • Fixed Price Project
  • Max $100
  • 3 months, 1 week 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
  • 1 year, 2 months left

Urgent Hiring.. Looking For Expert Writers!!!

If you are very tired of looking for numerous types of works, then this job is for you.! We are looking for more expert writers in writing different types of works for the websites.. We have numerous tasks to do. That's why; we are having an urgent hiring...

  • Fixed Price Project
  • Max $100
  • 2 weeks left

Part Time Developer

Small Startup Company is need of a Part-Time Developer Position New tech Development group. This Opening Budgeted for at least 1 year...

  • Fixed Price Project
  • Max $100
  • 10 months, 1 week 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
  • 1 year left

We Need You To Sell Our Amazing Products!

Our nutrition products are now being recognised by Doctors as a replacement for failing antibiotics and we want Top Sales Professionals to make your Country more aware of the Science behind our Product Range...

Skills Required: sales-management
  • Fixed Price Project
  • Max $200
  • 1 year, 2 months left

Long-term Reliable Academic Writers Needed

PLEASE ONLY APPLY IF YOU ARE SERIOUS AND RESPONSIBLE ABOUT WORKING ONLINE AS AN ACADEMIC WRITER! THANKS!! We are looking for a lot of good writers to work with us in the long term...

  • Fixed Price Project
  • Max $60
  • 2 years left

Sales Generation, Long Term Work

Search for dating site using Google or any other search engine, or use dating sites directories. Explore that sites and try to contact their owners by CONTACT US page or support chat. Send them the advertising message from our company including your personal discount promo code.

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

Are You A Sales Professional, Then We Must Talk?

Our products are now being recognised as a replacement and we want Top Sales Professionals to make your Country more aware of the Science behind our Product Range...

  • Fixed Price Project
  • Max $200
  • 1 year, 3 months left

Social Media Assistants Needed

We are looking for professionals to assist in our social media efforts. This includes setting up and maintaining accounts and managing our followers. Our project is growing quickly and for dedicated managers there is quite a bit to do. The work is long term and flexible, you can set your own hours..

  • Fixed Price Project
  • Max $1500
  • 1 week, 2 days left

Job Details

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