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
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...
After months of preparation and setting up we are soft Launched in Australia and New Zealand and we need dedicated Sales people to take us to the top in this area. We have pre launch Events in Melbourne / Hobart / Adelaide / Perth / Brisbane / Auckland / Wellington and Sydney over the next 2 weeks..
Hi, we are looking for a german speaking project manager in vietnam to work at the location of our software development team in vietnam. Your job will be to clarify tasks with customers and discuss directly with the team to get the software development jobs done. Please send your CV to us. Thanks T
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...
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..
Company: Small Software company uses freelance developers - SharePoint App development. Your job - THIS IS A RECURRING JOB - it does not have a finite end date. Ongoing business. The budget below is not indicative of compensation. This is to be negotiated...
The company is in need of someone who has commitment in making big projects together with the other people on the team. He/she will be responsible in all aspects of the website's back-end...
YourSales is looking for freelance sales professionals worldwide for a range of missions we carry out for clients...
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...