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 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
  • 5 months 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 experiance as well and explain in brief how and what you do to win these contracts over.

  • Fixed Price Project
  • Max $500
  • 3 years, 8 months left

Commission Sales (Phone/Leads/Support/Training) Provided

Orlando, FL based Loan/Debt Consolidation Company currently seeking Independent Sales Representatives. This is a home-office based position The Job consists of answering calls, making outbound calls and following-up via email. Our current sales representatives do 2-5 deals per week...

  • Fixed Price Project
  • Max $10000
  • 5 months left

Recruitment Consultants Needed

An exciting, fast paced opportunity has opened up for experienced HR professionals to place our high quality candidates into leading businesses across the UK...

  • Fixed Price Project
  • Max $1000
  • 1 month left

Long-term Reliable Academic Writers Needed

PLEASE ONLY APPLY IF YOU ARE SERIOUS AND RESPONSIBLE ABOUT WORKING ONLINE AS AN ACADEMIC WRITER! THANKS!! We are looking for a lot of good writers to work with us in the long term...

  • Fixed Price Project
  • Max $60
  • 1 year, 9 months left

Outbound Call Center

We are a small call center based in Bacolod City. Our business is called Merchant Service Center and we have been into business for the last 4 years...

  • Fixed Price Project
  • Max $1000
  • 5 months left

Payment Processing Accounts

I am looking suggestions for paypal like features for my website. I need the following: 1. User to create an account for transfering funds onto my website 2. Using a credit card/bank account the would be able to deposit funds into their account on my wesite 3...

  • Fixed Price Project
  • Max $100
  • 1 month, 3 weeks left

Sales Associates/Lead Generator

*Generation of leads by SEARCHING AND FINDING small Business in the United States that may be in need of Small Business Loans that meet qualifying criteria. *Calling Leads and speaking to owners about products and services that we can provide...

  • Fixed Price Project
  • Max $50000
  • 1 month left

Writers Needed 6am - 10pm (Mountain Time Zone, U.S.A.)

I represent a website, blog, and article content company. We need more English writers fast! We have a very efficient content development service -- so please read all of this job description carefully...

  • Fixed Price Project
  • Max $500
  • 1 month, 3 weeks left

Call Centre Bpo (centre Only Not Individual)

IF YOU ARE INDIVIDUAL DO NOT APPLY THIS IS FOR CALL CENTRE ONLY, WHICH MEANS A BPO COMPANY $200 per person per month 4 people needed 24/7 call chat and email handling - Cleint Assist - Agent Assist - Merchant Assist

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