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
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.
Integrated - Real Estate marketing websites: AND Home Owner Association Websites: like the ones these companies build http://www.hoa-sites.com/ , http://www.hoaconnections.com/ , and http://www.associationcomm...
Hello, We are seeking a fulltime web designer to work with us building web pages for affiliate marketing purposes. You should be a hard working team player who wants to be a permanent part of our company...
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.
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...
We are looking for a lot of good writers to work with us in the long term...
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...
PLEASE ONLY APPLY IF YOU ARE SERIOUS AND RESPONSIBLE ABOUT WORKING ONLINE AS AN ACADEMIC WRITER! THANKS!! We are looking for a lot of good writers to work with us in the long term...
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...
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...