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:

Urgent - We Need A Team Leader For Thailand

We have just opened Thailand 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...

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • 1 month, 3 weeks 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
  • 5 months, 3 weeks left

Japan Is Now Fully Open For Business

Japan is now fully open for Business and we are looking for Team Leaders in all the major Cities to take our products to a wider market in Japan and Worldwide. Our product range is consumed every day so is therefore a big market place...

  • Fixed Price Project
  • Max $1500
  • 6 months left

Credit Card Payment Processor Needed

We are a company outsourced by international Client that needs payment processing for her online shop. Volume is high with a minimum of $50,000 and maximum of $400,000 monthly...

  • Fixed Price Project
  • Max $15
  • 1 year, 8 months left

VCC Operations Manager India-Eur

Operations Manager needed to manage; recruit, hire, fire if necessary, track attendance daily, and train non technical live chat agents to be doing live 98% chat, ....but could include, some phone callback, some email possibly. 6 hour Schedule.....

Skills Required: call-center-management
  • Fixed Price Project
  • Max $5
  • 5 months left

Are You A Sales Professional, Then We Must Talk?

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
  • 9 months 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
  • 2 months 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
  • 4 weeks, 1 day 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, 9 months left

Wanted Call & Contact Center Across Albania-Romania-Moldavia-Ukraina & North Africa

WANTED CALL CENTER AND / OR OPERATORS OF THE ITALIAN LANGUAGE FOR CONDUCT OF TELE-MARKETING CAMPAIGN. RETAIL WILL TAKE PLACE AN OUTLET FOR APPOINTMENT OF AGENTS ENEL GREEN POWER ON THE MARKET RESIDENTIAL. FOR MORE INFO PLEASE CONTACT ME TO MY DIRECT CONTACT (EMAIL OR CELL)...

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