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:

Content Writer

Experienced Content Writer; Scope 10 is seeking an experienced Web Content Writer who will be responsible for creating web-ready optimized content for multiple client websites. The content writer will also be responsible for creating the title tags and meta descriptions for content written...

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

Campaign Manager Needed For Us Home Security Campaign, Very Long Term, Start Immediately, Great Pay

PLEASE READ THIS ENTIRE JOB POST: We are hiring a campaign manager for our home security program. Our campaign manager will be responsible for recruiting callers to sale our service, manage and train their team and the team's sales...

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

Wordpress Expert!

The company is in need of someone who has commitment in making big projects together with the other people on the team. He/she will be responsible in all aspects of the website's back-end...

  • Fixed Price Project
  • Max $420
  • 1 year, 1 month left

URGENTLY Hiring For Star Quality Sales Representatives!!!

We are urgently in need of 5 STAR sales representative who is able to come up with the best possible strategy to sell Online Ordering Service contract for US and Canadian restaurants. We need people who can start right away. We are compensating by hourly basis plus sales commission...

  • Fixed Price Project
  • Max $800
  • 3 months, 1 week left

Collaborators For Db Migration And Synchronization.

The project involves developing software to sync stock data on just about every Db and file structured system currently in use to a central Db over WAN's...

  • Fixed Price Project
  • Max $5
  • 3 months, 1 week 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
  • 10 months, 1 week 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, 11 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 month, 1 week 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
  • 2 years, 5 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