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, 2 months left

Urgent - We Need A Sales Team Leader For Slovenia

We have just opened Slovenia and need a dedicated Sales Team Leader to ensure we build fast in this Country. Our products are selling fast around the World and are consumed 75% of the Worlds population on a daily basis...

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

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
  • 3 months, 3 weeks left
  • Fixed Price Project
  • Max $80
  • 3 years, 4 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, 4 months 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
  • 1 year, 1 month 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
  • 4 months, 1 week left

Recruiting IT Guy With Business Background (FULL TIME)

this is a long shot but ideally, we would be looking for someone with following background (for full time) 1. business / accounting 2. IT (system support, basic software management, etc) 3. good command of communication in English and Thai we could consider Thai or foreigners and could provi

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

Looking For Freelance Sales Professionals

YourSales is looking for freelance sales professionals worldwide for a range of missions we carry out for clients. Let us know when we could have a talk about how it might be interesting for you to work with us? Contact us here on oDesk for further discussion. Jakob Thusgaard Founder & CEO,

  • Fixed Price Project
  • Max $50000
  • 8 years, 9 months left

Virtual Assistant EMEA (Long Term)

I-COM is a global trade body focused on the Digital Advertising Industry and creating events on Online Measurement. We are looking for a Virtual Assistant for Europe, the Middle East and Africa. Primary work is Appointment Scheduling & Researching items related to travel...

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

Job Details

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