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:

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

Community Representative - Australia

We are seeking Community Representatives to develop a localized voice for the company's social media and blog presence in each of our 16 global markets. If you're passionate about travel, social media and building a valuable community online, this is the perfect freelance opportunity for you

  • Fixed Price Project
  • Max $680
  • 4 months, 1 week left

Trinidad - We Are Growing Fast In Your Country.Join Us!

We are a Market Leader in Jamaica and we are soft Launched in Trinidad. We need a hard working driven person who can take our products to the Top in Trinidad. We are in 27 Countries with another 30 slated for opening over the next year...

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • 8 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, 2 months left

Business Consultant/expert For Registering Offshore Company Formation

Hi, Here are the things that we need. 1. Company formation registered in Belize, Cyprus, Delaware, USA or Panama.. I've heard it's called a LLC or LTD company. 2. We are in need of a bank account online for our projects.. 3...

  • Fixed Price Project
  • Max $1300
  • 7 months, 2 weeks left

Junior Project Coordinator

We are a web development business based in Australia and india. We require junior,project coordinator to keep track of our projects. Projects are mainly web development related. The job should only require a 2-3 hours a week at the moment. Pay is based on monthly rate.

  • Fixed Price Project
  • Max $40
  • 2 weeks, 1 day left

Data Entry Long Term Newbies Welcome

First goto the link goo.gl/of6gEi and register Read the following instructions carefully A notable internet company, based in the San Francisco Bay Area, currently needs a Data Specialist. You will be adding to, editing and merging data in a large database of international topics...

  • Fixed Price Project
  • Max $2000
  • 3 weeks, 4 days left

SEO Content Writer

Our team is in need of a Junior level SEO Writer. The project will start as a part time offer and based upon your skills, this could lead to a full time position. Ideal candidate must have at least 1 year of SEO writing experience...

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

Forex Introducing Broker/Affiliate

We have set up a website www.stocksoptionsforex.com to promote some of our best algorithmic trading solutions. Please see the ones available for forex here http://www.stocksoptionsforex.com/managed-forex-account. We also offer a partnership program with various brokers including hotforex...

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

Web Content Manager

Message Expansion Partners CEO Lakeisha McKnight needs a professional who can post new content on its website blogs 1-2 times per week to keep content fresh and obtain good ranking on google...

  • Fixed Price Project
  • Max $20
  • 2 months, 2 weeks left

Job Details

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