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:

APA, Chicago, Harvard, MLA Styles

Hello writers, READ THIS CAREFULLY AS WE WANT A NUMBER OF WRITERS AND THOSE WHO FOLLOW INSTRUCTIONS. We are in search of a number of ACADEMIC writers on: 1. MEDICAL AND HEALTH 2. Technology 3. Project Management 4. English 5. Engineering 6. Finance 7. Thesis/Dissertation Proposal 8. Essay 9...

  • Fixed Price Project
  • Max $1000
  • 1 year, 11 months left

APA, Chicago, Harvard, MLA Styles

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

Skills Required: research finance management
  • Fixed Price Project
  • Max $500
  • 1 week, 5 days 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 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
  • 2 weeks, 3 days left

Customer Service Rep CSR

We are looking for a self-motivated person to set appointments for free estimates. visit our website at http://jpcomputerbiz.wix.com/jpbiz We are looking for a self-motivated person to set appointments for free estimates. We have a family-like atmosphere and a friendly work environment...

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

Versatile Web Developer - Management Candidat

You are a truly versatile, motivated INDIAN Web Developer with excellent skills in Joomla, JomSocial, VirtueMart and similar Joomla extentions, preferably residing in CHENNAI or willing to relocate in the future there? Then we ascend not only an interesting, but long-term task with the ability to..

  • Fixed Price Project
  • Max $5
  • 5 years, 9 months left

We Are Open For Business From Today In Australia/NZ!

We are now fully open in Australia and New Zealand and on the first full Trading Day our Sales have been amazing. We need a Professional Team Leader in Australia/NZ (or both) to ensure we keep these high Sales Levels...

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • 2 months, 4 weeks left

Self Employed Sales Manager - Fantastic Growth Potential (UK Citizens And Commission Only)

Please see attached job and person specification. The ideal candidate will have a graphic design background or existing contacts within hotel and leisure, bars and restaurants, interior design, corporate business, etc...

  • Fixed Price Project
  • Max $5
  • 9 months, 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
  • 1 year, 11 months left

Web "Jack Of All Trades" Needed

Clothing company in need of skilled individual who can handle Square Space for website, Big Cartel for products, Word Press for blogs, all web design changes, and all back end technical requests that arise...

  • Fixed Price Project
  • Max $300
  • 1 year, 4 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