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:

Czech Republic - Do YOU Want To Manage Our Team?

We have just opened the Czech Republic 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
  • 1 month, 3 weeks left

Internet Marketing Partner- Design & Development Services Needed

We are looking to outsource a number of different projects for all of our local business clients. First and foremost, we are looking for someone to design/develop semi-custom, theme based, Responsive websites using top rated open source web design software (such as WordPress, Drupal, Joomla, etc.).

  • Fixed Price Project
  • Max $1000
  • 1 week, 4 days 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 $110
  • 4 months, 1 week left

Debt Consolidation Sale Reps Needed.

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 $50000
  • 1 week, 6 days 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, 3 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 experience as well and explain in brief how and what you do to win these contracts over.

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

Part Time Developer

Small Startup Company is need of a Part-Time Developer Position New tech Development group. This Opening Budgeted for at least 1 year...

  • Fixed Price Project
  • Max $100
  • 2 months, 1 week left

Community Representative - Australia

We are seeking Community Representatives to develop a localized voice for the company's social media and blog presence in each of our 16 global markets. If you're passionate about travel, social media and building a valuable community online, this is the perfect freelance opportunity for you

  • Fixed Price Project
  • Max $680
  • 1 week, 4 days 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
  • 1 year, 4 months 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
  • 1 year left

Job Details

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