The last weeks we took a look to management dashboard for webanalytics, how to create clear and nice visible charts in excel, and what KPI’s to include. This week I would like to go more into depth about the results of marketing activities in your dashboard. In the rapidly developing internet business nowadays there many channels which you can use for reaching your customers. In fact, seeing your website as the center there’s a wide landscape around you which you have to discover, because every channel needs its own marketing approach. Hence, your dashboard needs to provide you with channel-specific information Read more »
Tag Archives: "Management Dashboard"
Last week I wrote about some basics of webanalytics dashboards and explained how to make nice visualizations with excel charts. In fact, I would like to stay at excel this week as I’m getting more and more convinced of the enormous database potential the program offers. Some excel-advantages I discovered during my dashboard journey:
- It corresponds perfectly with data from major webanalytics tools (like Google Analytics or WebTrends)
- Information can be easily published in PDF
- Ease month-to-month (or year-to-year) analysis: define statistics, set targets, make a format and every month can be directly analysed
- Avoid people accessing the original web analytics tool (because these reports are often not usable for presenting the essential information compared to the dashboard)
- Include comments for evaluating reasons
- Choose from an enormous pool of free excel plugins different tools for fancy charts, specialized templates, tutorial software and other add-ons.
Ofcourse there are many more reasons for using excel – as also mentioned last week. But these above I really appreciate when executing such activities for a management board. If there are still some excel critics while reading this article, make a quick sidestep to discover if you’re making these mistakes ;)
…
Alright, now you’re totally convinced of using excel for business purposes. Let’s head on to this week’s subjects: what’s the essential information – or key performance indicators (KPI’s) – you want to report in the dashboard Read more »
Dashboards are nowadays an inevitable tool for management. Especially for internet projects, where information is easily accessible on a daily basis (even hourly or minutely, but I wasn’t intended to focus specifically on traders in this topic). Managers need a quick and clear access to the stats of their eCommerce or online marketing projects. How is online revenue from the webshop doing today? Which channels are generating the most traffic? How are other defined goal conversions working out? What website-improvements do we need to enhance our online results? Managers should be able to have immediate answers to such questions Read more »
ScanYours Weblog
ScanYours is your partner for internet consultancy. We focus on eStrategy, online marketing, design and creation, market research, and web development. Our goal: to increase online turnover and to improve online services. ScanYours works with motivated people, broad knowledge and effective tools. We combine fun and energy to deliver the best job possible.
On our weblog we write about the developments and stories that keep us inspired. Subscribe to our RSS-feed or follow us on Twitter or Facebook to receive the latest updates.