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:

Sales Agent

SportLabs is hiring! This commission based position is for someone who can: 1. Sell our website solutions and more 2...

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

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
  • 3 years, 7 months left

A New Product Development Project - Google (Harvard) Style

Need someone to proofread and make the paper meet all the instructions of the paper or just do it from the start. Need it ASAP like 24 hours time...

  • Fixed Price Project
  • Max $36
  • 8 months, 3 weeks left

I Need DJ Managers That Will Earn A 50% Comission On Every Show I Will Do !

Hello, I am a French DJ, I have played in more than a hundred clubs in Paris and In Europe (Cracow, Praha, Amsterdam, London, Paris, Arnhem, Beyrouth, ...)...

  • Fixed Price Project
  • Max $10000
  • 3 weeks left

WordPress Web Maintenance

We need a team of web developers that can maintain our clients websites to make minor changes each month. We normally bill our clients for 3hrs a month of maintenance each month and if they exceed the limit we then bill them at an hourly rate over and above their monthly maintenance contract...

  • Fixed Price Project
  • Max $30
  • 9 months, 2 weeks left

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 $15
  • 1 year, 11 months left

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, 11 months left

Best Of The Best Designer Or Developer Or Project Manager

I'm looking for the best of the best designer, developer, project managers, and English editors. I'm looking to start a web development company with some developers in the US, south america and every where else. I'm looking for the best of the best...

  • Fixed Price Project
  • Max $50000
  • Job Expired

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
  • 3 months, 1 week left

Virtual Assistant EMEA (Long Term)

I-COM is a global trade body focused on the Digital Advertising Industry and creating events on Online Measurement. We are looking for a Virtual Assistant for Europe, the Middle East and Africa. Primary work is Appointment Scheduling & Researching items related to travel...

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

Job Details

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