Need excel reports built for an ecommerce business. Data will come from multiple sources - the primary source being Google Analytics, but also will pull from other databases and files. These reports will be sent on a weekly basis to executive team. Below is a general description of what I'm looking for (though not a 100% comprehensive list).
1. Marketing Channel Performance
- Daily: performance by day & weekly total - visits, transactions, revenue, AOV, conversion rate, bounces
- Weekly: ROAS by channel, wk-over-wk comparison to prior week, new vs returning customer results
- Monthly: calculate weeks into monthly results & auto-populate report highlighting channel performance against budget
**Attached are 2 examples of channel reports, I based some of this off those reports (not the layout or style, just the information)
2. E-commerce Dashboard
- Weekly ecomm metrics: visits, unique visitors, bounce rate, session duration, page views, conversion rate, AOV, total revenue
- Weekly page load speeds compared to average
- Weekly new vs returning customers: unique visitors, conversion rate, AOV, orders, total revenue
- Monthly results charts
**I did not attach examples for this. Am looking for some visual representations of metrics and some metrics in tables.
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Financial analysis, Excel and VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank.
I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
Hello there,
I am an accountant/auditor with big 4 experience and excellent excel skills.
I can send you my resume if needed.
Please let me know.
Thanks.