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
  • 4 years, 8 months 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, 7 months left

Experienced Personal Assistant

Seeking an experienced (Or willing to learn fast) personal assistant with a successful proven tack record. Preferably with a degree Excellent, written, verbal,English Great communicator, Hard worker, efficient in a fast paced environment. Great analysis, organisational, management skills...

  • Fixed Price Project
  • Max $100
  • 1 year, 3 months left

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

Australia Is Now Open

We need a strong Sales Force for Australia and New Zealand. You must be a Leader and ready to build fast with a product the World uses every day, many times a day (but our product is unique and people love it)...

Skills Required: sales-management
  • Fixed Price Project
  • Max $1500
  • 1 month, 3 weeks left

We Are Still Looking For A Leader In The Philippines !

We have failed to find a Team Leader in the Philippines. Despite many interviews it is the only Country where we cannot find this Top Sales person to work with to build this amazing Country...

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

Campaign Manager Needed For Us Home Security Campaign, Very Long Term, Start Immediately, Great Pay

PLEASE READ THIS ENTIRE JOB POST: We are hiring a campaign manager for our home security program. Our campaign manager will be responsible for recruiting callers to sale our service, manage and train their team and the team's sales...

  • Fixed Price Project
  • Max $50000
  • 11 months, 2 weeks 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
  • 1 month, 3 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
  • 7 months left

3D Product Designers You Design We Print And Ship World Wide. 3D SLS, SLA, FDM, Multijet And Color Jet Printing

Calling all product designers! 3DCreationsystems.com is requesting designers to submit your product design for inclusion in our 3D online marketplace visit 3dcreationsystems.com and designfor3d.com. We will pay a negotiated rate but at minimum $5.00 per item. Plus $1...

  • Fixed Price Project
  • Max $5
  • 3 years, 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