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
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...
Hello writers, We are searching for a number of writers on FINANCE, MANAGEMENT MEDICAL AND HEALTH to join our team of writers. Do not apply if you do not know anything to do with this styles. Academic writing, proposals, Press release and research would be of added advantage...
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.
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...
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...
You are a truly versatile, motivated INDIAN Web Developer with excellent skills in Joomla, JomSocial, VirtueMart and similar Joomla extentions, preferably residing in CHENNAI or willing to relocate in the future there? Then we ascend not only an interesting, but long-term task with the ability to..
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...
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...
I am looking for the right call center to make appointments for me on a pay per appointment basis I have a construction company in the Los Angeles area...
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...