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:

RE:make My Hosing Account Successful

I have a hosting account that sales hosting and I need it to be successful I need someone who knows how to do web editing drive traffic and tah ke care of mailing list if you are ok with these thing Dont apply it will be a waste of time for us both I need someone who knows what there doing and can.

  • Fixed Price Project
  • Max $75
  • 2 years, 2 months left
  • Fixed Price Project
  • Max $50
  • 1 year, 2 months left

Sales Person In Education Industry!

We are looking for sales executive who has lot of experience in education industry and contacts with local schools, private tutoring, international schools, home schools etc. who can use http://www.hifikids.com for students, parents, teacher, tutors etc...

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

CSV - FTP Management Updates, And Integration For Yahoo Store

I have a yahoo store and my supplier provides daily CSV and FTP product updates. However, they have a standard CSV file that needs to be edited for yahoo integration. I'm looking for someone who can create a program or service to convert and auto update my site daily. I need a super star! I wo

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

Help Us Win More Contracts

We are in search of someone with skills to win over contracts. We need to increase our contracts. If you have the skills, please submit your cover letter, state you experiance as well and explain in brief how and what you do to win these contracts over.

  • Fixed Price Project
  • Max $500
  • 3 years, 5 months left

Help Us Win More Contracts

We are in search of someone with skills to win over contracts. We need to increase our contracts. If you have the skills, please submit your cover letter, state you experience as well and explain in brief how and what you do to win these contracts over.

  • Fixed Price Project
  • Max $500
  • 3 years, 5 months left

Hiring Harvard Writer In 2 Hours Time

Hello writers, We are searching for a number of writers on FINANCE and MANAGEMENT to join our team of writers. Do not apply if you do not know anything to do with this style. Academic writing, proposals, Press release and research would be of added advantage...

Skills Required: research finance management
  • Fixed Price Project
  • Max $500
  • 5 months, 2 weeks left

**Technical** Project Manager - Senior Technical Level Person

Company: Small Software company uses freelance developers - SharePoint App development. Your job - THIS IS A RECURRING JOB - it does not have a finite end date. Ongoing business. The budget below is not indicative of compensation. This is to be negotiated...

  • Fixed Price Project
  • Max $5000
  • 1 year, 7 months left

Operation Manager

This is a street sweeping company wit a small plant in Summerville SC, most of the work is at night, need be an honest and self motivated person that take care of 5 trucks, 4 drivers and 1 mechanic; must keep fleet running and supervise all the work. Must have a CDL Driver License, knowledge of truc

Skills Required: property-management
  • Fixed Price Project
  • Max $40000
  • 1 week, 1 day 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 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