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:

New Countries Development

We are a 19 year old Company that works in the field of Natural Health and Wellness and we are looking for Representatives in a number of Countries to promote our Top Branded products...

  • Fixed Price Project
  • Max $300
  • 4 months, 3 weeks left

Fulltime Web Designer (Affiliate Pages, Etc)

Hello, We are seeking a fulltime web designer to work with us building web pages for affiliate marketing purposes. You should be a hard working team player who wants to be a permanent part of our company...

  • Fixed Price Project
  • Max $350
  • 8 months, 1 week left

Internet Marketing Partner- Design & Development Services Needed

We are looking to outsource a number of different projects for all of our local business clients. First and foremost, we are looking for someone to design/develop semi-custom, theme based, Responsive websites using top rated open source web design software (such as WordPress, Drupal, Joomla, etc.).

  • Fixed Price Project
  • Max $1000
  • 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 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 left

Monthly Sales Article For Newslette - Tips And How To

I am looking for someone who has professional sales training and experience to write high quality articles. It's an ongoing project every month (budget is monthly for one article)...

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

Full Time Philippines Based Joomla, Php, HTML, CSS Website And , Apple/Android Apps Project Coordinator

Looking for a full time website / app project coordinator with the following experience from Philippines - Understanding of Joomla, Php, CSS and HTML website development - Understanding of Iphone/Andriod app development - Good communication skills in English - Ability to coordinate with offshore...

  • Fixed Price Project
  • Max $400
  • 4 months 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

Looking For Sales/Lead Generator For Florida Marketing Company

I Run a Local Consulting Agency In Florida. I'm Looking For Experienced and WELL SPOKEN B2B Salesperson to do the following : 1. Record The Company Voice Mail 2. Cold Call Local Businesses Offering OUR Services 3...

  • Fixed Price Project
  • Max $500
  • 1 month, 1 week left

Chief Of Processing & Compliance

SALARY $350 per Month, 8 Hours Per Day Manage Compliance Staff Communicate and disseminate essential policies or regulatory changes to senior management and the relevant business units and provide guidance on how the requirements could be met...

  • Fixed Price Project
  • Max $350
  • 3 weeks, 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