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:

Ab Initio Consultant

Job Title: Ab Initio Consultant (Multiple Positions) Location: NJ/FL/TX Duration: Full-time Job Requirements: "

  • Fixed Price Project
  • Max $100
  • 5 years left

RE:make My Hosing Account Successful

I have a hosting account that sales hosting and I need it to be successful I need someone who knows how to do web editing drive traffic and tah ke care of mailing list if you are ok with these thing Dont apply it will be a waste of time for us both I need someone who knows what there doing and can.

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

Sales Generation, Long Term Work

Search for dating site using Google or any other search engine, or use dating sites directories. Explore that sites and try to contact their owners by CONTACT US page or support chat. Send them the advertising message from our company including your personal discount promo code.

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

We Need You!

Our products are now being recognised as a replacement and we want Top Sales Professionals to make your Country more aware of the Science behind our Product Range...

  • Fixed Price Project
  • Max $200
  • 6 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
  • 2 months, 1 week left

LiveAuctionZone.com Sign Up Fees And Sales

Live Auction Zone is now looking for sale reps and sign up reps. All Sign up fees will be a percent of sign up sales. We Will Pay 50% For All Sign up fees and you many sign up your own sales reps and receive 25% For All Sign up fees and built a unlimited sale reps under you...

  • Fixed Price Project
  • Max $50000
  • 11 months, 1 week left

Looking For Freelance Sales Professionals

YourSales is looking for freelance sales professionals worldwide for a range of missions we carry out for clients...

  • Fixed Price Project
  • Max $50000
  • 8 years, 11 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